users@glassfish.java.net

jdbc-connection-pool overlap/confuse pools

From: <glassfish_at_javadesktop.org>
Date: Tue, 17 Jun 2008 11:29:28 PDT

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