sjdbc (version 1.6.0)

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.

Value

returns a data.frame containing the entire table.

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.

References

2004. http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getTypeInfo(). Java SE Developer Documentation. Redwood Shores, CA: Oracle Corporation.

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