Thanks for the response.
On 15 jul, 20:40, Thomas Mueller wrote:
> Hi,
>
> Currently it's not supported, but I am working on it. The plan is to
> support ANSI SQL standard 'common table expression'. The syntax is a
> bit strange:
>
> with recursive t(n) as (select 1 union all select n+1 from t w
Great! Thank you!
On 14 Jul., 16:13, Jeffrey Krzysztow
wrote:
> On Wed, Jul 14, 2010 at 2:41 AM, Michael Schmodt <
>
> michael.schm...@googlemail.com> wrote:
> > Hi,
> > I am using the TcpServer and I was wondering, if there is a
> > possibility to identify connections on serverside (e. g. the IP
The used url is:
jdbc:h2:target;ifexists=true
We use it to prevent empty databases being on the whole file system
and getting false positives for connections.
In my test I removed the parameter and then the upgrade worked.
Maybe this parameter shouldn't be used when converting the database
inter
Hi,
> Does it mean that regardless of the old format or the page store
> format, both of them are neither utf-8 nor base64 ?
Yes.
> I was wondering since the old format is already 'out of support', you
> could release some hints about it.
The source code is already available. Beyond that, I'm a
Hi,
> After 45-60 minutes connection was broken in client machine.
Do you use a firewall that breaks long running open connections? If
yes, could you try using AUTO_RECONNECT?
http://h2database.com/html/features.html#auto_reconnect - If not,
please provide the exception message and all stack trac
When I execute
call CSVWRITE('C:\holdings.csv', 'select * from bib_holdings');
and open the the holdings.csv file in notepad or wordpad there are
double quotes around each field value in addition to the comma
separating the fields. I have researched and found the
setEscapeCharacter
However, I ha
Hi,
This is already on my list. The problem is: if you delete a lot of
data and then close the database, the next time it is opened the
database will overwrite the empty space with zeroes. This is not a
problem for smaller databases, and it's not a problem unless you
delete a lot of data. My plan
Hi,
> The FAQ says that H2 Console will show progress information
That's actually no longer the case. I will remove this section. The
"Test Connection" is the new way, and your stack traces show the
problem is in fact overwriting unused blocks with zeroes.
Regards,
Thomas
--
You received this
Hi,
I already removed IFEXISTS=TRUE internally for the old connection, but
I didn't remove it case insensitive. Please retest with the next
version, it should be fixed now.
Regards
Christian
On Jul 16, 11:30 am, Duvel wrote:
> The used url is:
> jdbc:h2:target;ifexists=true
>
> We use it to pr
Did you find these:
http://www.h2database.com/html/functions.html#csvwrite
http://www.h2database.com/html/grammar.html#csv_options ?
Anyway, here's how to write a file with UTF-8 encoding and the pipe (|) as
field separator, no field delimiter, an escape character of ~, and use the
word 'nil' to
I toyed around with JVM heap size options and DB cache size today and
was able to run through "shutdown compact" without running into
OutOfMemoryErrors for the first time.
Now the DB has been compacted down to 2+ GB and connect speed is very
fast.
Thanks.
Duncan.
--
You received this message b
11 matches
Mail list logo