java.sql.Connection
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'. |
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 |
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. |