Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-07-28 Thread Noel Grandin
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

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-07-28 Thread Thomas Mueller
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

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-07-28 Thread Karl Pietrzak
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

Re: [h2] USE SCHEMA not supported in MySQL mode?

2014-07-28 Thread Thomas Mueller
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

[h2] Re: Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

2014-07-28 Thread Sanchand
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

[h2] org.h2.jdbc.jdbcSQLException - unique index or primary key violation: sys_id on public.sys(id) 23505-169

2014-07-28 Thread lingamoorthy bheeman balan
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

[h2] Re: Error using merge on a table that has a column with a default value.

2014-07-28 Thread danielfb
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