public Date getSystemDate() {
Query query = getEntityManager().createNativeQuery("select systimestamp from dual");
Object result[] = (Object[]) query.getSingleResult();
return (Date) result[0];
}
This throws
java.lang.ClassCastException: org.eclipse.persistence.internal.helper.NonSynchronizedVector
on the getSingleResult Line.
(The return statement is probably wrong, too, but it doesn't seem to be getting there...)
Thanks.
On Mar 24, 2009, at 12:44 PM, Gordon Yorke wrote:
Why is this not working? Are you getting an exception? You should expects an Object[] with a single element of timestamp.
--Gordon
David Parker wrote:
I need to execute a "select systimestamp from dual" against a 10g database. I'd like to use a JPA nativeQuery rather than going to JDBC, but I cannot for the life of me figure out how to get a timestamp object back from a Query.getSingleResult().
I just want to get a system time from a central place (the database) in a distributed system. Is there a better way to do this, if it isn't possible via a jpa native query?
=============================================
David Parker
dap@xxxxxxxxxxxxxxxxxxxx
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxxhttps://dev.eclipse.org/mailman/listinfo/eclipselink-users
=============================================
David Parker
