0 Replies Latest reply on May 24, 2002 1:07 PM by Mike Maag

    Properties attribute is not working with Sybase connections

    Mike Maag Newbie

      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.