JDBCConnection-class: JDBCConnection class

In hoesler/dbj: Provides access to databases through the JDBC interface

Description

JDBCConnection class

Usage

## 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)

Arguments

conn	A JDBCConnection object, as produced by dbConnect.
dbObj	A JDBCConnection object, as produced by dbConnect.
...	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 JDBCConnection

Methods (by generic)

• 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

Slots

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

hoesler/dbj documentation built on May 17, 2019, 4:36 p.m.