Description Abhishek VS 2016-07-25 03:30:22 EDT

We have two tables Audit and Audit_CHECK, where Audit Check has a unique key called AUDIT_CHECK_ID which refers AUDIT_ID from AUDIT table as foreign key reference.

When we used Jconnect 6, this relation had no problem in inserting the data and retrieving the same. 

But when we migrated to Jconnect 7 and we are getting below mentioned Error.
When we insert the data manually to above mentioned tables it works fine, while doing the same using Eclipse link we are getting Error. 

Error Details: 
 Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160428-59c81c5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc4.jdbc.SybSQLException: Foreign key constraint violation occurred, dbname =  'irathomauditdb', table name = 'AUDIT_CHECK', constraint name = 'FK_AUDIT_CHECK_AUDIT_ID'.

Error Code: 546
Call: INSERT INTO AUDIT_CHECK (GSM_BRC_FILTER, NAME, RANTYPE, RNRLOGFILE, RULEFILE, TYPE, UTRAN_BRC_FILTER, AUDIT_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
        bind => [8 parameters bound]
Query: ValueReadQuery(name="SEQ_GEN_IDENTITY" sql="SELECT @@IDENTITY")


Hence request you to let us know if this is and issue from Eclipse Link. for more details or logs you can comment or contact me on below mentioned id.

id: vsabhishek27@gmail.com