This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Ok, am not a database guy, but am having a problem with a parameter in my init.ora file. The parameter is QUERY_REWRITE_ENABLED. If I set it to true, which I need so oracle knows about hints. I get this error: java.sql.SQLException: No more data to read from socket at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:933) at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java, Compiled Code) at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java, Compiled Code) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java, Compiled Code) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java, Compiled Code) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java, Compiled Code) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java, Compiled Code) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java, Compiled Code) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:446) Compiled Code) I have downloaded the latest JDBC drivers, and that didn�t help. Help is greatly appreciated! Rama Ituarte
Are you sure that it is because of that init.ora parameter. It looks like it has something to do with the connection. Is the connection getting closed in between? What is the JDBC driver you are using and what is the database version? Regards Beksy [ September 18, 2002: Message edited by: Beksy Kurian ]
Joined: Apr 10, 2002
The drivers are the latest drivers that Oracle has out thier. The DB version is 8.1.7. Thanks for you reply. It make no sense that when I take out this parameter the call to the function works fine.