where is your connection (field conn) set?


Von:    robnangle <robnan...@gmail.com>
An:     users@tapestry.apache.org
Datum:  01.03.2011 13:53
Betreff:        Re: org.apache.tapestry5.runtime.ComponentEventException



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


Reply via email to