Subject Re: [Firebird-Java] Tomcat + DBCP + FireBird
Author brenmcguire@tariffenet.it
I think you have 2 way to resolve this problem:
1) Catch this exception and, if needed, get a new connection from the
datasource
2) (The best solution and the most adopted) Get a connection for each
transaction/set of queries, make your queries and close the connection at
the end.

solusinfo_lms wrote:

> Hi,
> I try to use Firebird 1.5 (NT4 Server) from Tomcat 4.1.30 (Debian
> server) with DBCP, JayBird 1.5 RC3 (using a BasicDatasourceFactory).
> If I use my web app, it works well but when i stop using it for a
> few time, when i want to use it again, connection seems to be lost
> and Throws a FBSQLExcetpion 'cannot read data from the connection',
> and then i only can restart Tomcat to go on working.
> I do not know what to do, so, please help me!!
> Thanks
> michel