jdbcTypeInfo
Retrieve Supported Column Type Info from a Database
Description
Retrieves a table containing the data types supported by the connected database.
Usage
jdbcTypeInfo(driverClass, con, user, password, keepAlive)
Arguments
driverClass | a string specifying the name of the Java class for the required JDBC driver. |
con | the JDBC connection string. |
user | a string specifying the user name with access to the database. |
password | a string containing the password for given the user name on the database. |
keepAlive | a logical. If TRUE, keeps the database connection alive after executing the query. The default is FALSE. |
Details
A direct interface to the java.sql.DatabaseMetaData.getTypeInfo() method. See
the Java documentation for description of the fields in the table. Useful for debugging.
Value
returns a data.frame containing the entire table.
References
Examples
## Not run:
jdbcTypeInfo(driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver",
con="jdbc:sqlserver://qadb-s2k:1433;databaseName=testdb;user=testqa;password=testqa;",
user="testqa", password="testqa")
## End(Not run)