File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Connection pooling using JBoss Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection pooling using JBoss" Watch "Connection pooling using JBoss" New topic

Connection pooling using JBoss

Urmi Birad

Joined: Nov 03, 2006
Posts: 2

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

Joined: Mar 06, 2001
Posts: 13459

"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

Urmi Birad

Joined: Nov 03, 2006
Posts: 2
I changed my profile. Is it ok now?
vishnu vardhana reddy vaka

Joined: May 03, 2006
Posts: 9

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


Vishnu Vardahna Reddy.Vaka
I agree. Here's the link:
subject: Connection pooling using JBoss
It's not a secret anymore!