At 13:41 04.08.2003 +0300, Alexey Loubyansky wrote:
Yes, something like that in hsqldb-ds.xml
<!-- this will be run before a managed connection is removed from the pool for use by a client-->
<!--<check-valid-connection-sql>select * from something</check-valid-connection-sql> -->
But I thing that our problem is, that this connections will be closed by the MySQL itself.
Rafal
alex
Monday, August 04, 2003, 12:35:44 PM, Rafal Kedziorski wrote:
> hi,
> WebLogic has an option to check the connection defined by:
> testTable
> (Required only if you set refreshTestMinutes, testConnsOnReserve, or
> testConnsOnRelease.) The name of a table in the database that is used to
> test the viability of connections in the connection pool. The query select
> count(*) from testTable is used to test a connection. The testTable must
> exist and be accessible to the database user for the connection. Most
> database servers optimize this SQL to avoid a table scan, but it is still a
> good idea to set testTable to the name of a table that is known to have few
> rows, or even no rows.
> Is there "the same" possibility in JBoss?
> Rafal
> At 10:25 04.08.2003 +0200, you wrote: >>hi, >> >>we had following problem. We are working with JBoss 3.2.2RC2, MySQL 4.0.14 >>(only with InnoDB tables) and Sun Java 1.4.2 and IBM Java 1.4.1 on Linux. >> >>Out application will be used only from monday to friday. that means, that >>this application is only running 2,5 days. The first 2-4 logins failed >>with this exceptions:
------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
