Home » Developer & Programmer » JDeveloper, Java & XML » Oracle hangs at OraclePreparedStatement.executeBatch() call
Oracle hangs at OraclePreparedStatement.executeBatch() call [message #92300] Fri, 21 May 2004 07:48 Go to next message
Aleksey
Messages: 2
Registered: May 2004
Junior Member
Hi!

Does anybody knows what may cause the Oracle (8.1.7)
JDBC driver to be blocked? This situation occures from time to time and I can not see any reason.

The thread dump is listed below:
"SdrWriterThread-1" prio=5 tid=0x184264c8 nid=0x214 runnable [[18f1f000..18f1fd94]]
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at oracle.net.ns.Packet.receive(Unknown Source)
at oracle.net.ns.NetInputStream.getNextPacket(Unknown Source)
at oracle.net.ns.NetInputStream.read(Unknown Source)
at oracle.net.ns.NetInputStream.read(Unknown Source)
at oracle.net.ns.NetInputStream.read(Unknown Source)
at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:718)
at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:690)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:373)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
- locked <0x10641b80> (a oracle.jdbc.ttc7.TTC7Protocol)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:2883)
- locked <0x100900d0> (a oracle.jdbc.driver.OraclePreparedStatement)
at com.jnetx.xr.persistence.DAO.executeBatch(DAO.java:66)
...

Thanks for any suggestion.
Re: Oracle hangs at OraclePreparedStatement.executeBatch() call [message #92354 is a reply to message #92300] Mon, 14 June 2004 06:33 Go to previous messageGo to next message
Adrian
Messages: 16
Registered: May 2002
Junior Member
Have you managed to solve this problem? I have encountered this problem today, but as yet haven't found a solution.
Re: Oracle hangs at OraclePreparedStatement.executeBatch() call [message #92361 is a reply to message #92354] Tue, 15 June 2004 01:48 Go to previous messageGo to next message
Aleksey
Messages: 2
Registered: May 2004
Junior Member
Hi, Andrian. It seems that this is a bug in Oracle. And I do not know is it a driver or server bug. We have started to use Oracle 9 server and JDBC drivers (old version was 8.1) and the problem disappeared.
Re: Oracle hangs at OraclePreparedStatement.executeBatch() call [message #114774 is a reply to message #92361] Tue, 05 April 2005 10:18 Go to previous messageGo to next message
cgerman
Messages: 1
Registered: April 2005
Junior Member
> It seems that this is a bug in Oracle

I have a similar problem, and I would like to investigate a bit further. Could you, please, tell me what makes you think it is a bug in Oracle ? Any bug ID? Any reference? Any article?
Re: Oracle hangs at OraclePreparedStatement.executeBatch() call [message #407423 is a reply to message #114774] Wed, 10 June 2009 02:49 Go to previous message
legolaus
Messages: 2
Registered: June 2009
Junior Member
hi,
we are getting this problem in Oracle 10g. Let me konw if there is any solutiopn for this.
Previous Topic: Java-level Deadlock
Next Topic: how to start developing with JDeveloper
Goto Forum:
  


Current Time: Wed Jul 23 02:56:20 CDT 2014

Total time taken to generate the page: 0.11994 seconds