[ https://hibernate.onjira.com/browse/HHH-7313?page=com.atlassian.jira.plug... ] Lukasz Antoniak edited comment on HHH-7313 at 5/12/12 5:46 AM: --------------------------------------------------------------- Madhumita, could you please attach the complete console output of this test (http://ci.jboss.org/jenkins/view/hibernate/ temporarily unavailable)? I cannot reproduce this issue on up-to-date (12 May 2012) master branch running local Sybase 15.7 database. The following query is executed without any issues: {code:sql} 12:42:37,000 DEBUG SQL:104 - select childentit0_.id as id12_, childentit0_.REV as REV12_, childentit0_.REVTYPE as REVTYPE12_, childentit0_.REVEND as REVEND12_, childentit0_.data as data12_, childentit0_.typeId as typeId12_, childentit0_.specificData as specificData12_ from ParentEntity_AUD childentit0_ where ( SELECT c.type FROM ClassTypeEntity c WHERE c.id = childentit0_.typeId )='Child' and childentit0_.id=? and ( childentit0_.REVEND is null ) for update {code} Query runs correctly from Interactive SQL tool as well (see attachment). I am using {{org.hibernate.dialect.SybaseASE157Dialect}} dialect and {{com.sybase.jdbc4.jdbc.SybDriver}} driver class. Sybase JDBC driver details: {code} Implementation-Vendor: Sybase, an SAP Company Implementation-Title: com.sybase.jdbc4.utils Implementation-Version: JDK 1.6/jdbcmain/Tue Dec 20 04:41:18 PST 2011 Specification-Vendor: Sybase, an SAP Company Built-By: nnishant Created-By: 1.6.0_03 (Sun Microsystems Inc.) Specification-Title: jConnect (TM) for JDBC(TM) Specification-Version: jConnect (TM) for JDBC(TM)/7.07 GA(Build 26686) /P/EBF19793/JDK 1.6.0/jdbcmain/Tue Dec 20 04:39:14 PST 2011 Main-Class: com.sybase.jdbc4.utils.SybVersion {code} was (Author: lukasz.antoniak): Madhumita, could you please attach the complete console output of this test (http://ci.jboss.org/jenkins/view/hibernate/ temporarily unavailable)? I cannot reproduce this issue on up-to-date (12 May 2012) master branch running local Sybase 15.7 database. The following query is executed without any issues: {code:sql} 12:42:37,000 DEBUG SQL:104 - select childentit0_.id as id12_, childentit0_.REV as REV12_, childentit0_.REVTYPE as REVTYPE12_, childentit0_.REVEND as REVEND12_, childentit0_.data as data12_, childentit0_.typeId as typeId12_, childentit0_.specificData as specificData12_ from ParentEntity_AUD childentit0_ where ( SELECT c.type FROM ClassTypeEntity c WHERE c.id = childentit0_.typeId )='Child' and childentit0_.id=? and ( childentit0_.REVEND is null ) for update {code} Query runs correctly from Interactive SQL tool as well (see attachment). I am using {{org.hibernate.dialect.SybaseASE157Dialect}} dialect and {{com.sybase.jdbc4.jdbc.SybDriver}} driver class. Sybase JDBC driver details: Implementation-Vendor: Sybase, an SAP Company Implementation-Title: com.sybase.jdbc4.utils Implementation-Version: JDK 1.6/jdbcmain/Tue Dec 20 04:41:18 PST 2011 Specification-Vendor: Sybase, an SAP Company Built-By: nnishant Created-By: 1.6.0_03 (Sun Microsystems Inc.) Specification-Title: jConnect (TM) for JDBC(TM) Specification-Version: jConnect (TM) for JDBC(TM)/7.07 GA(Build 26686) /P/EBF19793/JDK 1.6.0/jdbcmain/Tue Dec 20 04:39:14 PST 2011 Main-Class: com.sybase.jdbc4.utils.SybVersion -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://hibernate.onjira.com/browse/HHH-7313?page=com.atlassian.jira.plug... ] Lukasz Antoniak edited comment on HHH-7313 at 5/12/12 5:56 AM: --------------------------------------------------------------- Madhumita, could you please attach the complete console output of this test (http://ci.jboss.org/jenkins/view/hibernate/ temporarily unavailable)? I cannot reproduce this issue on up-to-date (12 May 2012) master branch running local Sybase 15.7 database. The following query is executed without any issues: {code:sql} 12:42:37,000 DEBUG SQL:104 - select childentit0_.id as id12_, childentit0_.REV as REV12_, childentit0_.REVTYPE as REVTYPE12_, childentit0_.REVEND as REVEND12_, childentit0_.data as data12_, childentit0_.typeId as typeId12_, childentit0_.specificData as specificData12_ from ParentEntity_AUD childentit0_ where ( SELECT c.type FROM ClassTypeEntity c WHERE c.id = childentit0_.typeId )='Child' and childentit0_.id=? and ( childentit0_.REVEND is null ) for update {code} Query runs correctly from Interactive SQL tool as well (see attachment). I am using {{org.hibernate.dialect.SybaseASE157Dialect}} dialect and {{com.sybase.jdbc4.jdbc.SybDriver}} driver class. Sybase JDBC driver details: {code} Implementation-Vendor: Sybase, an SAP Company Implementation-Title: com.sybase.jdbc4.utils Implementation-Version: JDK 1.6/jdbcmain/Tue Dec 20 04:41:18 PST 2011 Specification-Vendor: Sybase, an SAP Company Built-By: nnishant Created-By: 1.6.0_03 (Sun Microsystems Inc.) Specification-Title: jConnect (TM) for JDBC(TM) Specification-Version: jConnect (TM) for JDBC(TM)/7.07 GA(Build 26686) /P/EBF19793/JDK 1.6.0/jdbcmain/Tue Dec 20 04:39:14 PST 2011 Main-Class: com.sybase.jdbc4.utils.SybVersion {code} Sybase ASE version: Adaptive Server Enterprise/15.7.0/EBF 19808 SMP ESD#01 /P/NT (IX86)/Windows 2008 R2/aseasap/2918/32-bit/OPT/Wed Feb 08 04:07:02 2012 was (Author: lukasz.antoniak): Madhumita, could you please attach the complete console output of this test (http://ci.jboss.org/jenkins/view/hibernate/ temporarily unavailable)? I cannot reproduce this issue on up-to-date (12 May 2012) master branch running local Sybase 15.7 database. The following query is executed without any issues: {code:sql} 12:42:37,000 DEBUG SQL:104 - select childentit0_.id as id12_, childentit0_.REV as REV12_, childentit0_.REVTYPE as REVTYPE12_, childentit0_.REVEND as REVEND12_, childentit0_.data as data12_, childentit0_.typeId as typeId12_, childentit0_.specificData as specificData12_ from ParentEntity_AUD childentit0_ where ( SELECT c.type FROM ClassTypeEntity c WHERE c.id = childentit0_.typeId )='Child' and childentit0_.id=? and ( childentit0_.REVEND is null ) for update {code} Query runs correctly from Interactive SQL tool as well (see attachment). I am using {{org.hibernate.dialect.SybaseASE157Dialect}} dialect and {{com.sybase.jdbc4.jdbc.SybDriver}} driver class. Sybase JDBC driver details: {code} Implementation-Vendor: Sybase, an SAP Company Implementation-Title: com.sybase.jdbc4.utils Implementation-Version: JDK 1.6/jdbcmain/Tue Dec 20 04:41:18 PST 2011 Specification-Vendor: Sybase, an SAP Company Built-By: nnishant Created-By: 1.6.0_03 (Sun Microsystems Inc.) Specification-Title: jConnect (TM) for JDBC(TM) Specification-Version: jConnect (TM) for JDBC(TM)/7.07 GA(Build 26686) /P/EBF19793/JDK 1.6.0/jdbcmain/Tue Dec 20 04:39:14 PST 2011 Main-Class: com.sybase.jdbc4.utils.SybVersion {code} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://hibernate.onjira.com/browse/HHH-7313?page=com.atlassian.jira.plug... ] Madhumita Sadhukhan commented on HHH-7313: ------------------------------------------ attched the log however I am not using the latest master but hibernate packed(most of the changes from 4.1.3) within latest candidate of EAP6 available to us for testing -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://hibernate.onjira.com/browse/HHH-7313?page=com.atlassian.jira.plug... ] Lukasz Antoniak commented on HHH-7313: -------------------------------------- The error occurs only if "select for update" database parameter is enabled. To view the parameter value: sp_configure "select for update" To enable: sp_configure "select for update", 1 -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira