i have a small problem in the jsp code i have written "to send the data from form to database".
The table in the database has a primary key field whose values must be generated automatically.
so, i have created a sequence named t_seq and have written it like this:
String s = insert into tr values(t_seq.nextval,.........)
but the data isn't getting inserted
That's illegal SQL if you want to set only a subset of the fields (which you want, as you aren't setting the PK field).
You have to supply the actual fields you're setting as well, and in the correct order.