How to use Sequence using sql commands

[viral patel]

Im trying to insert data to my Accounts table. I have Created AccountId_sequence to generate accountID. I'm getting data from a form and and storing in database.Here how i'm trying to insert new data with sequence, but its not updating table. Can someone show me right way to do this.

 
stmt.executeUpdate (" INSERT INTO Accounts (firstName, lastName, mailAdress, Zipcode) VALUES (accountID_sequence.NEXTVAL,'"+firstName+"','"+lastName+"','"+address+"','"+zipCode+"')");
 

[Rajeshwari Natarajan]

u can retrieve the sequence value separately like this

select accountID_sequence.NEXTVAL from dual

store the value in a variable and use it in ur insert statement.

[SJ Adnams]

viral,
Ignore Rajeshwari your syntax looks ok to me.
try a commit(); on the connection?

[Jaime Garcia]

u are using
stmt.executeUpdate (" INSERT INTO Accounts (firstName, lastName, mailAdress, Zipcode) VALUES (accountID_sequence.NEXTVAL,'"+firstName+"','"+lastName+"','"+address+"','"+zipCode+"')");
But, the number of columns are diferent to the number of values, I mean, you should use :
(id, firstName, lastName, mailAdress, Zipcode)
where id is the name of the column where you want to insert the value of the sequence.
Hope this helps.

[SJ Adnams]

well spotted