This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Connection Pooling-Urgent " Watch "Connection Pooling-Urgent " New topic
Author

Connection Pooling-Urgent

Sahil Sharma
Ranch Hand

Joined: Aug 27, 2003
Posts: 152
Hi,
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
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
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]
 
 
subject: Connection Pooling-Urgent
 
Similar Threads
URGENT!!!
Urgent Help!!!
Regarding JDBC Connection (URGENT)
Connection Pooling - Urgent
DATABASE OBJECT-- URGENT URGENT