Hi James,
We use the Entity manager from
EJB 3.0. We use Oracle application server and oracle database. I am not mapping my result. I just obtain it as a List<Object []> where the Object [] will contain each row information.
I have this problem only with the quoted string as mentioned in the query. I do not have a problem when the String is obtained from the data stored in the database.
FYI - I did try with the raw JDBC and it worked out fine.
Regards,
-Anand
James Sutherland wrote:Odd, what JPA provider and JDBC driver are you using?
How are you executing the native query, are you mapping the result at all?
Try executing the query through raw JDBC to see what the JDBC driver is returning.