Looks like something went wrong with the sql statement. Can your jdbc driver provide more output through some configuration ? Maybe then the root cause can be seen.
On Tue, 17 Aug 2004 10:00:50 +0100 (BST), Ben Stokes <[EMAIL PROTECTED]> wrote: > Hi, > > I'm currently developing a web application on Tomcat 5 > embedded in Netbeans 3.6 and connecting to an Ingres > 2.6 database. I've setup a JdbcRealm in Tomcat to > authenticate users against the database to allow > access to the application and, from the outside, > everything appears to work well with the login process > working as it should. However, looking at the catalina > log there are obviously problems occuring that aren't > showing up on the web pages:- > > 2004-08-17 08:22:08 JDBCRealm[Catalina]: Exception > performing authentication > java.sql.SQLException: line 1, The dynamically defined > statement 'jdbc_stmt_0_0' not found. > Perhaps a PREPARE or DESCRIBE wasn't successful. > at > ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:509) > at > ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:348) > at ca.edbc.jdbc.EdbcPrep.execute(EdbcPrep.java:357) > at > ca.edbc.jdbc.EdbcPrep.executeQuery(EdbcPrep.java:243) > at > org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:449) > at > org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:393) > at > org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:176) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) > at > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688) > at java.lang.Thread.run(Thread.java:534) > > 2004-08-17 08:22:08 JDBCRealm[Catalina]: Username > tomcat successfully authenticated > 2004-08-17 08:22:08 JDBCRealm[Catalina]: Exception > performing authentication > java.sql.SQLException: line 1, The dynamically defined > statement 'jdbc_stmt_0_0' not found. > Perhaps a PREPARE or DESCRIBE wasn't successful. > at > ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:509) > at > ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:348) > at ca.edbc.jdbc.EdbcPrep.execute(EdbcPrep.java:357) > at > ca.edbc.jdbc.EdbcPrep.executeQuery(EdbcPrep.java:243) > at > org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:449) > at > org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:393) > at > org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:176) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) > at > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688) > at java.lang.Thread.run(Thread.java:534) > > 2004-08-17 08:22:08 JDBCRealm[Catalina]: Exception > performing authentication > java.sql.SQLException: line 1, The dynamically defined > statement 'jdbc_stmt_0_0' not found. > Perhaps a PREPARE or DESCRIBE wasn't successful. > at > ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:509) > at > ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:348) > at ca.edbc.jdbc.EdbcPrep.execute(EdbcPrep.java:357) > at > ca.edbc.jdbc.EdbcPrep.executeQuery(EdbcPrep.java:243) > at > org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:449) > at > org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:393) > at > org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:176) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) > at > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688) > at java.lang.Thread.run(Thread.java:534) > > 2004-08-17 08:22:08 JDBCRealm[Catalina]: Username > tomcat successfully authenticated > 2004-08-17 08:22:10 JDBCRealm[Catalina]: Exception > performing authentication > java.sql.SQLException: line 1, The dynamically defined > statement 'jdbc_stmt_0_0' not found. > Perhaps a PREPARE or DESCRIBE wasn't successful. > at > ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:509) > at > ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:348) > at ca.edbc.jdbc.EdbcPrep.execute(EdbcPrep.java:357) > at > ca.edbc.jdbc.EdbcPrep.executeQuery(EdbcPrep.java:243) > at > org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:449) > at > org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:393) > at > org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:176) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) > at > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688) > at java.lang.Thread.run(Thread.java:534) > > 2004-08-17 08:22:10 JDBCRealm[Catalina]: Exception > performing authentication > java.sql.SQLException: line 1, The dynamically defined > statement 'jdbc_stmt_0_0' not found. > Perhaps a PREPARE or DESCRIBE wasn't successful. > at > ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:509) > at > ca.edbc.jdbc.JdbcObject.readResults(JdbcObject.java:348) > at ca.edbc.jdbc.EdbcPrep.execute(EdbcPrep.java:357) > at > ca.edbc.jdbc.EdbcPrep.executeQuery(EdbcPrep.java:243) > at > org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:449) > at > org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:393) > at > org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:176) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:551) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) > at > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688) > at java.lang.Thread.run(Thread.java:534) > > I've searched the manual and web for 'jdbc_stmt_0_0' > but to no avail. Has anyone got an idea as to what's > going on? > > Thanks > > Ben Stokes > > ___________________________________________________________ALL-NEW Yahoo! Messenger > - all new features - even more fun! http://uk.messenger.yahoo.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]