details: https://code.openbravo.com/erp/devel/pi/rev/396b7943dbbe
changeset: 22658:396b7943dbbe
user: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
date: Mon Mar 10 14:45:53 2014 +0530
summary: Fixes Issue 0025855: Problem on Building runtime model when the
tablename starts with pg
Remove where clause that was excluding tables starting with pg and sql.
diffstat:
src/org/openbravo/base/session/SessionFactoryController.java | 3 +--
1 files changed, 1 insertions(+), 2 deletions(-)
diffs (13 lines):
diff -r 8c76a7a6bf32 -r 396b7943dbbe
src/org/openbravo/base/session/SessionFactoryController.java
--- a/src/org/openbravo/base/session/SessionFactoryController.java Sun Mar
09 12:58:18 2014 +0530
+++ b/src/org/openbravo/base/session/SessionFactoryController.java Mon Mar
10 14:45:53 2014 +0530
@@ -46,8 +46,7 @@
private static final String UNIQUE_CONSTRAINT_QUERY_ORACLE = "SELECT
UCC.TABLE_NAME,UCC.COLUMN_NAME,UCC.CONSTRAINT_NAME FROM USER_CONS_COLUMNS UCC
JOIN USER_CONSTRAINTS UC ON UC.CONSTRAINT_NAME=UCC.CONSTRAINT_NAME WHERE
UC.CONSTRAINT_TYPE = 'U' ORDER BY UCC.CONSTRAINT_NAME";
private static final String COLUMN_QUERY_POSTGRES = "SELECT t.tablename,
a.attname, a.attnotnull FROM pg_tables t, pg_class c, pg_attribute a "
- + "WHERE tablename NOT LIKE 'pg%' AND tablename NOT LIKE 'sql%' and "
- + "c.relname = t.tablename AND a.attnum > 0 AND a.attrelid = c.oid";
+ + "WHERE c.relname = t.tablename AND a.attnum > 0 AND a.attrelid =
c.oid";
private static final String COLUMN_QUERY_ORACLE = "SELECT C.TABLE_NAME,
C.COLUMN_NAME, C.NULLABLE "
+ "FROM USER_TAB_COLUMNS C ORDER BY C.TABLE_NAME";
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
