Hi,
I came across a dbconnectionbroker class that does the
connection pooling et al. this is available at
www.javaexchange.com and is free. I also read that
there is one at Apache, which is called turbine.
Turbine is actually an assorted collection of App
Server utilities. I have been using
DBConnectionBroker. Most others say it is really good,
albeit i have a strange problem for now. But, again i
am trying to trace it to my code.
The problem i am facing is that of not being able to
find a record that was just then created in a table.
When a user logs into our system, a sessionID is
created and further communication from the client
should be based on this session id. So when i try to
validate the session id just then created, it returns
false for simple query. Not sure why....
anyway, a lot of others are using this without any
problems... so should be fine...
Cheers!!!!
Victor.C
--- David Cao <dcao@e-travel.com> wrote:
> Hi Stefan,
>
> I have a very similar problem, I wrote my own
> connection pool, after several
> success access to the database, the connection lost
> ! the error message
> says, con't find suitable driver. and once I restart
> the tomcat, it work
> fine !
>
> I am thinking it's a bug on my code, but now I am
> thinking is this a seting
> problem in tomact or JDBC? I will looking at this
> problem soon, pls keep let
> me know if you got any progress, I will also let you
> know if i got further
> information.
>
> Thanks.
> david
>
> -----Original Message-----
> From: Stefan Urban [mailto:surban@pevo.de]
> Sent: Tuesday, August 29, 2000 6:14 AM
> To: tomcat-user@jakarta.apache.org
> Subject: Problems with JDBC
>
>
> Hi,
>
> I wrote a Servlet, which connects to a
> MySQL-Database. When I'm starting
> Tomcat
> it all works fine. But several Time later, the
> Servlet can't established the
> Database-
> connection again. I set the Classpath right, because
> when I'm stopping
> Tomcat, he shows me the rigth Classpath. When I'm
> starting Tomcat again, it
> all works fine again!!
>
> Why the hell it does not work several time later?
> Where should I set the
> Classpath?
>
> Thanx.
>
> -Stefan
>
__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
|