1 Reply Latest reply on May 14, 2002 11:52 PM by David Jencks

    Sybase ASA 8.x Connection and Pooled Datasuorce

    Peter Heller Newbie

      I am new to JBOSS but wanted to know about using jconn2.jar for jconnect 5.5.

      ASA provides javax.sql.PoolDataSource that manages it's pool. Is this needed when using JBOSS ?

      Where is the JNDI reference on how to setup for my database (example: "jdbc/BPPetstore") ?

      Are there any other config or xml files that I have left out ?

      <!-- Sybase BPPetstore Setup ==================================================================== -->

      com.sybase.jdbc2.jdbc.SybDriver



      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</a ttribute>
      BPPetstore
      jdbc:sybase:Tds:Localhost:2638/BPPetstore
      dba
      sql

      <!-- Sybase BPPetstore Setup ==================================================================== -->

        • 1. Re: Sybase ASA 8.x Connection and Pooled Datasuorce
          David Jencks Master

          > I am new to JBOSS but wanted to know about using
          > jconn2.jar for jconnect 5.5.

          Nice to mention which jboss you want to use.
          >
          > ASA provides javax.sql.PoolDataSource that manages
          > it's pool. Is this needed when using JBOSS ?

          NO! You can use Driver or XADataSource.
          >
          > Where is the JNDI reference on how to setup for my
          > database (example: "jdbc/BPPetstore") ?
          >
          > Are there any other config or xml files that I have
          > left out ?
          >
          > <!-- Sybase BPPetstore Setup
          &gt; p
          &gt; ======================================================
          &gt; ============= -->
          > <mbean code="org.jboss.jdbc.JdbcProvider"
          &gt; " name="DefaultDomain:service=JdbcProvider2">
          > <attribute
          &gt; e
          &gt; name="Drivers">com.sybase.jdbc2.jdbc.SybDriver</attrib
          &gt; te>
          >
          >
          > <mbean code="org.jboss.jdbc.XADataSourceLoader"
          &gt; "
          &gt; name="DefaultDomain:service=XADataSource,name=BPPetsto
          &gt; e">
          > <attribute
          &gt; e
          &gt; name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.
          > ADataSourceImpl

          This is your jndi name under java:/

          > BPPetstore
          > <attribute
          &gt; e
          &gt; name="URL">jdbc:sybase:Tds:Localhost:2638/BPPetstore<!- &gt; ttribute>
          > dba
          > sql
          >
          > <!-- Sybase BPPetstore Setup
          &gt; p
          &gt; ======================================================
          &gt; ============= -->


          IIRC this should be enough for jboss 2.x version. 3.0 config is completely different.