Bug 278272

Summary:	SQLServer: StoredProcWithOutputParamsAndResultSetTest failed
Product:	z_Archived	Reporter:	Edwin Tang <edwin.tang>
Component:	Eclipselink	Assignee:	Kevin Yuan <kevin.yuan>
Status:	CLOSED DUPLICATE	QA Contact:
Severity:	normal
Priority:	P3	CC:	christopher.delahunt, kevin.yuan, michael.f.obrien
Version:	unspecified	Keywords:	test
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Whiteboard:
Bug Depends on:
Bug Blocks:	299418

Description Edwin Tang

2009-05-28 15:16:35 EDT

org.eclipse.persistence.testing.tests.customsqlstoredprocedures.StoredProcWithOutputParamsAndResultSetTest failed with SQL Server 2k5

Stack Trace:
============
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '='. Error Code: 102 Call: EXECUTE Select_Output_and_ResultSet ARG1 = 1, @VERSION = ? bind => [=> version] Query: ReadAllQuery(name="dblogin" referenceClass=Employee sql="EXECUTE Select_Output_and_ResultSet ARG1 = ?, @VERSION = ? ")

Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.1.v20090430-r4097): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '='.
Error Code: 102
Call: EXECUTE Select_Output_and_ResultSet ARG1 = 1, @VERSION = ?
bind => [=> version]
Query: ReadAllQuery(name="dblogin" referenceClass=Employee sql="EXECUTE Select_Output_and_ResultSet ARG1 = ?, @VERSION = ? ")
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:332)
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:481)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:928)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:664)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:889)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:458)
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.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '='.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at org.eclipse.persistence.platform.database.SQLServerPlatform.executeStoredProcedure(SQLServerPlatform.java:357)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:568)

Comment 1 Edwin Tang

2009-05-28 15:33:40 EDT

Refer to the bug with Sybase
https://bugs.eclipse.org/bugs/show_bug.cgi?id=261663

Comment 2 Kevin Yuan

2010-03-10 09:11:01 EST


*** This bug has been marked as a duplicate of bug 299418 ***

Comment 3 Kevin Yuan

2010-03-10 09:37:53 EST

This bug is still there, and should depend on the block bug (299418) fixed.

Comment 4 Kevin Yuan

2010-06-03 14:43:10 EDT

This bug fix did not make the cut off for 2.1. We are deferring the bugs to
Future where we can properly sort them all together and severity. And then
assign them accordingly to future patch sets and releases.

Comment 5 Chris Delahunt

2010-08-10 15:36:31 EDT

I believe this is an issue with the test case; a duplicate of 261663.  Test is missing the argument qualifier in the SQL defined for the custom SQL setting on ARG1.

*** This bug has been marked as a duplicate of bug 261663 ***

Comment 6 Eclipse Webmaster

2022-06-09 10:09:38 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink