jQuery in Action, 3rd edition
The moose likes JSP and the fly likes Question on JSTL SQL tag Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Question on JSTL SQL tag" Watch "Question on JSTL SQL tag" New topic

Question on JSTL SQL tag

James Zhang
Ranch Hand

Joined: Sep 06, 2002
Posts: 30
Recently I got a weird error with the SQL tag of JSTL. We are using JSTL for simple database table maintenance and it worked fine before. I don't know what is changed but now we got sql error ORA-17004 (Invalid column type) every time when user tries to insert a new record. However, if all the form fields are filled in, there will be no problem. Does anybody have similar experience before?

By the way, We are using <sql aram...> and <sql ateparam...> to pass the values to the Sql statement, but I checked several times of the values passed in and there should not be any problem.

Thanks in advance!

Ben Souther

Joined: Dec 11, 2004
Posts: 13410

James Z,

It looks like you've been asked several times to fix your screen name.
Please see:

You can change it here:

Accounts with invalid screen names are subject to being closed.
Thank you.

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
Ben Souther

Joined: Dec 11, 2004
Posts: 13410

Thank you, James
I agree. Here's the link: http://aspose.com/file-tools
subject: Question on JSTL SQL tag
It's not a secret anymore!