We are migrating our application from Glassfish 3.1.2 to Glassfish 4.1 .Glassfish 4.1 is in full compliance with JEE 7.
There has been a issue with eclipselink 2.5.2 version which needs attention.The issue is whenever you try a persist or update operation ,you would see the generated query takes the schema name twice .This happens specially for sequence table generation.The schema name is duplicated for sequence tables.Please see the exception stack below for more understanding.
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: cross-database references are not implemented: "ngp.ngp.jpa_sequence"
Position: 8
Error Code: 0
Call: UPDATE ngp.ngp.jpa_sequence SET last_value = last_value + ? WHERE sequence_name = ?
bind => [500, AcademicDeliveryType]
Query: DataModifyQuery(name="AcademicDeliveryType" sql="UPDATE ngp.ngp.jpa_sequence SET last_value = last_value + ? WHERE sequence_name = ?")
From Eclipselink forum I came to know there is a bug with eclipselink version 2.5.2 .Please find the link here (https://www.eclipse.org/forums/index.php/t/798163/)
They fixing this issue with version 2.6 which is in development stage(https://bugs.eclipse.org/bugs/show_bug.cgi?id=445466)
The above issue needs immediate attention from Glassfish 4.1 technical support as we are unable to proceed untill this issue is fixed and a stable version of eclipselink comes bundled with Glassfish .
Any suggestion on this is highly appreciable .