Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 2 of 2

Thread: Exception Error on jps page to insert into database

  1. February 13th, 2013, 08:29 AM #1
    Lcc_terri
    Lcc_terri is offline
    Junior Member
    Join Date
    Feb 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default 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
    Reply With Quote Reply With Quote

  2. Default Related threads:

  3. February 13th, 2013, 09:09 AM #2
    KevinWorkman
    KevinWorkman is offline
    Crazy Cat Lady KevinWorkman's Avatar
    Join Date
    Oct 2010
    Location
    Washington, DC
    Posts
    5,424
    My Mood
    Hungover
    Thanks
    144
    Thanked 636 Times in 540 Posts

    Default 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.
    Useful links: How to Ask Questions the Smart Way | Use Code Tags | Java Tutorials
    Static Void Games - Play indie games, learn from game tutorials and source code, upload your own games!
    Reply With Quote Reply With Quote
« Try/Catch exception so i can return an array and print out an exception too | StackOverflowError in JScience »

Similar Threads

  1. how to insert data from a html page into mysql data base throw a servlet
    By hitman in forum Java Servlet
    Replies: 1
    Last Post: April 9th, 2012, 05:13 PM
  2. How to insert date in database
    By AJAXx195 in forum JDBC & Databases
    Replies: 1
    Last Post: January 24th, 2012, 03:26 PM
  3. [SOLVED] Using Java CheckBox to insert data to MSAccess Database
    By sandlucky in forum JDBC & Databases
    Replies: 1
    Last Post: May 15th, 2011, 11:43 PM
  4. Insert into database from flat file
    By HelloAll in forum JDBC & Databases
    Replies: 2
    Last Post: March 10th, 2011, 11:05 PM
  5. jsp insert into database error(java.lang.NumberFormatException: For input string: "")
    By cypher_girl in forum JavaServer Pages: JSP & JSTL
    Replies: 1
    Last Post: January 15th, 2010, 01:32 AM