-
1. Re: Datasource Connection Pool Problem
genman Jun 25, 2003 6:39 PM (in response to casadelnorte)There is a feature that supports the Oracle database, which decides (upon Exception) whether or not the physical connection is still valid. This appears in JBoss 3.2.1 I believe.
In any case, if you download the CVS version, you can write your own based off the OracleExceptionSorter (look in the connector directory.) Then, in your jboss-ds.xml file you reference your class:
<no-tx-datasource>
<jndi-name>xxx/ds</jndi-name>
<connection-url>jdbc:oracle:thin:@localhost:1521:system</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>xxx</user-name>
xxx
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</no-tx-datasource>
Copy the .jar file to the lib directory or make a .sar out of it. -
2. Re: Datasource Connection Pool Problem
casadelnorte Jun 27, 2003 3:47 PM (in response to casadelnorte)Lordy! Guess that's the answer though.
Thanks.