[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3427) executeUpdate never completes

[Svyatoslav Shymkiv (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=32408#action_32408 ] 

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira