error: Parameter index out of range (3 > number of parameters, which is 2).

[fred kitu]

im stuck on this problem where i can generate entries from the db but i cant do inputs
here is the service class and the above mentioned is the error im getting
i have triple checked the variables and they seem to be fine
help please. thanks

kitu

package com.assign4.service;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.naming.InitialContext;
import javax.sql.DataSource;

import com.assign4.model.Contact;
import com.assign4.model.Email;
import com.assign4.model.Phone;
import com.assign4.model.Anniversary;


public class ContactService {
		
		public static void persistContact(Contact contact) {
			Connection conn = null;
			PreparedStatement ps = null;
			Statement stmt = null;
			ResultSet rs = null;
			try { 
				InitialContext ctx = new InitialContext();
				DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/ics425");
				conn = ds.getConnection();
				conn.setAutoCommit(false);
				
				String contactInsert = "insert into contact(f_name, l_name) values(?,?)";
				String phoneInsert = "insert into phone(work_phone, home_phone) values(?,?)";
				String emailInsert = "insert into email(work_email, home_email) values(?,?)";
				String anniversaryInsert = "insert into anniversary(birthday, mothers_birthday) values(?,?)";


				
				Phone phone = contact.getPhone();
				Email email = contact.getEmail();
				Anniversary anniversary = contact.getAnniversary();

				
				ps = conn.prepareStatement(contactInsert);
				ps.setString(1, contact.getFirstName());
				ps.setString(2, contact.getLastName());
				ps.executeUpdate();
//				if (true) throw new Exception();
				
								
				stmt = conn.createStatement();
				rs  = stmt.executeQuery("SELECT LAST_INSERT_ID()FROM CONTACT");
				if (rs.next()) {
					int i = rs.getInt(1);
					ps = conn.prepareStatement(phoneInsert);
					ps.setString(1, phone.getWorkPhone());
					ps.setString(2, phone.getHomePhone());
					ps.setInt(3, i);
					ps.executeUpdate();
				}
				else{
					throw new IllegalStateException("Unable to retrieve last insert id");
				}
				
				stmt = conn.createStatement();
				rs  = stmt.executeQuery("SELECT LAST_INSERT_ID() from CONTACT");
				if (rs.next()) {
					int i = rs.getInt(1);
					ps = conn.prepareStatement(emailInsert);
					ps.setString(1, email.getWorkEmail());
					ps.setString(2, email.getHomeEmail());
					ps.setInt(3, i);
					ps.executeUpdate();
				}
				else
					
				{
					throw new IllegalStateException("Unable to retrieve last insert id");
				}
				stmt = conn.createStatement();
				rs  = stmt.executeQuery("SELECT LAST_INSERT_ID() from CONTACT");
				if (rs.next()) {
				
					int i = rs.getInt(1);
					ps = conn.prepareStatement(anniversaryInsert);
					ps.setString(1, anniversary.getBirthday());
					ps.setString(2, anniversary.getMbirthday());
					ps.setInt(3, i);
					ps.executeUpdate();
				} 
				else
					
				{
					throw new IllegalStateException("Unable to retrieve last insert id");
				}
				conn.commit();
			} catch (Exception e) {
				if (null != conn) {
					try {
						conn.rollback();
					} catch (SQLException se) {
						se.printStackTrace();
					}
				}
				e.printStackTrace();
			} finally {
				try {
					if (null != ps) ps.close();
					if (null != conn) conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
		
		public static List<Contact> getAllContacts(boolean useDataSource) {
			Connection conn = null, connDS = null;
			PreparedStatement ps = null;
			Statement stmt = null;
			ResultSet rs = null;
			ArrayList<Contact> contList = new ArrayList<Contact>();
			try {			
				if (useDataSource) {
					InitialContext ctx = new InitialContext();
					DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/ics425");
					conn = ds.getConnection();				
				} else {
					String dbURL = "jdbc:mysql://127.0.0.1:3306/assign3";
					String userName = "assign3";
					String password = "";
					conn = DriverManager.getConnection(dbURL, userName, password);				
				}
				String selectAll = "select F_NAME, L_NAME, WORK_PHONE, HOME_PHONE, WORK_EMAIL, HOME_EMAIL, BIRTHDAY, MOTHERS_BIRTHDAY " +
				                   " from contact c inner join phone p on p.contact_ID = C.ID INNER JOIN email e on e.contact_ID = c.ID " +
				                   " inner join anniversary a on a.contact_ID = c.ID";	

	stmt = conn.createStatement();
				rs  = stmt.executeQuery(selectAll);
				while (rs.next()) {
					
					Contact cont = new Contact();
					Email em =new Email();
					Phone ph =new Phone();
					Anniversary ann =new Anniversary();
					
					
					cont.setFirstName(rs.getString("F_NAME"));
					cont.setLastName(rs.getString("L_NAME"));
					ph.setWorkPhone(rs.getString("WORK_PHONE"));
					ph.setHomePhone(rs.getString("HOME_PHONE"));
					em.setWorkEmail(rs.getString("WORK_EMAIL"));
					em.setHomeEmail(rs.getString("HOME_EMAIL"));
					ann.setBirthday(rs.getString("BIRTHDAY"));
					ann.setMbirthday(rs.getString("MOTHERS_BIRTHDAY"));
					
					cont.setPhone(ph);
					cont.setEmail(em);
					cont.setAnniversary(ann);
					contList.add(cont);
				}			
			} catch (Exception e) {
				e.printStackTrace();
			} finally {
				try {
					if (null != ps) ps.close();
					if (null != conn) conn.close();
					if (null != connDS) connDS.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}		
			return contList;		
		}
	


}


HERE IS THE mySQL ddl
create table USER (
	ID int not null auto_increment, 
	FIRST_NAME varchar(50), 
	LAST_NAME varchar(50),
 	USERNAME varchar(30),
	PASSWORD varchar(30),
	primary key (ID)
	
);
create table ADDRESS (
	ID int not null auto_increment,
	STREET varchar (50),
	CITY varchar (20),
	STATE varchar (20),
	ZIP varchar(8),
	USER_ID int,
	constraint primary key (ID),
	constraint foreign key (USER_ID) references User (ID)
);

create table CONTACT (
	ID int not null auto_increment, 
	F_NAME varchar(50), 
	L_NAME varchar(50),
	constraint primary key (ID)
	); 	

create table PHONE (
	ID int not null auto_increment, 
	WORK_PHONE varchar(50), 
	HOME_PHONE varchar(50),
	CONTACT_ID int,
	constraint primary key (ID),
	constraint foreign key (CONTACT_ID) references CONTACT (ID)
); 	
create table EMAIL (
	ID int not null auto_increment, 
	WORK_EMAIL varchar(50), 
	HOME_EMAIL varchar(50),
	CONTACT_ID int,
	constraint primary key (ID),
	constraint foreign key (CONTACT_ID) references CONTACT (ID)
); 
create table ANNIVERSARY (
	ID int not null auto_increment, 
	BIRTHDAY varchar(50), 
	MOTHERS_BIRTHDAY varchar(50),
	CONTACT_ID int,
	constraint primary key (ID),
	constraint foreign key (CONTACT_ID) references CONTACT (ID)
	); 

[Maneesh Godbole]

Welcome to the Ranch

In future, while posting code, please UseCodeTags I have added them this time for you. As you can see, the tags make the code much more easier to read and understand.
Your question has got nothing to do with Servlets, which this forum is all about. I will move this post to a more appropriate forum for you.

[Lalit Mehra]

Please share the error log and the line number you are receiving error on.

[fred kitu]

i apologize in advance

this has tags in my dev kit page but when i paste it here they no longer there

dont how to add them on this page yet...in the meantime here is the error log

apologies once again

Apr 02, 2013 5:07:02 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.7.0_13\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre7/bin/client;C:/Program Files/Java/jre7/bin;C:/Program Files/Java/jre7/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\ThinkPad\Bluetooth Software\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Common Files\Lenovo;C:\Program Files\Common Files\Ulead Systems\MPEG;C:\Program Files\Lenovo\Access Connections\;C:\Program Files\Lenovo\Client Security Solution;C:\METRO STATE FILES\ICS 425\software\eclipse;;.
Apr 02, 2013 5:07:02 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:Assignment3' did not find a matching property.
Apr 02, 2013 5:07:02 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:assign3' did not find a matching property.
Apr 02, 2013 5:07:02 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:cs425s13-lab5' did not find a matching property.
Apr 02, 2013 5:07:02 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:Assignment_3' did not find a matching property.
Apr 02, 2013 5:07:02 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:assign3- original' did not find a matching property.
Apr 02, 2013 5:07:02 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:servlet' did not find a matching property.
Apr 02, 2013 5:07:02 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:assign4' did not find a matching property.
Apr 02, 2013 5:07:02 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Apr 02, 2013 5:07:02 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Apr 02, 2013 5:07:02 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1014 ms
Apr 02, 2013 5:07:02 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Apr 02, 2013 5:07:02 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.35
Apr 02, 2013 5:07:05 AM org.apache.catalina.core.StandardContext resourcesStart
SEVERE: Error starting static Resources
java.lang.IllegalArgumentException: Document base C:\Users\User\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Assignment3 does not exist or is not a readable directory
at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.java:138)
at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext.java:4912)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5092)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)

