[Persistence, JBoss/CMP, Hibernate, Database] - MappingException: JDBC Type -1(MySQL 5) - jboss-user

Tuesday, 1 July 2008

Hi? I'm using JBOSS-4.2.2, Mysql - 5.0.51a-0. Connector driver - 
mysql-connector-java-5.1.6. 
When using Native Queries (for example :
        Query query =getEntityManager().createNativeQuery("SELECT agr.AGREEMENTID ,
enc.NAME\n" +
  |                 "\tFROM GEL$DOC$AGREEMENT agr INNER JOIN GEL$DOC$AGR$ENCLOSURE
enc ON (enc.AGREEMENTID = agr.AGREEMENTID)\n" +
  |                 "UNION\n" +
  |                 "SELECT template.TEMPLATEID, tenc.NAME\n" +
  |                 "\tFROM GEL$DOC$TEMPLATE template INNER JOIN
GEL$DOC$TPL$PARAGRAPH tenc ON (tenc.TEMPLATEID = template.TEMPLATEID)") ;
  | 
  |         List<Object[]> obj = query.getResultList() ;
  | ) 
I get an error:

15:54:53,509 ERROR [STDERR] javax.ejb.EJBException: javax.persistence.Persistenc          
                                                                  eException:
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
  | 15:54:53,510 ERROR [STDERR]     at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptio      

nInOurTx(Ejb3TxPolicy.java:63)
  | 15:54:53,510 ERROR [STDERR]     at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(T      
                                                                      xPolicy.java:83)
  | 15:54:53,510 ERROR [STDERR]     at org.jboss.aspects.tx.TxInterceptor$Required.i      

nvoke(TxInterceptor.java:191)
  | 15:54:53,510 ERROR [STDERR]     at org.jboss.aop.joinpoint.MethodInvocation.invo      

keNext(MethodInvocation.java:101)
  | 15:54:53,510 ERROR [STDERR]     at org.jboss.aspects.tx.TxPropagationInterceptor      

.invoke(TxPropagationInterceptor.java:95)
  | 15:54:53,510 ERROR [STDERR]     at org.jboss.aop.joinpoint.MethodInvocation.invo      

keNext(MethodInvocation.java:101)
  | 15:54:53,510 ERROR [STDERR]     at org.jboss.ejb3.stateless.StatelessInstanceInt      

erceptor.invoke(StatelessInstanceInterceptor.java:62)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.aop.joinpoint.MethodInvocation.invo      

keNext(MethodInvocation.java:101)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.aspects.security.AuthenticationInte      

rceptor.invoke(AuthenticationInterceptor.java:77)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.ejb3.security.Ejb3AuthenticationInt      

erceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.aop.joinpoint.MethodInvocation.invo      

keNext(MethodInvocation.java:101)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.ejb3.ENCPropagationInterceptor.invo      

ke(ENCPropagationInterceptor.java:46)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.aop.joinpoint.MethodInvocation.invo      

keNext(MethodInvocation.java:101)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.ejb3.asynchronous.AsynchronousInter      

ceptor.invoke(AsynchronousInterceptor.java:106)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.aop.joinpoint.MethodInvocation.invo      

keNext(MethodInvocation.java:101)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.ejb3.stateless.StatelessContainer.l      

ocalInvoke(StatelessContainer.java:240)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.ejb3.stateless.StatelessContainer.l      

ocalInvoke(StatelessContainer.java:210)
  | 15:54:53,511 ERROR [STDERR]     at org.jboss.ejb3.stateless.StatelessLocalProxy.      

invoke(StatelessLocalProxy.java:84)
  | 15:54:53,511 ERROR [STDERR]     at $Proxy314.store(Unknown Source)
  | 15:54:53,511 ERROR [STDERR]     at ru.geckoSoftware.geleos.documents.faces.agree      

ment.AgreementInfo.store(Unknown Source)
  | 15:54:53,511 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(      
                                                                      Native Method)
  | 15:54:53,512 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke(N      

ativeMethodAccessorImpl.java:39)
  | 15:54:53,512 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invo      

ke(DelegatingMethodAccessorImpl.java:25)
  | 15:54:53,512 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:5      
                                                                      85)
  | 15:54:53,512 ERROR [STDERR]     at org.apache.myfaces.el.MethodBindingImpl.invok      

