Eclipse Community Forums: Dali » Unable to get Entity back from database as the Entity object.

Home » Eclipse Projects » Dali » Unable to get Entity back from database as the Entity object.(Data is returned as a java.lang.Object not my Entity object.)

Unable to get Entity back from database as the Entity object. [message #665241]

Wed, 13 April 2011 16:28

Eclipse User

So, I am up and running with Helios (for Java EE Developers) and trying to hit our databasae (Sybase) to retrieve data from some (any) table.

Also installed EclipseLink 2.0 (did I need this?)

I created a Java class to align with a DB table and added javax.persistence.* annotations, setter and getters and implemented Serializable.

I have test code that uses EntityManagerFactory to get an EntityManager that uses createNativeQuery(...).getResultList() and I do get a result list. However the result list contains Objects rather than my Entity objects. While debuging I can see the contents of the object but get a casting exception anytime I try to use the Object as an Entity.

I then found the "Entities From Tables" and re-generated my entity this way - essentially the same class but, still get the same Object result.
[Ljava.lang.Object; cannot be cast to com.jpa.test.ImagePerson
at com.jpa.test.Main.main(Main.java:29)

What am I missing, doing wrong or not doing?

-mike

Re: Unable to get Entity back from database as the Entity object. [message #665259 is a reply to message #665241]

Wed, 13 April 2011 18:09

Eclipse User

You don't need EclipseLink specifically, but you do need a JPA implementation, which EclipseLink provides.

Did you pass a resultClass parameter to createNativeQuery(...)? If not, this would explain why you got back objects instead of instances of your entity.

If you are getting started with JPA, I recommend picking up "Pro JPA 2" by Mike Keith and Merrick Schincariol.

Neil

Re: Unable to get Entity back from database as the Entity object. [message #665265 is a reply to message #665259]

Wed, 13 April 2011 19:27

Eclipse User

I wondered if Dali was doing somthing that you once needed EclipseLink (or other, Hibernate, OpenLink, etc.) for - OK so that's not the issue.

Yes I passed a simple SQL "SELECT * FROM tableName" for the method call.

Thanks for the book recommendation, new to Web Services in general (not just JPA) - coming from core and OSGi programming.

Re: Unable to get Entity back from database as the Entity object. [message #665526 is a reply to message #665259]

Thu, 14 April 2011 18:35

Eclipse User

So, after RTFM . . .

I was not using the EntityManager [em.createNativeQuery()] methods properly. It accepts native SQL or JPQL with/without the Entity class and when I understood the how and why it worked as expected.

Thanks again for the book recommendation.

Previous Topic:	Unable to generate JAXB classes
Next Topic:	provisional API changes

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 04 16:33:54 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter