Hai,
I have created three pools with names
jdbc/abcd for abcd database
jdbc/efgh for efgh database
jdbc/ijkl for ijkl database
I have hibernate application using jdbc/abcd
a servlet using jdbc/efgh and another servlet jdbc/ijkl
I use InitialContext, then DataSource lookup to get jdbc/efgh
and jdbc/ijkl connections in respective servlets.
However when they are deployed, often the tables are
overlapped. I mean, i see errors like tables being called
from wrong database. When servlet using jdbc/efgh is
coded to make use of tables under efgh database, I
often see errors like table ijkl.xxxx not found where xxxx
is part of efgh database.
This behaviour is same for glassfishv2 and v2ur2
Kind Regards
Sanjeev
[Message sent by forum member 'sanjeev_any' (sanjeev_any)]
http://forums.java.net/jive/thread.jspa?messageID=280807