DbTest database information tool
DbTest is a simple tool for dumping database metadata. It can be used to examine attributes which a particular database vendor supports such as transaction support, and table column sizes. DbTest reads the properties/rdbm.properties file to obtain the database connection information.
DbTest can be invoked from the uPortal build directory using ant by simply typing:
ant dbtest
It will produce output similar to the following (this is for a PostgreSQL database):
% 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,
...............