Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ora-17004 when using JSTL sql tag

843838Dec 20 2005 — edited Dec 21 2005

We are using the sql tag of JSTL inside JSP files for maintenance of simple database tables. It worked fine before but now generates ora-17004 error when user tried to insert a new record. The weird thing is that if user fills in all the fields of the record in the table, the error will not happen!

From what the error message says, invalid column type, filling all the fields won't be any better than just filling a subset of all fields. Is anybody experiencing similar problem before?

Furthermore, could somebody share the information of how to debug into JSTL code to get the sql statement just before it is sent to Oracle?

Thanks in advance!

--James

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2006

Added on Dec 20 2005

#javaserver-pages-jsp-and-jstl

1 comment

601 views