Connection Pooling

[jayant bhoge]

Hi,
I want to know what is connection pooling in JBoss? and how it is used to access SOL and ORACAL database?. Can connection pooling be done throgh coding? If so anybody has sample code snippets please do farward me.

Regards
Jayant

[Sanju Thomas]

Hi jayant,
You can easily create connection pool in JBoss. You need to deploy the xxxx-ds.xml file in to the jboss/server/default/deploy folder. You will get the sample xxxxxx-ds.xml files from the docs/examples/jca direcoty, that is coming along with the jboss build. To create oracle connection pool, you have to deploy the oracle-ds.xml (name doe's not mean much) in the jboss/server/default/deploy directory. (or in the instance which one you are using).

oracle.ds.xml file
------------------

  
 
<datasources>
  <local-tx-datasource>
    <jndi-name>OracleDS</jndi-name>
    <connection-url>jdbc oracle:thin:@youroraclehost:1521:yoursid</connection-url>
<!--
 
Here are a couple of the possible OCI configurations.
For more information, see <a href="http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm" target="_blank" rel="nofollow">http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm</a>
 
<connection-url>jdbc oracle oci:@youroracle-tns-name</connection-url>
or
<connection-url>jdbc oracle oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>
 
Clearly, its better to have TNS set up properly.
 -->
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>x</user-name>
    <password>y</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  </local-tx-datasource>
 
</datasources>

You need to change it according to your environment.

Now you can lookup your connection pool from any J2EE component, that is deployed in the server.

the lookup code is
------------------

  
  InitialContext jndiCntx = new InitialContext();
  DataSource ds = (DataSource)jndiCntx.lookup("java:/yourdsname");    
  connection = ds.getConnection();

yourdsname should be the same as in oracle-ds.xml file.

hope this will help you.
[ May 05, 2005: Message edited by: Sanju Thomas ]

[P Chandrasekaran]

I would like to know how to specify for datasources the equivalent of "capacityIncrement" found in Weblogic servers.

Chandra

[prashanth nagaraj]

There is a way for creating Connection pool by specifying the connection manager JBossManagedConnectionPool in jboss-service.xml, but how do we map this pool to the datasource mentioned in the <database>-ds.xml

thanks.
Prashanth
[ May 12, 2005: Message edited by: prashanth c n ]

[Sanju Thomas]

Yes, you can specify the max pool size and min pool size in the xxxx-ds.xml file.

You need to include two more elements in xxxx-ds.xml file,

<max-pool-size>50</max-pool-size>
<min-pool-size>10</min-pool-size>

[prashanth nagaraj]

How do we get the dtd for that?

If I can get that, I will study that and want to know what else we can add in <Database>-ds.xml

thanks,
prashant

[Sanju Thomas]

All dtds' and example xxxx-ds.xml files are available in the JBOSS_HOME/doc directory.

[P Chandrasekaran]

Originally posted by prashanth c n:
There is a way for creating Connection pool by specifying the connection manager JBossManagedConnectionPool in jboss-service.xml, but how do we map this pool to the datasource mentioned in the <database>-ds.xml

thanks.
Prashanth

[ May 12, 2005: Message edited by: prashanth c n ]

But am I corrrect in stating that a DataSource is by default a connection pool?

Chandra

[Sanju Thomas]

Yes, you are correct.

[vinod pandey It]

Hi,

Thanks Sanju. I got all your points. I need some more help regarding Hibernate.

Currently I am using connection pooling with Hibernate's c3p0 API. I want to ask that how can I use JBoss connection pooling support in place of c3p0. Please explain the configuration required for this.

@All: I will also appreciate if someone other can also help me.

Thanks
Vinod Pandey
Software Engg.
NHST, India

[Peter Johnson]

Vinod, welcome to Java Ranch!

Rather than resurrecting a 6 year old thread, it would be better if you started a new thread and post the complete details regarding the issue you are facing.
TellTheDetails