-
1. Re: Sybase ASA 8.x Connection and Pooled Datasuorce
davidjencks May 14, 2002 11:52 PM (in response to thehitman)> 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
> p
> ======================================================
> ============= -->
> <mbean code="org.jboss.jdbc.JdbcProvider"
> " name="DefaultDomain:service=JdbcProvider2">
> <attribute
> e
> name="Drivers">com.sybase.jdbc2.jdbc.SybDriver</attrib
> te>
>
>
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
> "
> name="DefaultDomain:service=XADataSource,name=BPPetsto
> e">
> <attribute
> e
> name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.
> ADataSourceImpl
This is your jndi name under java:/
> BPPetstore
> <attribute
> e
> name="URL">jdbc:sybase:Tds:Localhost:2638/BPPetstore<!- > ttribute>
> dba
> sql
>
> <!-- Sybase BPPetstore Setup
> p
> ======================================================
> ============= -->
IIRC this should be enough for jboss 2.x version. 3.0 config is completely different.