I have the same message with the version 1.3.172. But the code of the error is [50000-172]
How to know by the program wich use H2, what version is in use ? Thanks 2013/11/26 Thomas Mueller <[email protected]> > Hi, > > According to the error code ("[50000-160]") means you are using an old > version of H2, that is, version 1.3.160 from 2011-09-11. Since then, quite > a few problems have been fixed. Could you try again with a more recent > version? > > Regards, > Thomas > > > On Tue, Nov 26, 2013 at 4:26 PM, Patrice <[email protected]>wrote: > >> Hi ! >> I use H2 in a Java Program. >> This SQL order give an error : >> >> SQL = *INSERT INTO POINTS(id,longitude,latitude) VALUES >> (48602,25.91,46.05);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48603,25.88,46.22);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48604,25.79,46.37);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48605,25.65,46.49);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48606,25.47,46.56);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48607,25.51,46.7);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48608,25.42,46.84);* >> *INSERT INTO Limes(id,id_premier_point,id_dernier_point) VALUES >> (1545,48602,48608);* >> >> Error = *org.h2.jdbc.JdbcSQLException: General error: >> "java.lang.RuntimeException: rowCount expected 48602 got 48583 >> POINTS.I_LG_LA"; SQL statement:* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48602,25.91,46.05);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48603,25.88,46.22);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48604,25.79,46.37);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48605,25.65,46.49);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48606,25.47,46.56);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48607,25.51,46.7);* >> *INSERT INTO POINTS(id,longitude,latitude) VALUES (48608,25.42,46.84);* >> *INSERT INTO Limes(id,id_premier_point,id_dernier_point) VALUES >> (1545,48602,48608); [50000-160]* >> * at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)* >> * at org.h2.message.DbException.get(DbException.java:158)* >> * at org.h2.message.DbException.convert(DbException.java:281)* >> * at org.h2.table.RegularTable.addRow(RegularTable.java:139)* >> * at org.h2.command.dml.Insert.insertRows(Insert.java:124)* >> * at org.h2.command.dml.Insert.update(Insert.java:84)* >> * at org.h2.command.CommandContainer.update(CommandContainer.java:73)* >> * at org.h2.command.Command.executeUpdate(Command.java:219)* >> * at org.h2.command.CommandList.update(CommandList.java:41)* >> * at org.h2.command.Command.executeUpdate(Command.java:219)* >> * at >> org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:125)* >> * at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:110)* >> * at >> gestionhistoiremondiale.donnees.ConnexionBase.execute(ConnexionBase.java:257)* >> * at >> gestionhistoiremondialeMVC.vue.tableau.points.PointsModele.enregistrer(PointsModele.java:154)* >> * at >> gestionhistoiremondialeMVC.vue.tableau.abstrait.Tableau.enregistrer(Tableau.java:114)* >> * at >> gestionhistoiremondialeMVC.vue.document.DocumentTableau.enregistrer(DocumentTableau.java:142)* >> * at >> gestionhistoiremondialeMVC.vue.document.DocumentTableau$2.actionPerformed(DocumentTableau.java:79)* >> * 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:6505)* >> * at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)* >> * at java.awt.Component.processEvent(Component.java:6270)* >> * at java.awt.Container.processEvent(Container.java:2229)* >> * at java.awt.Component.dispatchEventImpl(Component.java:4861)* >> * at java.awt.Container.dispatchEventImpl(Container.java:2287)* >> * at java.awt.Component.dispatchEvent(Component.java:4687)* >> * 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:2719)* >> * at java.awt.Component.dispatchEvent(Component.java:4687)* >> * at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)* >> * at java.awt.EventQueue.access$200(EventQueue.java:103)* >> * at java.awt.EventQueue$3.run(EventQueue.java:694)* >> * at java.awt.EventQueue$3.run(EventQueue.java:692)* >> * 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:708)* >> * at java.awt.EventQueue$4.run(EventQueue.java:706)* >> * at java.security.AccessController.doPrivileged(Native Method)* >> * at >> java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)* >> * at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)* >> * at >> java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)* >> * at >> java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)* >> * at >> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)* >> * at >> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)* >> * at >> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)* >> * at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)* >> *Caused by: java.lang.RuntimeException: rowCount expected 48602 got 48583 >> POINTS.I_LG_LA* >> * at org.h2.message.DbException.throwInternalError(DbException.java:228)* >> * at org.h2.table.RegularTable.checkRowCount(RegularTable.java:169)* >> * at org.h2.table.RegularTable.addRow(RegularTable.java:122)* >> * ... 51 more* >> I understand the meaning of the error : h2 expect 48602 rows in the table >> POINTS and got 48583. >> The number of row is incorrect. >> >> The method for execute the SQL command is *ConnexionBase.execute(SQL);* >> In the class ConnexionBase we have >> * public static void execute(String sql)* >> * {* >> * try * >> * {* >> * //un traitement avec base modifiable (CONCUR_UPDATABLE) que >> l'on peut parcourir * >> * //dans les deux sens avec changements immédiatement visibles* >> * Statement stmt = >> connexionCourante().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, * >> * >> ResultSet.CONCUR_UPDATABLE);* >> * stmt.executeUpdate(sql);* >> * stmt.close ();* >> * } * >> * catch (SQLException e) * >> * {* >> * e.printStackTrace();* >> * } * >> * }* >> >> I precise that my table POINTS has 48601 data (1 to 48601). >> >> >> My answer is why i have this error and how i can resolve that. >> >> Thanks and sorry for my very poor english. >> >> PATRICE >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- Si vous vous intéressez à l'histoire, vous pouvez parcourir mon site : http://histoiremondiale.free.fr -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
