1 Replies - 13542 Views - Last Post: 07 July 2008 - 04:49 PM Rate Topic: -----

#1 fsloke  Icon User is offline

  • D.I.C Regular

Reputation: 25
  • View blog
  • Posts: 412
  • Joined: 19-December 07

How to set null value in Java Store Procedure?

Posted 07 July 2008 - 08:59 AM

How to set null value in Java Store Procedure?

It using CallableStatement...


How?
Is This A Good Question/Topic? 0
  • +

Replies To: How to set null value in Java Store Procedure?

#2 pbl  Icon User is offline

  • There is nothing you can't do with a JTable
  • member icon

Reputation: 8334
  • View blog
  • Posts: 31,857
  • Joined: 06-March 08

Re: How to set null value in Java Store Procedure?

Posted 07 July 2008 - 04:49 PM

View Postfsloke, on 7 Jul, 2008 - 08:59 AM, said:

How to set null value in Java Store Procedure?

It using CallableStatement...


How?


cs.setNull(index, sql.Types.INTEGER);
cs.setNull(index, sql.Types.DOUBLE);
cs.setNull(index, sql.Types.ARRAY);
cs.setNull(index, sql.Types.VARCHAR);
cs.setNull(index, sql.Types.BLOB);
cs.setNull(index, sql.Types.DATE);
cs.setNull(index, sql.Types.TIME);
cs.setNull(index, sql.Types.TIMESTAMP);
...
cs.setNull(index, sql.Types.OTHER); // for Object
Was This Post Helpful? 1

Page 1 of 1