[h2] Re: Column xxx must be in the GROUP BY list

2014-10-20 Thread Viktor Voytovych
Hello, Can you please comment this issue? I'd like to know if described behaviour is expected or not. Viktor On Wednesday, October 15, 2014 10:38:46 PM UTC+3, Viktor Voytovych wrote: Hello, H2 v1.4.181 H2 Console (jdbc:h2:mem:test) Create table and insert few rows in it: CREATE MEMORY

[h2] Column xxx must be in the GROUP BY list

2014-10-15 Thread Viktor Voytovych
Hello, H2 v1.4.181 H2 Console (jdbc:h2:mem:test) Create table and insert few rows in it: CREATE MEMORY TABLE IF NOT EXISTS test_table (field1 BIGINT, field2 VARCHAR, field3 DATETIME); INSERT INTO test_table (field1, field2, field3) VALUES (1, '1', '2000-01-01 12:00:00'); INSERT INTO test_table

Re: [h2] Timeout trying to lock table SYS during table creation

2014-09-29 Thread Viktor Voytovych
...@finaris.de javascript: www: http://www.finaris.de und http://www.rapidrep.com From:Viktor Voytovych vvoyt...@llnw.com javascript: To:h2-da...@googlegroups.com javascript: Date:25.09.2014 09:26 Subject:Re: [h2] Timeout trying to lock table SYS during table

Re: [h2] NullPointerException when SHOW TABLES

2014-09-29 Thread Viktor Voytovych
Hello, MULTI_THREADED=0 fixed the issue for me but it's not what I expected... What exactly MULTI_THREADED=1 does? Is there any good explanation posted? Does it really means that H2 is not multi threaded by default? Would all 32 CPU cores be used under heavy load? I've created a requested

Re: [h2] NullPointerException when SHOW TABLES

2014-09-29 Thread Viktor Voytovych
, Noel Grandin wrote: On 2014-09-29 10:17 AM, Viktor Voytovych wrote: Hello, MULTI_THREADED=0 fixed the issue for me but it's not what I expected... What exactly MULTI_THREADED=1 does? Is there any good explanation posted? Does it really means that H2 is not multi threaded by default

[h2] NullPointerException when SHOW TABLES

2014-09-25 Thread Viktor Voytovych
Hello, H2 v1.4.181 URL: jdbc:h2:mem:queries_db;CACHE_SIZE=32768;DATABASE_TO_UPPER=false;IGNORECASE=false;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;LOCK_TIMEOUT=1;LOG=0;UNDO_LOG=0;JMX=TRUE Happen regularly: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized

Re: [h2] Timeout trying to lock table SYS during table creation

2014-09-25 Thread Viktor Voytovych
7:48:11 PM UTC+3, Viktor Voytovych wrote: Thanks. Testing it. On Tuesday, September 23, 2014 11:04:53 AM UTC+3, Noel Grandin wrote: On 2014-09-23 09:57 AM, Viktor Voytovych wrote: Thanks. Would you recommend Version 1.3.176 (2014-04-05) that is Last Stable or Version 1.4.181 (2014-08

Re: [h2] Timeout trying to lock table SYS during table creation

2014-09-23 Thread Viktor Voytovych
Thanks. Would you recommend Version 1.3.176 (2014-04-05) that is Last Stable or Version 1.4.181 (2014-08-06) that is Beta? On Tuesday, September 23, 2014 10:23:15 AM UTC+3, Noel Grandin wrote: On 2014-09-22 04:24 PM, Viktor Voytovych wrote: Hello, I'm continuously getting timeouts

Re: [h2] Timeout trying to lock table SYS during table creation

2014-09-23 Thread Viktor Voytovych
Thanks. Testing it. On Tuesday, September 23, 2014 11:04:53 AM UTC+3, Noel Grandin wrote: On 2014-09-23 09:57 AM, Viktor Voytovych wrote: Thanks. Would you recommend Version 1.3.176 (2014-04-05) that is Last Stable or Version 1.4.181 (2014-08-06) that is Beta? Since you

[h2] Timeout trying to lock table SYS during table creation

2014-09-22 Thread Viktor Voytovych
Hello, H2 v1.3.175 URL: jdbc:h2:mem:queries_db;CACHE_SIZE=32768;DATABASE_TO_UPPER=false;IGNORECASE=false;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;LOCK_TIMEOUT=1;LOG=0;UNDO_LOG=0;JMX=TRUE I's embedded database with in-memory tables only (table per request). After table is created multiple threads

BUG (H2 ver.1.3.170): Numeric value out of range

2013-05-23 Thread Viktor Voytovych
Hi, Looks like I've discovered bug in H2 ver.1.3.170. Just use the following example to reproduce it: import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class TestSimple { public static void main(String... args) throws

Re: BUG (H2 ver.1.3.170): Numeric value out of range

2013-05-23 Thread Viktor Voytovych
Thank you On Thursday, May 23, 2013 11:34:17 AM UTC+3, Noel Grandin wrote: This is fixed in SVN. We should have a new official release without the next week or so, or you can use the nightly build. On 2013-05-23 10:29, Viktor Voytovych wrote: -- You received this message because

java.util.ConcurrentModificationException for SHOW TABLES query

2012-11-22 Thread Viktor Voytovych
Hi, H2 v1.3.169; Connection URL: jdbc:h2:mem:my_db;CACHE_SIZE=8192000;DATABASE_TO_UPPER=false;IGNORECASE=false;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;LOCK_TIMEOUT=1;LOG=0;UNDO_LOG=0 I'm experiencing issue with SHOW TABLES query. Every day I see the following exceptions in my logs (my