![]() |
Qore jni Module 2.4.0
|
Java wrapper for the Qore::SQL::DatasourcePool class in Qore. More...
Public Member Methods | |
| DatasourcePool (QoreObject ds) | |
| creates the object from the Qore object | |
| DatasourcePool (String config) throws Throwable | |
creates the object from the config string (ex: "pgsql:user/pass@db") | |
Public Member Methods inherited from org.qore.lang.AbstractDatasource | |
| AbstractDatasource (QoreObject ds) | |
| creates the object | |
| void | commit () throws Throwable |
| Commits the current transaction and releases any thread resources associated with the transaction. | |
| void | rollback () throws Throwable |
| Rolls the current transaction back and releases any thread resources associated with the transaction. | |
| Object | exec (String sql) throws Throwable |
| Executes an SQL command on the server and returns either the integer row count (for example, for updates, inserts, and deletes) or the data retrieved (for example, if a stored procedure is executed that returns values) | |
| Object | exec (String sql, Object... args) throws Throwable |
| Executes an SQL command on the server and returns either the integer row count (for example, for updates, inserts, and deletes) or the data retrieved (for example, if a stored procedure is executed that returns values) | |
| Object | vexec (String sql, Object[] vargs) throws Throwable |
| Executes an SQL command on the server and returns either the integer row count (for example, for updates, inserts, and deletes) or the data retrieved (for example, if a stored procedure is executed that returns values), taking a list for all bind arguments. | |
| Object | execRaw (String sql) throws Throwable |
| Executes an SQL command on the server and returns either the row count (for example, for updates and inserts) or the data retrieved (for example, if a stored procedure is executed that returns values) | |
| Object | select (String sql) throws Throwable |
| Executes an SQL select statement on the server and (normally) returns the result as a hash (column names) of lists (column values per row) | |
| Object | select (String sql, Object... args) throws Throwable |
| Executes an SQL select statement on the server and (normally) returns the result as a hash (column names) of lists (column values per row) | |
| Object | selectRow (String sql) throws Throwable |
| Executes an SQL select statement on the server and returns the first row as a hash (the column values) | |
| Object | selectRow (String sql, Object... args) throws Throwable |
| Executes an SQL select statement on the server and returns the first row as a hash (the column values) | |
| Object | selectRows (String sql) throws Throwable |
| Executes an SQL select statement on the server and returns the result as a list (rows) of hashes (the column values) | |
| Object | selectRows (String sql, Object... args) throws Throwable |
| Executes an SQL select statement on the server and returns the result as a list (rows) of hashes (the column values) | |
| Object | vselect (String sql, Object[] vargs) throws Throwable |
| Executes a select statement on the server and returns the results in a hash (column names) of lists (column values per row), taking a list for all bind arguments. | |
| Object | vselectRow (String sql, Object[] vargs) throws Throwable |
| Executes a select statement on the server and returns the first row as a hash (column names and values), taking a list for all bind arguments. | |
| Object | vselectRows (String sql, Object[] vargs) throws Throwable |
| Executes a select statement on the server and returns the results in a list (rows) of hashes (column names and values), taking a list for all bind arguments. | |
| void | beginTransaction () throws Throwable |
| Manually signals the start of transaction management on the AbstractDatasource. | |
| String | getUserName () throws Throwable |
| Returns the username parameter as a string or null if none is set. | |
| String | getPassword () throws Throwable |
| Returns the password parameter as a string or null if none is set. | |
| String | getDBName () throws Throwable |
| Returns the database name parameter as a string or null if none is set. | |
| String | getDBEncoding () throws Throwable |
| Retrieves the database-specific charset set encoding for the object. | |
| String | getOSEncoding () throws Throwable |
| Returns the Qore character encoding name for the object as a string or null if none is set. | |
| String | getHostName () throws Throwable |
| Returns the hostname parameter as a string or null if none is set. | |
| Integer | getPort () throws Throwable |
| Gets the port number that will be used for the next connection to the server. | |
| String | getDriverName () throws Throwable |
| Returns the name of the driver used for the object. | |
| Object | getServerVersion () throws Throwable |
| Returns the driver-specific server version data for the current connection. | |
| Object | getClientVersion () throws Throwable |
| Retrieves the driver-specific client library version information. | |
| boolean | inTransaction () throws Throwable |
| Returns True if a transaction is currently in progress. | |
| HashMap< String, Object > | getConfigHash () throws Throwable |
| Returns a datasource hash describing the configuration of the current object. | |
| String | getConfigString () throws Throwable |
| Returns a string giving the configuration of the current object in a format that can be parsed by parse_datasource() | |
| boolean | currentThreadInTransaction () throws Throwable |
| Should return true if the current thread is in a transaction with this object, must be re-implemented in subclasses to provide the desired functionality. | |
| AbstractSQLStatement | getSQLStatement () throws Throwable |
| Returns an AbstractSQLStatement object based on the current database connection object. | |
Java wrapper for the Qore::SQL::DatasourcePool class in Qore.
loads and initializes the Qore library and the jni module in static initialization if necessary
import qore.Qore.SQL.DatasourcePool;