JudoScript Object - DBConnection

Built-In Object Type: DBConnection

Inherits All, JavaObject: `java.sql.Connection`

(MORE DESCRIPTION TO COME.)

Members:

Name	Writable	Description
driver	no	The JDBC driver Java class name for this connection.
autoCommit	yes	The boolean auto-commit flag.
readOnly	yes	The boolean read-only flag.
catalog	yes	The catalog.
typeMap	yes	The type map.
transactionIsolation	yes	The transaction isolation level. Valid values are 'transaction_non', 'transaction_read_uncommitted', 'transaction_read_committed' and 'transaction_serializable'.

Methods:

Name	Arguments	Description
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.