...
It will produce output similar to the following (this is for a PostgreSQL database):
Code Block |
---|
% ant dbtest
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,_
...............
|