Community
Participate
Working Groups
tests.customsqlstoredprocedures.StoredProcWithOutputParamsAndResultSetTest failed on Sybase Exception: ========== Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '='. Error Code: 102 Call: EXECUTE Select_Output_and_ResultSet ARG1 = 1, @VERSION = ? OUTPUT bind => [0 => version] Query: ReadAllQuery(name="dblogin" referenceClass=Employee sql="EXECUTE Select_Output_and_ResultSet ARG1 = ?, @VERSION = ? OUTPUT") Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0.20090115-SNAPSHOT): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '='. Error Code: 102 Call: EXECUTE Select_Output_and_ResultSet ARG1 = 1, @VERSION = ? OUTPUT bind => [0 => version] Query: ReadAllQuery(name="dblogin" referenceClass=Employee sql="EXECUTE Select_Output_and_ResultSet ARG1 = ?, @VERSION = ? OUTPUT") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:322) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:656) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:501) at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:872) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:262) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:599) at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:480) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:930) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:664) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:891) at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:457) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2243) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1181) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1165) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1139) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1112) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1092) at org.eclipse.persistence.testing.tests.customsqlstoredprocedures.StoredProcWithOutputParamsAndResultSetTest.test(StoredProcWithOutputParamsAndResultSetTest.java:98) at org.eclipse.persistence.testing.framework.TestCase.executeTest(TestCase.java:543) at org.eclipse.persistence.testing.framework.TestCase.execute(TestCase.java:154) at org.eclipse.persistence.testing.framework.TestCase.runBare(TestCase.java:263) at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:247) at org.eclipse.persistence.testing.framework.TestSuite.execute(TestSuite.java:75) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:247) at org.eclipse.persistence.testing.framework.TestModel.execute(TestModel.java:208) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:247) at org.eclipse.persistence.testing.framework.TestModel.execute(TestModel.java:208) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near '='. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) at com.sybase.jdbc3.jdbc.SybCallableStatement.executeQuery(Unknown Source) at org.eclipse.persistence.platform.database.SybasePlatform.executeStoredProcedure(SybasePlatform.java:265) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:568)
For references, I'm including following info. These tests failed with same error on Sybase 15.03_Jconnect: StoredProcWithOutputParamsAndResultSetTest customSQL Bind StoredProcWithOutputParamsAndResultSetTest customSQL don'tBind
This bug fix did not make the cut off for 2.0.0. We are deferring the bugs to Future where we can properly sort them all together based on community votes and severity. We will then assign them accordingly to future patch sets and releases.
Changing the priority of the bugs that have been recently triaged to future. Targetting them to P2 will differentiate them from the P3s that have been triaged into future earlier.
2.1 Bug scrubbing, deferring to 2.1.1.
*** Bug 278272 has been marked as a duplicate of this bug. ***
Created attachment 176272 [details] proposed test case fix test fails on Sybase and SQLServer because arguments on those platforms require a '@' qualifier which is missing on the ARG1 definition on the custom SQL string.
test case Fix checked into main and 2.1.1
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink