Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Error while uploading files in database through plugin

Vedant Kulkarni
Vedant Kulkarni November 15, 2017

I am getting error after navigating to servlet url is that 

java.lang.IllegalStateException: Unable to process parts as no multi-part configuration has been provided

I correctly written servlet url in .xml file 

CourseSchedule.java

@WebServlet("/CourseSchedule")

@MultipartConfig()
@@Named("CourseSchedule"
public class CourseSchedule extends HttpServlet
{
@ComponentImport
private TemplateRenderer tr;
@ComponentImport
private PageBuilderService pbs;
@ComponentImport
private ActiveObjects ao;

@Inject
public CourseSchedule(TemplateRenderer tr, PageBuilderService pbs,ActiveObjects ao)
{
this.tr=tr;
this.pbs=pbs;
this.ao=ao;
}

@Override
protected void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException
{

tr.render("/templates/adminOperations/courseSchedule.vm", response.getWriter());

Connection con=null;
Statement st=null;
String msg=null;
String url="jdbc:mysql://localhost:3306/LU_Data?useSSL=false";
String user="root";
String password="123456";

Random rand = new Random();
int n = rand.nextInt(9999) + 1;
String idTemp=(String.valueOf(n));

String semesterName=request.getParameter("semesterName");
Part part=request.getPart("scheduleFile");

PrintWriter pw=response.getWriter();
pw.print(semesterName);

InputStream is=null;

if(part != null)
{
long fileSize=part.getSize();
String fileContent=part.getContentType();
is=part.getInputStream();
}

try
{
Class.forName("com.mysql.cj.jdbc.Driver");

con=DriverManager.getConnection(url, user, password);

PreparedStatement pst=con.prepareStatement("INSERT INTO Course_schedule VALUES(?,?,?)");
pst.setString(1, semesterName);
pst.setString(2, idTemp);

pst.executeUpdate();

if(is!=null)
{
pst.setBinaryStream(3, is, (int) part.getSize());
}

int row=pst.executeUpdate();

if(row==0)
{
pw.print("Error in Uploading a file");
}
else
{
pw.print("File Uploaded Successfully");

}

}
catch(SQLException e)
{
e.printStackTrace();
} catch (ClassNotFoundException e)
{
e.printStackTrace();
}
finally
{
if(con!= null)
try {
con.close();
}catch(SQLException e) {e.printStackTrace();}
}
}

courseSchedule.vm

<html>
<head>
<title>Course Schedule</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<center>
<h1>Upload Course Schedule</h1>
<form action="CourseSchedule" method="post" enctype="multipart/form-data">
<table border="0">
<tr>
<td>Semester Name</td>
<td><input type="text" name="semesterName" size="50"/></td>
</tr>
<tr>
<td>Course Schedule File </td>
<td><input type="file" name="scheduleFile" size="50"/></td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="Upload">
</td>
</tr>
</table>
</form>
</center>
<center>
</center>
</body>
</html>

 

Answer
Watch
Like Be the first to like this
697 views

0 answers

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events