Odd Exception when retrieving a datarow [message #997147] |
Fri, 04 January 2013 00:00 |
Wan Li Messages: 4 Registered: December 2012 |
Junior Member |
|
|
Hi All,
I had posted an earlier topic about retrieving TimeZone information using Oracle's TIMESTAMPTZ datatype when associated to a Calendar type within an entity class.
I have that working, where I can persist and retrieve timezone information. However, whenever I run a NamedQuery to retrieve datarows from a table that contains the TIMESTAMPTZ type, i get the follow WARNING exception in my glassfish log:
WARNING: java.lang.ClassNotFoundException: com.sun.gjc.spi.base.ConnectionHolder
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:423)
at java.lang.ClassLoader.loadClass(ClassLoader.java:356)
at org.eclipse.persistence.platform.server.sunas.SunAS9ServerPlatform.unwrapGlassFishConnectionHelper(SunAS9ServerPlatform.java:124)
at org.eclipse.persistence.platform.server.sunas.SunAS9ServerPlatform.unwrapConnection(SunAS9ServerPlatform.java:105)
at org.eclipse.persistence.platform.database.oracle.Oracle8Platform.getConnection(Oracle8Platform.java:104)
at org.eclipse.persistence.platform.database.oracle.Oracle9Platform.getTIMESTAMPTZFromResultSet(Oracle9Platform.java:199)
at org.eclipse.persistence.platform.database.oracle.Oracle9Platform.getObjectFromResultSet(Oracle9Platform.java:166)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.getObject(DatabaseAccessor.java:1206)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.fetchRow(DatabaseAccessor.java:999)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processResultSet(DatabaseAccessor.java:723)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:621)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:566)
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.executeSelectCall(DatasourceCallQueryMechanism.java:264)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:648)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2617)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2554)
at org.eclipse.persistence.queries.ReportQuery.executeDatabaseQuery(ReportQuery.java:846)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1043)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:392)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1131)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1463)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:485)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:742)
This is the query that generated the issue:
FINE: SELECT t0.ID, t0.COMMENTS_OVERRIDE, t0.DESCRIPTION_OVERRIDE, t0.END_DATE_TIME, t0.LOCATION_ADDR_OVERRIDE, t0.RECORD_STATUS, t0.START_DATE_TIME, t0.APPT_EVENT_ID, t0.LOCATION_TYPE_OVERRIDE, t0.TENANT_ID FROM APPT_ELEMENT t0, APPT_EVENT_CONTACTS t2, APPT_EVENT t1 WHERE (((((t0.TENANT_ID = ?) AND (t0.START_DATE_TIME > ?)) AND (t0.START_DATE_TIME < ?)) AND (t2.USER_ID = ?)) AND ((t1.ID = t2.APPT_EVENT_ID) AND (t0.APPT_EVENT_ID = t1.ID)))
bind => [98, 2012-12-30 00:00:00.0, 2013-02-10 00:00:00.0, 3]
The odd thing is, the program doesn't crash, and I actually get all the rows returned to me from the query with the correct timezone information in my Calendar object.
Is this perhaps an issue with GlassFish?
Has anyone ever seen this before or have any thoughts?
I am using Oracle 11 Platform, and GlassFish 3.1.2.2.
I saw this on EclipseLink 2.3.2 and 2.3.3
Thanks!
[Updated on: Fri, 04 January 2013 00:01] Report message to a moderator
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03048 seconds