e(MethodBindingImpl.java:129)
  | 15:54:53,512 ERROR [STDERR]     at org.apache.myfaces.application.ActionListener      

Impl.processAction(ActionListenerImpl.java:63)
  | 15:54:53,512 ERROR [STDERR]     at javax.faces.component.UICommand.broadcast(UIC      
                                                                      ommand.java:106)
  | 15:54:53,512 ERROR [STDERR]     at org.ajax4jsf.component.AjaxViewRoot.processEv      

ents(AjaxViewRoot.java:184)
  | 15:54:53,512 ERROR [STDERR]     at org.ajax4jsf.component.AjaxViewRoot.broadcast      

Events(AjaxViewRoot.java:162)
  | 15:54:53,512 ERROR [STDERR]     at org.ajax4jsf.component.AjaxViewRoot.processAp      

plication(AjaxViewRoot.java:350)
  | 15:54:53,512 ERROR [STDERR]     at org.apache.myfaces.lifecycle.LifecycleImpl.in      

vokeApplication(LifecycleImpl.java:343)
  | 15:54:53,512 ERROR [STDERR]     at org.apache.myfaces.lifecycle.LifecycleImpl.ex      

ecute(LifecycleImpl.java:86)
  | 15:54:53,512 ERROR [STDERR]     at javax.faces.webapp.FacesServlet.service(Faces      
                                                                      Servlet.java:137)
  | 15:54:53,512 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterCha      

in.internalDoFilter(ApplicationFilterChain.java:290)
  | 15:54:53,512 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterCha      

in.doFilter(ApplicationFilterChain.java:206)
  | 15:54:53,513 ERROR [STDERR]     at org.apache.myfaces.webapp.filter.ExtensionsFi      

lter.doFilter(ExtensionsFilter.java:100)
  | 15:54:53,513 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterCha      

in.internalDoFilter(ApplicationFilterChain.java:235)
  | 15:54:53,513 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterCha      

in.doFilter(ApplicationFilterChain.java:206)
  | 15:54:53,513 ERROR [STDERR]     at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter      

(BaseXMLFilter.java:141)
  | 15:54:53,513 ERROR [STDERR]     at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseF      
                                                                      ilter.java:281)
  | 15:54:53,513 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterCha      

in.internalDoFilter(ApplicationFilterChain.java:235)
  | 15:54:53,513 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterCha      

in.doFilter(ApplicationFilterChain.java:206)
  | 15:54:53,513 ERROR [STDERR]     at org.apache.myfaces.webapp.filter.ExtensionsFi      

lter.doFilter(ExtensionsFilter.java:147)
  | 15:54:53,513 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterCha      

in.internalDoFilter(ApplicationFilterChain.java:235)
  | 15:54:53,513 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterCha      

in.doFilter(ApplicationFilterChain.java:206)
  | 15:54:53,513 ERROR [STDERR]     at org.jboss.web.tomcat.filters.ReplyHeaderFilte      

r.doFilter(ReplyHeaderFilter.java:96)
  | 15:54:53,513 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterCha      

in.internalDoFilter(ApplicationFilterChain.java:235)
  | 15:54:53,513 ERROR [STDERR]     at org.apache.catalina.core.ApplicationFilterCha      

in.doFilter(ApplicationFilterChain.java:206)
  | 15:54:53,514 ERROR [STDERR]     at org.apache.catalina.core.StandardWrapperValve      

.invoke(StandardWrapperValve.java:230)
  | 15:54:53,514 ERROR [STDERR]     at org.apache.catalina.core.StandardContextValve      

.invoke(StandardContextValve.java:175)
  | 15:54:53,514 ERROR [STDERR]     at org.jboss.web.tomcat.security.SecurityAssocia      

tionValve.invoke(SecurityAssociationValve.java:179)
  | 15:54:53,514 ERROR [STDERR]     at org.apache.catalina.authenticator.Authenticat      

orBase.invoke(AuthenticatorBase.java:524)
  | 15:54:53,514 ERROR [STDERR]     at org.jboss.web.tomcat.security.JaccContextValv      

