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]
