[jBoss-Dev] Connection Pooling in jboss

[M Munavar Baig]

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