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.
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.