payara 5.181 full... jpa (eclipselink issue with TIMESTAMP format)

100 views
Skip to first unread message

Peter Belbin

unread,
Apr 4, 2018, 1:39:59 AM4/4/18
to Payara Forum
I am seeing an exception showing up in the server log files which appears to have a bug raised for it in eclipselink


this is causing me some pain.  things that should be working, are not working.


Local Exception Stack:
Exception [EclipseLink-3005] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.ConversionException
Exception Description: Incorrect timestamp format: [2012-05-05 11:30:00+00] (expected [YYYY-MM-DD HH:MM:SS.NNNNNNNNN])
        at org.eclipse.persistence.exceptions.ConversionException.incorrectTimestampFormat(ConversionException.java:139)
        at org.eclipse.persistence.internal.helper.Helper.timestampFromString(Helper.java:2074)
        at org.eclipse.persistence.internal.helper.ConversionManager.convertObjectToTimestamp(ConversionManager.java:757)
        at org.eclipse.persistence.internal.helper.ConversionManager.convertObject(ConversionManager.java:112)
        at org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform.convertObject(DatasourcePlatform.java:203)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.getObjectThroughOptimizedDataConversion(DatabaseAccessor.java:1386)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.getObject(DatabaseAccessor.java:1271)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.fetchRow(DatabaseAccessor.java:1080)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processResultSet(DatabaseAccessor.java:748)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:661)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:564)
        at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2093)
        at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:600)
        at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:261)
        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:270)
        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:256)
        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:742)
        at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2803)
        at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2756)
        at org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:559)
        at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1221)
        at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911)
        at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1180)
        at org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:445)
        at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1268)
        at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2979)
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1892)
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1874)
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1824)
        at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:1004)
        at org.eclipse.persistence.internal.jpa.EntityManagerImpl.findInternal(EntityManagerImpl.java:946)
        at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:822)
        at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:688)
        at com.sun.enterprise.container.common.impl.EntityManagerWrapper.find(EntityManagerWrapper.java:342)

Peter Belbin

unread,
Apr 5, 2018, 1:42:49 PM4/5/18
to Payara Forum
I should probably add that I'm using the postgresql 9.4 db with their latest jdbc driver, with db having the column defined as 'timestamp with time zone'.

Ondro Mihályi

unread,
May 19, 2018, 2:35:07 AM5/19/18
to Peter Belbin, Payara Forum
This seems like an issue to fix. Please raise an issue on Payara's github.

Thanks

Dňa št 5. 4. 2018, 19:42 Peter Belbin <pbe...@gmail.com> napísal(a):
I should probably add that I'm using the postgresql 9.4 db with their latest jdbc driver, with db having the column defined as 'timestamp with time zone'.

--
You received this message because you are subscribed to the Google Groups "Payara Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to payara-forum...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/payara-forum/b28c5825-4be6-427e-92fe-2b9082c3b20d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages