When connecting JBoss to Sybase via JDBC, I have been unable to get the 'Properties' attribute in the jboss.jcml file to pass through to the database. I successfully receive database connections with no errors, but the connection properties 'DYNAMIC_PREPARE' and 'APPLICATIONNAME' never get set. The 'DYNAMIC_PREPARE' property allows me to optimally use the 'conn.prepareStatement()' and the 'APPLICATIONNAME' allows me to see where my connections are coming from on the database side.
I am using 'JBoss-2.4.4_Tomcat-4.0.1' with 'Sybase 12' and 'jConnect5_5'.
Here is the associated jboss.jcml code snipet:
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=DefaultDS">
<attribute name="PoolName">SybasePool</attribute>
<attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="Properties">DYNAMIC_PREPARE=true;APPLICATIONNAME=JBoss</attribute>
<attribute name="URL">jdbc:sybase:Tds:MyServer:2025/mydb?CHARSET=iso_1</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">userid</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">passwd</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">false</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">true</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
Thanks for any insight into my problem.
