Passage de mysql à derby, probleme
Bonsoir, tout mon application ayant été dévéloppé avec mysql, je me vois dans l'obligation de passer à derby. Jusqu'ici tout va bien mais voici comment je gère mes tableaux sous mysql
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| public static void InitialiserTableau() throws SQLException {
String query = "SELECT * FROM produits ORDER BY nom ASC";
Requete rq = new Requete();
rq.connexion();
ResultSet resultat = rq.executer(query);
ResultSetMetaData Mresultat = resultat.getMetaData();
Object[] titre = {"Matricule","Nom","Marque","Categorie","Prix Unitaire","Prix D'achat"};
resultat.last();
Object[][] data = new Object[resultat.getRow()][Mresultat.getColumnCount()];
resultat.beforeFirst();
int j = 1;
while (resultat.next()) {
for (int i = 1; i <= Mresultat.getColumnCount(); i++) {
data[j - 1][i - 1] = resultat.getObject(i);
}
j++;
}
jTable1.setModel(new DefaultTableModel(data, titre));
} |
tout marchais bien mais sous derby j'ai ces erreurs que je ne comprends pas et que je ne sais pas comment les corriger.
Citation:
sept. 24, 2015 10:07:32 PM Tg.Base.Conteneur jMenuItem8ActionPerformed
Grave: null
java.sql.SQLException: La méthode 'last()' est uniquement autorisée sur les curseurs de défilement.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.checkScrollCursor(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.last(Unknown Source)
at Tg.Pharmacie.GestionProduits.InitialiserTableau(GestionProduits.java:36)
at Tg.Pharmacie.GestionProduits.<init>(GestionProduits.java:26)
at Tg.Base.Conteneur.togererproduits(Conteneur.java:89)
at Tg.Base.Conteneur.jMenuItem8ActionPerformed(Conteneur.java:483)
at Tg.Base.Conteneur.access$700(Conteneur.java:32)
at Tg.Base.Conteneur$8.actionPerformed(Conteneur.java:262)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
at java.awt.Component.processMouseEvent(Component.java:6504)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
at java.awt.Component.processEvent(Component.java:6269)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4860)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4686)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2713)
at java.awt.Component.dispatchEvent(Component.java:4686)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
at java.awt.EventQueue.access$000(EventQueue.java:101)
at java.awt.EventQueue$3.run(EventQueue.java:666)
at java.awt.EventQueue$3.run(EventQueue.java:664)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:680)
at java.awt.EventQueue$4.run(EventQueue.java:678)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
Caused by: java.sql.SQLException: La méthode 'last()' est uniquement autorisée sur les curseurs de défilement.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 49 more
merci d'avance
