Insertion sql avec code java.

Fermé
Akrouti Ezzeddin Messages postés 50 Date d'inscription samedi 26 novembre 2011 Statut Membre Dernière intervention 31 mai 2012 - 30 avril 2012 à 19:33
Bonjour,
voila la requête d'insertion:

state.execute("insert into session ('dateDebutSession','dateFinSession','debitMax','debitMoy','modeTech') values ('"+getTagValue("Date",eElement)+"','"+"'DATE_ADD('"+getTagValue("Date",eElement)+"', INTERVAL '1:1' MINUTE_SECOND);'"+","+getTagValue("DebitE",eElement)+","+getTagValue("DebitR",eElement)+",'"+getTagValue("ModeTech",eElement)+"')");






Le message d'erreur:
java.sql.SQLException: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt]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 'DATE_ADD('2012-04-30 17:12:48', INTERVAL '1:1' MINUTE_SECOND);',49798.734,5100.5' at line 1
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at client.ReadXMLFile.main(ReadXMLFile.java:49)

A voir également: