Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Exception after successful login

 
B Stokes
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I'm using Tomcat along with its JDBC Realm to authorise entry to my web app. Everything appears to work well during use, but after looking at the logs I'm not so sure. I'm developing on Netbeans 3.6 and connecting to an Ingres 2.6 database for the username/password/roles. I'm also using the JDBC driver contained in edbc.jar (Computer Associates JDBC driver for Ingres)

Looking at the log I seem to be logging in ok, but for some reason it then throws an SQL exception. The strange thing is that the web app itself seems to go on functioning perfectly, and I'm able to log in and out as I should be able to, it's just the log that's worrying me.

Has anyone seen something similar?


2004-08-16 15:18:19 JDBCRealm[Catalina]: Username tomcat successfully authenticated
2004-08-16 15:18:35 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.FormAuthenticator.authenticate(FormAuthenticator.java:274)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
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)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic