Page Comparison

Buildfile: build.xml

prepare:

compile:

     [copy] Copying 2 files to C:\portal\build\WEB-INF\classes\properties

dbtest:

     [echo] Invoking DbTest
     [java] Database name: 'PostgreSQL'
     [java] Database version: '7.4.5'

     [java] Driver name: 'PostgreSQL Native Driver'

     [java] Driver version: 'PostgreSQL 7.4.5 JDBC3 with SSL (build 215)'

     [java] Driver class: 'org.postgresql.Driver'

     [java] Connection URL: 'jdbc:postgresql://localhost:5432/test'

     [java] User: 'postgres'

     [java] supportsANSI92EntryLevelSQL:

 true
     [java] supportsANSI92FullSQL:

 false
     [java] supportsCoreSQLGrammar:

 false
     [java] supportsExtendedSQLGrammar:

 false
     [java] supportsTransactions:

 true
     [java] supportsMultipleTransactions:

 true
     [java] supportsOpenCursorsAcrossCommit:

 false
     [java] supportsOpenCursorsAcrossRollback:

 false
     [java] supportsOpenStatementsAcrossCommit:

 true
     [java] supportsOpenStatementsAcrossRollback:

 true
     [java] supportsStoredProcedures:

 false
     [java] supportsOuterJoins:

 true
     [java] supportsFullOuterJoins:

 true
     [java] supportsLimitedOuterJoins:

 true
     [java] supportsBatchUpdates:

 true
     [java] supportsColumnAliasing:

 true
     [java] supportsExpressionsInOrderBy:

 true
     [java] supportsOrderByUnrelated:

 true
     [java] supportsPositionedDelete:

 false
     [java] supportsSelectForUpdate:

 true
     [java] supportsUnion:

 true
     [java] supportsUnionAll:

 true

     [java] getMaxColumnNameLength:

 63
     [java] getMaxColumnsInIndex:

 32
     [java] getMaxColumnsInOrderBy:

 0
     [java] getMaxColumnsInSelect:

 0
     [java] getMaxColumnsInTable:

 1600
     [java] getMaxConnections:

 8192
     [java] getMaxCursorNameLength:

 63
     [java] getMaxIndexLength:

 0
     [java] getMaxRowSize:

 1073741824
     [java] getMaxStatements:

 1
     [java] getMaxTableNameLength:

 63
     [java] getMaxTablesInSelect:

 0
     [java] getMaxUserNameLength:

 63
     [java] getSearchStringEscape: \\

     [java] Table Types: INDEX,SEQUENCE,SYSTEM INDEX,SYSTEM TABLE,SYSTEM TOAST I

NDEX,SYSTEM TOAST TABLE,SYSTEM VIEW,TABLE,TEMPORARY INDEX,TEMPORARY TABLE,VIEW

     [java] SQL Types: bool,bytea,char,name,int8,int2,int2vector,int4,regproc,te

xt,oid,tid,xid,cid,oidvector,SET,pg_type,pg_attribute,pg_proc,pg_class,pg_shadow

,pg_group,pg_database,smgr,point,lseg,path,box,polygon,line,_line,float4,float8,

abstime,reltime,tinterval,unknown,circle,_circle,money,_money,macaddr,inet,cidr,

_bool,_bytea,_char,_name,_int2,_int2vector,_int4,_regproc,_text,_oid,_tid,_xid,

_
...............