File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes setting the null  and getting null Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "setting the null  and getting null" Watch "setting the null  and getting null" New topic

setting the null and getting null

ramchander yshetti
Ranch Hand

Joined: Apr 22, 2006
Posts: 97
sorry, iam not clear about the answer

i created a table as

sno number(5)
sname varchar2(15)

PreparedStatement pst=con.prepareStatement("insert into mytab values(?,?)");
pst.setNull(1,Types.NULL); //invalid column name

when i execute the above program it is giving the invalid column name
error at run time.

please solve my query.
and how to getNull value form table..
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1082

Originally posted by yathamshetti ramchander:
sorry, iam not clear about the answer

Seems it is continuation of other thread

Make your PreparedStatement as

PreparedStatement pst=con.prepareStatement("insert into mytab(sno,sname ) values(?,?)");


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Parthasarathy balakrishnan

Joined: Apr 20, 2007
Posts: 14
hi Yathamshetti ramchander ,

change your code and work it out

PreparedStatement pst=con.prepareStatement("insert into <<tablename>> values(?,?)");
pst.setNull(1,java.sql.Types.INTEGER); //invalid column name

example can be view in :


Thanks and Regards,<br />-------------------<br />Parthasarathy Balakrishnan,<br />Bangalore.
I agree. Here's the link:
subject: setting the null and getting null
jQuery in Action, 3rd edition