Apr 02, 2013 5:07:05 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error in resourceStart()
Apr 02, 2013 5:07:05 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error getConfigured
Apr 02, 2013 5:07:05 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/Assignment3] startup failed due to previous errors
Apr 02, 2013 5:07:05 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Apr 02, 2013 5:07:05 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Apr 02, 2013 5:07:05 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 2255 ms
Apr 02, 2013 5:07:15 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading Context with name [/Assignment_3] has started
Apr 02, 2013 5:07:15 AM org.apache.catalina.core.StandardContext reload
INFO: Reloading Context with name [/Assignment_3] is completed
java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3813)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3795)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3840)
at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3784)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:120)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:120)
at com.assign4.service.ContactService.persistContact(ContactService.java:59)
at com.assign4.controllers.CreateContactServlet.doPost(CreateContactServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3813)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3795)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3840)
at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3784)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:120)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:120)
at com.assign4.service.ContactService.persistContact(ContactService.java:59)
at com.assign4.controllers.CreateAnniversaryServlet.doPost(CreateAnniversaryServlet.java:49)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
java.sql.SQLException: Access denied for user 'assign3'@'localhost' (using password: NO)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at com.assign4.service.ContactService.getAllContacts(ContactService.java:132)
at org.apache.jsp.displaycontacts_jsp._jspService(displaycontacts_jsp.java:84)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339)
at com.assign4.controllers.CreateAnniversaryServlet.doPost(CreateAnniversaryServlet.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)

