Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017074Openbravo ERPA. Platformpublic2011-05-09 15:082011-05-16 16:23
Reporteradrianromero 
Assigned Toadrianromero 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP29 
Target Version2.50MP30Fixed in Version2.50MP30 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017074: Can't import products: No Dialect mapping for JDBC type
DescriptionThis happens on version 3.0.1 of initial data load

The validation of the products import fails:

Exception in component tJavaRow_18
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
    at org.hibernate.dialect.TypeNames.get(TypeNames.java:77)
    at org.hibernate.dialect.TypeNames.get(TypeNames.java:100)
    at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:375)
    at org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:590)
    at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.performDiscovery(CustomLoader.java:516)
    at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:532)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1962)
    at org.hibernate.loader.Loader.doQuery(Loader.java:802)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
    at org.hibernate.loader.Loader.doList(Loader.java:2533)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
    at org.hibernate.loader.Loader.list(Loader.java:2271)
    at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
    at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
    at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
    at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
    at org.openbravo.idl.proc.ReferenceList.getReferenceList(ReferenceList.java:74)
    at org.openbravo.idl.proc.ReferenceList.getReferenceListByName(ReferenceList.java:50)
    at org.openbravo.idl.proc.IdlService.getReferenceValue(IdlService.java:370)
    at org.openbravo.idl.initial_data_load.productjob_0_1.ProductJob.tFileInputDelimited_1Process(ProductJob.java:7213)
    at org.openbravo.idl.initial_data_load.productjob_0_1.ProductJob.runJobInTOS(ProductJob.java:7716)
    at org.openbravo.idl.initial_data_load.productjob_0_1.ProductJob.runJob(ProductJob.java:7613)
    at org.openbravo.idl.proc.ProductsProcess.runJob(ProductsProcess.java:50)
    at org.openbravo.idl.proc.IdlServiceETL.executeImport(IdlServiceETL.java:20)
    at org.openbravo.idl.proc.IdlService.executeProcess(IdlService.java:88)
    at org.openbravo.idl.form.IDL_import.doPost(IDL_import.java:103)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:456)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:427)
    at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
    at java.lang.Thread.run(Thread.java:619)
Steps To ReproduceGo to master data management > Initial Data Load > Process > Import
Select the attached cvs
Select Product as entity
Click validate
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00170733.0RC7 closed adrianromero Can't import products: No Dialect mapping for JDBC type 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-05-09 15:10adrianromeroTypedefect => backport
2011-05-09 15:10adrianromerofix_in_branch => 2.50
2011-05-09 15:11adrianromeroversionpi => 2.50MP29
2011-05-09 15:11adrianromeroTarget Version3.0RC7 => 2.50MP30
2011-05-09 19:31adrianromeroNote Added: 0036582
2011-05-09 19:31adrianromeroNote Added: 0036583
2011-05-09 19:31adrianromeroStatusscheduled => resolved
2011-05-09 19:31adrianromeroFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c3b8fa166f261455cf37f71030aa066e2db03805 [^]
2011-05-09 19:31adrianromeroResolutionopen => fixed
2011-05-09 19:32adrianromeroFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/c3b8fa166f261455cf37f71030aa066e2db03805 [^] => http://code.openbravo.com/erp/stable/2.50/rev/80dbc32ecfd63ed76086dd784023df0046a62dcf [^]
2011-05-09 19:36adrianromeroNote Added: 0036584
2011-05-16 16:23ioritzCiaStatusresolved => closed
2011-05-16 16:23ioritzCiaFixed in Version => 2.50MP30

Notes
(0036582)
adrianromero   
2011-05-09 19:31   
Repository: erp/stable/2.50
Changeset: e8f0359d2a728f10f17cb9393fde5b703bd2f73d
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon May 09 17:18:13 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/e8f0359d2a728f10f17cb9393fde5b703bd2f73d [^] [^]

Test case for issue 17058 Can't import products: No Dialect mapping for JDBC type

---
M src-test/org/openbravo/test/dal/IssuesTest.java
---
(0036583)
adrianromero   
2011-05-09 19:31   
Repository: erp/stable/2.50
Changeset: 80dbc32ecfd63ed76086dd784023df0046a62dcf
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon May 09 17:21:14 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/80dbc32ecfd63ed76086dd784023df0046a62dcf [^] [^]

Fixes issue 17058 Can't import products: No Dialect mapping for JDBC type
A new mapping has been added for NVARCHAR for the Oracle dialog

---
M src/org/openbravo/base/session/OBOracle10gDialect.java
---
(0036584)
adrianromero   
2011-05-09 19:36   
*Testing the issue

In Oracle, kindly follow the steps to test and verify that no error is thrown.

It can also been tested with the new JUnit test of the note.

* Other areas affected

This fix affects Hibernate native SQL queries with NVARCHAR and NCHAR fields in Oracle. It is supposed that this change fixes all these queries.