Discussion :

[hidalg007]

Bonsoir j'ai une requete sql que je veux charger a travers une application java via le JDBC ODBC :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
 
res=(ResultSet)stm.executeQuery("insert into Conteneur values (' "+ Connexion.c.length+" ',' "+ctr.nom+
         " ', ' "+ctr.poids+" ' ,' "+ctr.type+" ',' " +ctr.source+" ',' "+ctr.destination+" ',' "+ctr.arrivé+" ',' "
         +ctr.depAuPlusTard+" ',' "+ctr.depAuPluTot+" ',' "+ctr.operateur+" ',' "+ctr.remarque+
         "',' "+ctr.indiceZone+" ',' "+ctr.indiceBaie+ " ',' "+ctr.indicePile+" ',' "+ctr.emp+" ');"
         );

et je reçois ça comme stacktrace :

java.sql.SQLException: No ResultSet was produced
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:259)
at baie.Connexion.inserrer(Connexion.java:360)
at baie.BaieView.jButton1ActionPerformed(BaieView.java:492)
at baie.BaieView.access$800(BaieView.java:29)
at baie.BaieView$4.actionPerformed(BaieView.java:185)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6041)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5806)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4413)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2440)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

[tchize_]

c'est executeUpdate pour les commande qui ne retournent pas de résultat. Aussi, évitez d'utiliser les pont JDBC/ODBC si vous pouvez, il n'est pas prévu pour être utilisé en production.