e.invoke(JaccContextValve.java:84)
  | 15:54:53,514 ERROR [STDERR]     at org.apache.catalina.core.StandardHostValve.in      

voke(StandardHostValve.java:127)
  | 15:54:53,514 ERROR [STDERR]     at org.apache.catalina.valves.ErrorReportValve.i      

nvoke(ErrorReportValve.java:102)
  | 15:54:53,514 ERROR [STDERR]     at org.jboss.web.tomcat.service.jca.CachedConnec      

tionValve.invoke(CachedConnectionValve.java:157)
  | 15:54:53,514 ERROR [STDERR]     at org.apache.catalina.core.StandardEngineValve.      

invoke(StandardEngineValve.java:109)
  | 15:54:53,514 ERROR [STDERR]     at org.apache.catalina.connector.CoyoteAdapter.s      

ervice(CoyoteAdapter.java:262)
  | 15:54:53,514 ERROR [STDERR]     at org.apache.coyote.http11.Http11Processor.proc      

ess(Http11Processor.java:844)
  | 15:54:53,514 ERROR [STDERR]     at org.apache.coyote.http11.Http11Protocol$Http1      

1ConnectionHandler.process(Http11Protocol.java:583)
  | 15:54:53,514 ERROR [STDERR]     at org.apache.tomcat.util.net.JIoEndpoint$Worker      

.run(JIoEndpoint.java:446)
  | 15:54:53,515 ERROR [STDERR]     at java.lang.Thread.run(Thread.java:595)
  | 15:54:53,515 ERROR [STDERR] Caused by: javax.persistence.PersistenceException: o      

rg.hibernate.MappingException: No Dialect mapping for JDBC type: -1
  | 15:54:53,515 ERROR [STDERR]     at org.hibernate.ejb.AbstractEntityManagerImpl.t      

hrowPersistenceException(AbstractEntityManagerImpl.java:629)
  | 15:54:53,515 ERROR [STDERR]     at org.hibernate.ejb.QueryImpl.getResultList(Que      
                                                                      ryImpl.java:73)
  | 15:54:53,515 ERROR [STDERR]     at ru.geckoSoftware.geleos.service.documents.agr      

eement.AgreementServiceImpl.store(Unknown Source)
  | 15:54:53,516 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(      
                                                                      Native Method)
  | 15:54:53,516 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke(N      

ativeMethodAccessorImpl.java:39)
  | 15:54:53,516 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invo      

ke(DelegatingMethodAccessorImpl.java:25)
  | 15:54:53,516 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:5      
                                                                      85)
  | 15:54:53,516 ERROR [STDERR]     at org.jboss.aop.joinpoint.MethodInvocation.invo      

keNext(MethodInvocation.java:112)
  | 15:54:53,516 ERROR [STDERR]     at org.jboss.ejb3.interceptor.InvocationContextI      

mpl.proceed(InvocationContextImpl.java:166)
  | 15:54:53,516 ERROR [STDERR]     at org.jboss.ejb3.interceptor.EJB3InterceptorsIn      

terceptor.invoke(EJB3InterceptorsInterceptor.java:63)
  | 15:54:53,516 ERROR [STDERR]     at org.jboss.aop.joinpoint.MethodInvocation.invo      

keNext(MethodInvocation.java:101)
  | 15:54:53,516 ERROR [STDERR]     at org.jboss.ejb3.entity.TransactionScopedEntity      

ManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
  | 15:54:53,516 ERROR [STDERR]     at org.jboss.aop.joinpoint.MethodInvocation.invo      

keNext(MethodInvocation.java:101)
  | 15:54:53,516 ERROR [STDERR]     at org.jboss.ejb3.AllowedOperationsInterceptor.i      

nvoke(AllowedOperationsInterceptor.java:47)
  | 15:54:53,516 ERROR [STDERR]     at org.jboss.aop.joinpoint.MethodInvocation.invo      

keNext(MethodInvocation.java:101)
  | 15:54:53,516 ERROR [STDERR]     at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(T      
                                                                      xPolicy.java:79)
  | 15:54:53,517 ERROR [STDERR]     ... 60 more
  | 15:54:53,517 ERROR [STDERR] Caused by: org.hibernate.MappingException: No Dialec      
                                                                      t mapping for JDBC
