Re: [h2] USE SCHEMA not supported in MySQL mode?
org.h2.command.Parser is the class you want. On 2014-07-28 12:08 AM, Karl Pietrzak wrote: I can definitely submit a patch, especially if someone can send me the name of the class/unit test to look at to point me in the right direction. -- 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] USE SCHEMA not supported in MySQL mode?
Hi, I can definitely submit a patch, especially if someone can send me the name of the class/unit test to look at to point me in the right direction. Yes, that would be the Parser class, method parsePrepared. The statement use schema x would be the same as set schema x I believe. A simple test case would be nice as well, but I can do that as well. Regards, Thomas -- 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] USE SCHEMA not supported in MySQL mode?
On Mon, Jul 28, 2014 at 2:10 AM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, I can definitely submit a patch, especially if someone can send me the name of the class/unit test to look at to point me in the right direction. Yes, that would be the Parser class, method parsePrepared. The statement use schema x would be the same as set schema x I believe. A simple test case would be nice as well, but I can do that as well. Here's a tiny patch. It's quite simplistic; I'm not sure if this is how you guys wanna handle this case. -- Karl -- 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. h2-use.schema.support.patch Description: Binary data
Re: [h2] USE SCHEMA not supported in MySQL mode?
Hi, Thanks! The patch is merged now. Regards, Thomas On Mon, Jul 28, 2014 at 4:39 PM, Karl Pietrzak kap4...@gmail.com wrote: On Mon, Jul 28, 2014 at 2:10 AM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, I can definitely submit a patch, especially if someone can send me the name of the class/unit test to look at to point me in the right direction. Yes, that would be the Parser class, method parsePrepared. The statement use schema x would be the same as set schema x I believe. A simple test case would be nice as well, but I can do that as well. Here's a tiny patch. It's quite simplistic; I'm not sure if this is how you guys wanna handle this case. -- Karl -- 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.
[h2] Re: Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)
Having the same problem any solution to come out of this. using h2-1.3.160.jar and Apache-Tomcat-7.0.22. When tried to run recover option and recreate database found that create statement for some tables are found twice. What could be the reason for this? On Monday, March 17, 2014 3:07:11 PM UTC+8, Dieter Cailliau wrote: Using version 1.3.168 (in jboss 7.2.0). URL: jdbc:h2:/tmp/bms;DB_CLOSE_DELAY=-1;LOCK_TIMEOUT=5000 Database file is attached. Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] »···at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) [h2-1.3.168.jar:1.3.168] »···at org.h2.message.DbException.get(DbException.java:169) [h2-1.3.168.jar:1.3.168] »···at org.h2.message.DbException.get(DbException.java:146) [h2-1.3.168.jar:1.3.168] »···at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:81) [h2-1.3.168.jar:1.3.168] »···at org.h2.index.TreeIndex.add(TreeIndex.java:62) [h2-1.3.168.jar:1.3.168] »···at org.h2.table.RegularTable.addRowsToIndex(RegularTable.java:327) [h2-1.3.168.jar:1.3.168] »···at org.h2.table.RegularTable.addIndex(RegularTable.java:256) [h2-1.3.168.jar:1.3.168] »···at org.h2.engine.Database.open(Database.java:619) [h2-1.3.168.jar:1.3.168] »···at org.h2.engine.Database.openDatabase(Database.java:222) [h2-1.3.168.jar:1.3.168] »···at org.h2.engine.Database.init(Database.java:217) [h2-1.3.168.jar:1.3.168] »···at org.h2.engine.Engine.openSession(Engine.java:56) [h2-1.3.168.jar:1.3.168] »···at org.h2.engine.Engine.openSession(Engine.java:159) [h2-1.3.168.jar:1.3.168] »···at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138) [h2-1.3.168.jar:1.3.168] »···at org.h2.engine.Engine.createSession(Engine.java:121) [h2-1.3.168.jar:1.3.168] »···at org.h2.engine.Engine.createSession(Engine.java:28) [h2-1.3.168.jar:1.3.168] »···at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:305) [h2-1.3.168.jar:1.3.168] »···at org.h2.jdbc.JdbcConnection.init(JdbcConnection.java:108) [h2-1.3.168.jar:1.3.168] »···at org.h2.jdbc.JdbcConnection.init(JdbcConnection.java:92) [h2-1.3.168.jar:1.3.168] »···at org.h2.Driver.connect(Driver.java:72) [h2-1.3.168.jar:1.3.168] »···at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:181) [h2-1.3.168.jar:1.3.168] »···at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:331) [h2-1.3.168.jar:1.3.168] »···at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:441) -- 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.
[h2] org.h2.jdbc.jdbcSQLException - unique index or primary key violation: sys_id on public.sys(id) 23505-169
Hi All, Can anyone help us in resolving the below issue. The H2 Database file was created with the version 1.3.160 and it is copied and being used in around 1500 local systems. But this db file is being accessed by the Java application with the h2 jar version 1.3.169. There was no problem at all in accessing this db since April'14. But suddenly few days back, it has thrown the exception saying org.h2.jdbc.jdbcSQLException - unique index or primary key violation: sys_id on public.sys(id) 23505-169 thus not able to open and insert the data. Surprise, this problem is occurred only in around 400 systems and not in all. So, kindly give us your ideas, suggestions and solutions to resolve this without causing any problem to the Client's data stored in this db. Your ideas, views, suggestions and solutions on this will be more helpful to us. -- View this message in context: http://h2-database.66688.n3.nabble.com/org-h2-jdbc-jdbcSQLException-unique-index-or-primary-key-violation-sys-id-on-public-sys-id-23505-169-tp4029704.html Sent from the H2 Database mailing list archive at Nabble.com. -- 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.
[h2] Re: Error using merge on a table that has a column with a default value.
Why is this not accepted? -- View this message in context: http://h2-database.66688.n3.nabble.com/Error-using-merge-on-a-table-that-has-a-column-with-a-default-value-tp4029698p4029702.html Sent from the H2 Database mailing list archive at Nabble.com. -- 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.