File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes how to the setNull() method Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to the setNull() method" Watch "how to the setNull() method" New topic
Author

how to the setNull() method

ramchander yshetti
Ranch Hand

Joined: Apr 22, 2006
Posts: 97
hai,
i created a table student(sno number(2),sname varchar2(15));
i want to set null to the, sno and sname.

->i tried using the
insert into student values(?,?);

st.setNull(1,null);
st.setNull(2,null);

-> but it is not working.
->can any one suggest me.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29245
    
139

Are there any other fields? You can't set all the fields to null in a row - it would have no meaning.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to the setNull() method
 
Similar Threads
Data Conversion Process
facing problem while creating JPA namedQuery
how to the setNull() method
Error in ArrayList and Enumeration program. need help please...
Regd: Pass sql statements through XML