Akrouti Ezzeddin
Messages postés50Date d'inscriptionsamedi 26 novembre 2011StatutMembreDernière intervention31 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)