details: /erp/devel/pi/rev/cd6e4afe4afc
changeset: 12068:cd6e4afe4afc
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Mon May 09 13:54:37 2011 +0200
summary: Test case for issue 17058 Can't import products: No Dialect mapping
for JDBC type
details: /erp/devel/pi/rev/c3b8fa166f26
changeset: 12069:c3b8fa166f26
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Mon May 09 13:57:27 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 f3be3266eed1 -r c3b8fa166f26
src-test/org/openbravo/test/dal/IssuesTest.java
--- a/src-test/org/openbravo/test/dal/IssuesTest.java Mon May 09 16:41:58
2011 +0200
+++ b/src-test/org/openbravo/test/dal/IssuesTest.java Mon May 09 13:57:27
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.Restrictions;
import org.openbravo.base.model.ModelProvider;
import org.openbravo.base.model.Reference;
@@ -599,4 +601,27 @@
OBDal.getInstance().remove(hbLogRead);
}
+
+ /**
+ * 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 f3be3266eed1 -r c3b8fa166f26
src/org/openbravo/base/session/OBOracle10gDialect.java
--- a/src/org/openbravo/base/session/OBOracle10gDialect.java Mon May 09
16:41:58 2011 +0200
+++ b/src/org/openbravo/base/session/OBOracle10gDialect.java Mon May 09
13:57:27 2011 +0200
@@ -40,6 +40,8 @@
super();
registerHibernateType(Types.NUMERIC, StandardBasicTypes.LONG.getName());
+ registerHibernateType(Types.NVARCHAR, StandardBasicTypes.STRING.getName());
+ registerHibernateType(Types.NCHAR, StandardBasicTypes.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