[Maneesh Godbole]

fred kitu wrote:
this has tags in my dev kit page but when i paste it here they no longer there

dont how to add them on this page yet...

Here is how you can add the code tags https://coderanch.com/how-to/java/UseCodeTags

[Vanessa Danin]

The problem is that the prepared statements which set parameters for the phoneInsert, emailInsert and anniversaryInsert sql Strings are setting three parameters and yet the query Strings only declare two parameter placeholders. For example, you have declared String phoneInsert = "insert into phone(work_phone, home_phone) values(?,?)" which has two parameter placeholders (?,?). However, you then try to set three parameters (two Strings and one int) by coding the following:
ps.setString(1, phone.getWorkPhone());
ps.setString(2, phone.getHomePhone());
ps.setInt(3, i);

[fred kitu]

thanks vannesa
i more question
im trying to set the foreign key with SELECT_LAST_ID()
SELECT_LAST_ID() can only work from the last auto increment entry...
how do i modify that to get from previous entries or a specific ? foreign key the remainder of the table happens to be CONTACT_ID
i get this error

INFO: Reloading Context with name [/Assignment_3] is completed
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`assign3`.`email`, CONSTRAINT `email_ibfk_1` FOREIGN KEY (`CONTACT_ID`) REFERENCES `contact` (`ID`))
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)