aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Question on JSTL SQL tag" Watch "Question on JSTL SQL tag" New topic
Author

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!

--James
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

James Z,

It looks like you've been asked several times to fix your screen name.
Please see:
http://www.javaranch.com/name.jsp

You can change it here:
http://www.coderanch.com/forums/user/edit

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
Sheriff

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