Connecting to different pools in a single Business method
843833Jan 14 2003 — edited Jan 14 2003Hi,
I have crested 2 pools called apool and bpool in weblogic 6.1 Aplication server. There are two methods getA() and getB() in a stateless session bean which connect to apool and bpool respectively.
There is one business method where i am calling these two methods one after the other so that when i call this business method from a servlet i will get the output of the two methods getA() and getB() stored in Hashtable to the servlet. The problem is when i am calling the method i am getting the SQLException..>
java.sql.SQLException: Connection has already been created in this tx context for pool named apool. Illegal attempt to create connection from another pool: bpool
at weblogic.jdbc.jts.Driver.getExistingConnection(Driver.java:288)
at weblogic.jdbc.jts.Driver.connect(Driver.java:123)
i am creating the connection object in each method and closing before the end of the method.but still it is unable to connect to different pools.
can anybody help in solving this problem..
sowjanya