Description Usage Arguments Methods (by generic) Slots
JDBCConnection class
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | ## S4 method for signature 'JDBCConnection'
dbSQLDialect(conn)
## S4 method for signature 'JDBCConnection'
dbGetInfo(dbObj, ...)
## S4 method for signature 'JDBCConnection'
dbGetException(conn, ...)
## S4 method for signature 'JDBCConnection'
dbListResults(conn, ...)
## S4 method for signature 'JDBCConnection'
dbGetDriver(dbObj, ...)
## S4 method for signature 'JDBCConnection'
dbIsValid(dbObj, timeout = 0, ...)
## S4 method for signature 'JDBCConnection'
show(object)
|
conn |
A |
dbObj |
A |
... |
Other parameters passed on to methods. |
timeout |
The time in seconds to wait for the database operation used to validate the connection to complete. If the timeout period expires before the operation completes, this method returns false. A value of 0 indicates a timeout is not applied to the database operation. |
object |
An object of class |
dbSQLDialect
: Get the sql_dialect
of the driver which created this connection.
dbGetInfo
: Returns a named list with the following entries:
dbname
(the name of the database),
db.version
(the version of the database),
username
(the username which was used to connect),
jdbc_driver_name
(the name of the JDBC driver),
jdbc_driver_version
(the version of the JDBC driver),
url
(the url of the JDBC connection),
host
(currently NULL),
port
(currently NULL)
and feature.savepoints
(a logical indicating if the database supports savepoints).
dbGetException
: Not implemented. Returns an empty list.
dbListResults
: Returns an empty list. JDBC does not keep track of active results.
dbGetDriver
: Returns the JDBCDriver
which created this connection.
dbIsValid
: Check if the connection is valid. Returns a logical.
show
: Prints a short info about the connection
state
An environment for mutable states
j_connection
A jobjRef
holding a java.sql.Connection.
info
The connection info list.
driver
A JDBCDriver
object.
create_new_query_result
The factory function for JDBCQueryResult
objects.
create_new_update_result
The factory function for JDBCUpdateResult
objects.
sql_dialect
an sql_dialect
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.