Previous Topic

Next Topic

Passing "NULL" as a JDBC Prepared Statement Parameter

It is common to submit a NULL value for a c-treeSQL statement parameter in a JDBC function to bind the parameter such as the following:

CtreePreparedStatement.setString(x,null)

The c-treeSQL JDBC driver has been enhanced to support passing null as a value to the following supported functions:

  • CtreePreparedStatement.setBigDecimal()
  • CtreePreparedStatement.setString()
  • CtreePreparedStatement.setBytes()
  • CtreePreparedStatement.setDate()
  • CtreePreparedStatement.setTime()
  • CtreePreparedStatement.setTimestamp()
  • CtreePreparedStatement.setObject()

Note: Functions not in this list are not qualified to accept the NULL value.