Other mapping extensions

The remaining method signatures are listed next, along with any additional considerations that apply. In each case, the HCL OneDB™ type must be the last parameter to the standard JDBC PreparedStatement.setXXX() interface.

IfmxPreparedStatement.setArray()
public void setArray(int parameterIndex, Array x, int ifxType) 
   throws SQLException
IfmxPreparedStatement.setAsciiStream()
public void setAsciiStream(int i, InputStream x, int length, int 
   ifxType) throws SQLException

When your application is inserting a very large ASCII value into a LONGVARCHAR column, it is sometimes more efficient to send the ASCII value to the server using java.io.InputStream.

IfmxPreparedStatement.setBigDecimal()
public void setBigDecimal(int i, BigDecimal x, int ifxType)
   throws SQLException
IfmxPreparedStatement.setBinaryStream()
public void setBinaryStream(int i, InputStream x, int length, int 
   ifxType) throws SQLException

When your application is inserting a very large binary value into a LONGVARbinary column, it is sometimes more efficient to send the binary value to the server using java.io.InputStream.

IfmxPreparedStatement.setBlob()
public void setBlob(int parameterIndex, Blob x, int ifxType) 
   throws SQLException
IfmxPreparedStatement.setBoolean()
public void setBoolean(int i, boolean x, int ifxType) throws 
   SQLException
IfmxPreparedStatement.setByte()
public void setByte(int i, byte x, int ifxType) throws 
   SQLException
IfmxPreparedStatement.setBytes()
public void setBytes(int i, byte x[], int ifxType) throws 
   SQLException
IfmxPreparedStatement.setCharacterStream()
public void setCharacterStream(int parameterIndex, Reader reader, 
   int length, int ifxType) throws SQLException

When your application is setting a LONGVARCHAR parameter to a very large UNICODE value, it is sometimes more efficient to send the UNICODE value to the server using java.io.Reader.

IfmxPreparedStatement.setClob()
public void setClob(int parameterIndex, Clob x, int ifxType) 
   throws SQLException
IfmxPreparedStatement.setDate()
public void setDate(int i, Date x, int ifxType) throws 
   SQLException
public void setDate(int parameterIndex, Date x, Calendar Cal, 
   int ifxType) throws SQLException
IfmxPreparedStatement.setDouble()
public void setDouble(int i, double x, int ifxType) throws SQ
   LException
IfmxPreparedStatement.setFloat()
public void setFloat(int i, float x, int ifxType) throws 
   SQLException
IfmxPreparedStatement.setInt()
public void setInt(int i, int x, int ifxType) throws SQLException
IfmxPreparedStatement.setLong()
public void setLong(int i, long x, int ifxType) throws 
   SQLException
IfmxPreparedStatement.setNull()
public void setNull(int i, int sqlType, int ifxType) throws 
   SQLException
IfmxPreparedStatement.setShort()
public void setShort(int i, short x, int ifxType) throws 
SQLException
IfmxPreparedStatement.setString()
public void setString(int i, String x, int ifxType) throws 
   SQLException
IfmxPreparedStatement.setTime()
public void setTime(int i, Time x, int ifxType) throws 
   SQLException
public void setTime(int parameterIndex, Time time, Calendar Cal, 
   int ifxType) throws SQLException
IfmxPreparedStatement.setTimestamp()
public void setTimestamp(int i, Timestamp x, int ifxType) throws 
   SQLException
public void setTimestamp(int parameterIndex, Timestamp x, Calendar 
   Cal) throws SQLException