Image uploading problem

Jun 16, 2015 10:07:50

hello friends ,

i am trying to upload image and save it to mysql database
but don't no why it is giving the null pointer exception ..

please help me to solve this

following is the html code

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<form action="InsertImage" method="post" enctype="multipart/form-data">
Select Image :- <input type="file" name="imageName" />
<input type="submit" value="Save Image" >
</form>
</body>
</html>

following is the servlet code

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
FileInputStream fis=null;
Connection conn = null;
PreparedStatement pst = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "product";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";
try{
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url + dbName, userName, password);
String INSERT_PICTURE = "insert into MyPictures(photo) values (?)";
Part filePart = request.getPart("imageName");
InputStream is = null;
if (filePart != null) {
// debug messages
System.out.println(filePart.getName());
System.out.println(filePart.getSize());
System.out.println(filePart.getContentType());
// obtains input stream of the upload file
is = filePart.getInputStream();
}
if (is != null) {
// fetches input stream of the upload file for the blob column
pst.setBlob(1,is);
}
pst = conn.prepareStatement(INSERT_PICTURE);
pst.executeUpdate();
conn.commit();
System.out.println("Saved Successfully !!!!!!!");
}catch(Exception e){
e.printStackTrace();
}
}

following is the console for null pointer exception

java.lang.NullPointerException
at com.demo.image.InsertImage.doPost(InsertImage.java:59)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)

Jun 16, 2015 23:21:08

Your exception says that the problem happened at InsertImage.java:59. So go and put logging statements just before line 59 in your code and print all the values of the variables are used at line 59. This will let you know what is null.

Jun 16, 2015 23:24:56

this is the line no 59 .
which is giving null pointer exception

Jun 17, 2015 02:08:34

Is your servlet marked as @MultipartConfig?

Jun 17, 2015 02:12:51

No
how to do that ?

can you please suggest ?

Jun 17, 2015 02:18:37

You add the annotation at the top of your servlet class or you can use an xml config See here

Jun 17, 2015 02:21:41

E Armitage wrote:You add the annotation at the top of your servlet class or you can use an xml config See here

Thank you for your help

Jun 17, 2015 03:33:48

And just to preempt another Null Pointer problem, you are doing pst.setBlob before you create the PreparedStatement.

The problems of the world fade way as you eat a piece of pie. This tiny ad has never known problems:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com