need help on multipart/form-data

[Manjit Barman]

Hi,
we have an application where JSP's sending a form data to the database.
Form data validation is done on Javascript in the client side.
Everything is working fine so far.
My manager came up with a new requirement to upload and download files through the JSP's to the Oracle Database.

In form section

Previously...
<form name="ReportForm" method="POST" onSubmit="CheckFields();"
.......
.....
</form>

NOW
<form name="ReportForm" method="POST" onSubmit="CheckFields(); enctype="multipart/form-data">
.......
.....
</form>

When i put "enctype="multipart/form-data" i am getting sql exception
Exception: java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected

So,my question is that....what is the effect of form data when use
enctype="multipart/form-data"?

Thanks!

[Bear Bibeault]

One major effect is that request.getParameter() and its cousins no longer work.

[Luke Shannon]

You need to get your params a different way. Here is how I'm getting them (using the oreilly.servlets package, commons.fileupload has something similar):

protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
//put all params in here
Hashtable parameters = new Hashtable();
try {
// file limit size of five megabytes
MultipartParser parser = new MultipartParser(request,
5 * 1024 * 1024);
Part _part = null;
while ((_part = parser.readNextPart()) != null) {
if (_part.isFile()) {
//do all the file upload stuff here
}
//grab all the params 
else if (_part.isParam()) {
ParamPart param = (ParamPart)_part;
parameters.put(param.getName(), param.getStringValue());
}
}// end while

} catch (Exception e) { }
 
}

[Manjit Barman]

Thanks you so much!