Re: [h2] Persistent console history

2014-06-13 Thread Martin Grajcar
Hi! On Thu, Jun 5, 2014 at 6:52 PM, Thomas Mueller wrote: > Hi, > > I will not have time to implement this feature, but if you want to try, > please go ahead. Patches are welcome. > Sure. I wrote something (attached), let me know what do you think. It gets allowed by creating an entry "commandH

Re: [h2] MODE=MySQL oddity

2014-06-13 Thread Göran Schwarz
Sybase/SAP ASE (and I guess mssql, since it originates from Sybase) supports the 0x prefix for binaries... So it's not *just* MySql /Goran Skickat från min iPhone 13 jun 2014 kl. 15:20 skrev Thomas Mueller : Hi, H2 is not 100% compatible with MySQL. The syntax "0x..." is not SQL standard (AFA

Re: [h2] Sorting of results base on EBCDIC order

2014-06-13 Thread Noel Grandin
You can use the SET COLLATION command http://h2database.com/html/grammar.html#set_collation to set the ordering of strings. I think that ICU4J has an EBCDIC ordering, but you'll have to do some research to figure out which one that is. Otherwise you will need to implement EBCDIC ordering yours

[h2] Sorting of results base on EBCDIC order

2014-06-13 Thread Petr Vilčinský
Hello, we are planning to move from CA Datacom to H2. CA Datacom returns data based on EBCDIC order when ORDER BY is used. It means that numbers are after alpha characters and tilde (~) character is between r and s letters (http://en.wikipedia.org/wiki/EBCDIC). We would like to get the data from

Re: [h2] MODE=MySQL oddity

2014-06-13 Thread Thomas Mueller
Hi, H2 is not 100% compatible with MySQL. The syntax "0x..." is not SQL standard (AFAIK it only really works with MySQL). For H2, this means a number (the same as for Java), while for MySQL it means a binary. For H2, the number is then converted to a binary using serialization (I guess). This is n

Re: [h2] H2 1.3.175 Database may be already in use: "Waited for database closing longer than 1 minute"

2014-06-13 Thread Thomas Mueller
Hi, > So how can I access the database concurrently? I would try using the server mode, or possibly the "automatic mixed mode" (see the documentation). > I can't use server mode because I have lots of H2 database. The server mode should work fine, what would be the problem? Regards, Thomas

Re: [h2] Strange NoClassDefFoundError with 1.4.178

2014-06-13 Thread Thomas Mueller
Hi, See http://stackoverflow.com/questions/34413/why-am-i-getting-a-noclassdeffounderror-in-java Regards, Thomas On Wed, Jun 11, 2014 at 8:52 AM, Peter Schütt wrote: > Hallo, > I got a strange error with the following configuration > > jdbc:h2:file:c:\\temp\\h2\\mydatabase;AUTO_SERVER=TRUE;M

Re: [h2] Problem with JDBC Url (h2 server mode)

2014-06-13 Thread Thomas Mueller
Hi, I don't know, I can't reproduce the problem with your URL. Did you set the "h2.baseDir" directory? Do those directories exist, and what is in the directory? Does a directory "ma" exist within "h2"? Do you get the same exception if you use a standalone program, such as: public static void