Yes stupidly I forgot to set the connection but the errors remain. The
onSuccess():
public String onSuccess() throws Exception {
createDb();
String statement = "INSERT INTO teams(user_id, team_name,
keeper,
fullBack1, fullBack2, fullBack3, halfBack1, halfBack2, halfBack3, midfield1,
midfield2, halfForward1, halfForward2, halfForward3, fullForward1,
fullForward2, fullForward3) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?)";
prep = conn.prepareStatement(statement);
prep.setObject(1, team.getUser_id());
prep.setString(2, team.getTeam_name());
prep.setString(3, team.getKeeper());
prep.setString(4, team.getFullBack1());
prep.setString(5, team.getFullBack2());
prep.setString(6, team.getFullBack3());
prep.setString(7, team.getHalfBack1());
prep.setString(8, team.getHalfBack2());
prep.setString(9, team.getHalfBack3());
prep.setString(10, team.getMidfield1());
prep.setString(11, team.getMidfield2());
prep.setString(12, team.getHalfForward1());
prep.setString(13, team.getHalfForward2());
prep.setString(14, team.getHalfForward3());
prep.setString(15, team.getFullForward1());
prep.setString(16, team.getFullForward2());
prep.setString(17, team.getFullForward3());
prep.executeUpdate();
return "index";
}
I know its not a great idea to have the code in here, once working it will
be moved to the correct package.
--
View this message in context:
http://tapestry.1045711.n5.nabble.com/org-apache-tapestry5-runtime-ComponentEventException-tp3404853p3404886.html
Sent from the Tapestry - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org
For additional commands, e-mail: users-h...@tapestry.apache.org
