Connection pooling using JBoss

[Urmi Birad]

Hi

I want to use connection pooling feature in my project using JBoss application server with Oracle database server.
Anybody can tell me how to do this please.

There are two ways to do this -
1. Using Jboss feature
2. Using JDBC 3.0 with the help of newly added featured.

If possible please tell me the solutions for both the cases.
If any sample code and good link are also appritiated.

Thanks in advance

[David O'Meara]

"Java Crazy",
Welcome to the JavaRanch.

We're a friendly group, but we do require members to have valid display names.

Display names must be two words: your first name, a space, then your last name. Fictitious names are not allowed.

Please edit your profile and correct your display name since accounts with display names get deleted, often without warning

thanks,
Dave

[Urmi Birad]

I changed my profile. Is it ok now?

[vishnu vardhana reddy vaka]

  
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/dev_dbname</jndi-name>
  <!--  <connection-url>jdbc:odbc:DEVAMS</connection-url>
    <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
    -->
<connection-url>jdbc:microsoft:sqlserver://DEV:1435;databaseName=dev_db;selectMethod=cursor</connection-url>
    <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<!--
 <connection-url>jdbc:odbc:DEV</connection-url>
   <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
   -->
   <user-name>user1</user-name>
    <password>user1pass</password>
      <metadata>
         <type-mapping>MS SQLSERVER2000</type-mapping>
      </metadata>
  </local-tx-datasource>
 

The above is sample Connection Pooling configuration file
save the above code with your parameters
as datasorce.xml or what ever name you want with .xml extenstion
and deploy it in same directory where you deployed you are jar's or war's or rar files eg (C:\jboss-4.0.2\server\default\deploy)
after you deploy it if the configuration is successful
in jobss debug console you can see the messages like
"connection bound" ..
after that you can refer to the jndi name above given to get connection objects

Regards,
Vishnu