Bonjour,
Voici mon problème : je veux exécuter la requête suivante sur ma base :
INSERT INTO CLIENT VALUES('','Jean','Dupond')
J'ai l'erreur suivante :
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'IDCLIENT' at row 1
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:717)
at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3102)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1862)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1343)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1260)
at Modele.ModeleUpdateBase.<init>(ModeleUpdateBase.java:46)
at Control.ControleFenetreCreerSession.actionEvenement(ControleFenetreCreerSession.java:102)
at Control.ControleFenetreCreerSession.mouseClicked(ControleFenetreCreerSession.java:53)
at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
2830910
Erreur SQL 3:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'IDCOMPTE' at row 1
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:717)
at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTrunc
etc...
JDBC gère pourtant bien kes champs extra genre "auto-increment" ??
Merci pour vos réponses
