aspose file tools*
The moose likes JSP and the fly likes Error while parsing and storing xml data in database using jsp jstl tags Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Error while parsing and storing xml data in database using jsp jstl tags" Watch "Error while parsing and storing xml data in database using jsp jstl tags" New topic
Author

Error while parsing and storing xml data in database using jsp jstl tags

Shailesh Kumar Saxena
Greenhorn

Joined: Dec 15, 2012
Posts: 25

I have to read an xml file, display its content in the form of a table and need to store the data in database table.
Firstly I tried to only display the data using jstl1.2 tags in my jsp. It is working fine. But when I tried to implement
some code to insert the records I am getting this error..



My Jsp code is as:


Please provide your suggestion which tag shall I use to set the values to insert query parameters? How to get the xml elements data to set in query parameters?
Thanks & Regards


Shailesh Saxena,
Pilibhit, U.P. INDIA
Shailesh Kumar Saxena
Greenhorn

Joined: Dec 15, 2012
Posts: 25

I tried hard to get the solution of my problem but unfortunately couldn't get any help.
While googling I got some basic idea to cope with this. I tried this



But I got this error:



As in my table balance(last column) is integer type. When I googled I got that jstl tags automatically take care of casting.
But it is showing error as by default <c:set > tag places value for variable as string.
Any idea? Any help? Any suggestion? Please let me know.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error while parsing and storing xml data in database using jsp jstl tags
 
Similar Threads
How to store extracted xml values in a database?
JasperException with RSS and JSTL
JSTL-XML problem
JDom and XPath
How to save values in a database in JSTL?