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
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
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
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
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
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
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
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