I'm getting similar errors from toplink/MSSQLServer, eclipselink/MSSQLServer and toplink/Oracle from my sample JPA program. I want it to the little ddl dance and create the appropriate tables in these empty database.
Can someone guide me on my selection of jpa providers and help me correct this problem? This program (with a similar persistence.xml) works with Hypersonic SQL and ObjectDB.
Can someone help me with the queries? I'm new to HQL and JPA QL. These queries worked with ObjectDB and HSQL (I think I got them to work in H2 too -- not sure) and I was expecting them to work with other databases like Oracle/MSSQL.
Is that not a reasonable expectation?
I think these are HQL or JPA QL statements -- are not they?
Here they are. Can you help me rewrite them so they will work with JPA QL and Oracle and MSSQL?
Joined: Aug 11, 2000
OK, so I commented out some code and tried executing a persist function instead of a query statement and I get this error:
I think I need to do something different to toplink but I'm not sure what.
Joined: Oct 01, 2007
The first error seemed to be related to your code being compiled with JPA 2.0, but your runtime using TopLink Essentials that only support JPA 1.0.
Consider upgrading to EclipseLink (TopLink 11g).
Your second error seemed to occur because you have not packaged or deployed your application correctly. Ensure you list your classes in the persistence.xml, and that they are annotated with @Entity.