schrieb Noel Grandin:
>
> That is some kind of DB corruption. If you can supply a test-case, we
> could try to track it down. Otherwise I would suggest using the older
> PageStore engine for now, by appending "MV_STORE=false" to your DB URL.
>
> On 11 April 2016 at 10
Hello,
we are currently running the H2-database successfully on Android using
multiple apps to acces it via the mixed-mode.
Occasionally we get an error when opening the database: The file seems to
be locked.
Restarting the device (and thus all apps accessing the database) leads to
the exceptio
I don't really understand all the details, but could it be a problem if
other processes access the database at the same time?
If so, is there a way to tell H2 to not allow new connections (and close
all connections except the current one)?
Am Mittwoch, 6. April 2016 10:23:45 UTC+2 schrieb Noel G
Hello,
we are currently using H2 on Android for accessing from multiple processes.
In order to allow backups and recovery of the database in case of
corruption we wrote a simple app to use the recovery-tool to backup the
database.
Currently we have a database with a size of only 1.9MB, but can
Hi!
I'm seeing the same issue on 1.4.187. It happens intermittently and I'm not
able to find a way to easily reproduce it. This is definitely a blocker for
us so I'm going to revert back to an older version for now.
org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: Block not
fo
ocalhost//~/data.
Am Montag, 5. Mai 2014 07:46:15 UTC+2 schrieb Thomas Mueller:
>
> Hi,
>
> I can't reproduce the problem with your database URL. Do you use Windows?
> Do you use the "baseDir" setting? Could you post the complete error message
> including all stack
sincerely
______
Stefan
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send
Hi,
for a project I need to know the syntactical differences between H2SQL and
PostgreSQL. Has somebody already done this?
Note: I am not planing to simply convert databases from this to that, so
something like Flywaydb is not what I am looking for...
Thanks,
Stefan
--
You received this
to iterate all rows, calculate the value and then update a single row and
fetch the next.
I couldn't find an example or way to do this via a stored procedure. But
maybe an update via a fetch logic is also possible.
What is the fastest to implement such a complex update?
Thanks,
Stefan
On 2012-03-29 9:50, Thomas Mueller wrote:
Hi,
FYI this will be fixed in the next release:
Issue 387: WHERE condition getting pushed into sub-query with LIMIT
Confirmed. Works for me now:
https://github.com/szeiger/scala-query/commit/3354fe9cfeda1741171769e119aced4ffcd0da82
Cheers,
Stefan
(
select COF_NAME, PRICE from COFFEES order by COF_NAME LIMIT 2
);
-- finds Colombian and Colombian_Decaf
select * from (
select COF_NAME, PRICE from COFFEES order by COF_NAME LIMIT 2
) where PRICE < 10;
-- should find only Colombian but also finds French_Roast
--
Stefan Zeiger
Typesafe <
ample in
https://groups.google.com/forum/?fromgroups#!topic/h2-database/haMFbcuewog?
It's basically the same problem but with plain declarative SQL.
Cheers,
Stefan
--
Stefan Zeiger
Typesafe <http://typesafe.com> - The software stack for applications
that scale
Twitter: @StefanZeige
) a2 WHERE (a2.a10 < 8.0)
) a1
This gives me Set((Colombian,42), (French_Roast,42)) as the result set. The
second entry should not not have made it past the innermost sub-query.
Apparently, H2 pushed the additional WHERE clause into the sub-query with
the LIMIT.
Is this the intended be
If I run the following query:
String query = "select a from b where c = 3;"
Sql sql = new Sql(dataSource)
sql.rows(query)
This works in H2, but fails when I test against a real Oracle 11g
database. The issue is the semi-colon, which is reported as an
"INVALID CHARACTER". Why doesn't this fail in
Problem described fully here:
http://stackoverflow.com/questions/7177662/running-jasper-reports-against-an-in-memory-h2-datasource
I have two datasources; one is a BasicDataSource, and one is a
TransactionalAwareDataSourceProxy. I'm using both to build reports
from Jasper, and I send in .getConne
tion.(JdbcConnection.java:94)
at org.h2.Driver.connect(Driver.java:73)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at dbfparser.Main.main(Main.java:42)
Stefan
--
You received this message because you are subscribed to the Google Gr
h2 with hsqldb which worked ok,
a test with a Java 1.5 on an another machine was ok,
a test with another Windows 98 couldn't be done till yet.
The machine which caused the problems, can only very rarely used, so
testing is very difficult.
Stefan
--
You received this message because you are su
Hello,
I'm getting the following error:
ERROR root main.46 - org.h2.jdbc.JdbcSQLException: File corrupted
while reading record: "wrong checksum". Possible solution: use the
recovery tool [90030-143]
with this code:
Connection conn=null;
try {
conn = DriverManager.getConnection("jdbc:h2:./dbf-
Hi Steffen,
I went from 143 straight to 145. With 143 this error never happened to
me.
Kind regards
Stefan
On Nov 9, 2:24 pm, Steffen Bach wrote:
> Hi.
>
> The error disappears for me if I downgrade to version 143.
>
> @Stefan:
> Could I get you to check if the error disappe
Hi list,
I'm getting the same error on version 145. I haven't tested 144.
But for me it only shows up when I'm using MULTI_THREADED=1
In my case the error and query look like this:
org.h2.jdbc.JdbcSQLException: Column "RNG.RANGE" must be in the GROUP
BY list; SQL statement:
INSERT INTO propertyR
f there is a way I can get more specific
informations just let me know.
Best regards
Stefan
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group,
s.google.com/leaf?id=0B3y7SvKpZ6GsZmVhNzBjNDItYjdjOC00ZGE1LTk5NWItZTBjOWNkY2I4MmZl&hl=en&authkey=CNSp6v8G
I hope my report is of any use
Best regards
Stefan
On Aug 27, 11:13 am, Thomas Mueller
wrote:
> Hi,
>
> From the exception it looks like it's trying to convert a CLOB to a
> BINARY, which is weir
o interpret the exceptions? How can I test to get more
specific errors?
Sincerely
Stefan
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email
a:966)
at org.h2.server.web.WebApp$1.next(WebApp.java:969)
at org.h2.server.web.WebThread.process(WebThread.java:161)
at org.h2.server.web.WebThread.run(WebThread.java:88)
at java.lang.Thread.run(Thread.java:619)
Kind regards
Stefan
On Aug 5, 9:19 am, Thomas Mueller
wrote:
> Hi,
>
>
Hello group,
I tried the new CTE feature and it works almost as expected. I have
two questions:
Normal I have statements of the form:
INSERT INTO table1 (coll1, col2, ..)
SELECT col1, col2,... FROM table2
How can I insert the results of a CTE into a table?
I tried the following forms.
INSERT...
Hi,
thanks this seems to work, but I still cannot see if it is activated.
Regards
Stefan
On Aug 4, 8:53 am, Thomas Mueller
wrote:
> Hi,
>
> Try setting the property when starting:
>
> java -Dh2.x=y ...
>
> Regards,
> Thomas
>
> On Tuesday, August 3, 2010,
oing something
wrong here?
How do I know if the setting is active?
Best regards
Stefan
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group
Thank you both for the information.
On Jul 29, 6:45 pm, Thomas Mueller
wrote:
> Hi,
>
> Currently, the only change is that an open transaction is not
> committed. But table creation itself can't be rolled back (the table
> is created "outside of a transaction").
>
> Regards,
> Thomas
--
You rec
still there.
Thanks
Stefan
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
F
7/
owl#InverseFunctionalProperty') AND ((CLSA.ENTITY = PRP1.PROPERTY) AND
((CLSA.ENTITY = PRP2.PROPERTY) AND (PRP1.OBJECT = PRP2.OBJECT)))
GROUP BY PRP1.SUBJECT, PRP2.SUBJECT
Kind regards
Stefan
On Jan 5, 4:45 pm, Sam Van Oort wrote:
> Hi again Stefan,
>
> You're right that it cr
WHERE part. Is this okay?
I write again when I can post the result of the EXPLAIN query.
Thanks for the response
Cheers
Stefan
On Jan 4, 7:07 pm, Sam Van Oort wrote:
> Hi Stefan,
>
> Writing a triple-store, maybe RDF-based metadata?
>
> First:
> Do you have indices for ob
rows.
How long is this query supposed to be running? (Orders of magnitude.)
Thanks
Stefan
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this grou
to work, I would be grateful if anyone can provide some help.
Thanks. Stefan
My problem: I get the following error at step 5 below:
org.h2.jdbc.JdbcSQLException:
Database may be already in use: Server is running. Possible solutions: close
all other connection(s); use the server mode [90020-112]
Well, thats not possible, because the file is created with user
permissions only. So no one else can delete it.
The lock-file is also completely disable-able.
2009/5/10 Thomas Mueller :
>
> Hi,
>
> I suggest to solve the access rights problem in the system. Currently
> H2 creates temporary files
If the database is used by (system)user A, the log-files owner is user
A. Now, if (system)user B tries to open the db, h2 tries to delete the
old log file which is not possible because A is the owner, and not B.
2009/5/4 Thomas Mueller :
>
> Hi,
>
>> I want to disable the creation of the h2-log
Hi,
I want to disable the creation of the h2-log files. Is that possible
yet?
Thanks!
Stefan
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h
But hey - on the Netbeans H2 plugin page at Google Code - there's no
downloads. Is this vaporware?
Anyways, are you able to get NetBeans to talk to H2 already somehow?
On Mar 29, 7:08 am, Bogdan Maryniuck wrote:
> On Sun, Mar 29, 2009 at 4:49 AM, Stefan Scott
>
> wrote:
&g
ote:
> On Sun, Mar 29, 2009 at 4:49 AM, Stefan Scott
>
> wrote:
> > What sort of tools do people use for visual data modeling with H2?
>
> I use NetBeans... Maybe you could look at:http://db.netbeans.org/HTH.
>
> --
> bo
--~--~-~--~~~---~--~-
efinitions for a Java or Scala front-end. But who knows how
practical this all is.
Anyways thanks for the suggestions and I will keep on evaluating them!
On Mar 28, 4:49 pm, Stefan Scott wrote:
> What sort of tools do people use for visual data modeling with H2?
>
> It would be great to
What sort of tools do people use for visual data modeling with H2?
It would be great to have a tool which allowed the developer to draw E/
R diagrams, and visually build queries - and then output DDL for H2.
I'm currently evaluating Toad Data Modeler - which doesn't
specifically support H2, and
40 matches
Mail list logo