Notes on Using the EJB Service
−setLong(int parameterIndex, long x)
−execute()
−setObject(int parameterIndex, Object x)
−setObject(int parameterIndex, Object x, int targetSqlType)
−setObject(int parameterIndex, Object x, int targetSqlType, int scale)
−setBigDecimal(int parameterIndex, BigDecimal x)
When column data type is round number type(real type, float type)
−setTimestamp(int parameterIndex, Timestamp x)
When column data type is character string type(char type, varchar type)
−setString(int parameterIndex, String x)
When column data type is datetime type and smalldatetime type
•ResultSetMetaData class
−getCatalogName(int column)
−getColumnLabel(int column)
•Statement class
−setEscapeProcessing(boolean enable )
−getQueryTimeout()
−setQueryTimeout(int seconds)
−cancel()
−getMoreResults()
−getResultSet()
−getUpdateCount()
•JDBC 2.0
In the JDBC 2.0, some of the methods that were supported in JDBC1.X are positioned as ‘not recommended methods’ and others are supported in place of them. Also, new classes and methods are supported.
The JDBC driver supports the following methods only in place of those no longer recommended. All other new APIs are not supported yet.
−CallableStatement class getBigDecimal(int parameterIndex)
−ResultSet class getBigDecimal(int columnIndex) getBigDecimal(String columnName)
−DriverManager class getLogWriter() setLogWriter(PrintWriter out)