Specifying Exception Sorter for JBossManagedConnectionPool

[vidyesh]

We are using JBossManagedConnectionPool as MBean Service with following entries, where I would also like to specify "exception-sorter-class-name" as "org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter".

Question 1. How do I specify that ? There is no Setter/Getter method for ExceptionSorterClassName.
Question 2. Where do I get the above exception sorter class ?

<depends optional-attribute-name="ManagedConnectionFactoryName">

MYDS


<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@::</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>


<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


<depends optional-attribute-name="ManagedConnectionPool">
1
10
5000
15
ByContainer


<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
jboss.jca:service=RARDeployer

[adrian.brock]

1) Like most options, it is a config property on the connection factory:

<config-property name="CheckValidConnectionSQL" type="java.lang.String">
org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
</config-property>

2) If it is not in the jboss distribution it is not supported in the version of jboss you have.
I assume you are using an early version of 3.0.x?

Regards,
Adrian

[vidyesh]

Thanks Adrian for prompt reply.

We are using JBoss 3.0.4.

I tried specifying following config-property

<config-property name="CheckValidConnectionSQL" type="java.lang.String">SELECT 1 FROM DUAL</config-property>

Error I got was :

java.lang.IllegalArgumentException: The class 'class org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory' has no setter for config property 'CheckValidConnectionSQL', ObjectName:jboss.jca:service=NoTxCM,name=MYDS


Could you please also tell me which jar file has "org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter" class ?

Thanks & Regards

[adrian.brock]

Not your version. Looking at CVS it was introduced in 3.0.7 or 3.2.x
http://cvs.sourceforge.net/viewcvs.py/jboss/jbosscx/src/main/org/jboss/resource/adapter/jdbc/vendor/OracleExceptionSorter.java

Before you ask, No It will not work in 3.0.4

Regards,
Adrian

[vidyesh]

Thanks for your reply.

What could be workaround in JBoss 3.0.4 to check connection before it is returned from the pool? Is there any way to refresh this pool if connections are stale ?

Regards,
Vidyesh