exception lors d'insertion (PreparedStatement)
salut,
j'ai executé depuis java la requete suivante et j'ai eu une exception
Code:
1 2 3 4 5 6 7 8
| window.requete = "INSERT INTO logfile VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)";
PreparedStatement p;
p = (PreparedStatement)window.connexion.prepareStatement(window.requete);
p.setShort(1, (short)omsg.get_Creator());
.
.
.
p.executeUpdate(window.requete); |
Code:
1 2 3 4
| com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '?, ?, ?, ?, ?, ?, ?, ?, ?)' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) |
qu'est ce qui cloche?:calim2: