Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Next items

JavaConnectionMBS.AutoCommit as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The current auto-commit state.
Notes:
See the java documentation for details on java.sql.Connection.SetAutoCommit.
(Read and Write computed property)

Feedback, Comments & Corrections

JavaConnectionMBS.Catalog as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Sets or gets the given catalog name in order to select a subspace of this Connection object's database in which to work.
Notes:
If the driver does not support catalogs, it will silently ignore this request.
(Read and Write computed property)

Feedback, Comments & Corrections

JavaConnectionMBS.clearWarnings
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Clears all warnings reported for this Connection object.
Notes: After a call to this method, the method getWarnings returns null until a new warning is reported for this Connection object.

Feedback, Comments & Corrections

JavaConnectionMBS.close
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Releases this Connection object's database and JDBC resources immediately instead of waiting for them to be automatically released.

Feedback, Comments & Corrections

JavaConnectionMBS.CLOSE_CURSORS_AT_COMMIT as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating that ResultSet objects should be closed when the method Connection.commit is called.

Feedback, Comments & Corrections

JavaConnectionMBS.commit
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
Notes: See the java documentation for details on java.sql.Connection.Commit.

Feedback, Comments & Corrections

JavaConnectionMBS.CONCUR_READ_ONLY as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating the concurrency mode for a ResultSet object that may NOT be updated.

Feedback, Comments & Corrections

JavaConnectionMBS.CONCUR_UPDATABLE as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating the concurrency mode for a ResultSet object that may be updated.

Feedback, Comments & Corrections

JavaConnectionMBS.Constructor
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 15.1 Yes Yes Yes Yes No
Function: The private constructor.

Feedback, Comments & Corrections

JavaConnectionMBS.createBlob as JavaBlobMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 11.3 Yes Yes Yes Yes No
Function: Constructs an object that implements the Blob interface.
Notes: The object returned initially contains no data. The setBinaryStream and setBytes methods of the Blob interface may be used to add data to the Blob.

Feedback, Comments & Corrections

JavaConnectionMBS.createClob as JavaClobMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 11.3 Yes Yes Yes Yes No
Function: Constructs an object that implements the Clob interface.
Notes: The object returned initially contains no data. The setAsciiStream, setCharacterStream and setString methods of the Clob interface may be used to add data to the Clob.

Feedback, Comments & Corrections

JavaConnectionMBS.createStatement as JavaStatementMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Creates a Statement object for sending SQL statements to the database.
Notes:
SQL statements without parameters are normally executed using Statement objects. If the same SQL statement is executed many times, it may be more efficient to use a PreparedStatement object.
Result sets created using the returned Statement object will by default be type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY.

Returns:
a new default Statement object

See also:

Feedback, Comments & Corrections

JavaConnectionMBS.createStatement(resultSetType as Integer, resultSetConcurrency as Integer) as JavaStatementMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Creates a Statement object that will generate ResultSet objects with the given type and concurrency.
Notes:
This method is the same as the createStatement method above, but it allows the default result set type and concurrency to be overridden.
Parameters:
resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
Returns:
a new Statement object that will generate ResultSet objects with the given type and concurrency

See also:

Feedback, Comments & Corrections

JavaConnectionMBS.createStatement(resultSetType as Integer, resultSetConcurrency as Integer, resultSetHoldability as Integer) as JavaStatementMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Creates a Statement object that will generate ResultSet objects with the given type, concurrency, and holdability.
Notes:
This method is the same as the createStatement method above, but it allows the default result set type, concurrency, and holdability to be overridden.
Parameters:
resultSetType - one of the following ResultSet constants: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency - one of the following ResultSet constants: ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
resultSetHoldability - one of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
Returns:
a new Statement object that will generate ResultSet objects with the given type, concurrency, and holdability

See also:

Feedback, Comments & Corrections

JavaConnectionMBS.FETCH_FORWARD as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating that the rows in a result set will be processed in a forward direction; first-to-last.
Notes: This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

Feedback, Comments & Corrections

JavaConnectionMBS.FETCH_REVERSE as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating that the rows in a result set will be processed in a reverse direction; last-to-first.
Notes: This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

Feedback, Comments & Corrections

JavaConnectionMBS.FETCH_UNKNOWN as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating that the order in which rows in a result set will be processed is unknown.
Notes: This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

Feedback, Comments & Corrections

JavaConnectionMBS.getMetaData as JavaDatabaseMetaDataMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves a DatabaseMetaData object that contains metadata about the database to which this Connection object represents a connection.
Notes:
The metadata includes information about the database's tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, and so on.
Returns:
a DatabaseMetaData object for this Connection object

Feedback, Comments & Corrections

JavaConnectionMBS.Holdability as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Changes or retrieves the holdability of ResultSet objects created using this Connection object to the given holdability.
Notes:
Parameters:
holdability - a ResultSet holdability constant; one of ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
(Read and Write computed property)

Feedback, Comments & Corrections

JavaConnectionMBS.HOLD_CURSORS_OVER_COMMIT as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating that ResultSet objects should not be closed when the method Connection.commit is called.

Feedback, Comments & Corrections

JavaConnectionMBS.isClosed as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves whether this Connection object has been closed.
Notes:
A connection is closed if the method close has been called on it or if certain fatal errors have occurred. This method is guaranteed to return true only when it is called after the method Connection.close has been called.
This method generally cannot be called to determine whether a connection to a database is valid or invalid. A typical client can determine that a connection is invalid by catching any exceptions that might be thrown when an operation is attempted.

Returns:
true if this Connection object is closed; false if it is still open

Feedback, Comments & Corrections

