details: /erp/stable/2.50/rev/e8f0359d2a72
changeset: 9413:e8f0359d2a72
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Mon May 09 17:18:13 2011 +0200
summary: Test case for issue 17058 Can't import products: No Dialect mapping
for JDBC type
details: /erp/stable/2.50/rev/80dbc32ecfd6
changeset: 9414:80dbc32ecfd6
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Mon May 09 17:21:14 2011 +0200
summary: 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
diffstat:
src-test/org/openbravo/test/dal/IssuesTest.java | 25 ++++++++++++++++++
src/org/openbravo/base/session/OBOracle10gDialect.java | 2 +
2 files changed, 27 insertions(+), 0 deletions(-)
diffs (53 lines):
diff -r 427cf19a3e88 -r 80dbc32ecfd6
src-test/org/openbravo/test/dal/IssuesTest.java
--- a/src-test/org/openbravo/test/dal/IssuesTest.java Mon May 09 13:25:50
2011 +0200
+++ b/src-test/org/openbravo/test/dal/IssuesTest.java Mon May 09 17:21:14
2011 +0200
@@ -32,6 +32,8 @@
import org.apache.log4j.Logger;
import org.dom4j.Document;
import org.dom4j.io.SAXReader;
+import org.hibernate.SQLQuery;
+import org.hibernate.Session;
import org.hibernate.criterion.Expression;
import org.openbravo.base.model.Reference;
import org.openbravo.base.model.domaintype.LongDomainType;
@@ -565,4 +567,27 @@
dth.run();
OBContext.setOBContext(obContext);
}
+
+ /**
+ * Testing issue 0017058. It verifies that the NVARCHAR JDBC type is
properly mapped The test SQL
+ * query is used in the IDL module.
+ */
+ public void test17058() {
+
+ setSystemAdministratorContext();
+
+ final Session session = OBDal.getInstance().getSession();
+ SQLQuery query = session
+ .createSQLQuery("SELECT AD_REF_LIST.VALUE AS VALUE, AD_REF_LIST.NAME
AS LISTNAME, TRL.NAME AS TRLNAME "
+ + "FROM AD_REF_LIST LEFT OUTER JOIN "
+ + "(SELECT AD_REF_LIST_ID, NAME FROM AD_REF_LIST_TRL WHERE
AD_REF_LIST_TRL.AD_LANGUAGE = ?) TRL "
+ + "ON AD_REF_LIST.AD_REF_LIST_ID = TRL.AD_REF_LIST_ID "
+ + "WHERE AD_REF_LIST.AD_REFERENCE_ID = ?");
+ query.setString(0, "en_US");
+ query.setString(1, "800025");
+
+ java.util.List<Object[]> l = query.list();
+
+ }
+
}
\ No newline at end of file
diff -r 427cf19a3e88 -r 80dbc32ecfd6
src/org/openbravo/base/session/OBOracle10gDialect.java
--- a/src/org/openbravo/base/session/OBOracle10gDialect.java Mon May 09
13:25:50 2011 +0200
+++ b/src/org/openbravo/base/session/OBOracle10gDialect.java Mon May 09
17:21:14 2011 +0200
@@ -40,6 +40,8 @@
super();
registerHibernateType(Types.NUMERIC, Hibernate.LONG.getName());
+ registerHibernateType(Types.NVARCHAR, Hibernate.STRING.getName());
+ registerHibernateType(Types.NCHAR, Hibernate.STRING.getName());
registerColumnType(Types.VARCHAR, 4000, "nvarchar2($l)");
registerColumnType(Types.VARCHAR, 100, "varchar2($l)");
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
