Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Question on JSTL SQL tag

 
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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:
https://coderanch.com/forums/user/edit

Accounts with invalid screen names are subject to being closed.
Thank you.
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank you, James
 
You totally ruined the moon. You're gonna hafta pay for that you know. This tiny ad agrees:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic