• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

image and form data upload problem

 
muntago Richard
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64959
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Paul Clapham
Sheriff
Posts: 21113
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
muntago Richard
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic