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> -->
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:
>>
>>exception in server.log:
>>------------------------
>>2003-08-04 10:07:47,259 ERROR
>>[org.jboss.security.auth.spi.DatabaseServerLoginModule] Query failed
>>java.sql.SQLException: Communication link failure: java.io.IOException
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java(Compiled
>> Code))
>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java(Compiled Code))
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java(Compiled Code))
>> at com.mysql.jdbc.Connection.execSQL(Connection.java(Compiled Code))
>> at
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1538)
>> at
>> org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:289)
>> at
>> org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(DatabaseServerLoginModule.java:100)
>> at
>> org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:143)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
>>
>> Code))
>> at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
>> at
>> javax.security.auth.login.LoginContext.invoke(LoginContext.java(Compiled Code))
>> at
>> javax.security.auth.login.LoginContext.access$000(LoginContext.java:150)
>> at
>> javax.security.auth.login.LoginContext$4.run(LoginContext.java:633)
>> at java.security.AccessController.doPrivileged(Native Method)
>> at
>> javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:630)
>> at
>> javax.security.auth.login.LoginContext.login(LoginContext.java:556)
>> at
>> org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityManager.java:462)
>> at
>> org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityManager.java:417)
>> at
>> org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java(Compiled
>>
>> Code))
>> at
>> org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java(Compiled
>>
>> Code))
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled
>>
>> Code))
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81)
>> at
>> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
>> at
>> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
>> at
>> org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310)
>> at org.jboss.ejb.Container.invoke(Container.java(Compiled Code))
>> at
>> org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272)
>> at
>> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
>> at $Proxy52.create(Unknown Source)
>> at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown Source)
>> at
>> de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown
>> Source)
>> at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown
>> Source)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>> at
>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
>> at
>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
>> at
>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1714)
>> at
>> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)
>> at org.mortbay.http.HttpServer.service(HttpServer.java:863)
>> at org.jboss.jetty.Jetty.service(Jetty.java:460)
>> at org.mortbay.http.HttpConnection.service(HttpConnection.java:775)
>> at
>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939)
>> at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792)
>> at
>> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)
>> at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
>> at
>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled Code))
>>2003-08-04 10:07:47,982
>>WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
>>ResourceException cleaning up
>>ManagedConnection:org.jboss.resource.JBossResourceException: Could not
>>cleanup: ; - nested throwable: (java.sql.SQLException: No operations
>>allowed after connection closed)
>>2003-08-04 10:07:48,022 ERROR [org.jboss.ejb.plugins.SecurityInterceptor]
>>Authentication exception, principal=mmcms
>>2003-08-04 10:07:48,026 ERROR [org.jboss.ejb.plugins.LogInterceptor]
>>EJBException, causedBy:
>>java.lang.SecurityException: Authentication exception, principal=mmcms
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled
>>
>> Code))
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81)
>> at
>> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
>> at
>> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
>> at
>> org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310)
>> at org.jboss.ejb.Container.invoke(Container.java(Compiled Code))
>> at
>> org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272)
>> at
>> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
>> at $Proxy52.create(Unknown Source)
>> at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown Source)
>> at
>> de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown
>> Source)
>> at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown
>> Source)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>> at
>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
>> at
>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
>> at
>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1714)
>> at
>> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)
>> at org.mortbay.http.HttpServer.service(HttpServer.java:863)
>> at org.jboss.jetty.Jetty.service(Jetty.java:460)
>> at org.mortbay.http.HttpConnection.service(HttpConnection.java:775)
>> at
>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939)
>> at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792)
>> at
>> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)
>> at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
>> at
>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled Code))
>>2003-08-04 10:07:48,195 WARN [org.jboss.jbossweb] WARNING: Exception for
>>/mmcmsxml
>>javax.ejb.EJBException: checkSecurityAssociation; CausedByException is:
>> Authentication exception, principal=mmcms
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled
>>
>> Code))
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81)
>> at
>> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
>> at
>> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
>> at
>> org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310)
>> at org.jboss.ejb.Container.invoke(Container.java(Compiled Code))
>> at
>> org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272)
>> at
>> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
>> at $Proxy52.create(Unknown Source)
>> at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown Source)
>> at
>> de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown
>> Source)
>> at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown
>> Source)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>> at
>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
>> at
>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
>> at
>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1714)
>> at
>> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)
>> at org.mortbay.http.HttpServer.service(HttpServer.java:863)
>> at org.jboss.jetty.Jetty.service(Jetty.java:460)
>> at org.mortbay.http.HttpConnection.service(HttpConnection.java:775)
>> at
>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939)
>> at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792)
>> at
>> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)
>> at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
>> at
>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled Code))
>>java.lang.SecurityException: Authentication exception, principal=mmcms
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled
>>
>> Code))
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81)
>> at
>> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
>> at
>> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
>> at
>> org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310)
>> at org.jboss.ejb.Container.invoke(Container.java(Compiled Code))
>> at
>> org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272)
>> at
>> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
>> at $Proxy52.create(Unknown Source)
>> at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown Source)
>> at
>> de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown
>> Source)
>> at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown
>> Source)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>> at
>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
>> at
>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
>> at
>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1714)
>> at
>> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)
>> at org.mortbay.http.HttpServer.service(HttpServer.java:863)
>> at org.jboss.jetty.Jetty.service(Jetty.java:460)
>> at org.mortbay.http.HttpConnection.service(HttpConnection.java:775)
>> at
>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939)
>> at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792)
>> at
>> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)
>> at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
>> at
>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled Code))
>>
>>
>>exception in our log file:
>>--------------------------
>>
>>2003-08-04 10:07:48,226 FATAL [de.polonium.servlets.ErrorServlet] doGet()
>>error request from 10.0.60.21 (10.0.60.21)
>>status_code: 500
>>uri: /mmcmsxml
>>exception:
>>javax.ejb.EJBException: checkSecurityAssociation; CausedByException is:
>> Authentication exception, principal=mmcms
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled
>>
>> Code))
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81)
>> at
>> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
>> at
>> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
>> at
>> org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310)
>> at org.jboss.ejb.Container.invoke(Container.java(Compiled Code))
>> at
>> org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272)
>> at
>> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
>> at $Proxy52.create(Unknown Source)
>> at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown Source)
>> at
>> de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown
>> Source)
>> at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown
>> Source)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>> at
>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
>> at
>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
>> at
>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1714)
>> at
>> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)
>> at org.mortbay.http.HttpServer.service(HttpServer.java:863)
>> at org.jboss.jetty.Jetty.service(Jetty.java:460)
>> at org.mortbay.http.HttpConnection.service(HttpConnection.java:775)
>> at
>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939)
>> at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792)
>> at
>> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)
>> at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
>> at
>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled Code))
>>java.lang.SecurityException: Authentication exception, principal=mmcms
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled
>>
>> Code))
>> at
>> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81)
>> at
>> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
>> at
>> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
>> at
>> org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310)
>> at org.jboss.ejb.Container.invoke(Container.java(Compiled Code))
>> at
>> org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272)
>> at
>> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
>> at $Proxy52.create(Unknown Source)
>> at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown Source)
>> at
>> de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown
>> Source)
>> at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown
>> Source)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>> at
>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
>> at
>> org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
>> at
>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1714)
>> at
>> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507)
>> at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)
>> at org.mortbay.http.HttpServer.service(HttpServer.java:863)
>> at org.jboss.jetty.Jetty.service(Jetty.java:460)
>> at org.mortbay.http.HttpConnection.service(HttpConnection.java:775)
>> at
>> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939)
>> at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792)
>> at
>> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)
>> at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
>> at
>> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled Code))
>>
>>Is this a JBoss or MySQL problem?
>>
>>
>>Best Regards,
>>Rafal
>>
>>
>>
>>-------------------------------------------------------
>>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
-------------------------------------------------------
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
