details: http://code.openbravo.com/erp/devel/pi/rev/b4a5b190f530
changeset: 3462:b4a5b190f530
user: Antonio Moreno <antonio.moreno <at> openbravo.com>
date: Fri Mar 27 11:25:23 2009 +0100
summary: Related to issue 0008110. Added step in the diagnostic utility to
check if the NLS_NCHAR_CHARACTERSET attribute is set to the right value in an
Oracle database.
diffstat:
src-diagnostics/src/org/openbravo/task/CheckDB.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diffs (35 lines):
diff -r 2cd8acf18d55 -r b4a5b190f530
src-diagnostics/src/org/openbravo/task/CheckDB.java
--- a/src-diagnostics/src/org/openbravo/task/CheckDB.java Thu Mar 26
19:24:44 2009 +0100
+++ b/src-diagnostics/src/org/openbravo/task/CheckDB.java Fri Mar 27
11:25:23 2009 +0100
@@ -31,6 +31,7 @@
import org.openbravo.utils.PropertiesManager;
import org.openbravo.utils.Version;
+
public class CheckDB extends Task {
static Logger log4j = Logger.getLogger(CheckDB.class);
@@ -163,6 +164,23 @@
log4j.info("Open cursors OK");
}
+ try {
+ st = connSystem
+ .prepareStatement("select value from nls_database_parameters where
parameter='NLS_NCHAR_CHARACTERSET'");
+ result = st.executeQuery();
+ result.next();
+ String nchar_charset = result.getString(1);
+ if (nchar_charset.equals("AL16UTF16"))
+ log4j.info("NCHAR charset encoding OK.");
+ else {
+ throw new BuildException("NCHAR charset encoding incorrect. Current
encoding: "
+ + nchar_charset + ". Required encoding: AL16UTF16");
+ }
+ result.close();
+ st.close();
+ } catch (final Exception e) {
+ throw new BuildException(e.getMessage());
+ }
} else { // PostgreSQL
// Check version
log4j.info("Checking PostgreSQL version...");
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
