Unsupported Methods in Embedded Java API

Certain JDBC methods, supported by the external NuoDB JDBC driver (nuodbjdbc.jar), are not currently supported by the Embedded Java API used for NuoDB Java stored procedures, triggers, and user defined functions. The following table lists methods that are supported in the external NuoDB JDBC driver but which are not currently supported by the Embedded Java API. Some of these methods actually do nothing in the NuoDB JDBC driver, but are accepted syntactically; these are noted as such. The methods in this table should be avoided in JDBC clients which the user may want in the future to convert to a NuoDB Java stored procedure, trigger, or user defined function.

Class Method Unsupported in Embedded Java API Notes

Connection

prepareStatement(String sql, int[] columns)

prepareStatement(String sql, String[] columns)

setReadOnly(boolean value)

setCatalog(String value)

This method does nothing in NuoDB JDBC driver.

setCatalog(String value)

setTransactionIsolation(int value)

getWarnings()

clearWarnings()

getHoldability()

close()

isValid()

getClientInfo(String name)

This method returns a hardcoded answer in NuoDB JDBC driver.

getClientInfo()

This method returns a hardcoded answer in NuoDB JDBC driver.

getNetworkTimeout()

This method returns a hardcoded answer in NuoDB JDBC driver.

CallableStatement

getBigDecimal(int paramIndex, int scale)

getBigDecimal(String paramName, int scale)

getObject(int paramIndex)

getObject(String paramName)

getCharacterStream(int paramIndex)

getCharacterStream(String paramName)

DatabaseMetaData

getURL()

getSQLKeywords()

getNumericFunctions()

getStringFunctions()

getSystemFunctions()

getTimeDateFunctions()

getExtraNameCharacters()

getVersionColumns(String catalog, String schema, String table)

This method returns a hardcoded answer in NuoDB JDBC driver.

getSuperTypes(String catalog, String schema, String type)

getSuperTables(String catalog, String schema, String table)

getRowIdLifetime()

This method returns a hardcoded answer in NuoDB JDBC driver.

getSchemas(String catalog, String schema)

getClientInfoProperties()

This method returns a hardcoded answer in NuoDB JDBC driver.

getFunctions(String catalog, String schema, String function)

getFunctionColumns(String catalog, String schema, String function, String column)

PreparedStatement

addBatch()

setAsciiStream(int paramIndex, InputStream stream, int length)

setAsciiStream(int paramIndex, InputStream stream, long length)

setAsciiStream(int paramIndex, InputStream stream)

setBinaryStream(int paramIndex, InputStream stream, int length)

setBinaryStream(int paramIndex, InputStream stream, long length)

setBinaryStream(int paramIndex, InputStream stream)

setCharacterStream(int paramIndex, Reader reader, int length)

setCharacterStream(int paramIndex, Reader reader, long length)

setCharacterStream(int paramIndex, Reader reader)

setObject(int paramIndex, Object value, int type, int scale)

setObject(int paramIndex, Object value, int type)

setObject(int paramIndex, Object value)

setDate(int paramIndex, Date value, Calendar cal)

Same as setDate(Date)

setTime(int paramIndex, Time value, Calendar cal)

Same as setTime(Time)

setTimeStamp(int paramIndex, Timestamp value, Calendar cal)

Same as setTimestamp(Timestamp)

ResultSet

The NuoDB JDBC driver only exposes read-only result sets. The embedded JDBC driver allows users to modify the result set representing the return value.

getAsciiStream(int column)

getCharacterStream(int column)

getBinaryStream(int column)

getWarnings()

clearWarnings()

getObject(int column)

isBeforeFirst()

isAfterLast()

isFirst()

isLast()

getRow()

previous()

getFetchDirection()

This method returns a hardcoded answer in NuoDB JDBC driver.

getFetchSize()

This method returns a hardcoded answer in NuoDB JDBC driver.

getType()

This method returns a hardcoded answer in NuoDB JDBC driver.

getConcurrency()

This method returns a hardcoded answer in NuoDB JDBC driver.

rowUpdated()

This method returns a hardcoded answer in NuoDB JDBC driver.

rowInserted()

This method returns a hardcoded answer in NuoDB JDBC driver.

rowDeleted()

This method returns a hardcoded answer in NuoDB JDBC driver.

getRef(int column)

getHoldability()

This method returns a hardcoded answer in NuoDB JDBC driver.

isClosed()

setFetchSize()

ResultSetMetaData

isCaseSensitive(int column)

isCurrency(int column)

isSigned(int column)

getColumnClassName(int column)

This method returns a hardcoded answer in NuoDB JDBC driver.

Statement

executeUpdate(String sql, int[] columns)

executeUpdate(String sql, String[] columns)

execute(String sql, int[] columns)

execute(String sql, String[] columns)

getMaxFieldSize()

This method returns a hardcoded answer in NuoDB JDBC driver.

getMaxRows()

setMaxRows(int max)

getQueryTimeout()

setQueryTimeout(int timeout)

getWarnings()

clearWarnings()

setCursorName(String name)

getFetchDirection()

This method returns a hardcoded answer in NuoDB JDBC driver.

setFetchDirection(int direction)

This method returns a hardcoded answer in NuoDB JDBC driver.

getFetchSize()

setFetchSize(int rows)

getResultSetConcurrency()

This method returns a hardcoded answer in NuoDB JDBC driver.

getResultSetType()

This method returns a hardcoded answer in NuoDB JDBC driver.

addBatch(String sql)

clearBatch()

getResultSetHoldability()

This method returns a hardcoded answer in NuoDB JDBC driver.

setPoolable(boolean value)

This method does nothing in NuoDB JDBC driver.

isPoolable()

This method returns a hardcoded answer in NuoDB JDBC driver.

closeOnCompletion()

This method does nothing in NuoDB JDBC driver.

isCloseOnCompletion()

This method returns a hardcoded answer in NuoDB JDBC driver.

The class ParameterMetaData has more support in the NuoDB Embedded Java API. ParameterMetaData in the NuoDB external JDBC driver only gives you the number of parameters in a prepared statement, and the names of the arguments of the stored procedure in a CALL/EXECUTE statement. In the Embedded Java API ParamaterMetaData also provides the type and precision of these arguments, i.e. access to getParameterName(), getParameterTypeName(), getParameterType(), getScale(), getPrecision(), isNullable() and getParameterMode() of the ParameterMetaData interface are exposed. The only ParameterMetaData method we don’t support in the Embedded Java API is getParameterClassName().