Hi,
Yes, this issue was reported (issue 605) and is now fixed in the trunk. I
wanted to release a new version this weekend, but unfortunately I was sick.
Right now I'm trying to fix an important issue (also related to LOBs);
hopefully there release will be this weekend.
Regards,
Thomas
On Friday
Hi,
Yes, this issue was reported last week as well; it should be fixed in trunk.
Regards,
Thomas
On Tue, Apr 7, 2015 at 12:11 PM, John McMahon > wrote:
> We are experiencing null pointer exceptions when we attempt to store a
> null geometry in H2 when we close the connection
>
> Attached is a s
Hi,
Yes, use
SELECT * FROM INFORMATION_SCHEMA.LOCKS;
SELECT * FROM INFORMATION_SCHEMA.SESSIONS;
To cancel a transaction of a different connection, see
http://h2database.com/html/functions.html#cancel_session
Regards,
Thomas
On Tue, Apr 7, 2015 at 12:20 PM, Антон Чехов > wrote:
> Hi Thomas Th
Hi,
I would probably try version 1.3.176 (2014-04-05), which is marked as the
"last stable" version.
The method DatabaseMetaData#getSchema(String,String) is there since about
February 2011, but threw an exception back then ("unsupported"). In
February 2013 (revision 4659) the method was correctly
Hi,
Where is it documented ?
>
That's a good point. It is not well documented currently, I will fix that.
The documented limitations only apply to the PageStore storage engine,
which is the default in version 1.3.x. With version 1.4.x, the MVCC mode is
enabled by default, and better tested, and a
Hi,
What database URLs do you currently use?
Maybe we should add a way to auto-delete the database file if it is closed?
This could be done in the file system abstraction, for example using the
prefix "autoDelete:", so that a database URL would look like
"jdbc:h2:autoDelete:./target/db/test" (usi
RUE
>
> I had to change that everywhere to instead
> use jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1
>
> On Wed, Apr 8, 2015 at 7:37 AM, Thomas Mueller <
> thomas.tom.muel...@gmail.com
> > wrote:
>
>> Hi,
>>
>> What database URLs do you currently use?
>>
>
Hi,
We added db_close_delay because we have tests that open a Hibernate Session
> (connection), do some work, close that Session (thus closing that
> connection), open a new Session and try to do some work with the stuff done
> in the initial Session. But H2 had dropped the database in between.
>
Hi,
The source code of H2 is now migrated to Github:
https://github.com/h2database/h2database
The list of issues could not be migrated, I hope I can still do that, but
if not I guess it's not a big issue.
The links from the web page will need to be changed.
Regards,
Thomas
--
You received thi
Hi,
As I already wrote, the bugfix and a test case are already committed in the
trunk.
Regards,
Thomas
On Thu, Apr 9, 2015 at 6:15 PM, John McMahon
wrote:
> Hi Thomas,
>
> Did you have time to look into this?
>
> Thanks
> John
>
> On 8 April 2015 at 09:18, John McMahon wrote:
>
>> Minor corr
Hi,
I would say, it depends on what you do exactly...
Regards,
Thomas
On Thu, Apr 9, 2015 at 12:13 PM, Cecil Westerhof > wrote:
> The first time I send a query to H2 it takes around 25 seconds. All
> subsequent queries are ready in less as a second. Is this normal? Can I
> circumvent this?
>
>
Hi,
Sorry I don't understand the question. After shutdown, the database is
closed of course.
Regards,
Thomas
On Thursday, April 9, 2015, sim wrote:
> Hi,
>
> db returns in multi_threaded false state after executing shutdown defrag.
>
> Is that a normal behaviour?
>
>
> --
> You received thi
Hi,
I think you are missing an index on table B, column A.
But probably the explain plan is a big confusing as well, not sure how to
be fix this.
Regards,
Thomas
On Tuesday, March 17, 2015, Fred&Dani&Pandora&Aquiles
wrote:
> Hi,
>
>
> There are 2 tablescans in the query, there should only
Hi,
I found some more issues with nioMemLZF, I will fix that as well. And add a
test case. Also, the page sizes are probably too small, I will check that.
By the way the prefixes are "nioMemFS:" and "nioMemLZF:".
Regards,
Thomas
On Thursday, April 9, 2015, Ravi Sanwal > wrote:
> There is a b
Hi
The Google Group will be kept.
Regards,
Thomas
On Friday, April 10, 2015, Fred&Dani&Pandora&Aquiles
wrote:
> Hi,
>
> The discussions about the requests will move there now too, or you'll
> still keep this group for a time?
>
> Regards,
>
> Fr
Hi,
Thanks! My mistake, I didn't copy all the files... I fixed it now, but it
will take some more time until it is synchronized.
Regards,
Thomas
On Sat, Apr 11, 2015 at 4:29 PM, bocher wrote:
>
> Dear Thomas,
>
> The maven repository contains only the sources for the last release
> 1.4.187 (h
Hi,
Yes, I added a timeout.
First I wanted to keep the CLOB / BLOB objects only until the next
transaction. The problem is that some methods in JdbcConnection started a
new transaction (Statement.getQueryTimeout for example). It would be better
if those transactions are not required, but thats a
my purpose.
>
> Any suggestion?
>
> Regards,
> Arun
>
>
> On Friday, April 10, 2015 at 9:33:04 PM UTC+5:30, Thomas Mueller wrote:
>>
>> Hi,
>>
>> You would need to use a more recent version of H2. The version you are
>> using does not support serializ
Hi,
As I already wrote, it depends on what you do exactly. If you don't give us
that info, then we can't help I'm afraid.
Regards,
Thomas
On Sun, Apr 12, 2015 at 12:55 PM, Cecil Westerhof > wrote:
> 2015-04-12 12:03 GMT+02:00 Fred&Dani&Pandora&Aquiles >:
>
>> Hi Cecil,
>>
>> I tried that, but
Hi,
> If this were just my local database I would do upgrade myself, but since
this "old" version is on customer side, and most of them are computer
unsavy this would be a no go...
Well, you could automate that...
Regards,
Thomas
On Tue, Apr 14, 2015 at 9:30 AM, Andy Rozman > wrote:
> Ok. So
Hi,
> how to get the where clause?
Well, why do you need it exactly?
Regards,
Thomas
On Sun, Apr 12, 2015 at 6:39 PM, Pablo Beltran > wrote:
> Hi Fred,
>
> I've searched for the condition attribute in the org.h2.command.dml.Select
> class source code and it's declared as private:
>
> *private
Hi,
There was a problem migrating the Google Code issues to Github. Maybe this
can still be resolved, but maybe its simpler to just keep the old issues in
Google Code and not migrate them.
For now, I would prefer if you just send an email with the issue report to
this group instead of using the i
source.html?file=org/h2/mvstore/db/MVSpatialIndex.java&line=103&build=186>)
>
> at org.h2.mvstore.db.MVTable.addIndex(MVTable.java:433
> <http://h2database.com/html/source.html?file=org/h2/mvstore/db/MVTable.java&line=433&build=186>)
>
> at org.h2.com
ke SQL queries from any standard industry reporting
> tool like Birt, jasperReports, etc.
>
> I've provided a bit large answer because I think this is an interesting
> business case for H2 as it can be used to wrap any custom language (even
> Lucene queries, for instance) into stand
Hi,
Could you tell us, what database URL and what options do you use? Which
version was the database created with?
Regards,
Thomas
On Thu, Apr 16, 2015 at 9:05 AM, Noel Grandin > wrote:
> There are various possibilities:
>
> (1) Don't use SET LARGE_TRANSACTIONS TRUE
>
> (2) Very large result s
Hi,
I will push the commit shortly.
Regards,
Thomas
On Wednesday, April 15, 2015, bocher wrote:
>
> Hi,
>
> Please read https://github.com/h2database/h2database/pull/2.
>
> Erwan
>
>
> Le mardi 14 avril 2015 19:31:09 UTC+2, wener a écrit :
>>
>> Any explain of "EXTERNAL" table type ? Glad to
Hi,
Do you have a reproducible test case that I could run? What is the database
URL? Is this an old database or a fresh one?
Regards,
Thomas
On Thu, Apr 16, 2015 at 8:27 AM, Sourav Mandal > wrote:
> Hi,
> We have been using H2 databases in our production, recently due to
> one activity so
java:174)
> at org.h2.mvstore.db.MVTable.removeRow(MVTable.java:611)
> at org.h2.command.dml.Delete.update(Delete.java:94)
> at org.h2.command.CommandContainer.update(CommandContainer.java:78)
> at org.h2.command.Command.executeUpdate(Command.java:254)
> at org.h2.jdbc.JdbcStatement.executeIn
Hi,
Thanks a lot for your help! I have merged the pull requests.
I agree the bit field should not be needed. It is currently needed mainly
for the PageStore storage mechanism; I think this can be removed once we
only need to support the MVStore.
Regards,
Thomas
On Wed, Apr 15, 2015 at 11:38 AM
Hi,
I have merged the pull requests.
> Next few months me and probably my colleagues from Apache Ignite will be
contributing to H2 often
That's great! By the way I'm an Apache committer as well (Apache Jackrabbit
Oak).
> it would be nice if pull requests will be processed faster.
Unfortunately
Hi,
The problem seems to be that you use a slow algorithm, kind of like bubble
sort instead of quicksort. Your algorithm seems to take quadratic time
(twice the number of rows results in four times slower performance).
Why don't you use just one update?
update table XYZ set a_id = userDefine
Hi,
Yes, I think there was a change in this area because of a bug, but I don't
fully remember.
Could you please create a simple test case that shows the problem? I mean
something like:
drop all objects;
create table parent(id int primary key);
create table child(id int primary key, parent_id int
Hi,
> You can have indexed column lower_x which will contain lower(x) and do
queries like
> ... where lower_x = lower(?)
Yes. One addition: the column "lower_x" can be a computed column, so you
don't have to update it yourself:
create table test(x varchar, lower_x varchar as lower(x));
i
it does not make sense for non-snapshotable datastores.
>
> I assume your answer will be related to MVStore maturity, right?
>
> Sergi
>
> 2015-04-16 21:20 GMT+03:00 Thomas Mueller >:
>
>> Hi,
>>
>> Thanks a lot for your help! I have merged the pull reques
Hi,
Most of those settings are dangerous, so I would expect you get a corrupt
database (at least with the PageStore). But if it's just a cache, then that
might be OK. I have to say that for others reading this email.
Version 1.4.x (the MVStore) doesn't use that many temp files. The only
situation
hanks again
> John
>
>
>
> On 16 April 2015 at 12:07, Thomas Mueller > wrote:
>
>> Hi,
>>
>> You are right, this is not yet working. I will committed a fix for it
>> shortly. However I'm not sure performance is good with many null entries (I
>> didn
Hi,
I don't know what's wrong, but maybe your class is in a different package?
Regards,
Thomas
On Tuesday, April 14, 2015, blu10 wrote:
> Thanks!...
>
> Trying to test now
> I created a Trigger class that implements the Trigger interface. I
> compiled this to a class file and into a jar a
Hi,
I suspect we will have to do something similar to ImageIO and do our
> own management.
>
I would like to avoid that. Instead, I would like to avoid temp files at
all. With the MVStore, there is only one case where temp files are used
(that I know of): very large transactions (updates, deletes
Script attached. If you run in the browser console,
>> you can browse the schema and see the two indexes.
>>
>> On Thursday, April 16, 2015 at 10:43:47 PM UTC-7, Thomas Mueller wrote:
>>>
>>> Hi,
>>>
>>> Yes, I think there was a change in this are
Hi,
As documented, for H2 the syntax is:
ALTER TABLE ALTER COLUMN x RENAME TO y
I'm not sure if Oracle supports that as well. As for rename, only renaming
the columns is currently supported:
ALTER TABLE tableName RENAME TO newName
Patches are welcome!
Regards,
Thomas
On Monday, Apri
Hi,
That's strange. I see that a null password, salt, or hash results in a NPE,
and I will fix that. But an existing database shouldn't have such users.
Could you send me the database file?
Regards,
Thomas
On Tuesday, April 21, 2015, Wes Clark wrote:
> I am using the latest build 1.4.187. I a
Hi,
We cannot set A_ID to correct value (as part of insert) because this is an
> ID column for the actual value column "A".
> For example , column A could be "Customer Name" column.
> The A_ID column for this column would be "Customer_ID".
>
I would probably try to combine those steps, so that yo
> On Tue, Apr 21, 2015 at 10:59 PM, Thomas Mueller <
> thomas.tom.muel...@gmail.com
> > wrote:
>
>> Hi,
>>
>> Thanks a lot! Yes, I think it is a bug. I have a fix for it now. This is
>> related to a bugfix in version 1.4.179, change log "Referential int
Hi,
Yes, I will update the documentation.
Regards,
Thomas
On Saturday, April 18, 2015, sim wrote:
> Hi Noel,
>
> You was right, multi_threaded=true works fine. I can't see a thread
> blocking any more,
> but then h2 documentation has to be edited.
>
> Thank you.
>
> On Saturday, April 18, 201
Hi,
Thanks for the patch! It looks good, I will commit it.
Regards,
Thomas
On Saturday, April 18, 2015, Jared White wrote:
> Greetings,
>
> When a LinkedTable is defined to point to a table in Oracle with a
> function-based index, H2 throws a NullPointerException when attempting to
> model th
Hi,
Could you post the error message and stack trace please?
Regards,
Thomas
On Thu, Apr 23, 2015 at 1:25 PM, Rami Ojares > wrote:
> Hi,
>
> I have reported a related issue but maybe I can give now more clues.
> I am using 1.4.187 with mvstore and multithreaded true.
> However this issue I am
Hi,
Thanks a lot! The patch looks good. It's great to have good test cases!
I did make the following changes:
* Source code formatting / spaces: "} else {" instead of "}else{" and ") {"
instead of "){". To automatically find those places, I use Checkstyle, with
the configuration at src/installer
to tests things (testGrantSchema, at
the end), I fixed that.
I added an entry in the change log.
I updated the SQL syntax in the help.csv file.
Regards,
Thomas
On Thursday, April 23, 2015, Thomas Mueller
wrote:
> Hi,
>
> Thanks a lot! The patch looks good. It's great to have good test cases!
Hi,
Using Travis is a good idea, I will have a look at it.
In the past, I configured a Windows laptop to do a build (lasting about 3
hours, including code coverage) per night. This stopped working with
Windows 7, because automated "waking up from suspend" no longer works.
Currently, the automate
Hi,
Do you have any indexes? Did you read
http://h2database.com/html/performance.html ?
Regards,
Thomas
On Sun, Apr 26, 2015 at 6:52 PM, sim wrote:
> Hi,
>
> Let's assume I have two tables
>
> table clients
> =
> cl_id bigint primary key,
> cl_name varchar
>
> table requests
> ===
Hi Sim,
> Can't you create your own topic?
I don't understand. As far as I see, it _is_ a separate topic (email
subject).
> I have set a custom serializer for Java object contained in columns of
type OTHER
Why can't you use the default serialization mechanism? What problem do you
want to solve?
; indexes.
> I fixed them and I created a push request for the change on Friday.
> If you have time would you be able to take a look at it?
>
> Thanks
> John
>
>
>
> On 17 April 2015 at 12:11, Thomas Mueller
> wrote:
>
>> Hi,
>>
>> That's
Hi,
Yes. The MVStore is what is beta. For that to be marked stable, I think we
would need at least a few weeks where no issues are found with this
storage. I would say were are almost there. The next release will still be
beta, and then I think the MVStore can be marked as stable (unless
something
Hi,
Many users ran into problems because they used something like
"jdbc:h2:test" and then either didn't find the database file, or created a
second database when running the application in a different directory.
That's why in version 1.4.x, now relative path only work when using ".", as
in "jdb:h2
Hi,
H2 simply drops the constraint as well in this case. I understand this is
not how other databases work, this should be changed. H2 supports "drop ...
restrict" and "cascade", but currently ignores it. Patches are welcome!
Regards,
Thomas
On Monday, April 27, 2015, cmarquesumu wrote:
> I am
Hi,
Thanks for the patch!
I wonder, why do you need to log the session user, and not just the session
id?
I think I understand the problem you want to solve, but the patch is larger
than necessary: logAndConvert could be overriden for example, which should
make the patch a lot smaller. The patch
Hi,
I wonder why the conditions are in "having" and not in "where". Also, I
would probably use "module in (...)" instead of that many "or" conditions.
But that shouldn't change the result.
We would need to have a complete test case, including "create table" and
"insert" statements.
Regards,
Thom
Hi,
The database is trying to read past the end of the file... Would it be
possible to send me the database file to investigate?
Regards,
Thomas
On Wednesday, April 29, 2015, Osvaldas Ziukas
wrote:
> This happend with newest H2 version i got and updated programs. h2-1.4.187.jar
>
> In 3 Days i
Hi,
> But already for many years the spatial support was provided by a
combination of geodb + hatbox libraries and integration in GeoTools world
Yes. However, those don't use the built-in R tree. Do they use an external
R tree?
> All these was done on BLOB type where a geometry WKB is stored.
Hi,
The following should work for an empty, and single element array:
select ();
select (1,);
But I agree it looks like a hack.
Regards,
Thomas
On Mon, May 4, 2015 at 12:07 PM, wrote:
> Hi Noel,
>
> your suggestion leads to the same result as cast (1 as ARRAY), the type of
> the array e
I get "
> java.lang.UnsupportedClassVersionError:
> org/h2/Driver : Unsupported major.minor version 52.0" trying to load the H2
> driver. Is there a Java compiler mismatch? We're using Java 1.7 64-bit.
>
>
>> On Apr 22, 2015 10:44 PM, "Thomas Mueller" > &g
Hi,
I would probably use INT. Small values use less space than large values, as
variable size coding is used. Performance is not affected much; INT should
be a bit faster but not much.
Regards,
Thomas
On Saturday, May 2, 2015, Stig Christensen
wrote:
> Hi and thanks for a great database. I'm u
Hi,
That's strange. The last part of the file is missing.
Looking at the H2 source code, the file truncate code is very simple and
conservative (MVStore.shrinkFileIfPossible, which is calling
getFileLengthInUse). It looks unlikely that there is a bug in this area.
Could you describe what you did
Hi,
I think "smallint" doesn't use variable size coding, so with small values
(1, 2, 3), using "int" actually saves space. If you have randomly
distributed values within the range of smallint, then smallint uses less
space.
Regards,
Thomas
On Tue, May 5, 2015 at 7:45 A
Hi,
Yes, I think this is a bug. I'm still working on a test case.
Regards,
Thomas
On Tuesday, April 28, 2015, wrote:
> Hi,
>
> in my opinion, the code below contains a bug in the last line. Shouldn't
> it be
>
> *return ValueResultSet.get(x); *
>
> instead of
>
> *return ValueResultSet.get(rs
Hi,
Sorry I don't understand. What is the problem exactly? Where is the
behavior of H2 different from Oracle?
Regards,
Thomas
On Monday, May 4, 2015, Peter Fich wrote:
> While using H2 as a replacement for Oracle in test, I have come across
> this problem.
>
> Searching the group I have found
Hi,
The MVStore should work well with Android. The main differences to SQLite
are:
* SQLite overwrites / writes blocks of the size 4 KB. With flash or solid
state disks this is not that great, as internally (by the firmware or OS)
those writes are translated to much larger writes, for example 128
Hi,
No, I'm sorry, I think there is currently no way to influence this.
Regards,
Thomas
On Monday, May 4, 2015, Peter wrote:
> I am having some problems with indices and order by in H2 1.3.176. I
> managed to get it to work when I only query one table by:
> * making sure the index has DESC s
Hi,
I understand. However, I'm afraid I will not have time to work on this
issues. I think those uses cases are not that common. Patches or ideas on
how to fix this are welcome!
Regards,
Thomas
On Sunday, May 3, 2015, Vitali wrote:
> I would add also my case here.
>
> Seems a query like
>
>
Hi,
Yes this could explain the problem. See also the change log.
Regards,
Thomas
On Monday, May 4, 2015, Rami Ojares wrote:
> It seems that the database was running 187 but my webserver (and dev
> client) was running 186.
> Could that explain the problem?
>
> - Rami
>
> On 4.5.2015 15:54, Noel
015 10:45 PM, Thomas Mueller > wrote:
>
> Hi,
>
> The nightly build is currently created with Java 8 (on a Raspberry Pi by
> the way). I will switch to Java 7.
>
> Regards,
> Thomas
>
>
> On Friday, May 1, 2015, Wes Clark > wrote:
>
>> I am using t
Hi,
There were some changes in this area, and an important bugfix in version
1.4.187. If the LOB data was already removed before that, then I'm afraid
the data can not be restored easily. See also the change log for details.
Regards,
Thomas
On Sunday, May 3, 2015, Vitali wrote:
> Hi.
>
>
> H2
Hi,
This should be fixed now, see
https://github.com/h2database/h2database/commit/cfb2cc373854f39fe8e0511fd22ca248c48f662f
Regards,
Thomas
On Wednesday, May 6, 2015, Thomas Mueller
wrote:
> Hi,
>
> Yes, I think this is a bug. I'm still working on a test case.
>
> Regard
Hi,
> Should I still take my database offline when doing a backup?
Either this, or use the "backup" SQL statement. With the MVStore storage,
this should work very well. With the PageStore, it should also work, but I
didn't test as much.
Regards,
Thomas
On Friday, May 8, 2015, Ryan How wrote:
Hi,
I would like clarification on one item:* can I use mvstore reliably without
> calling .close().*
>
Yes, that should work. However, please note that this scenario is not fully
tested yet (as much as with SQLite). At the moment, I would either ensure
it works for you with your own tests, or don
mi
>
> On 6.5.2015 10:46, Rami Ojares wrote:
>
> Ok, I will put the multithreaded back on making sure all clients are also
> using version 187.
> I will report if the corruption turns up again after that.
>
> - Rami
>
> On 6.5.2015 9:21, Thomas Mueller wrote:
>
gt; initialized earlier than LOB storage is initialized in Database class.
>
>
>
> Vitali.
>
> On Wednesday, May 6, 2015 at 9:21:48 AM UTC+3, Thomas Mueller wrote:
>>
>> Hi,
>>
>> There were some changes in this area, and an important bugfix in version
&g
Hi,
Thanks a lot! I have analyzed the database file, and I think I know what
the problem is. It looks like the disk (or operating system) re-ordered
write operations, so that changes later in time (and later in the file)
were written, but one earlier change (both in time and in the file) was not
w
Hi,
I don't know what the problem could be. There were no changes in this area.
What is strange is: The exception says it is trying to read past the end of
a page that is 2048 bytes long. The default page size is 4096 bytes, did
you set it manually to 2048 bytes? According to the database URL it
Hi,
Do you mean, how to get the information without having to change the SQL
statements (without adding "explain analyze")? You can't.
Regards,
Thomas
On Friday, May 8, 2015, Kriss Lu wrote:
> I am tracing the performance of a program with "explain analyze" command.
> I run this command in H2
Hi,
Ah sorry, I thought the test already passes... You are right, this is
unexpected. I have fixed it now. However, this is a tricky area. If I was
you, I would avoid relying on this behavior of Oracle, because no other
database works like this.
Regards,
Thomas
On Wednesday, May 6, 2015, Peter
ble on that PC.
> (The affected PC runs Windows 7, and uses a Samsung 850 EVO SSD drive if
> that matters.)
>
> /Mikael
>
>
> Den fredag 8 maj 2015 kl. 18:12:07 UTC+2 skrev Thomas Mueller:
>>
>> Hi,
>>
>> Thanks a lot! I have analyzed the database file,
Hi,
There were quite a few bugfixes since version 1.4.181, but it's hard to say
what the reason is.
Could you send me the database file? I would be interested to analyze it,
and (hopefully) I can improve the recover tool so that it can process it.
Regards,
Thomas
On Thu, May 14, 2015 at 3:12 AM
Hi,
This should be documented under
http://h2database.com/html/advanced.html#odbc_driver
Regards,
Thomas
On Friday, May 8, 2015, syed usman wrote:
> Hi Victor,
>
> Can you please list me the steps you use to connect h2 server via
> postgresql odbc driver.
> I am actually trying to connect Ru
Hi,
Yes, you can't log to a file when using the in-memory mode. You would need
to use the persistent mode (save the database file on disk). Or, you could
use Slf4J, as documented here:
http://www.h2database.com/html/features.html?highlight=SLF4J&search=slf4j#other_logging
Regards,
Thomas
On Mo
Hi,
> I see them on the method signature for the init method but this is hit
when the triggers are set up not when the trigger is actually fired...
Yes. If you need to know the table name, you could keep that in a field
within the trigger class.
Regards,
Thomas
On Mon, May 11, 2015 at 11:1
Hi,
I think in this case, HSQLDB keeps the index on disk.
I ran the test on my machine and it looks like there is a problem in H2
here when using the PageStore (which is the default for the version of H2
you are using). With a recent version of H2 (with the MVStore), it is much
better, even thoug
Hi,
I think this issue was resolved in version 1.4.179, see the changelog entry:
- Databases created with version 1.3.175 and earlier that contained
foreign keys in combination with multi-column indexes could not be opened
in some cases. This was due to a bugfix in version 1.3.176: Refer
Hi,
I think this issue was resolved in version 1.4.179, see the changelog entry:
- Databases created with version 1.3.175 and earlier that contained
foreign keys in combination with multi-column indexes could not be opened
in some cases. This was due to a bugfix in version 1.3.176: Refer
Hi,
It looks like there is a wrong pom file on maven.org. I'm afraid I can't
fix that on my side. The original file are here:
http://hsql.sourceforge.net/m2-repo/com/h2database/h2/1.4.187/h2-1.4.187.jar
http://hsql.sourceforge.net/m2-repo/com/h2database/h2/1.4.187/h2-1.4.187.pom
http://h2database
ot just
> a local configuration issue.
>
> Please see also:
>
> http://stackoverflow.com/questions/23572460/h2-database-in-tomcat-with-server-mode-and-automatic-mixed-mode-when-using-activ
>
> Grüße,
> Aydin
>
>
> Am Freitag, 13. Juni 2014 15:20:11 UTC+2 schrieb Thomas Mu
Hi,
Why is it that MVStore ends up using 10 timers more disk space in this test?
>
By default, the MVStore keeps the data of the last 45 seconds. After that,
the disk space is re-used. The database file size will usually shrink when
you close the database.
Regards,
Thomas
--
You received this
Hi,
Could you provide a simple, small, reproducible test case please?
Regards,
Thomas
On Monday, May 25, 2015, Meni Hillel wrote:
> Thanks Jose.
>
> I saw this issue and I did not think it applied to me. In my case, it does
> not skip in 32, there was no crash. I think the cause in my case is
that a multi-threaded transactions that attempts to create the same
> record in a table would reproduce it.
>
> Meni
>
> On Mon, May 25, 2015 at 10:43 PM, Thomas Mueller <
> thomas.tom.muel...@gmail.com> wrote:
>
>> Hi,
>>
>> Could you provide a simple,
Hi,
ABS(0.0) is negative zero.
>
I think this is a bug, I will fix it.
-0.0 is allowed and not turned into 0.0.
>
Yes, this is how Java behaves.
> -0.0 is not zero.
>
This is somewhat unexpected, but I think it is reasonable. H2 uses
Double.compare(x, y), which first checks the sign.
ABS(-0
Hi,
You would need to describe the exact steps (what did you do exactly, how
did you do it).
Regards,
Thomas
On Thu, May 28, 2015 at 10:29 AM, z161 <
harael...@hotmail.com> wrote:
> Hello,
>
>
> i'm a newcomer to H2 and i want to use it either with a Java application
> or with
Hi,
> I can also create a patch and contribute.
That would be great! A patch would be very welcome.
Regards,
Thomas
On Thu, May 28, 2015 at 10:37 AM, Václav Tregner wrote:
> Do you plan to add Oracle's TRUNC(date, datepart) function? I will very
> appriciate it. I can also create a patch an
;
> Nicolas Fortin
> IRSTV FR CNRS 2488
> GIShttp://orbisgis.org
> Spatial DB http://h2gis.org
> Noise http://noisemap.orbisgis.org
>
>
>
> Le vendredi 8 mai 2015 07:42:36 UTC+2, Thomas Mueller a écrit :
>>
>> Hi,
>>
>> I would like clarifica
Hi,
I'm not really interested to "Mavenize" everything. It would be nice to
have a Maven build for the _default_ setup, to simplify setting up the IDE.
I personally didn't have much trouble importing H2 into Eclipse, but I
understand it could be easier.
But building the installer or the docs or e
Hi,
I'm sorry, but H2 does not work well if you have thousands of tables.
Regards,
Thomas
On Tuesday, June 2, 2015, Ryan How wrote:
> Maybe you are better off with a different database for each "book", and
> open and close them 1 at a time?
>
> It really depends on your application...
>
>
>
1001 - 1100 of 1812 matches
Mail list logo