File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Tomcat and the fly likes JDBC Exception after successful login Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "JDBC Exception after successful login" Watch "JDBC Exception after successful login" New topic
Author

JDBC Exception after successful login

B Stokes
Greenhorn

Joined: Aug 04, 2004
Posts: 9
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)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Exception after successful login
 
Similar Threads
Run jsp: Unable to find a javac compiler
Problem connecting to sqlserver from Tomcat
MyEclipse - WebApplication deployment - problem
validation fieldcheck required ?
connectionURL to SQL Server 2005