I'm having a problem where I get a Table not found SQL exception when running a query against an Oracle 8.1.7 DB. Here is the stack trace...
2003-05-14 01:04:14,069 ERROR [STDERR] [2003/05/14 01:04:14.049] SEVERE DebugPreparedStatement.executeQuery: Table not found: SYS_USER_AUTHENTICATION in statement [Select USER_ID, USERNAME, PASSWORD, STATUS_CD, INACTIVE_REASON_CD, LAST_LOGGED_IN, INVALID_LOGIN_ATTEMPTS from SYS_USER_AUTHENTICATION where username = 'superuser']
java.sql.SQLException: Table not found: SYS_USER_AUTHENTICATION in statement [Select USER_ID, USERNAME, PASSWORD, STATUS_CD, INACTIVE_REASON_CD, LAST_LOGGED_IN, INVALID_LOGIN_ATTEMPTS from SYS_USER_AUTHENTICATION where username = 'superuser']
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Result.(Unknown Source)
at org.hsqldb.jdbcConnection.executeHSQL(Unknown Source)
at org.hsqldb.jdbcConnection.execute(Unknown Source)
at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbcStatement.executeQuery(Unknown Source)
at org.hsqldb.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:289)
------------
My question is this: Am I even connecting to my Oracle database? Is this trying to connect to Hypersonic instead? Here is my Oracle-ds.xml file...
<local-tx-datasource>
<jndi-name>KidstarDS</jndi-name>
<connection-url>jdbc:oracle:thin:@138.69.21.249:1521:cskidtst</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>ohdkidstar</user-name>
ohdkidstar
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
Any Ideas?
Thanks,
Sean
You are definitely using hsqldb, but without knowing where the access comes from it is pretty hard to say how this happens. Make sure the log does say your ds is being bound.