Hallo I solved the problem. It is embarrasing to me but in some cases I didn't close the connection. So therefore I had this problem.
Thanks. 2006/2/3, Hans Sowa <[EMAIL PROTECTED]>: > > Hi > > I'm working on a webapplikation using JNDI to lookup for a database > connection. Actually it works for several times and then it stopps and I > don't get an connection. I analysed it and found out that Method > getConnnection has a problem. > > Here is my code: > > protected Connection lookupJNDIConnection(final String resource) { > InitialContext ic = null; > try { > System.out.println("will InitialContext"); > ic = new InitialContext(); > System.out.println("lookup nach comp/env"); > Context envContext = (Context) ic.lookup("java:/comp/env"); > System.out.println ("lookup."); > DataSource ds = (DataSource) envContext.lookup(resource); > System.out.println("return getconnection."); > return ds.getConnection(); > > } catch (Exception e) { > e.printStackTrace(); > return null; > } > } > > I can see the out.println("return getconnection.") but the out.printlnafter > that, in the method which calls the this method, are not visible. > > And for every sql statement I perform a lookup, get the connection, > perform the sql statement and then close the connection. Has anyone an idea > what the problem is? > > Thanks in advance. > > -- > mfg Hans Sowa > mailto:[EMAIL PROTECTED] -- mfg Hans Sowa mailto:[EMAIL PROTECTED]