| Packages | |
| io.vertx.ceylon.sql | |
| Dependencies | ||
ceylon.json | 1.2.2 | |
io.vertx.ceylon.core | 3.3.0.CR2 | |
io.vertx.vertx-sql-common | 3.3.0.CR2 | |
java.base (jvm) | 8 | |
| Values | |
none | shared none noneFor engines that support it, none isolation means that each statement would essentially be its own transaction. |
read_committed | shared read_committed read_committedSpecifies that shared locks are held while the data is being read to avoid dirty reads, but the data can be changed before the end of the transaction, resulting in nonrepeatable reads or phantom data. |
read_uncommitted | shared read_uncommitted read_uncommittedImplements dirty read, or isolation level 0 locking, which means that no shared locks are issued and no exclusive locks are honored. When this option is set, it is possible to read uncommitted or dirty data; values in the data can be changed and rows can appear or disappear in the data set before the end of the transaction. This is the least restrictive of the four isolation levels. |
repeatable_read | shared repeatable_read repeatable_readLocks are placed on all data that is used in a query, preventing other users from updating the data, but new phantom rows can be inserted into the data set by another user and are included in later reads in the current transaction. Because concurrency is lower than the default isolation level, use this option only when necessary. |
resultSet | shared resultSet resultSet |
serializable | shared serializable serializablePlaces a range lock on the data set, preventing other users from updating or inserting rows into the data set until the transaction is complete. This is the most restrictive of the four isolation levels. Because concurrency is lower, use this option only when necessary. |
transactionIsolation | shared transactionIsolation transactionIsolation |
updateResult | shared updateResult updateResult |
| Classes | |
ResultSet | shared ResultSetRepresents the results of a SQL query.
It contains a list for the column names of the results, and a list of |
SQLConnection | shared SQLConnectionRepresents a connection to a SQL database |
TransactionIsolation | shared abstract TransactionIsolationRepresents a Transaction Isolation Level |
UpdateResult | shared UpdateResultRepresents the result of an update/insert/delete operation on the database. The number of rows updated is available with getUpdated and any generated keys are available with getKeys. |
none | shared noneFor engines that support it, none isolation means that each statement would essentially be its own transaction. |
read_committed | shared read_committedSpecifies that shared locks are held while the data is being read to avoid dirty reads, but the data can be changed before the end of the transaction, resulting in nonrepeatable reads or phantom data. |
read_uncommitted | shared read_uncommittedImplements dirty read, or isolation level 0 locking, which means that no shared locks are issued and no exclusive locks are honored. When this option is set, it is possible to read uncommitted or dirty data; values in the data can be changed and rows can appear or disappear in the data set before the end of the transaction. This is the least restrictive of the four isolation levels. |
repeatable_read | shared repeatable_readLocks are placed on all data that is used in a query, preventing other users from updating the data, but new phantom rows can be inserted into the data set by another user and are included in later reads in the current transaction. Because concurrency is lower than the default isolation level, use this option only when necessary. |
resultSet | shared resultSet |
serializable | shared serializablePlaces a range lock on the data set, preventing other users from updating or inserting rows into the data set until the transaction is complete. This is the most restrictive of the four isolation levels. Because concurrency is lower, use this option only when necessary. |
transactionIsolation | shared transactionIsolation |
updateResult | shared updateResult |