Bug 261663

Summary: tests.customsqlstoredprocedures.StoredProcWithOutputParamsAndResultSetTest failed on Sybase
Product: z_Archived Reporter: Edwin Tang <edwin.tang>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P2 CC: christopher.delahunt, kevin.yuan, prabaharan.vijayaratnam
Version: unspecifiedKeywords: test
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard:
Attachments:
Description Flags
proposed test case fix none

Description Edwin Tang CLA 2009-01-20 11:02:31 EST 
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)
Comment 1 Praba Vijayaratnam CLA 2009-11-24 05:05:06 EST 
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
Comment 2 Peter Krogh CLA 2009-11-27 13:41:06 EST 
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.
Comment 3 Peter Krogh CLA 2009-11-30 11:36:26 EST 
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.
Comment 4 Peter Krogh CLA 2010-06-04 14:39:08 EDT 
2.1 Bug scrubbing, deferring to 2.1.1.
Comment 5 Chris Delahunt CLA 2010-08-10 15:36:31 EDT 
*** Bug 278272 has been marked as a duplicate of this bug. ***
Comment 6 Chris Delahunt CLA 2010-08-10 15:39:44 EDT 
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.
Comment 7 Chris Delahunt CLA 2010-08-10 15:47:45 EDT 
test case Fix checked into main and 2.1.1
Comment 8 Eclipse Webmaster CLA 2022-06-09 10:24:22 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink