Register / Login
Win a copy of
Java Mock Exams (software)
this week in the
Programmer Certification (OCPJP)
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
Object Relational Mapping
again array mapping
posted 7 years ago
I have user function in my PostgreSQL database that returns user defined type containing int and double precision  columns. Until now I have been using
4.2.3 and by adding
<mapping> <java-type>java.sql.Array</java-type> <jdbc-type>ARRAY</jdbc-type> <sql-type>ARRAY</sql-type> </mapping>
to server/default/conf/standardjbosscmp-jdbc.xml I was able to get the result correctly mapped to
Now I have switched to JBoss 5 and all this entity manager stuff. I try to invoke my function:
entityManager.createNativeQuery("SELECT * FROM my_func(?,?,?,?)").setParameter(1, .....
and I still keep getting org.hibernate.MappingException: No Dialect mapping for
I there any simple way to fix this? I thought using native query will bypass all hibernate restrictions/default mappings and will work as java.sql.Connection.prepareStatement or prepareCall...
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
Boost this thread!
stuck up in the problem
JBoss 4.0 and MSSQL Server 2000
How to map Oracle ORDImage type in standardjbosscmp-jdbc.xml
CMP 2.0 problem in Jboss 4.0.2
javax.jms.JMSSecurityException: User null is NOT authenticated