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.
Joined: Jan 23, 2002
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...