[h2] Re: Congrats on MVStore!
Is this it? http://search.maven.org/#search%7Cga%7C1%7Ca%3A%22h2-mvstore%22 -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Erroraccessingdatabase
Hi, I think this issue was resolved in version 1.4.179, see the changelog entry: - Databases created with version 1.3.175 and earlier that contained foreign keys in combination with multi-column indexes could not be opened in some cases. This was due to a bugfix in version 1.3.176: Referential integrity constraints sometimes used the wrong index. I suggest to use a recent version of H2, but append ;mv_store=false to the database URL. Worst case, you would need to export the database to a SQL script with an old version, and re-created it from the script in the new version. Regards, Thomas On Fri, May 22, 2015 at 6:29 PM, Carson carsonhuang2...@gmail.com wrote: Hi, I'm new to H2, and I have to work with an pre-existing h2 database. So basically, when I first access the database through the console, I manage to log in. However, after disconnecting, and trying to re-access it, I get the following error: Unique index or primary key violation: PRIMARY KEY ON .PAGE_INDEX; SQL statement: ALTER TABLE PUBLIC.PPT_TEMPLATE ADD CONSTRAINT PUBLIC.CONSTRAINT_21 FOREIGN KEY(ID_TEMPLATE) REFERENCES PUBLIC.PPT_TEMPLATE(ID_TEMPLATE) NOCHECK [23505-176] The only way for to re-access it is to get a fresh copy in git, but everytime, after I access it, I won't be able to re-access it... Can anyone pinpoint me to where I may be able to solve this issue? My database version is 1.3.176 (I took the version shown on the tab when I open the database through the H2 console tab) My URL is: jdbc:h2:C:\Users\Carson\db\PPT_DB;CIPHER=AES -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout. -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Strange NoClassDefFoundError with 1.4.178
Hi, this issue seems to affect multiple users (me including) so it's not just a local configuration issue Sorry I can't follow your reasoning. Just because multiple people get the same problem doesn't mean it's _not_ a local configuration issue. Most likely it _is_ a local configuration problem. See also http://stackoverflow.com/questions/34413/why-am-i-getting-a-noclassdeffounderror-in-java Regards, Thomas On Sun, May 17, 2015 at 8:52 PM, Aydin K. ako...@gmail.com wrote: Hi Thomas, this issue seems to affect multiple users (me including) so it's not just a local configuration issue. Please see also: http://stackoverflow.com/questions/23572460/h2-database-in-tomcat-with-server-mode-and-automatic-mixed-mode-when-using-activ Grüße, Aydin Am Freitag, 13. Juni 2014 15:20:11 UTC+2 schrieb Thomas Mueller: Hi, See http://stackoverflow.com/questions/34413/why-am-i-getting-a-noclassdeffounderror-in-java Regards, Thomas On Wed, Jun 11, 2014 at 8:52 AM, Peter Schütt goo...@pstt.de wrote: Hallo, I got a strange error with the following configuration jdbc:h2:file:c:\\temp\\h2\\mydatabase;AUTO_SERVER=TRUE;MODE=Oracle Allgemeiner Fehler: java.lang.NoClassDefFoundError: org/h2/mvstore/db/TransactionStore$1 General error: java.lang.NoClassDefFoundError: org/h2/mvstore/db/TransactionStore$1 [5-178] http://10.12.111.141:8082/login.do?jsessionid=a164e3daa845fac830cad2320b880769# HY000/5 (Hilfe) http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c5 org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler: java.lang.NoClassDefFoundError: org/h2/mvstore/db/TransactionStore$1 General error: java.lang.NoClassDefFoundError: org/h2/mvstore/db/TransactionStore$1 [5-178] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344 http://h2database.com/html/source.html?file=org/h2/message/DbException.javaline=344build=178) at org.h2.message.DbException.get(DbException.java:167 http://h2database.com/html/source.html?file=org/h2/message/DbException.javaline=167build=178) at org.h2.message.DbException.convert(DbException.java:290 http://h2database.com/html/source.html?file=org/h2/message/DbException.javaline=290build=178) at org.h2.server.TcpServerThread.sendError(TcpServerThread.java:222 http://h2database.com/html/source.html?file=org/h2/server/TcpServerThread.javaline=222build=178) at org.h2.server.TcpServerThread.run(TcpServerThread.java:155 http://h2database.com/html/source.html?file=org/h2/server/TcpServerThread.javaline=155build=178) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NoClassDefFoundError: org/h2/mvstore/db/TransactionStore$1 at org.h2.mvstore.db.TransactionStore.getChanges(TransactionStore.java:511 http://h2database.com/html/source.html?file=org/h2/mvstore/db/TransactionStore.javaline=511build=178) at org.h2.mvstore.db.TransactionStore$Transaction.getChanges(TransactionStore.java:800 http://h2database.com/html/source.html?file=org/h2/mvstore/db/TransactionStore.javaline=800build=178) at org.h2.engine.Session.rollbackTo(Session.java:602 http://h2database.com/html/source.html?file=org/h2/engine/Session.javaline=602build=178) at org.h2.command.Command.executeUpdate(Command.java:278 http://h2database.com/html/source.html?file=org/h2/command/Command.javaline=278build=178) at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:199 http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcPreparedStatement.javaline=199build=178) at org.h2.server.TcpServer.addConnection(TcpServer.java:140 http://h2database.com/html/source.html?file=org/h2/server/TcpServer.javaline=140build=178) at org.h2.server.TcpServerThread.run(TcpServerThread.java:152 http://h2database.com/html/source.html?file=org/h2/server/TcpServerThread.javaline=152build=178) ... 1 more at org.h2.engine.SessionRemote.done(SessionRemote.java:610 http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.javaline=610build=178) at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:129 http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.javaline=129build=178) at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:434 http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.javaline=434build=178) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:348 http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.javaline=348build=178) at org.h2.jdbc.JdbcConnection.init(JdbcConnection.java:107 http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.javaline=107build=178) at org.h2.jdbc.JdbcConnection.init(JdbcConnection.java:91 http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.javaline=91build=178) at org.h2.Driver.connect(Driver.java:74
Re: [h2] Unique index or primary key violation: PRIMARY KEY ON .PAGE_INDEX error
Hi, I think this issue was resolved in version 1.4.179, see the changelog entry: - Databases created with version 1.3.175 and earlier that contained foreign keys in combination with multi-column indexes could not be opened in some cases. This was due to a bugfix in version 1.3.176: Referential integrity constraints sometimes used the wrong index. I suggest to use a recent version of H2, but append ;mv_store=false to the database URL. Worst case, you would need to export the database to a SQL script with an old version, and re-created it from the script in the new version. Regards, Thomas On Fri, May 22, 2015 at 6:18 PM, Carson carsonhuang2...@gmail.com wrote: Hi, I'm new to H2, and I'm working with an already existing H2 database. When I first run H2 Console and access the database, I manage to get in. However, after I disconnect, and try to re-access the database, the following error occurs: Unique index or primary key violation: PRIMARY KEY ON .PAGE_INDEX; SQL statement: ALTER TABLE PUBLIC.PPT_TEMPLATE ADD CONSTRAINT PUBLIC.CONSTRAINT_21 FOREIGN KEY(ID_TEMPLATE) REFERENCES PUBLIC.PPT_TEMPLATE(ID_TEMPLATE) NOCHECK [23505-176] I would need to get a fresh copy of the db from my git to be able to 're-access' the database. My URL is the following: jdbc:h2:C:\Users\carson\.db\PPT_DB;CIPHER=AES My H2 version is, I think 1.3.176 (it's the version I see on the H2 console tab) Do you guys know why this is occurring? -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout. -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
Re: [h2] Missing jar file in maven repository
Hi, It looks like there is a wrong pom file on maven.org. I'm afraid I can't fix that on my side. The original file are here: http://hsql.sourceforge.net/m2-repo/com/h2database/h2/1.4.187/h2-1.4.187.jar http://hsql.sourceforge.net/m2-repo/com/h2database/h2/1.4.187/h2-1.4.187.pom http://h2database.com/m2-repo/com/h2database/h2/1.4.187/h2-1.4.187.jar http://h2database.com/m2-repo/com/h2database/h2/1.4.187/h2-1.4.187.pom Regards, Thomas On Fri, May 22, 2015 at 3:04 PM, Eric Chatellier chatell...@codelutin.com wrote: Le 22/05/2015 15:03, Eric Chatellier a écrit : search UI bug. Or invalid pom file : http://repo1.maven.org/maven2/com/h2database/h2/1.4.187/h2-1.4.187.pom -- Éric Chatellier - www.codelutin.com - 02.40.50.29.28 -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout. -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.