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.StandardV
