[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1657?page=c... ] Tamir Solomon commented on HHH-1657: ------------------------------------ Hi. i have the same issue as David the update query is : update ADSocket remoteSocket set remoteSocket.twinSocket = (select localSocket from ADSocket localSocket " + "where localSocket.isLocalSocket=true and " + "(remoteSocket.ip!=null and localSocket.ip=remoteSocket.ip and " + "remoteSocket.port=localSocket.port " + "and remoteSocket.isServerSocket=localSocket.isServerSocket)) where as the generated sql is : Hibernate: insert into #AD_SOCKET select adsocket0_.SO_SOCKET_ID as SO_SOCKET_ID from AD_SOCKET adsocket0_ inner join AD_ENTITY adsocket0_1_ on adsocket0_.SO_SOCKET_ID=adsocket0_1_.EN_ID where ( EN_IS_DELETED is null or EN_IS_DELETED = 0) and SO_DETECTION_SERVER_ID=? and SO_IS_LOCAL=0 Hibernate: update AD_SOCKET set SO_TWIN_SOCKET=(select SO_SOCKET_ID from AD_SOCKET adsocket1_ inner join AD_ENTITY adsocket1_1_ on adsocket1_.SO_SOCKET_ID=adsocket1_1_.EN_ID where ( adsocket1_1_.EN_IS_DELETED is null or adsocket1_1_.EN_IS_DELETED = 0) and adsocket1_.SO_IS_LOCAL=1 and (adsocket0_.SO_IP is not null) and adsocket1_.SO_IP=adsocket0_.SO_IP and adsocket0_.SO_PORT=adsocket1_.SO_PORT and adsocket0_.SO_IS_SERVER_SOCKET=adsocket1_.SO_IS_SERVER_SOCKET) where (SO_SOCKET_ID) IN (select SO_SOCKET_ID from #AD_SOCKET) Hibernate: insert into #AD_SOCKET select adsocket0_.SO_SOCKET_ID as SO_SOCKET_ID from AD_SOCKET adsocket0_ inner join AD_ENTITY adsocket0_1_ on adsocket0_.SO_SOCKET_ID=adsocket0_1_.EN_ID where ( EN_IS_DELETED is null or EN_IS_DELETED = 0) Hibernate: update AD_SOCKET set SO_TWIN_SOCKET=(select SO_SOCKET_ID from AD_SOCKET adsocket1_ inner join AD_ENTITY adsocket1_1_ on adsocket1_.SO_SOCKET_ID=adsocket1_1_.EN_ID where ( adsocket1_1_.EN_IS_DELETED is null or adsocket1_1_.EN_IS_DELETED = 0) and adsocket1_.SO_IS_LOCAL=1 and (adsocket0_.SO_IP is not null) and adsocket1_.SO_IP=adsocket0_.SO_IP and adsocket0_.SO_PORT=adsocket1_.SO_PORT and adsocket0_.SO_IS_SERVER_SOCKET=adsocket1_.SO_IS_SERVER_SOCKET) where (SO_SOCKET_ID) IN (select SO_SOCKET_ID from #AD_SOCKET) and the error from the DB is (on the last update statement): com.sybase.jdbc3.jdbc.SybSQLException: ASA Error -142: Correlation name 'adsocket0_' not found Anyone ?? T. -- 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