1 Reply Latest reply on May 15, 2003 9:04 AM by David Jencks

    Oracle database connection problem in JBoss 3.2.0

    Sean Gayle Newbie

      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