JavaConnectionMBS.TransactionIsolation as Integer

The constants defined in the interface Connection are the possible transaction isolation levels.
Note: If this method is called during a transaction, the result is implementation-defined.

Parameters:
level - one of the following Connection constants: Connection.TRANSACTION_READ_UNCOMMITTED, Connection.TRANSACTION_READ_COMMITTED, Connection.TRANSACTION_REPEATABLE_READ, or Connection.TRANSACTION_SERIALIZABLE. (Note that Connection.TRANSACTION_NONE cannot be used because it specifies that transactions are not supported.)
(Read and Write computed property)

JavaConnectionMBS.TRANSACTION_NONE as Integer

JavaConnectionMBS.TRANSACTION_READ_COMMITTED as Integer

This level only prohibits a transaction from reading a row with uncommitted changes in it.

JavaConnectionMBS.TRANSACTION_READ_UNCOMMITTED as Integer

This level allows a row changed by one transaction to be read by another transaction before any changes in that row have been committed (a "dirty read"). If any of the changes are rolled back, the second transaction will have retrieved an invalid row.

JavaConnectionMBS.TRANSACTION_REPEATABLE_READ as Integer

This level prohibits a transaction from reading a row with uncommitted changes in it, and it also prohibits the situation where one transaction reads a row, a second transaction alters the row, and the first transaction rereads the row, getting different values the second time (a "non-repeatable read").

JavaConnectionMBS.TRANSACTION_SERIALIZABLE as Integer

This level includes the prohibitions in TRANSACTION_REPEATABLE_READ and further prohibits the situation where one transaction reads all rows that satisfy a WHERE condition, a second transaction inserts a row that satisfies that WHERE condition, and the first transaction rereads for the same condition, retrieving the additional "phantom" row in the second read.

JavaConnectionMBS.typeARRAY as Integer

JavaConnectionMBS.typeBIGINT as Integer

Var d as JavaConnectionMBS
MsgBox str(d.typeBIGINT)

JavaConnectionMBS.typeBINARY as Integer

JavaConnectionMBS.typeBIT as Integer

Some examples using this method:

• /Java/JavaDatabase/JavaDatabase to JSON

JavaConnectionMBS.typeBLOB as Integer

JavaConnectionMBS.typeCHAR as Integer

JavaConnectionMBS.typeCLOB as Integer

JavaConnectionMBS.typeDATE as Integer

JavaConnectionMBS.typeDECIMAL as Integer

JavaConnectionMBS.typeDISTINCT as Integer

JavaConnectionMBS.typeDOUBLE as Integer

JavaConnectionMBS.typeFLOAT as Integer

Some examples using this method:

• /Java/JavaDatabase/JavaDatabase to JSON

JavaConnectionMBS.typeINTEGER as Integer

Some examples using this method:

• /Java/JavaDatabase/JavaDatabase to JSON

JavaConnectionMBS.typeJAVA_OBJECT as Integer

JavaConnectionMBS.typeLONGVARBINARY as Integer

JavaConnectionMBS.typeLONGVARCHAR as Integer

JavaConnectionMBS.typeNULL as Integer

JavaConnectionMBS.typeNUMERIC as Integer

JavaConnectionMBS.typeOTHER as Integer

JavaConnectionMBS.typeREAL as Integer

Some examples using this method:

• /Java/JavaDatabase/JavaDatabase to JSON

JavaConnectionMBS.typeREF as Integer

JavaConnectionMBS.typeSMALLINT as Integer

Some examples using this method:

• /Java/JavaDatabase/JavaDatabase to JSON

JavaConnectionMBS.typeSTRUCT as Integer

JavaConnectionMBS.typeTIME as Integer

JavaConnectionMBS.typeTIMESTAMP as Integer

JavaConnectionMBS.typeTINYINT as Integer

Some examples using this method:

• /Java/JavaDatabase/JavaDatabase to JSON

JavaConnectionMBS.typeVARBINARY as Integer

JavaConnectionMBS.typeVARCHAR as Integer

JavaConnectionMBS.TYPE_FORWARD_ONLY as Integer

JavaConnectionMBS.TYPE_SCROLL_INSENSITIVE as Integer

JavaConnectionMBS.TYPE_SCROLL_SENSITIVE as Integer