Addition of JDBCTypes enum and SQLType interface

[Lance Andersen - Oracle]

Based on an earlier discussion with the JDBC EG, we are planning to add an additional set/updateObject which leverages a SQLType

The changes include the addition of  JDBCTypes enum and a SQLType interface which will be used for the new generic setObject.  This pattern is from Effective Java 2 and is used already in java.nio.file.  As an example see:


Files.copy(Path source, Path target, CopyOptions... options)



So we would have a signature similar to the following in PreparedStatement/CallableStatement:

 void setObject(int  columnIndex, Object x, SQLType type) 
 void setObject(String columnLabel, Object x, SQLType type)

similar change would be added to ResultSet for updateObject

Attached is the javadocs for JDBCTypes and SQLType.




Best
Lance

Lance Andersen| Principal Member of Technical Staff | +1.781.442.2037
Oracle Java Engineering 
1 Network Drive 
Burlington, MA 01803
Lance.Andersen at oracle.com