This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes init.ora parameter HELP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "init.ora parameter HELP" Watch "init.ora parameter HELP" New topic
Author

init.ora parameter HELP

Rama Ituarte
Ranch Hand

Joined: Apr 10, 2002
Posts: 62
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
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
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 ]
Rama Ituarte
Ranch Hand

Joined: Apr 10, 2002
Posts: 62
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.
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

How about this?
Bug 1528882 Fixed: 8.1.7.1
Hangs / Spins
High parse times are possible for queries with long OR chains if
query_rewrite_enabled is set to true.


Perhaps this is happening, and your query times out?
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
That could be right!
I tried to test this with my 8.1.7.4 (installed the 8.1.7.4 patch set yesterday) database (which has bfiles) and couldn't duplicate the problem.
Regards
Beksy
Rama Ituarte
Ranch Hand

Joined: Apr 10, 2002
Posts: 62
Well, I ended up creating a TAR with Oracle. Their solution was to upgrade to 8.1.7.4. Thanks for the input guys.
Rama Ituarte
 
 
subject: init.ora parameter HELP
 
Similar Threads
Callign an oragle package in Java with JDBC
invalid host/bind variable name
Access Violation
java.sql.SQLException: ORA-01733: virtual column not allowed here
Error writing greater than 4000 chars to CLOB