You should not use the JDBC-ODBC bridge. Try to find a Type 3 or
Type 4 driver for your DB, or use a Type 2 if you must, but avoid the
bridge.
Aaron
On Thu, 9 Nov 2000, M Munavar Baig wrote:
> Hello all,
>
> I am new to JBoss and i am trying for connection pooling using jboss as
> per given in the documentaion i did it is deploying and at runtime when i am
> accessing i am getting null value. at deployment time showing all the things
> that the datasource bound to so and so name. Can any body give me suggestion
> what can be the wrong. Here the listing i did..
>
> jboss.jcml
>
> <mbean name="DefaultDomain:service=XADataSource,name=PoolName">
> <attribute name="Properties"></attribute>
> <attribute name="URL">jdbc:odbc:MirimSquareInch</attribute>
> </mbean>
>
> jboss.conf
>
> <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar,rt.jar"
> CODEBASE="../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="PoolName">
> <ARG TYPE="java.lang.String"
> VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> </MLET>
>
> Testing code
>
> Properties p = new Properties();
>
> p.put("java.naming.factory.initial","org.jnp.interfaces.NamingContextFactory
> ");
> p.put("java.naming.provider.url","mbaig:1099");
> beanContext = new InitialContext(p);
> System.out.println("Going to Lookup:");
> homeObj = beanContext.lookup("PoolName");
> System.out.println("Got Reference");
> System.out.println(" homeObj = "+homeObj);
> javax.sql.DataSource ds = (javax.sql.DataSource)
> homeObj;
> System.out.println(" Ds = "+ds);
>
>
> ======== jboss Server message ==============
> [Configuration] GCMinIdleTime set to 1200000 in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] ShrinkPercent set to 0.33 in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] GCEnabled set to false in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] LoggingEnabled set to false in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] TimestampUsed set to false in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] Blocking set to false in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] GCInterval set to 120000 in
> DefaultDomain:service=XADataSource,name=PoolName
>
> [Configuration] InvalidateOnError set to false in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] JDBCUser set to sa in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] MinSize set to 0 in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] ShrinkMinIdleTime set to 600000 in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] ShrinkingEnabled set to false in
> DefaultDomain:service=XADataSource,name=PoolName
> [Configuration] VerifyDeployments set to true in
> EJB:service=ContainerFactory
>
> [XADataSource] XA Connection pool PoolName bound to PoolName
>
> Thanx in Advance,
> Munavar
>
