Hello everybody,
I'm getting this exception, when I perform a select over an Oracle 8i database.
java.sql.SQLException: ORA-00942: table or view does not exist
12:08:42,775 INFO [STDOUT] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
12:08:42,776 INFO [STDOUT] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
12:08:42,776 INFO [STDOUT] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
12:08:42,776 INFO [STDOUT] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
12:08:42,776 INFO [STDOUT] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:880)
12:08:42,776 INFO [STDOUT] at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2516)
12:08:42,777 INFO [STDOUT] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2850)
12:08:42,777 INFO [STDOUT] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)12:08:42,777 INFO [STDOUT] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:537)
12:08:42,777 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
The point when it is thrown is when i do a:
rs = ps.executeQuery();
ps is a Select. and before this call I have:
ps = conexion.prepareStatement( sql );
ps.setLong( 1, empleado.getCedulaEmpleado().longValue() );
I have checked that the value that I'm sending to the select is ok, so what could the problem be?
Thanks a lot for any help.