Operating System objects

Here is the list of Operating System reported objects :

• Os Account
• Os Name
• Os Architecture
• Os Version
• Path Separator
• Current user's Home Directory
• Working Directory
• Java Version
• Java Vendor
• Java Vendor Url
• JAVA_HOME
• JVM spec. version
• JVM spec. name
• JVM version
• JVM implementation vendor
• JVM implementation name
• JRE spec. version
• JRE spec. vendor
• JRE spec. name
• Java Class Format Version Number
• Classpath
• LIBPATH
• User's TEMP directory
• JIT compiler
• Java Extension directory (or directories)

Database Driver Properties

Driver Major Version

Driver Minor Version

Driver Name

Driver Version

Identifier quoted string

JDBC Major Version

JDBC Minor Version

The login timeout

Database Connection Properties

• Database Catalog (when applicable)
• The Catalog term for this DBMS
• Transaction Isolation Level
• Catalog separator
• Database Product Name
• Database Product Version
• Default Transaction Isolation Level
• The name used in this database for "database procedure"
• The name used to describe a schema
• The JDBC url used to get the connection
• The user name under wich the connection has been established
• Maximum number of connections

Database Limitations

• Max binary litteral length
• Max char litteral length
• Max column name length
• Max columns in group by statement
• Max columns in index
• Max columns in order by
• Max columns in select
• Max tables in select
• Max columns in Table
• Max cursor name length
• Max index length
• Max schema name length
• Max user name length
• Max procedure name length
• Max table name length
• Max Catalog name length
• Max row size
• Does max row size include blobs
• Max SQL statement length
• Max statements
• Does this database support data definition and data definition transactions ?
• Does this database support Data manipulation transactions only
• Does data definition cause Transaction commit ?
• Are data definition ignored in Transactions ?
• All details about different cursors types including Trasnactions isolation levels and supports
• All details about how Transactions (inserts, delete, updates) are managed between concurrent sessions
• Does this database support batch updates ?
• Does this database support savepoints ?
• Does this database support named parameters ?
• Does this database support multiple open resulsets ?
• Does this database support the "get generated keys feature" ?
• Does this database support statements pooling ?
• Do allocators update copy ?

Database objects

As i try to get the maximum set of properties from the driver through the Jdbc Api, you should be able to retrieve the values you can get through the Jdbc API, when they are implented (which is not always the case ...). When a feature is not available in driver's API, the exception output message is displayed instead. Depending on how the JDBC API has been implemented (and most of all how the implementation respects the official JDBC API) the report strongly depends on the driver you are using, here are the database objects you will be able to find in your report :

• The database types with all their properties (size, type, name, length, and some more detailed properties)
• The SQL reserved keywords of the RDBMS
• The native db Time/Date functions
• The native db System functions
• The native db String functions
• The native db Numeric functions
• User defined available stored procedure and functions, with their parameters descriptions (type, order, nullable, remarks and some other details), as well as remarks (when available)
• Tables are reported (according to driver features, see limitations section). On each table, a summarized report (like the row size, the table type, the row buffer size, the row char octet length) is provided, but you also have report on it's columns, indexes, primary keys, and privileges