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.