ORA-00904, ojdbc14.jar and server 8.1.7.3 [message #92126] |
Thu, 18 March 2004 05:23 |
Ignacio Sanchez
Messages: 4 Registered: February 2003
|
Junior Member |
|
|
Hi,
We're devoloping an app under Orion, connecting via the Oracle driver ojdbc14.jar to a Oracle server 8.1.7.3. In our development, everything goes well, but in our client, it crashes like this:
java.sql.SQLException: ORA-00904: invalid column name
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:241)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1477)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2051)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1961)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:452)
We've got some desc from our client, and all columns are OK in the table. But we cannot reproduce it in our environment. We're using server 8.1.7.0.1 for Linux and the latest ojdbc14.jar. Could it be a bug on a previous version of our client's server/JDBC driver? Anyone has faced this problem before?
Once again, I must remark that yes, we have checked if the columns are OK in the insert, and data types and even BD parameters (charsets, date formats, language, etc.) are the same!!!! And selects work fine!!! :-O
If someone could please help us... It's urgent, important, and we can't give any answer.
BYe
|
|
|
|