Shawn Glisson

I have determined that the problem is not with the db. From a jsp page I call a static method in a seperate class that receives an integer. The integers value is 2373. Here is the static method...
public void insertMethod(int total) { int i = total; //performs insert if (conn != null) { try { while (count < i) { String insertRow = "INSERT INTO shareholders (vendor_id, vendor_name, invoice_number, date, amount) " + "VALUES ('" + vendorID[count] + "','" + vendorName[count] + "','" + invoiceNumber[count] + "','" + invoiceDate[count] + "','" + amount[count] + "')"; stat = conn.createStatement(); stat.executeUpdate(insertRow); count++; } } catch (SQLException ex) { while (ex != null) { ex.printStackTrace(); ex = ex.getNextException(); } } } }
Now when I use the variable count as the index for the arrays I only end up with 256 records instead of the 2373 that I need.
BUT
If I replace the variable count with a number like 2000, then I get all 2373 records into the table. Of course they are all the same record but it still goes through the loop the necessary amount of times.

I have tried to committhe inserts and no gold. Also my data types for the table i am inserting to consist of 4 chars and 1 decimal(10,2).
I am not sure what the problems is. Is it possible that an array in java can hold no more than 256 elements?

I am attempting to insert over 2000 rows to MySQL. My code all works correctly but from the 2300 inserts, only the first 256 inserts get saved into my table.
Is this a MySQL issue?
I am testing on WinXP Pro, with MySQL 3.23 using connector-J as the driver.
oh and my table is of type MyISAM.
please help
thanks

Nevermind - I just couldnt find my JDBC driver. That made my connection object null. I moved my JDBC, MySQL driver into the lib dir of my web app and all is well. TGIF

Here is the code...
//inserts text file values into MySQL public void insertMethod() throws IOException { //performs insert try { String insertRow = "INSERT INTO shareholders (vendor_id, vendor_name, invoice_number, date, amount) " + "VALUES ('" + vendorID[12] + "','" + vendorName[12] + "','" + invoiceNumber[12] + "','" + invoiceDate[12] + "','" + amount[12] + "')"; stat = conn.createStatement(); stat.executeUpdate(insertRow); //stat.close(); //conn.close(); } catch (SQLException ex) { while (ex != null) { ex.printStackTrace(); ex = ex.getNextException(); } }
I call this method from a jsp page and Tomcat returns and error page as follows.....
type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534) root cause java.lang.NullPointerException at admin.AdminShare.insertMethod(AdminShare.java:123) at org.apache.jsp.index_jsp._jspService(index_jsp.java:105) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534)
Please help.

Here is my JSP page....
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>MNVap Website Administration</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link href="styles.css" rel="stylesheet" type="text/css"> </head> <body bgcolor="#FFFFFF" leftmargin="0" topMargin="10" border="0" marginheight="0" marginwidth="0"> <div align="center"> <table width="760" border="0" cellpadding="0" cellspacing="0"> <tr><td colspan="3"><img src="images/title.gif" border="0"></td></tr> <tr><td bgcolor="#666600" height="5"></td><td bgcolor="#CCCC66" height="5"></td><td bgcolor="#999900" height="5"></td></tr> </table> <table width="760" border="0" cellpadding="0" cellspacing="0"> <tr><td><br></td></tr> <tr><td width="760" height="25" align="left" valign="middle" bgcolor="#008000" id="title">Update Shareholders Database</td></tr> <tr><td><br></td></tr> <form method="get" action="index.jsp"> <tr><td>Enter the File Name:<input type="text" name="whatfile" /> <input type="submit" value="Go" /></td></tr> </form> </table> <%@ page import="admin.*" %> <%@ page buffer="8000kb" %> <% Shareholders sh = new Shareholders(request.getParameter("whatfile")); if (sh.huh() != null) { out.print(sh.totalLines()); } %> <% out.print(sh.huh()); %> <br> </div> </body> </html>
Here is my public class....
package admin; import java.io.*; import java.util.*; public class Shareholders { String fileName; public Shareholders(String file) { this.fileName = file; } public int totalLines() { int x = 1; try { BufferedReader in = new BufferedReader(new FileReader(fileName)); String s = in.readLine(); StringTokenizer line = new StringTokenizer(s, "\n"); while ((s = in.readLine()) != null) { if (line.hasMoreTokens()) { x++; } } in.close(); } catch (IOException e) { System.err.println(fileName); System.exit(1); } return x; } public String huh() { return fileName; } }
The Problem...
From my JSP page I call the 'public int totalLines()' method in my public class. That method works fine running in a standalone app. but when I attempt to execute it on Tomcat it crashes.
The JSP file takes the filename as a string input. Then it looks for that filename and when it goes into count the total lines in that file it crashes. In fact if I enter in any random string, once it hits that totalLines() method it crashes. I am not validating the string at this point and wont need to when this is complete. But WHY is it crashing when I call that method???
Is Tomcat not finding the file? Where does this text file need to go in relation to my class and JSP files?
Please help...
thanks