[h2] Re: Connecting remote H2 embedded database over SSH

2014-12-03 Thread rado
Hello, for tunnel to work- the client must connect to the port of the tunnel, and the tunnel must connect to the h2 server -- 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

[h2] Wrong results using the BETWEEN operator (H2 1.3.176)

2014-12-03 Thread christoff . schmitz
Hi, The following statement returns 0 rows as result, obviously, the result should be one row containing the value 17: SELECT ZEILE_RELATIV FROM ( SELECT ZEILE_RELATIV FROM ( SELECT 16 AS ZEILE_RELATIV UNION ALL SELECT 17 AS ZEILE_RELATIV

[h2] High processor usage when no transactions taking place

2014-12-03 Thread Stephen Lake
Hi, I am having an issue with processor usage permanently in the 5% - 50% for an H2 Server Mode deployment when no reads or writes are taking place. Some details about the system: - 24 proc box with SSD's - 5 H2 database servers running on the machine, serving different instances