File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of Barcodes with iOS this week in the iOS forum
or Core Java for the Impatient in the Java 8 forum!

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:
subject: Question on JSTL SQL tag