[JCA/JBoss] - Re: Message DB + Oracle database connection count problems
by 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
18Â years, 8Â months