tQueryTimeout(JdbcConn
>
> This doesn't make much sense. Is there another client, running in a
> different process?
>
> I don't know why this would hang.
>
> Regards,
> Thomas
>
>
> On Wed, Mar 28, 2012 at 8:07 PM, Alexander Hartner
> wrote:
>
In my application one (possibly more) query never returns a result. This
happened since I upgraded to the latest available release. I tried to debug it,
and got the following stack trace. I switched back to an older release and did
not encounter this issue.
java.net.SocketInputStream.socketRead
For some time now when I try to access my database I get the following error :
2012-Feb-02 16:42:20 [JCLLoggerAdapter - WARN] exception clearing
maxRows/queryTimeout
org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status
1325408256" [90067-149]
at org.h2.message.DbExcepti
Hi Thomas,
Thanks for getting back to me. I am using JSTL - SQL tab library
SELECT Events.description, Events.summary,
...
Since the description and summary columns are defined as Clobs I am getting
those back an
When I run a given query on the web console the resulting text is nicely
formatted and indented.
TEXT
MORE TEXT
However when I read the string value from my own application I get back
STRINGDECODE('TEXT\nMORE TEXT')
which seems to be encoded in some form. I haven't seen this encod
I have been able to reproduce this in an isolated test case. I have emailed the
sample application to Thomas. If anybody else on this list is interested please
email me.
Alex
On 10 Dec 2010, at 17:52, LostInSpace2011 wrote:
> My application consists of a web application which uses Hibernate J
I did a little bit more research and now I am able to reproduce this in an
isolated test case as well. The difference between my earlier test was that is
was using the file based url, while the problem occurs using the tcp based jdbc
url.
On 10 Dec 2010, at 17:52, LostInSpace2011 wrote:
> My a
Yes it works great with hibernate.
On 8 Apr 2010, at 18:49, marco.bagnaresi wrote:
> I want to use the H2 database for my project after some searches in
> the available databases because it seems really fit my needs.
> I have only some questions : is it compatible with hibernate, and
> particular
Hi all,
I am still getting this using 1.2.128. Should I try with the latest release
build ? Please let me know if you require further details.
2010-mars-31 07:56:55 [JCLLoggerAdapter - WARN] SQL Error: 5, SQLState:
HY000
2010-mars-31 07:56:55 [JCLLoggerAdapter - ERROR] General error:
"jav
Would this help ? Not quite sure which version that was with. I believe it
could be 1.2.126 (from the exception [5-126]) but I am not sure at all. I
will try to find out more details.
Kind regards
Alex
> Caused by: com.j2anywhere.addressbookserver.AddressBookServerException:
> org.hibernat
I haven't been able to reproduce this. Hopefully the stack trace and the query
shed some light on the underlying cause of this issue.
Regards
Alex
On 13 Jan 2010, at 18:35, Alexander Hartner wrote:
> I am getting a similar error using H2, version: 1.2.126 (2009-12-18). I can'
I am getting a similar error using H2, version: 1.2.126 (2009-12-18). I can't
rule out database corruption due to power issues / system crashes.
2010-Jan-13 18:27:03 [CentralAddressBook - FATAL] Contact ID criteria : IN
('585F7196-10F8-4ED8-8948-839B2653EBDE')
2010-Jan-13 18:27:04 [JCLLoggerAda
Oracle, SQL Server and DB2 I believe support creating tables in different
schema, which is similar to using a prefix, but subtly different.
Personally I really don't like using a prefix at all at it addresses neither
true separation, nor consolidates the data. Yes, the data is separate, but
no
It would be good to see which part takes the most time. Maybe it's one of the
queries which doesn't have the right indexes set and with the amount of data
increasing a full table scan becomes more and more expensive ?
On 22 Dec 2009, at 08:18, Marcus Wolschon wrote:
> The following code works i
I have been using 1.2.125 and 1.2 .126 for a while, however since upgrading to
either release I am not able to run online backups via the BackupTool
The following stack trace might shed some light on this issue :
Caused by: org.h2.jdbc.JdbcSQLException: Cannot change the setting "backup"
when t
eady supports the "merge" command :-)
>
> Cheers
> Kerry
>
>
> On Wed, Dec 2, 2009 at 9:15 AM, Alexander Hartner
> wrote:
> Is this not an extension to ANSI SQL ? If it is I would prefer not to have it
> to prevent creating database specific code. After all that
Is this not an extension to ANSI SQL ? If it is I would prefer not to have it
to prevent creating database specific code. After all that is the purpose of an
SQL standard.
On 1 Dec 2009, at 20:11, Franklin Schmidt wrote:
> Both Postgres and MySQL allow using a join in an update statements.
>
n up these files.
Thanks in advance for any assistance.
Alex
On 26 Nov 2009, at 23:57, Alexander Hartner wrote:
> I have also tried setting the system property (h2.defaultMaxLengthInplaceLob)
> to 500,000 as this had been changed in release : Version 1.1.119 (2009-09-26)
> Changlog extra
I have also tried setting the system property (2.defaultMaxLengthInplaceLob) to
500,000 as this had been changed in release : Version 1.1.119 (2009-09-26)
Changlog extract:
New system property h2.defaultMaxLengthInplaceLob to change the default maximum
size of an in-place LOB object.
However th
Hi All,
Thanks for all your help. After having a look I figure I check the manual and
found this :
Storing and Reading Large Objects
If it is possible that the objects don't fit into memory, then the data type
CLOB (for textual data) or BLOB (for binary data) should be used. For these
data typ
I have since upgraded my H2 version to : h2-1.2.123.jar and still have this
issue.
Regards
Alex
On 24 Nov 2009, at 20:11, Thomas Mueller wrote:
> Hi,
>
> I'm not sure if you got my email, it looks like not. So I repeat it here:
>
> What is your database URL?
>
> The temporary files could be
I did get it, but I am not sure what to make of it. My application does use
paging, but this should not prevent it from running for extended periods of
time. Currently these temp files are fulling up rather quickly and filled up
the entire 200GB disk previously. Since the entire database is only
Could it be that I am not closing a particular transaction or connection. How
can I trace that.
On 14 Nov 2009, at 19:17, Christopher Lakey wrote:
> Alex,
>
> Are you using AUTO_SERVER=true?
> How much heap space does your JVM have?
>
> I have noticed a similar problem in recent versions unde
Hi Christopher,
I dont' think I am using AUTO_SERVER. For me these files remain even after
restarting my JVM.
Regards
Alex
On 14 Nov 2009, at 19:17, Christopher Lakey wrote:
> Alex,
>
> Are you using AUTO_SERVER=true?
> How much heap space does your JVM have?
>
> I have noticed a similar pro
24 matches
Mail list logo
