Description Praba Vijayaratnam 2011-08-15 09:10:39 EDT

This maybe related to bug 295997(Sybase-DataDirect), but failed with different exception for same SQL code.
Exception points to 'bind' section of SQL code issued.
--------
Test Env:
----------
Sybase 15.5
jconnect3.jar
JDK 1.6.0-26

Models failed:
----------- 
org.eclipse.persistence.testing.tests.customsqlstoredprocedures.CustomSQLTestModel.CustomSQLTestModel
org.eclipse.persistence.testing.tests.workbenchintegration.MappingWMIntegrationStoredProcedureTestModel.MappingWMIntegrationStoredProcedureTestModel

Local Exception Stack:
---------------------
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20110813-r9886): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0TC: Attempted conversion between an illegal pair of types.
Error Code: 0
Call: EXECUTE Insert_Employee @EMP_ID = ?, @SALARY = ?, @END_DATE = ?, @MANAGER_ID = ?, @START_DATE = ?, @F_NAME = ?, @L_NAME = ?, @GENDER = ?, @ADDR_ID = ?, @VERSION = ?, @START_TIME = ?, @END_TIME = ?, @OUT_VERSION = ? OUTPUT
bind => [13 parameters bound]
Query: InsertObjectQuery(Employee: Fred Jones)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.buildOutputRow(DatabaseAccessor.java:260)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:910)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1713)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:1192)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObject(DatabaseQueryMechanism.java:385)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:472)
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287)
at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1512)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1494)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1445)
at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:191)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:136)
at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3795)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1505)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitRootUnitOfWork(UnitOfWorkImpl.java:1325)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commit(UnitOfWorkImpl.java:1087)
at org.eclipse.persistence.testing.models.employee.relational.EmployeeSystem.populate(EmployeeSystem.java:164)
at org.eclipse.persistence.testing.framework.TestSystem.run(TestSystem.java:179)