Re: Using AUTO_SERVER=TRUE

2009-04-06 Thread Nitai @ SixSigns
Perfect :-) On Apr 5, 2009, at 1:54 PM, Thomas Mueller wrote: Hi, I still have to think (guess) that remote connection is not possible in auto_server=true mode since in your last sentence is says that the process needs to have access to the database file, which is not the case from a rem

Re: JdbcSQLException: User XYZ already exists

2009-04-06 Thread ptie
Hi Thomas, Thanks for your quick reply! We 'll upgrade to the latest version. And if it does happen in the future, we 'll use the recover tool first. Thanks! Peter --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "H2

Re: NIO storage

2009-04-06 Thread Jan Kotek
Maybe it was not closed properly. Can you try Channel implementation? Jan On Sun, Apr 5, 2009 at 1:03 PM, Thomas Mueller wrote: > > Hi, > >> There is a problem though: I could not connect to a previous database >> created with jdbc:h2:..  using jdbc:h2:nioMapped:... Is it normal? Is >> so, do yo

Re: Problem with SELECT ... ORDER BY no data!

2009-04-06 Thread Alex
We had the same issue some time ago on the older version of H2 See http://groups.google.com/group/h2-database/browse_thread/thread/ee669f2d2bd211b1/565f05257287c514?lnk=gst&q=a701440#565f05257287c514 The only way we could recover was to recreate the index on the latest version of H2 (at the time

Re: Problem with SELECT ... ORDER BY no data!

2009-04-06 Thread Thomas Mueller
Hi, I found the problem. It's quite serious, and I will create a new release later this week. Queries that are ordered by an indexed column returned no rows in certain cases (if all rows were deleted from the table previously, and there is a low number of rows in the table, and when not using ot

field/table alias in select statement with joins

2009-04-06 Thread Thilo
Hi, in H2 1.1.110 (2009-04-03) - given this setup: create table "M_1" ( "d1" int, "d2" int, VALUE DOUBLE); create table "M_2" ( "d1" int, "d2" int, VALUE DOUBLE); create table "D" ( "id" int); the following select statement fails (with a "Column D1.ID not found"): SELECT "m1"."VALUE" + "m2"."