tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hans Sowa <hanss...@gmail.com>
Subject Re: problem with JNDI
Date Fri, 03 Feb 2006 12:38:36 GMT
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 <hanssowa@gmail.com>:
>
> 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:hanssowa@gmail.com




--
mfg Hans Sowa
mailto:hanssowa@gmail.com

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message