Exception Error on jps page to insert into database
Good Afternoon Ladies and Gentlemen
I have a problem where i am maintaining a bespoke system that was designed by someone else. i only have a little knowledge of java. We have a jsp page (createaccounts_fast_jsp) that runs automatically during the night... the page basically looks at one database (sql) and imports/updates the data in a mysql database on another server.
Some records are inserted/updated but others are not. This is the expection error i am getting in my log file.
can anyone help me please......as i'm new to java.
java.sql.SQLException: Error reading from InputStream java.io.IOException
at com.mysql.jdbc.PreparedStatement.readblock(Prepare dStatement.java:2376)
at com.mysql.jdbc.PreparedStatement.streamToBytes(Pre paredStatement.java:2486)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(Pr eparedStatement.java:2304)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1746)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1619)
at org.apache.jsp.createaccounts_fast_jsp._jspService (createaccounts_fast_jsp.java:1849)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:136)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:204)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:289)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:240)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:558)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run( JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
i will thank you in advance.... i have been trying to work out this error for weeks now but getting no where.... please help. :-(
thank you:-?
Re: Exception Error on jps page to insert into database
It's going to be pretty impossible to help you without any code, specifically an SSCCE. But it sounds like your problem is more intricate than a simple SSCCE, so I'm not sure what we can do over a forum. If this is for your job, you might suggest putting a Java developer on the project.