Forums Register Login

image and form data upload problem

+Pie Number of slices to send: Send
Good day experts, i want to upload image and forms input to database using apachae method but it returns an error display below



here is my main code

For name and city, i used text datatype.
For image i used longblob

I dont know whether the problem is from datatype i used for name and city.

Please what do I do. Thanks mutago
+Pie Number of slices to send: Send
Welcome to the Ranch.

Step 1: move all the Java code out of the JSP and into a Java class where it belongs. Java code in JSPs has been discredited for over 8 years now. Time to update your JSP knowledge.

Step 2: Once in a Java class, the syntax and other errors will likely be easier to diagnose.
+Pie Number of slices to send: Send
 

muntago Richard wrote:I dont know whether the problem is from datatype i used for name and city.



First of all, you should follow Bear's advice and get that code into a servlet where it belongs. But as for the datatype you used for name and city: that's what the error messages are telling you.
You didn't use any datatype for them. See those lines numbered 17 and 18 in your posted code? Those aren't declarations, they are comments.
They don't declare datatypes for name and city, they don't do anything.
+Pie Number of slices to send: Send
Thanks for your guidance. But this programme was an assignment and i was ask to do it with Jsp technology. But if insist on moving it to java servlet.Then no problem. How ever why i comment this line
is because I was thought theortically that get parameter cannot work with mutipartform.
but when i uncomment the above 2 lines of code and secondly by removing
line 42 and 43 shown below
because i cannot convert varchar datatype to byte
the programme runs and uploads image into database but name and city returns null. Honestly,this is a very big problem for all the students.It seems apache common upload strategy is too complicated.

In a nut Shell, if You think datatype is the bone of contention. what datatype should i used for
Image,name and city.
below is the modified code.
thanks I appreciate your time and concern

No prison can hold Chairface Chippendale. And on a totally different topic ... my stuff:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 2926 times.
Similar Threads
image uploaded to database, but other column returns null
Charts In JSP
Charts In JSP
Problem loading the class
Unable to compile class for JSP
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 08:03:38.