Return-Path: <just_darren@hotmail.com>
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 55776 invoked from network); 10 Jul 2000 10:13:10 -0000
Received: from f181.law3.hotmail.com (HELO hotmail.com) (209.185.241.181)
  by locus.apache.org with SMTP; 10 Jul 2000 10:13:10 -0000
Received: (qmail 66164 invoked by uid 0); 10 Jul 2000 10:12:45 -0000
Message-ID: <20000710101245.66163.qmail@hotmail.com>
Received: from 203.117.188.5 by www.hotmail.com with HTTP;
	Mon, 10 Jul 2000 03:12:45 PDT
X-Originating-IP: [203.117.188.5]
From: "Darren Lee Deliang" <just_darren@hotmail.com>
To: tomcat-user@jakarta.apache.org
Subject: I am really stumped at this one any1?
Date: Mon, 10 Jul 2000 18:12:45 SGT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed


I have problems trying to write data into my MS SQL Server database. Here is 
the codes in my java bean that calls and writes to it:

String SQLstatement ="INSERT INTO ApplicationRecord VALUES('?', '?', '?', ?, 
?, ?, ?, ?, ?, ?, ?, '?', '?', ?, ?, ?, '?', '?')";

try
{
	addcon.setAutoCommit(false);
	PreparedStatement stm = addcon.prepareStatement(SQLstatement);
	stm.setString(1, getAppNo());
	stm.setString(2, getUserNRIC());
	stm.setString(3, getCourseNo());
	stm.setDouble(4, appmanHrs);
	stm.setInt(5, appmanDays);
	stm.setTimestamp(6, appstartDate);
	stm.setTimestamp(7, appendDate);
	stm.setTimestamp(8, appDeadline);
	stm.setDouble(9, getAppFees());
	stm.setDouble(10, appfeesPaid);
	stm.setDouble(11, getAppotherCosts());
	stm.setString(12, getAppclaimDetails());
	stm.setString(13, getAppRemarks());
	stm.setBoolean(14, appsupervisorApproval);
	stm.setBoolean(15, appdirectorApproval);
	stm.setBoolean(16, appAttendance);
	stm.setString(17, appsuperNRIC);
	stm.setString(18, appdirectorNRIC);

	stm.executeUpdate();
	System.out.println(" Inserting Data Successful");

	addcon.commit();
	con.setAutoCommit(true);

	stm.close();
	addcon.close();
}
catch(SQLException ex)
{
	System.err.println("SQLException: " + ex.getMessage());
	if(addcon != null)
	{
		try
		{
			System.err.println("Transaction is being rolled back");
			addcon.rollback();
		}
		catch(SQLException excep)
		{
			System.err.println("SQLException: " + excep.getMessage());
		}
	}
}

i get the following error in my browser:

Internal Servlet Error:

javax.servlet.ServletException
	at 
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:386)
	at 
jsp.RetrainingWebApp._0002fjsp_0002fRetrainingWebApp_0002fconfirmed_0002ejspconfirmed_jsp_1._jspService(_0002fjsp_0002fRetrainingWebApp_0002fconfirmed_0002ejspconfirmed_jsp_1.java:124)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at 
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174)
	at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
	at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at 
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
	at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
	at 
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
	at java.lang.Thread.run(Unknown Source)

Root cause:
java.lang.ArrayIndexOutOfBoundsException
	at sun.jdbc.odbc.JdbcOdbcPreparedStatement.clearParameter(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setNull(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString(Unknown Source)
	at Retraining.ApplyCourses.addRecord(ApplyCourses.java:374)
	at 
jsp.RetrainingWebApp._0002fjsp_0002fRetrainingWebApp_0002fconfirmed_0002ejspconfirmed_jsp_1._jspService(_0002fjsp_0002fRetrainingWebApp_0002fconfirmed_0002ejspconfirmed_jsp_1.java:91)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at 
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174)
	at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
	at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at 
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
	at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
	at 
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
	at java.lang.Thread.run(Unknown Source)

Can any1 kindly tell me what is wrong?

Darren
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com