Hi,
It looks like a directory permissions issue rather than a H2 specific
issue. Can you try changing the database URL to something that the user
will have write permission to?
Not sure about the log file, someone else might be able to help you on
that one :).
Cheers, Ryan
On 5/11/2010
Hi,
Is this a new change? I have an app using multi-threaded mode and the
backup does not block other queries. Does it mean if the backup is
synchronised on the database and the queries are synchronised on the
session then the backup does not block queries?
Or was it found dangerous that
I don't know the answer, but howcome you don't want to close the
database on exit? Shouldn't it always be closed when the JVM exits
unless you want to use the database in a shutdown hook or something?.
I don't understand the log, someone qualified will need to answer that
one! :)
Ryan
On
Hi,
Closing the database doesn't lose data. It is good practice, like
shutting down your computer rather than just killing the power. As is my
understanding anyway :).
I would try removing the DB_CLOSE_ON_EXIT option you are using.
Then if that doesn't work I would check that auto create
Hi,
What is this Drop and re-create database schema on startup?
Maybe that is resetting the sequence...
And the MVCC setting is for row level locking, which from what some
others have said seems to help with deadlock issues when using hibernate.
Ryan
On 24/09/2010 6:40 AM, mcevikce
Hi,
Is it a different client and server version?
The error indicated version 1.1.119, not 1.2.140 ?
I think somewhere along the line there was an issue where with different
client and server versions. It outputs an error that doesn't make sense
like what you are getting. So I think the
Well it depends on how much data is them. I don't know if there is a
way to calculate how much memory a database would use. I think it would
be easier to create a database that would be similar to your
requirements and see how much memory it uses. Then multiply by 20.
Perhaps if you
Hi Peter,
From my experience I would use MULTI_THREADED=TRUE if those updates you
have are long running statements. ie. A single update may run for
several seconds. Using multi-threaded will mean it doesn't block other
threads accessing the database at the same time. Use MVCC if you are
I've been using it for a year in production and it works really well.
for the usecase you described above? (webapp with embedded db +
multiple clients)
Yep. Works great.
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to
Hi Endre.
Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while
reading record: type: 135. Possible solution: use the recovery tool;
SQL statement:
Just adding, I have also had this error a few times when using
multithreaded. I have not been able to find a test case to reproduce
Hi Rami,
Transaction is made up of one or more queries. So a long running
transaction can be many small queries.
When a query is running it will block everything else unless you have
multithreaded on. A long running transaction (made up of many small
queries) will not block other queries,
Hi,
By Default H2 only allows access for a single thread to the database at
a time internally. It doesn't seem to create performance issues because
usually the disk IO is the bottleneck. Don't get confused between
concurrent transactions and multi-threaded access.
It only creates issues if
Kind of. I guess each query gets it's turn in sequence. Someone else can
probably answer that better.
I think with multi-threaded off, even read operations are done
sequentially, not simultaneously.
Yes, if multi-threaded is on then multiple queries can be running at the
same time.
Yeah exactly. I probably didn't word it very well!.
On 27/05/2010 7:32 PM, Wildam Martin wrote:
On Thu, May 27, 2010 at 12:28, Ryan Howr...@exemail.com.au wrote:
By Default H2 only allows access for a single thread to the database at a
time internally.
But that does not mean that I
Hi,
I used to use version 1.1.117 without any issues. As I recall 118 and
119 had issues, so I never used them. I switched over to the new page
store format because it handled large transactions better. I haven't had
any issues with the page store once moving over. The early page store
Sure does.
What specifically isn't working?
On 15/05/2010 4:06 PM, spywx wrote:
i have a question about if the h2 database is supported on windows 7
because i have been trying to use it on windows 7 but its not working
while it worked with me fine on windows xp
--
You received this
Hi,
Could you just set the h2 tcp server to run on port 80? Or does it need
to be http traffic?
Ryan
On 13/05/2010 6:19 AM, Vinod wrote:
Hi,
I am trying to get the data access from a remote H2 thru port 80. As
the web service is running on the server, it is possible for me to
create a web
You could set up a file extension association with your application.
Because with the page store it is just the single file you could just
use it as the document format for your application. I reckon it would be
nifty :). I've seen it done with Access databases quite a bit.
On May 7, 2:51
You can use the Script command to dump it to a file. Then start a new
connection to a file database and use Runscript to recreate your database.
So just like backing up and restoring using script / runscript, but when
backing up use your in memory database, and when restoring use a file
Hi,
I got the following error when running a query. And also the identical
error again (identical stack trace and query) but type: 25. Repeating
the query after this did not produce any errors.
Running H2 version 128.
Database created with H2 version 128.
Connection settings are: Embedded
I know nothing about PHP or Rails, but how would you use a Postgres
database from them? Can't you just use the same thing for H2 and put it
in PG mode?
On 6/04/2010 5:11 PM, Wildam Martin wrote:
On Sun, Apr 4, 2010 at 19:26, georgegeorge.st...@yahoo.com wrote:
(ODBC seems to be the most
I don't know about Oracle. But by default H2 is case sensitive on string
matching. So if you want a case insensitive match on your like you need
to use VARCHAR_IGNORECASE() for the column type. Or I think there are
other ways too. But I got caught out on that one a few times.
On 3/04/2010
Exception in thread main org.h2.jdbc.JdbcSQLException: Version
mismatch, driver version is current client version: 5; minimum
version: 6 but server version is {1} [90047-131]
I'm no expert, but the error code indicates the version is 1.2.131 (the
-131 is the version). So I would say your
I haven't used in memory databases. But H2 usually closes a database
after all connections to it close. So you either need to use a
connection pool. Keep a single connection open as a control
connection. Delay the closing of the database, or have it not close the
database until you close the
What I could interpret from this statistic: There are more
C-Programmers than Java-Programmers. There are more SQLite users using
ohloh.net than H2 users (I didn't know ohloh.net until now for
instance). And I even could interpret that there is no need for a H2
in C because there is already
Hi,
This feature is a bit dangerous. It is not completely tested with all
scenarios. If you want to use it, I suggest to run your own test
cases.
That would be a LOT of test cases to cover all the possible scenarios
I'm sure :)
What would be another solution to stop the backup blocking
*the |BACKUP|* statement does not lock the database objects, and
therefore does not block other users
I just wanted to add. For me it did block access to the database unless
I was running in multi-threaded mode.
Cheers, Ryan
Dario Fassi wrote:
Hi,
Online backup it's a critical function
I've never been able to get it to work. I always have access say unknown
error -4744 or something like that, do you get that also?
fd wrote:
When i connect a table from Access i see this error in the trace log
of H2,
and the operation fails
Error: Table PG_ATTRDEF not found; SQL statement:
Are you sure it isn't picking up an old version off the classpath? I
thought the old store was removed in the latest version.
Penta wrote:
I noticed that with release 1.2.129 if I create a new db using h2
console, using this url: jdbc:h2:file:c:/eclipse-workspace/testdb,
it's created in the
I run a web app in embedded mode. I keep a single connection open as a
control connection. Then when the app closes I close that connection.
On the last connection closing the database closes. Seems to work
well I also use that control connection while the application is
running for some
Is it the server or the client running out of memory?
You need to make sure the server is running with plenty of memory, I
don't think the client needs it in this case.
uyeee wrote:
Thank you Chuck
I download from here
http://www.h2database.com/h2-2010-01-30.zip
I used
Hi,
I have a query which is running slower than I think it should. It takes
about 6 seconds to complete first time, then 500ms each subsequent time
and returns about 100 rows. The table has about 300,000 rows in it.
I can't figure out how to tell if it is using an index or not (or the
right
.
Thanks,
Ryan
Ryan How wrote:
Hi,
I have a query which is running slower than I think it should. It
takes about 6 seconds to complete first time, then 500ms each
subsequent time and returns about 100 rows. The table has about
300,000 rows in it.
I can't figure out how to tell if it is using
Sorry, I didn't do a very good job of explaining and confused everything!
I had to regenerate the script because I didn't have the original copy,
so I took the script from a tcp connection to the server rather than
taking the server offline and doing it in embedded mode (like I did
Mueller wrote:
Hi,
It looks like H2 now needs more heap space than it used to, specially
when creating tables. I will have to fix the memory usage methods.
Could you send me the backup_script.ZIP?
Regards,
Thomas
On Fri, Feb 5, 2010 at 4:17 AM, Ryan How r...@exemail.com.au wrote:
Hi,
I've
Hi,
I've switched over to the new page store, version 1.2.128. I haven't
done tests, but a lot of things appear to be faster than before which is
nice (and database size is much smaller!!)
Anyway, my issue is related to the SCRIPT TO command. I am running out
of heap space and it seems to
Do you mean like Access, where you can access heterogeneous data sources
like they are one database, but also have the ability to pass-through
to the originating data source?
Ryan
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this
Hi,
I had a need to import a bulk lot of data that will both insert new data
and update existing data in several tables. I have this in a transaction
because I don't want any of it to go ahead if any errors occur. It has
been working great, but I recently tried importing quite a lot of data
For this reason I doubt would will get many people who have stretched their
databases to such extend.
If not well tested, You could always put together a quick test case. From what
I've seen usually the limits in H2 are on memory usage.
Ryan
--
You received this message because
You could try the serialized lock (which may be a little slow) but allow
you to run it in embedded mode and have multiple clients connect. But I
don't know if it is unstable.
Or run a tcp server and connect using TCP (this is probably the best way
if it is possible).
Or use the auto server
Hi,
No obligation to answer this as it isn't technically related to
anything, but I am very intrigued as to the motivation behind this
project. I use H2 in a few projects and it is a fantastic project. Like
a swiss army knife of databases (in flexibility and quality!). And I
have to say the
It will be under the home directory of the user that the service is
running as.
Ayodeji Aladejebi wrote:
Hi,
I have a problem knowing where H2 places my database folder when i
start the database with the following Database URL configuration
AM, Ryan How r...@exemail.com.au wrote:
I have this jaqu query,
long okCount = db.from(msli)
.innerJoin(ms).on(ms.maintenanceStatusId).is(msli.maintenanceStatusId)
.innerJoin(sp).on(ms.samplePointId).is(sp.samplePointId)
.whereTrue(Function.and(ms.latest
Hi Guys, I don't know a lot about this but reading through the thread...
I doubt anyone will respond. People focus on their own issues.
I respond if I can help. Or not help in this case but just felt like
responding...
I interpret it to mean that passing in a value of zero sets it to the
I am assuming this would mean the number of fields no longer needs to
match either?
Cheers,
Ryan
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this group, send email to
Oh and 1 other thing I forgot (coz I was just using it now!). Make sure
the order of the fields in your database and the order of fields in your
java class match up! Otherwise it'll get up to all sorts of mischeif!
ArturoMS wrote:
What issues I would be able to have, if i use jaqu in a simple
Maybe it is something with the eclipse plugin blocking the UI thread?.
That would be my guess... I can't see it would be a H2 specific thing...
Have you tried plugging in another database to see if it still does it
on long running queries?
zvikico wrote:
On Jul 10, 9:04 pm, bob mcgee
I wonder if this will fix the MS Access issue. I'm keen to try it out
next release :)
Ryan
Thomas Mueller wrote:
Hi,
Thanks a lot for the patch! I will integrate it, and it will be
included in the next release.
Regards,
Thomas
On Sat, Jul 4, 2009 at 2:21 PM, Sergi
You could do an online backup, rsync it and then restore. But it would
use a lot more resources than just doing a one way transaction
replication. And it would need to take the slave down while restoring.
I'll be doing this on a project coming up, but it is acceptable for me
to take the slave
Okie dokie. This pops up in the trace.db when MS Access (I forgot to
say, it is Access 2003) lists the tables to link to (See below). But the
tables list fine, there isn't a problem there. I am guessing it is just
looking for a table with some preferences or something. Second time
around
201 - 250 of 250 matches
Mail list logo
