File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes Connection Pooling-Urgent Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
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.
Lasse Koskela

Joined: Jan 23, 2002
Posts: 11962
I guess both of the DataSources should be XA because you are using two separate managed resources within a single transaction. I'm not too good with databases, though, so you might want to get another opinion on that one...

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
I agree. Here's the link:
subject: Connection Pooling-Urgent
It's not a secret anymore!