Single quote in Oracle native query incorrectly maps to java Character instead of java String --------------------------------------------------------------------------------------------- Key: HHH-3925 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3925 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.2.2 Reporter: andrew zimmer Hi Folks, This little snippet results in a ClassCastException because Hibernate thinks that the single quote in my native query in an Oracle database should be mapped to a Character. It should map to a String. Query q = em.createNativeQuery("select 'fuz','buz' from dual"); List<Object[]> rows = q.getResultList(); System.out.println("Value: " + rows.iterator().next()[0]); System.out.println((String)(rows.iterator().next()[0])); The above throws java.lang.ClassCastException: java.lang.Character. I have figured out that using a bind variable (example below) instead does the right thing, but this seriously impairs my ability to write a plain SQL String in one method and then pass it into a general purpose method that would do a simple EntityManager.createNativeQuery().getResultList(). The general purpose "execute this piece of SQL for me" won't work because it has to be aware of the bind variables, which is exactly what I"m trying to avoid. Query q = em.createNativeQuery("select :v1,'buz' from dual"); q.setParameter("v1","fuz"); List<Object[]> rows = q.getResultList(); System.out.println("Value: " + rows.iterator().next()[0]); System.out.println((String)(rows.iterator().next()[0])); regards, andrew -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira