Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0017073
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2011-05-09 15:082011-05-16 16:22
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionfixedFixed in Version3.0RC7
StatusclosedFix in branchpiFixed in SCM revisionc3b8fa166f26
ProjectionnoneETAnoneTarget Version3.0RC7
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0017073: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00170742.50MP30 closedadrianromero Openbravo ERP Can't import products: No Dialect mapping for JDBC type 
has duplicate defect 0017058 closedadrianromero Modules Can't import products: No Dialect mapping for JDBC type 

-  Notes
(0036569)
adrianromero (manager)
2011-05-09 15:10

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)");
(0036575)
adrianromero (manager)
2011-05-09 17:08

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
---
(0036576)
adrianromero (manager)
2011-05-09 17:09

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
---
(0036585)
adrianromero (manager)
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.

- Issue History
Date Modified Username Field Change
2011-05-09 15:08 adrianromero New Issue
2011-05-09 15:08 adrianromero Assigned To => adrianromero
2011-05-09 15:08 adrianromero Modules => Core
2011-05-09 15:09 adrianromero Relationship added has duplicate 0017058
2011-05-09 15:10 adrianromero Note Added: 0036569
2011-05-09 15:10 adrianromero Status new => scheduled
2011-05-09 15:10 adrianromero fix_in_branch => pi
2011-05-09 17:08 adrianromero Note Added: 0036575
2011-05-09 17:09 adrianromero Note Added: 0036576
2011-05-09 17:09 adrianromero Status scheduled => resolved
2011-05-09 17:09 adrianromero Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c3b8fa166f261455cf37f71030aa066e2db03805 [^]
2011-05-09 17:09 adrianromero Resolution open => fixed
2011-05-09 19:36 adrianromero Note Added: 0036585
2011-05-16 16:22 ioritzCia Status resolved => closed
2011-05-16 16:22 ioritzCia Fixed in Version => 3.0RC7


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker