This week's book giveaway is in the Java in General forum.
We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield on-line!
See this thread for details.
Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Pooling - Urgent

 
Sahil Sharma
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic