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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0017058
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Initial data loadmajoralways2011-05-06 20:212011-05-12 13:31
ReporterelopioView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision80dbc32ecfd6
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary

0017058: 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 Filescsv file icon Products.csv [^] (1,819 bytes) 2011-05-06 20:21

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 00170733.0RC7 closedadrianromero Openbravo ERP Can't import products: No Dialect mapping for JDBC type 

-  Notes
(0036558)
adrianromero (viewer)
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 (viewer)
2011-05-09 15:09

 It has been closed to move it to the Openbravo ERP project
(0036573)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (viewer)
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 (viewer)
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

- Issue History
Date Modified Username Field Change
2011-05-06 20:21 elopio New Issue
2011-05-06 20:21 elopio Assigned To => mirurita
2011-05-06 20:21 elopio File Added: Products.csv
2011-05-06 20:21 elopio OBNetwork customer => No
2011-05-09 09:40 mirurita Assigned To mirurita => adrianromero
2011-05-09 12:38 adrianromero Note Added: 0036558
2011-05-09 13:50 shuehner Issue Monitored: shuehner
2011-05-09 15:09 adrianromero Relationship added duplicate of 0017073
2011-05-09 15:09 adrianromero Note Added: 0036568
2011-05-09 15:09 adrianromero Status new => closed
2011-05-09 15:09 adrianromero Resolution open => duplicate
2011-05-09 17:02 hgbot Checkin
2011-05-09 17:02 hgbot Note Added: 0036573
2011-05-09 17:02 hgbot Checkin
2011-05-09 17:02 hgbot Note Added: 0036574
2011-05-09 17:02 hgbot Status closed => resolved
2011-05-09 17:02 hgbot Resolution duplicate => fixed
2011-05-09 17:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c3b8fa166f261455cf37f71030aa066e2db03805 [^]
2011-05-09 17:08 adrianromero Status resolved => closed
2011-05-09 19:29 hgbot Checkin
2011-05-09 19:29 hgbot Note Added: 0036579
2011-05-09 19:29 hgbot Checkin
2011-05-09 19:29 hgbot Note Added: 0036580
2011-05-09 19:29 hgbot Status closed => resolved
2011-05-09 19:29 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/c3b8fa166f261455cf37f71030aa066e2db03805 [^] => http://code.openbravo.com/erp/stable/2.50/rev/80dbc32ecfd63ed76086dd784023df0046a62dcf [^]
2011-05-09 19:33 adrianromero Status resolved => closed
2011-05-12 13:31 hudsonbot Checkin
2011-05-12 13:31 hudsonbot Note Added: 0036867
2011-05-12 13:31 hudsonbot Checkin
2011-05-12 13:31 hudsonbot Note Added: 0036868

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker