• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Inserting into a table

 
Shaan patil
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a table name with table name = account , And The account table has four fields namely, account number,accountname,password,balance.
I am interested in inserting only first three fileds.using the following snippet of the code.


Code snippet to insert into fisrt three fields.

PreparedStatement pst=con.prepareStatement("insert into bank values(?,?,?)");
pst.setInt(1,i);
pst.setString(2,strNme);
pst.setString(3,strPwd);
pst.execute();

But I am getting SQL exception error.What is the workaround solution for the same ?

Regards
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

pst.execute();

try executeUpdate() instead. This may not do it, but without knowing what your SQLException says I can't suggest much more.
 
Shaan patil
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

The error says that insufficient value are provided.


Regards
 
kkk guptha
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

You can get the result with pst.executeUpdate(); instead of pst.execute();

--- KKKGuptha
 
Shilpa Tendulkar
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Shaan patil:

PreparedStatement pst=con.prepareStatement("insert into bank values(?,?,?)");
Regards


Try insert query as "insert into bank (accountnumber,accountname,password)
values(?,?,?)
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic