createNativeQuery causing SQL syntax error

[Amy Saari]

All

This took a bit to figure out so I thought I would share.

Query query = em.createNativeQuery("SELECT a, bunch, of, fields, somefield FROM atable WHERE somefield = #somefield");
query.setParameter("somefield", somefield_value);

See that # - if you're using toplink you want the # for a named substitution BUT if you're using hibernate you want a :
and somefield is a string in the above - you don't need to wrap it in quotes. toplink at least will figure it out.

sheesh....that su...ed...and yes i know, i know, blah, blah, blah....don't use native queries...more blahs...
hope the above is helpful....

Amy

[James Sutherland]

Parameters are meant to be indexed in JPA native SQL queries using the "?" marker.