type: -1
  | 15:54:53,517 ERROR [STDERR]     at org.hibernate.dialect.TypeNames.get(TypeNames      
                                                                      .java:56)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.dialect.TypeNames.get(TypeNames      
                                                                      .java:81)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.dialect.Dialect.getHibernateTyp      

eName(Dialect.java:370)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.loader.custom.CustomLoader$Meta      

data.getHibernateType(CustomLoader.java:559)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.loader.custom.CustomLoader$Scal      

arResultColumnProcessor.performDiscovery(CustomLoader.java:485)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.loader.custom.CustomLoader.auto      

DiscoverTypes(CustomLoader.java:501)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.loader.Loader.getResultSet(Load      
                                                                      er.java:1796)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.loader.Loader.doQuery(Loader.ja      
                                                                      va:674)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.loader.Loader.doQueryAndInitial      

izeNonLazyCollections(Loader.java:236)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.loader.Loader.doList(Loader.jav      
                                                                      a:2220)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.loader.Loader.listIgnoreQueryCa      

che(Loader.java:2104)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.loader.Loader.list(Loader.java:      
                                                                      2099)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.loader.custom.CustomLoader.list      

(CustomLoader.java:289)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.impl.SessionImpl.listCustomQuer      

y(SessionImpl.java:1695)
  | 15:54:53,518 ERROR [STDERR]     at org.hibernate.impl.AbstractSessionImpl.list(A      

bstractSessionImpl.java:142)
  | 15:54:53,519 ERROR [STDERR]     at org.hibernate.impl.SQLQueryImpl.list(SQLQuery      
                                                                      Impl.java:152)
  | 15:54:53,519 ERROR [STDERR]     at org.hibernate.ejb.QueryImpl.getResultList(Que      
                                                                      ryImpl.java:64)
  | 15:54:53,519 ERROR [STDERR]     ... 74 more
  | 

Here is my persistence.xml :

  | <persistence>
  |     <persistence-unit name="GP">
  |         <jta-data-source>java:/GPDS</jta-data-source>
  |         <properties>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <property
name="hibernate.dialect"
value="org.hibernate.dialect.MySQLDialect"/>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <property
name="hibernate.hbm2ddl.auto" value=""/>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <property
name="hibernate.show_sql" value="false" />
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <property
name="hibernate.use_outer_join" value="true" />
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <property
name="hibernate.max_fetch_depth" value="0" />
  |             <property name="com.intellij.javaee.persistence.datasource"
value="252"/>
  |             <!--<property
name="connection.url">jdbc:mysql://195.34.12.76:3306/geleos</property> 
              <property
name="connection.username">geleos</property>-->
  | 	        <!--<property
name="connection.driver_class">com.mysql.jdbc.Driver</property>        
   <property name="connection.password">geleos</property>-->
  |         </properties>
  |     </persistence-unit>
  | </persistence>
  | 

And application-ds.xml

  | <datasources>
  |     <local-tx-datasource>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <jndi-name>GPDS</jndi-name>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 
<connection-url>jdbc:mysql://192.168.0.251:3306/geleos?zeroDateTimeBehavior=convertToNull</connection-url>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 
<driver-class>com.mysql.jdbc.Driver</driver-class>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <user-name>user</user-name>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <password>pswd</password>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <connection-property
name="autoReconnect">true</connection-property>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <connection-property
name="autoReconnectForPools">true</connection-property>ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 
  |         <!--<metadata>-->
  | <!--ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 
<type-mapping>mySQL</type-mapping>-->
  | <!--ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  </metadata>-->
  | ÃÂ 
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <min-pool-size>5</min-pool-size>
  | ÃÂ 
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  <max-pool-size>30</max-pool-size>
  | ÃÂ 
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 
<idle-timeout-minutes>30</idle-timeout-minutes>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 
  |        
<exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name>
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 
  | ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 
<valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name>
   </local-tx-datasource>
  | </datasources>

When using non native queries everithing is ok.

View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4161753#...

Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[Persistence, JBoss/CMP, Hibernate, Database] - MappingException: JDBC Type -1(MySQL 5)