JavaConnectionMBS.nativeSQL(sql as string) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Converts the given SQL statement into the system's native SQL grammar.
Notes:
A driver may convert the JDBC SQL grammar into its system's native SQL grammar prior to sending it. This method returns the native form of the statement that the driver would have sent.
Parameters:
sql - an SQL statement that may contain one or more '?' parameter placeholders
Returns:
the native form of this statement

Feedback, Comments & Corrections

JavaConnectionMBS.prepareCall(sql as string) as JavaCallableStatementMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Creates a CallableStatement object for calling database stored procedures.
Notes:
The CallableStatement object provides methods for setting up its IN and OUT parameters, and methods for executing the call to a stored procedure.
Note: This method is optimized for handling stored procedure call statements. Some drivers may send the call statement to the database when the method prepareCall is done; others may wait until the CallableStatement object is executed. This has no direct effect on users; however, it does affect which method throws certain SQLExceptions.

Result sets created using the returned CallableStatement object will by default be type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY.

Parameters:
sql - an SQL statement that may contain one or more '?' parameter placeholders. Typically this statement is a JDBC function call escape string.
Returns:
a new default CallableStatement object containing the pre-compiled SQL statement

See also:

Feedback, Comments & Corrections

JavaConnectionMBS.prepareCall(sql as string, resultSetType as Integer, resultSetConcurrency as Integer) as JavaCallableStatementMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency.
Notes:
This method is the same as the prepareCall method above, but it allows the default result set type and concurrency to be overridden.
Parameters:
sql - a String object that is the SQL statement to be sent to the database; may contain on or more ? parameters
resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
Returns:
a new CallableStatement object containing the pre-compiled SQL statement that will produce ResultSet objects with the given type and concurrency

See also:

Feedback, Comments & Corrections

JavaConnectionMBS.prepareCall(sql as string, resultSetType as Integer, resultSetConcurrency as Integer, resultSetHoldability as Integer) as JavaCallableStatementMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Creates a CallableStatement object that will generate ResultSet objects with the given type and concurrency.
Notes:
This method is the same as the prepareCall method above, but it allows the default result set type, result set concurrency type and holdability to be overridden.
Parameters:
sql - a String object that is the SQL statement to be sent to the database; may contain on or more ? parameters
resultSetType - one of the following ResultSet constants: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency - one of the following ResultSet constants: ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
resultSetHoldability - one of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
Returns:
a new CallableStatement object, containing the pre-compiled SQL statement, that will generate ResultSet objects with the given type, concurrency, and holdability

See also:

Feedback, Comments & Corrections

JavaConnectionMBS.prepareStatement(sql as string) as JavaPreparedStatementMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Creates a PreparedStatement object for sending parameterized SQL statements to the database.
Notes:
A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method prepareStatement will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until the PreparedStatement object is executed. This has no direct effect on users; however, it does affect which methods throw certain SQLException objects.

Result sets created using the returned PreparedStatement object will by default be type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY.

Parameters:
sql - an SQL statement that may contain one or more '?' IN parameter placeholders

See also:

Feedback, Comments & Corrections

JavaConnectionMBS.prepareStatement(sql as string, autoGeneratedKeys as Integer) as JavaPreparedStatementMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Creates a default PreparedStatement object that has the capability to retrieve auto-generated keys.
Notes:
The given constant tells the driver whether it should make auto-generated keys available for retrieval. This parameter is ignored if the SQL statement is not an INSERT statement.
Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, the method prepareStatement will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until the PreparedStatement object is executed. This has no direct effect on users; however, it does affect which methods throw certain SQLExceptions.

Result sets created using the returned PreparedStatement object will by default be type TYPE_FORWARD_ONLY and have a concurrency level of CONCUR_READ_ONLY.

Parameters:
sql - an SQL statement that may contain one or more '?' IN parameter placeholders
autoGeneratedKeys - a flag indicating whether auto-generated keys should be returned; one of Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS
Returns:
a new PreparedStatement object, containing the pre-compiled SQL statement, that will have the capability of returning auto-generated keys

See also:

Feedback, Comments & Corrections

JavaConnectionMBS.prepareStatement(sql as string, resultSetType as Integer, resultSetConcurrency as Integer) as JavaPreparedStatementMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Creates a PreparedStatement object that will generate ResultSet objects with the given type and concurrency.
Notes:
This method is the same as the prepareStatement method above, but it allows the default result set type and concurrency to be overridden.
Parameters:
sql - a String object that is the SQL statement to be sent to the database; may contain one or more ? IN parameters
resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
Returns:
a new PreparedStatement object containing the pre-compiled SQL statement that will produce ResultSet objects with the given type and concurrency

See also:

Feedback, Comments & Corrections

JavaConnectionMBS.prepareStatement(sql as string, resultSetType as Integer, resultSetConcurrency as Integer, resultSetHoldability as Integer) as JavaPreparedStatementMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Creates a PreparedStatement object that will generate ResultSet objects with the given type, concurrency, and holdability.
Notes:
This method is the same as the prepareStatement method above, but it allows the default result set type, concurrency, and holdability to be overridden.

Parameters:
sql - a String object that is the SQL statement to be sent to the database; may contain one or more ? IN parameters
resultSetType - one of the following ResultSet constants: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency - one of the following ResultSet constants: ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
resultSetHoldability - one of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
Returns:
a new PreparedStatement object, containing the pre-compiled SQL statement, that will generate ResultSet objects with the given type, concurrency, and holdability

See also:

Feedback, Comments & Corrections

Next items

The items on this page are in the following plugins: MBS Java Plugin.




Links
MBS Xojo Plugins