Hi
Thomas, I have reduced the test case to a minimal version:
create table a (id int)
select * from a union select * from a ORDER BY a.id
But I don't understand the code in that section well enough to fix it.
Regards, Noel Grandin
On 2012-02-17 22:49, Victor wrote:
sorry that got.
the pr
I used the recover tool. What should I look for in the SQL file
generated by the recover?
On 18 fév, 08:27, Thomas Mueller wrote:
> Hi,
>
> > Can I add some debug settings on customer side?
>
> There are two options:
>
> - Use the trace options to analyze the JDBC method calls (append
> ;TRACE_LE
Hi
In order to monitor for bad transactions, how about we add a
TRANSACTION_START column to the SESSIONS meta-table?
Regards, Noel Grandin
On 2012-02-18 09:27, Thomas Mueller wrote:
Hi,
Can I add some debug settings on customer side?
There are two options:
- Use the trace options to anal
Hello,
>
> > IMHO permanently reducing the number of idle threads can always be
> > beneficial
>
> H2 doesn't use that many threads - just one per database usually. I
> think using a thread pool would cause more problems that it would
> solve, so I'm against going in this direction.
in my case i
It should be useful to add this kind of information as JMX operation
(like list sessions).
On 20 fév, 10:59, Noel Grandin wrote:
> Hi
>
> In order to monitor for bad transactions, how about we add a
> TRANSACTION_START column to the SESSIONS meta-table?
>
> Regards, Noel Grandin
>
> On 2012-02-1
Hi Thomas,
Sorry about the delay in responding - I've been caught up with other
things.
My problem is that when I append DATABASE_TO_UPPER=FALSE to the
database URL and reload the database, none of my tables are loaded and
I get an error message like "There exists no table named
'PRIVACCTS.PUBLIC
> Quoting from the Javadoc of the first link: "Threads that have not
been used for sixty seconds are terminated and removed from the cache.
> Thus, a pool that remains idle for long enough will not consume any
resources."
I think you are getting the doc wrong! 'Idle' here means: 'Threads that
ha
For information
My connection string is:
jdbc:h2:file:D:\ProductDev\cockpitconsole\build\projects\mserver\dist
\h2\cockpit
\cockpit;MVCC=TRUE;AUTOCOMMIT=OFF;LOCK_MODE=3;LOG=2;CACHE_TYPE=SOFT_LRU
I change also some settings like:
statement.execute("set WRITE_DELAY 0");
statement.execute("SET MAX_MEM
Make sure you can build and test the H2 source code locally, and I'll
make you a patch tomorrow for displaying the transaction start time in
the SESSIONS table.
Then you can log the output of that table regularly to see who the culprit is.
On Mon, Feb 20, 2012 at 18:16, IntensiveH2 wrote:
> For
Please, can you send me directly the jar file also. I don't have the
build environment yet.
On 20 fév, 17:25, Noel Grandin wrote:
> Make sure you can build and test the H2 source code locally, and I'll
> make you a patch tomorrow for displaying the transaction start time in
> the SESSIONS table.
Hi,
Sorry, but I don't understand the problem. Is there some error message and
stack trace? If yes could you post it? Do you have a simple reproducible
test case?
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this g
Hi,
Yes, there is an option "lineComment". Set it to "#" and the commented
lines will be ignored. See the docs for details.
CSVREAD('test.csv', 'ID|NAME|LEVEL', 'charset=UTF-8 fieldSeparator=|
lineComment=#')
Regards,
Thomas
On Saturday, February 18, 2012, h2 wrote:
> Hi
>
> I have a csv
Hi,
> Poor cache hit rate
> Why is that? Wouldn't each database maintain its own cache?
Yes, but with some many databases each cache would need to be
extremely small, otherwise it would run out of memory. Or, as an
alternative, the cache sizes would need to be actively managed, which
would compli
Hi,
If you want, I have some code that could be used as a starting point.
It's work in progress.
Warning: I havent test it; I didn't run it at all. It could be
completely wrong, and possibly corrupt the database. Also, the term
"TRANSACTION_TIMEOUT" is misleading and has to be changed (it should
Hi H2 Group,
I have an H2 database that I use the built in AES file encryption. I
would like to find a good backup solution in which the backup is also
encrypted using the same file password
I could copy the database file, but the database will always be
running, so simply copying the file may n
On 20/02/2012 11:15 AM, Christoph Läubrich wrote:
> Quoting from the Javadoc of the first link: "Threads that have not
been used for sixty seconds are terminated and removed from the cache.
> Thus, a pool that remains idle for long enough will not consume any
resources."
I think you are getting
Hi Thomas & co,
Currently if I want to add 2 or more columns to a table in H2, I need
to execute multiple ALTER TABLE ADD commands:
ALTER TABLE customer ADD foo INTEGER;
ALTER TABLE customer ADD foo2 INTEGER;
Oracle allows adding two columns at once:
ALTER TABLE customer ADD (foo INTEGER, foo2
I just deduce this from your comment that 'there are many idle threads
floating around' because if the thread is short living you won't see
much threads around (and thats where a Threadpool can help reduce the
thread allocation costs), but if the thread is sitting around (waiting
for I/O, block
18 matches
Mail list logo