wood burning stoves 2.0*
The moose likes JDBC and the fly likes setNull(2, java.sql.Types.DATE);  Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic

setNull(2, java.sql.Types.DATE);

Kee Kee moon
Ranch Hand

Joined: Dec 11, 2009
Posts: 147
If I use setNull(1, java.sql.Types.DATE); function, it will insert null on my table's column.
I want to select the date from another table and insert into my table's column, what should I do?
I am sure I cannot call setNull(1,java.sql.Types.DATE), it will insert NULL in my column.

Thanks in advance.
Jan Cumps

Joined: Dec 20, 2006
Posts: 2491

Let's discuss in your original post:

OCUP UML fundamental and ITIL foundation
youtube channel
I agree. Here's the link: http://aspose.com/file-tools
subject: setNull(2, java.sql.Types.DATE);
Similar Threads
setNull(1, java.sql.Types.DATE)
addBatch - help/ideas?
preparedstatment and order by ?
Need to parse StringBuffer
JDBC and null dates