JDBC-ODBC bridge: objects and methods

This page lists the objects and methods that are supported for the JDBC-ODBC bridge which can be called from script with db.connect() using the jdbc:olodbc prefix (see connect()).

For a description of the methods listed below, see: https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html.

Connection

The supported methods of the Connection object are:

• close()

• createStatement()

• isClosed()

• prepareStatement(String sql)

Statement

The supported methods of the Statement object are:

• close()

• executeQuery(String sql)

• getConnection()

• getMaxRows()

• getResultSet()

• setMaxRows(int max)

ResultSet

The supported methods of the ResultSet object are:

• close()

• findColumn(String columnLabel)

• getMetaData()

• getObject(int columnIndex)

• getObject(String columnLabel)

• getRow()

• getStatement()

• getString(int columnIndex)

• getString(String columnLabel)

• isClosed()

• next()

PreparedStatement

The supported methods of the PreparedStatement object are:

• executeQuery()

ResultSetMetaData

The supported methods of the ResultSetMetaData object are:

• getColumnCount()

• getColumnLabel(int column)

• getTableName(int column)