Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017058ModulesInitial data loadpublic2011-05-06 20:212011-05-12 13:31
Reporterelopio 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0017058: 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
duplicate of defect 00170733.0RC7 closed adrianromero Openbravo ERP Can't import products: No Dialect mapping for JDBC type 
Attached Filescsv Products.csv (1,819) 2011-05-06 20:21
https://issues.openbravo.com/file_download.php?file_id=3950&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-05-06 20:21elopioNew Issue
2011-05-06 20:21elopioAssigned To => mirurita
2011-05-06 20:21elopioFile Added: Products.csv
2011-05-06 20:21elopioOBNetwork customer => No
2011-05-09 09:40miruritaAssigned Tomirurita => adrianromero
2011-05-09 12:38adrianromeroNote Added: 0036558
2011-05-09 13:50shuehnerIssue Monitored: shuehner
2011-05-09 15:09adrianromeroRelationship addedduplicate of 0017073
2011-05-09 15:09adrianromeroNote Added: 0036568
2011-05-09 15:09adrianromeroStatusnew => closed
2011-05-09 15:09adrianromeroResolutionopen => duplicate
2011-05-09 17:02hgbotCheckin
2011-05-09 17:02hgbotNote Added: 0036573
2011-05-09 17:02hgbotCheckin
2011-05-09 17:02hgbotNote Added: 0036574
2011-05-09 17:02hgbotStatusclosed => resolved
2011-05-09 17:02hgbotResolutionduplicate => fixed
2011-05-09 17:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c3b8fa166f261455cf37f71030aa066e2db03805 [^]
2011-05-09 17:08adrianromeroStatusresolved => closed
2011-05-09 19:29hgbotCheckin
2011-05-09 19:29hgbotNote Added: 0036579
2011-05-09 19:29hgbotCheckin
2011-05-09 19:29hgbotNote Added: 0036580
2011-05-09 19:29hgbotStatusclosed => resolved
2011-05-09 19:29hgbotFixed 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:33adrianromeroStatusresolved => closed
2011-05-12 13:31hudsonbotCheckin
2011-05-12 13:31hudsonbotNote Added: 0036867
2011-05-12 13:31hudsonbotCheckin
2011-05-12 13:31hudsonbotNote Added: 0036868

Notes
(0036558)
adrianromero   
2011-05-09 12:38   
This problem is raised problably because it is needed a new mapping in the Oracle Dialog class:


diff --git a/src/org/openbravo/base/session/OBOracle10gDialect.java b/src/org/openbravo/base/session/OBOracle10gDialect.java
--- a/src/org/openbravo/base/session/OBOracle10gDialect.java
+++ b/src/org/openbravo/base/session/OBOracle10gDialect.java
@@ -40,6 +40,7 @@
     super();
 
     registerHibernateType(Types.NUMERIC, StandardBasicTypes.LONG.getName());
+ registerHibernateType(Types.NVARCHAR, StandardBasicTypes.STRING.getName());
 
     registerColumnType(Types.VARCHAR, 4000, "nvarchar2($l)");
     registerColumnType(Types.VARCHAR, 100, "varchar2($l)");
(0036568)
adrianromero   
2011-05-09 15:09   
It has been closed to move it to the Openbravo ERP project
(0036573)
hgbot   
2011-05-09 17:02   
Repository: erp/devel/pi
Changeset: cd6e4afe4afc85a55b8574056d5f00a9b061be2b
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon May 09 13:54:37 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cd6e4afe4afc85a55b8574056d5f00a9b061be2b [^]

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

---
M src-test/org/openbravo/test/dal/IssuesTest.java
---
(0036574)
hgbot   
2011-05-09 17:02   
Repository: erp/devel/pi
Changeset: c3b8fa166f261455cf37f71030aa066e2db03805
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon May 09 13:57:27 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c3b8fa166f261455cf37f71030aa066e2db03805 [^]

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
---
(0036579)
hgbot   
2011-05-09 19:29   
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
---
(0036580)
hgbot   
2011-05-09 19:29   
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
---
(0036867)
hudsonbot   
2011-05-12 13:31   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c40e579fcd38 [^]

Maturity status: Test
(0036868)
hudsonbot   
2011-05-12 13:31   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c40e579fcd38 [^]

Maturity status: Test