[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3427) executeUpdate never completes
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3427?page=c...
]
Svyatoslav Shymkiv commented on HHH-3427:
-----------------------------------------
This happens to me all the time I'm trying to execute my query.
Hibernate: 3.3.1.GA
Oracle, version: Oracle9i Enterprise Edition Release 9.2.0.5.0
JDBC driver: Oracle JDBC driver, version: 9.2.0.8.0, 10.2.0.4.0
Java: j2sdk1.4.2_14, jdk1.5.0_12, jdk1.6.0_04
I'm running simple named query to detect if I can write into a table:
<sql-query name="Run.UpdateTest">
<![CDATA[
update
table
set
column_1 = column_1
where
rownum = 1
]]>
</sql-query>
I found out that Thread is blocked on Socket Read operation. Below there is stack trace:
main" prio=5 tid=0x00037db8 nid=0x230 runnable [0x0007e000..0x0007fc38]
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.DataPacket.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.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1104)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1075)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:480)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1135)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3500)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3584)
- locked <0x10018840> (a oracle.jdbc.driver.T4CPreparedStatement)
- locked <0x10636280> (a oracle.jdbc.driver.T4CConnection)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at
org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:165)
at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1163)
at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:334)
executeUpdate never completes
-----------------------------
Key: HHH-3427
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3427
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.2.0.ga
Environment: Hibernate 3.2.0 ga, Oracle 10.2.0.1.0, JAVA 1.6
Reporter: Mojmir Tuljak
Update (query.executeUpdate()) never completes. Using oracle enterprise manager we can
see that oracle has completed the update but method executedUpdate() never returned any
result so the application is waiting. The problem is not always reproducable and happens
once or twice a day, always when the same executeUpdate is called while the previous one
is still in progress. No exception is thrown.
Executing the same query directly without the use of hibernate does not lead to the above
problems.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira