The following table lists the JDBC data types supported by Advanced Server and the JDBC connector. If you are binding to an Advanced Server type (shown in the middle column) using the setObject() method, supply a JDBC value of the type shown in the left column. When you retrieve data, the getObject() method will return the object type listed in the right-most column:
Note: Types.REF_CURSOR is only supported for JRE 4.2.Note: Types.OTHER is not only used for UUID, but is also used if you do not specify any specific type and allow the server or the JDBC driver to determine the type. In the case where the parameter is an instance of java.util.UUID, the JDBC driver determines the appropriate internal type and sends it to the server.