[jboss-user] [JCA/JBoss] - Re: Message DB + Oracle database connection count problems

[Malert]

Hi, i also encounter similar problem when contacting the Database, i use jboss 4.0.5.BA and Oracle 9i.

SQL exception occurs at the execution of following line
conn.createStatement();   //conn is the ConnectionManager

the trace is given below:
Exception in [WrappedConnection.java ] At line 537 !
java.sql.SQLException: Connection handle has been closed and is unusable
	at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)
	at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524)
	at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:142)
.
.
.

I am not able to identify the problem
my oracle-ds.xml file is given below

  <local-tx-datasource>
    <jndi-name>DataSource</jndi-name>
    <use-java-context>false</use-java-context>
    <connection-url>jdbc:oracle:thin:@oracleserver:1521:SID
    </connection-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>x</user-name>
    y
    <min-pool-size>50</min-pool-size>
    <max-pool-size>50</max-pool-size>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
    </exception-sorter-class-name>
    
   <type-mapping>Oracle9i</type-mapping>
    
  </local-tx-datasource>


looking for Help.

Thanks
Malert Jones

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4071182#4071182

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4071182