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 - Urgent Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection Pooling - Urgent" Watch "Connection Pooling - Urgent" New topic

Connection Pooling - Urgent

Sahil Sharma
Ranch Hand

Joined: Aug 27, 2003
Posts: 152
Need urgent help on this.
My application needs to interact with two different Databases.
I am using weblogic 8.1 as my application server and oracle 9i as my DB.i am also using EJB's for DB interactions.
With one DB i am doing all the operations(insert,update,delete)through entity beans but the other DB i am using only for "SELECT" purpose through Stateless Session bean.
i have made two different connection pools (using non-XA thin driver for both of them) but i am getting this error when my application tries to use the second connection pool(configured for "SELECT" purpose only)
"java.sql.SQLException: Connection has already been created in this tx context for pool named MyConnectionPool. Illegal attempt to create connection from another pool: MyConnectionPool1 ".
how should i solve this problem.
I agree. Here's the link:
subject: Connection Pooling - Urgent
jQuery in Action, 3rd edition