How to set a MySQL TIMESTAMP to null

Fernand Vanrie <[email protected]> Thu, 24 Jun 2010 14:09:53 +0200
Newsgroups gmane.comp.openoffice.dba.devel
Message-ID <[email protected]>
Hallo all

Windows
00 3.2.1
MySQL as dbsever
native connector
we  use a "preparedstatement" to update a mySQL table with a timestamp 
column and text columns

oStatement.setNull(1,1111 ) for a "textfield" works fine (1111 = long 
SQLType "others")
oStatement.setNull(2,1111 ) for a "timestamp" returns "00-00-00 
00:00:00" and not the Mysql (null)

i tried SQLtype 0 also with same results


Thanks for any hint

Fernand