Built-In Object Type: DBConnection

Inherits All, JavaObject: java.sql.Connection
(MORE DESCRIPTION TO COME.)
Members:
NameWritableDescription
driver noThe JDBC driver Java class name for this connection.
autoCommit yesThe boolean auto-commit flag.
readOnly yesThe boolean read-only flag.
catalog yesThe catalog.
typeMap yesThe type map.
transactionIsolation yesThe transaction isolation level. Valid values are 'transaction_non', 'transaction_read_uncommitted', 'transaction_read_committed' and 'transaction_serializable'.
Methods:
NameArgumentsDescription
addTypeMap
name
typeClass
Adds the type Java class typeClass for type name for this connection.
clearWarning
  Clears the warning.
commit
  Commits the last transaction.
countRows
tableName
Returns the number of rows for table tableName in this database.
databaseObjectExists
existsDatabaseobject
objName
This is Oracle specific. Returns true if the object objName exists in the schema. (It queries table user_objects.)
describe
desc
tableName
Returns the table information for tableName in a TableData object.
disconnect
close
  Disconnects the connection to the database.
executeBatch
sqls
The parameter sqls is an array of SQL statements. Executes them in a batch and returns the total result count.
executeQuery
sql
Executes the query sql and returns the result set.
executeSQL
sql
Executes the SQL sql and returns the result count.
executeSQLFile
sqlFile
...
Executes the SQL statements in files represented by sqlFile's and returns the result count. The SQL statements in the file must be separated by ; and is runnable by the JDBC driver. Lines starting with # are comments and are ignored.
getDatabaseObjectType
objName
This is Oracle specific. Returns the type of the object objName if it exists in the schema. (It queries table user_objects.)
getMetaData
  Returns the database meta data (DBMetaData) for this connection.
nativeSQL
sql
Returns the RDBMS's native SQL for sql.
procedureExists
procExists
procPattern
Returns true if procedure procPattern exists. The procPattern is a pattern in the form of catalog.schema.pattern.
reportWarnings
  Returns the boolean value indicating whether warnings are shown.
rollback
  Rolls back the last transaction.
tableExists
tablePattern
Returns true if table tablePattern exists. The tablePattern is a pattern in the form of catalog.schema.pattern.
userTypeExists
userDefinedTypeExists
typePattern
Returns true if user-defined type typePattern exists. The typePattern is a pattern in the form of catalog.schema.pattern.