Hi,
I'm overriding 4 classes of the java.io package
In theory, what you do should work, but making it 100% compatible with
java.io.* is very hard, if not impossible: some applications may rely on
implementation details. You could argue this is a bug in the application,
but it's still
Hi,
I think the problem is that the sub-query is re-executed for each row of
the outer table, because rand is not deterministic. Test case:
drop table test;
create table test(id int, name varchar);
insert into test select x, 'hello ' || x from system_range(1, 10);
select * from
and
ready to assist.
On Thu, Apr 24, 2014 at 7:40 AM, Thomas Mueller
thomas.tom.muel...@gmail.comjavascript:_e(%7B%7D,'cvml','thomas.tom.muel...@gmail.com');
wrote:
Hi,
At the moment 1.4 defaults to MVCC=true, and 1.4 doesn't support the
combination of MVCC and MULTI_THREADED.
Actually
Hi,
Is this normal?
No.
Is some setup required to get the TestFileSystem class going?
No, TestFileSystem works for me if run alone. What operating system and
file system do you use? Is your file system read-only maybe?
Before you think about using your file system with a database, I
Hi,
i didnt found stack trace inside databaseName.trace.db file
Did you find the file? If not, what database URL do you use? If yes, what
does it contain?
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To unsubscribe from this
Hi,
Sorry the information you provided is not sufficient to reproduce the
issue. We would need your database or a reproducible test case.
Regards,
Thomas
On Mon, Apr 28, 2014 at 7:36 AM, vinay saharan
vsahar...@gmail.comjavascript:_e(%7B%7D,'cvml','vsahar...@gmail.com');
wrote:
its clearly
be:
Restore.execute(D:\\h2\test.zip, memFS:, test)
I just tried this with the 1.4.177 release, and it is still not restoring.
Just to make sure I tested running the Restore.execute() before and after
creating a connection.
On Friday, 25 April 2014 09:46:29 UTC-4, Thomas Mueller wrote:
Hi,
The parameters
Hi,
There is a special test for file systems, it's probably easier and more
reliable to test a new file system implementation that way instead of using
the database engine to test it. The test class is
org.h2.test.unit.TestFileSystem.
Registering a file system is usually done using a static
Hi,
Maybe the stack trace is in the databaseName.trace.db file?
Regards,
Thomas
On Sat, Apr 26, 2014 at 5:47 PM, Noel Grandin noelgran...@gmail.com wrote:
Sorry, that doesn't give us enough information. Is there a way to make
this DBeaver tool display the full stack trace?
It looks like
, and then
processing them in the local DB, deleting entries that are part of
completed transactions and leaving others. Is there some way I could make
this simpler/more transparent/automatic?
Thanks
Joel
On Thursday, 17 April 2014 16:47:21 UTC+10, Thomas Mueller wrote:
Hi,
What you could
Hi,
Yes, it looks like a concurrency problem. Would it be possible to post or
send me a reproducible test case? If not, could you describe what your
program is doing (how many tables, does it use transactions, BLOB or CLOB,
what is the schema of the table or tables,...)?
Regards,
Thomas
On
the `OsgiDataSourceFactory`
and register it as a service)?
Yes.
Regards,
Thomas
On Fri, Apr 25, 2014 at 12:01 PM, Anders Engström epirea...@gmail.comwrote:
Hi again!
On 04/24/2014 09:09 PM, Thomas Mueller wrote:
I didn't find any standard logging strategy in the h2 code base
Well, at this level
Hi,
The parameters of Restore.execute are, as documented:
executehttp://h2database.com/javadoc/org/h2/tools/Restore.html#execute_String_String_String(String
zipFileName, String directory, String db)
Restore.execute(D:\\h2\test.zip, memFS:test;DB_CLOSE_DELAY=-1)
The restore tool does not
Hi,
Sorry I don't understand comparison of SHA-1 (MD4. MD5)
So writing it *once and well* for all
Well, so far it's not a popular feature request.
Regards,
Thomas
On Wed, Apr 23, 2014 at 9:20 AM, t603 stepan.rybar.1...@gmail.com wrote:
On Wednesday, April 23, 2014 9:00:40 AM UTC+2, Noel
, similar to how it's done in
org.h2.value.DataType.GEOMETRY_CLASS_NAME / GEOMETRY_CLASS, with
Class.forName()?
Regards,
Thomas
On Thu, Apr 24, 2014 at 8:37 AM, Anders Engström epirea...@gmail.comwrote:
Hi Thomas!
On Wednesday, April 23, 2014 9:05:26 PM UTC+2, Thomas Mueller wrote:
Hi
tell me what I'm
doing wrong and how to get the expected results.
On Tuesday, 22 April 2014 14:03:45 UTC-4, Thomas Mueller wrote:
Hi,
BTW: If you run a recent Linux, there is a default in memory filesystem
named /dev/shm
OK, I didn't know this. I didn't test it, but my guess
Hi,
Yes, I fixed the version problem in the code. About your patch (I like to
discuss it here in the mailing list, as there are only very few looking at
the issue tracker):
The DataSouceFactory specification is not supported by default in most
OSGi frameworks.
In which framework and version is
Hi,
At the moment 1.4 defaults to MVCC=true, and 1.4 doesn't support the
combination of MVCC and MULTI_THREADED.
Actually, the combination of multi-thread and MVCC is supported in version
1.4.177, but not for in-memory databases. In the next version (the current
trunk), it will be supported
Hi,
BTW: If you run a recent Linux, there is a default in memory filesystem
named /dev/shm
OK, I didn't know this. I didn't test it, but my guess is that the
in-memory file system memFS: is faster than /dev/shm, as it doesn't need
any operating system or other native calls.
Regards,
Thomas
...@yahoo.com wrote:
You're correct that is more what I was hinting at, but doing that with an
in memory database without the filesystem backup.
On Friday, 18 April 2014 05:36:26 UTC-4, Thomas Mueller wrote:
Hi,
Your question does not seem to be whether MVMap supports serializable.
You don't want
Hi,
It's usually a network configuration or firewall issue. Verify /etc/hosts
is correct, then try running ./build.sh testNetwork in the H2 directory.
For me, the result is:
Target: testNetwork
localhost:
localhost/127.0.0.1
localhost/127.0.0.1
localhost/0:0:0:0:0:0:0:1
Hi,
Is there a complete sample for how to use offheap, or another file system?
Yes, this is documented. I would start with the in-memory file system.
Instead of using regular file names, use memFS:test. So the database URL
would be jdbc:h2:memFS:test. Then you can backup and restore the file
do to help diagnose this.
Regards,
Steve
On Thursday, 17 April 2014 17:15:50 UTC+2, Thomas Mueller wrote:
Hi,
Probably it's due to the long default retention time, see
http://h2database.com/html/grammar.html#set_retention_time - try adding
;retention_time=1000 to the database URL
2014 09:43:14 UTC, Thomas Mueller wrote:
Hi,
It sounds like you want something like the TransactionStore utility
(org.h2.mvstore.db.TransactionStore), but for serializable transactions:
http://h2database.com/html/mvstore.html#transactions
I would like to get reads of values to either block
Hi,
No, sorry, this is currently not supported.
It's hard to say whether it will be supported in the future, it depends on
whether many people ask for it. So far chances are low. Except if somebody
provides a patch of course :-)
Regards,
Thomas
On Thu, Apr 17, 2014 at 12:29 PM, Мaryia
, 18 April 2014 14:04:37 UTC+2, Thomas Mueller wrote:
Hi,
Hm, that didn't help much. Could you send me the (compressed) database
files please? If it's too big, what is the compressed size of the files?
Regards,
Thomas
On Fri, Apr 18, 2014 at 1:07 PM, Steve McLeod steve@gmail.comwrote
Hi,
What you could do is (all in H2):
create linked table ora_events(
'oracle.jdbc.OracleDriver',
'jdbc:oracle:thin:@FOOBAR:1526:FOOBAR',
'FOOBAR', 'FOOBAR',
'(select EV_ID, OPERATION_REFERENCE, CREATION_DATE_DB, ' ||
'CLIENT_APPLICATION_NAME ' ||
Hi,
Thanks a lot for the test case! I can reproduce it using an in-memory
database, with MVCC enabled. I think for the next version, I will disable
the whole RegularTable / MultiVersionIndex / TreeIndex code, and use an
in-memory MVStore instead. In the long run, this will allow us to reduce
the
Hi,
Probably it's due to the long default retention time, see
http://h2database.com/html/grammar.html#set_retention_time - try
adding ;retention_time=1000
to the database URL, and tell us if and how much this reduced the size.
Regards,
Thomas
On Thu, Apr 17, 2014 at 3:51 PM, Steve McLeod
Hi,
You mean, the MVMap should be serializable? It's possible to do that. It's
possible to make almost every class serializable. But I don't see the value
in this case. Why do you want it? What are you trying to do? What problem
are you trying to solve?
Regards,
Thomas
On Thu, Apr 17, 2014 at
Hi,
By the way, a shorter SQL script test case:
drop table test;
create table test(id int primary key, a int unique, b int);
set autocommit false;
insert into test values (1, 1, 1);
insert into test values (2, 2, 2);
-- gives a constraint violation
update test set a = 1 where id = 2;
-- the row
Hi,
I suggest to try H2HA: https://github.com/shesse/h2ha - would that be an
option for you? H2HA is basically replication.
I'm afraid the current H2 clustering will no longer be supported in the
future. I'm thinking about re-writing it completely, with features similar
to MongoDB (replication
(WebApp.java:958)
at org.h2.server.web.WebThread.process(WebThread.java:167)
at org.h2.server.web.WebThread.run(WebThread.java:94)
at java.lang.Thread.run(Unknown Source)
Thanks in advance,
Hans
2014-04-14 8:45 GMT+02:00 Thomas Mueller thomas.tom.muel...@gmail.com:
Hi
Hi,
Could you try again with the latest (beta) version? The MVStore should be
more stable for multi-threaded usage.
Regards,
Thomas
On Monday, March 10, 2014, Alex bind...@gmail.com wrote:
well, this question mostly related to understanding locking mech rather
then practical use.
On
Hi,
I found it a bit weird and investigated. In server mode, appending ;
autocommit=false to the database URL is actually working, but the return
value of Connection.getAutoCommit() is wrong (until you execute the first
statement I believe). So, is a bug, and it will be fixed in the next
version.
at 8:45 AM, Thomas Mueller
thomas.tom.muel...@gmail.com wrote:
Hi,
Could you try with the latest beta version please? The multi-threaded
feature should be more stable now. There might still be issues as it is not
yet well tested, but the remaining issues should be easier to solve.
Regards
Hi,
Could you try with the latest beta version please? The multi-threaded
feature should be more stable now. There might still be issues as it is not
yet well tested, but the remaining issues should be easier to solve.
Regards,
Thomas
On Tuesday, March 11, 2014, Noel Grandin
Hi,
I'm writing this as if we were talking about *any *dependency, but actually
it is H2 itself I'm depending on.
Have you ever had any thought about adding H2 to the default classpath
when compiling user source code?
That works for me already. I'm not sure what the problem might be, sorry.
Hi,
Could you try with the latest (beta) version of H2? I'm not sure if it's
faster or slower, but it should be more stable with the multi-threaded
option.
Regards,
Thomas
On Wednesday, March 19, 2014, Vishwanatha Sundarappa vishwas...@gmail.com
wrote:
Thank you very much for your suggestion
/org/h2/constant/ErrorCode.html#c42000
2014-04-03 18:25 GMT+02:00 Thomas Mueller
thomas.tom.muel...@gmail.comjavascript:_e(%7B%7D,'cvml','thomas.tom.muel...@gmail.com');
:
Hi,
See also the documentation at
http://h2database.com/html/features.html#user_defined_functions
Your example
Hi,
JavaFileManager fileManager = new
ClassFileManager(JAVA_COMPILER.getStandardFileManager(null,
null, null));
Where ClassFileManager is an inner class which forwards requests for class
files to our parent classloader.
Yes. To analyze the problem, could you patch H2 as follows and post
Hi,
The CreateCluster tool will not work well with large databases. Do to the
various limitations, the whole clustering solution within probably be
replaced at some point, maybe with the H2HA project, and / or with MVStore
clustering. I recommend to try the H2HA project.
H2HA:
Hi,
I wrote the code, it's mine
Well, the patch includes source code from
org.apache.commons.lang3.StringUtils#replaceChars, so obviously you didn't
write the code.
I will have to remove the patch, sorry. But I'm not sure if we are allowed
to copy source code from an Apache project 1:1. Unless
Hi,
OK, I have re-implemented the translate function. But next time, don't
copypaste source code, and then claim you wrote it.
Regards,
Thomas
On Sat, Apr 12, 2014 at 8:35 AM, Thomas Mueller
thomas.tom.muel...@gmail.com wrote:
Hi,
I wrote the code, it's mine
Well, the patch includes
Hello,
A new version of H2 is available at http://www.h2database.com
(you may have to click 'Refresh').
This is a beta version, it uses a new storage engine (MVStore).
For details, see the 'Change Log' at
http://www.h2database.com/html/changelog.html
For future plans, see the 'Roadmap' page at
Hi,
Thomas, perhaps we need a way of adding sorted entries to MVStore that is
optimized to reduce writes and reduce internal page node splitting?
Well, inserting entries in sorted order shouldn't be all that slow. Is it?
What is quite slow is adding entries in random order. I ran into this
cause problems in some cases, so probably for productive application it is
not recommended to have these settings always, am I right?
Regards,
Kais
On Wed, Apr 9, 2014 at 7:57 AM, Thomas Mueller
thomas.tom.muel...@gmail.com wrote:
Hi,
The inserts are all done in one transaction. This works
Hi,
Keys have a near to random distribution.
I think that's the problem. If you insert random keys, then all pages are
affected all the time, and you end up having lots of I/O. I ran into a
similar problem recently (actually twice: first to optimize the create
index, and then for the
Hi,
I'm very interesting to know if you have already planned an automatic
migration from the previous storage from the new MV_STORE storage?
Automatic migration is not yet implemented. I guess it will be implemented
at some point (the same as for the migration from H2 1.2 to 1.3). For the
near
Hi,
Yes, I think you can do that, but you will need to read a bit of the Lucene
API documentation. H2 currently uses (in the FullTextLucene.search method):
QueryParser parser = new QueryParser(
Version.LUCENE_30,
LUCENE_FIELD_DATA, analyzer);
Query query =
Hi,
The field separator in you data is a comma (the default separator) and not
the | character. I would try:
create table tabla(nom varchar(255), dir varchar(255), mail
varchar(255))
AS SELECT * FROM CSVREAD('E:\\TESIS\\modulocarga\\addresses.csv');
or
create table tabla(nom
Hi,
The inserts are all done in one transaction. This works well with the new
MVStore storage (beta), but not for the default PageStore storage. The
PageStore will try to flush all the changes to truncate the transaction
log, but can't because the transaction is still open. I guess this could be
Hi,
The sequence is OK. With shutdown immediately, the files should be closed
(if not, then that would be a bug). However, after shutdown immediately,
closing the connection throws an exception (The database has been
closed). What you could do is catch and ignore that exception.
An alternative
Cailliau
dieter.caill...@gmail.comwrote:
Thoms the database is attached to the first post of this topic.
Op donderdag 20 maart 2014 07:53:26 UTC+1 schreef Thomas Mueller:
Hi,
I'm not using temporary tables
I think there are some cases where Hibernate creates temporary tables
Hello,
A new version of H2 is available at http://www.h2database.com
(you may have to click 'Refresh').
For details, see the 'Change Log' at
http://www.h2database.com/html/changelog.html
For future plans, see the 'Roadmap' page at
http://www.h2database.com/html/roadmap.html
P.S. If you reply
Hi,
Keys are values are stored next to each other in the same page (first all
keys, then all values). Currently, when reading a page, all keys and values
are read and parsed (all Java objects are created). It's true that this is
not always needed, but even if only the keys are parsed (which would
Hi,
See also the documentation at
http://h2database.com/html/features.html#user_defined_functions
Your example statement works for me, and it doesn't match the statement in
your exception message...
Regards,
Thomas
On Thu, Apr 3, 2014 at 1:55 PM, Noel Grandin
Hi,
We close the database with the Close method of theEntityManagerFactory,
but the h2 database file is still locked.
Well, it looks like the database is not closed then.
You could execute the command shutdown:
http://h2database.com/html/grammar.html#shutdown
Regards,
Thomas
On Tue, Apr
Hi,
Try using an absolute path in the database URL:
jdbc:h2:file:/data/db/mydb
or a path relative to the current user home directory:
jdbc:h2:file:~/db/mydb
Regards,
Thomas
On Tuesday, April 1, 2014, upgradingd...@gmail.com wrote:
Hi all, I'm sure I'm overlooking something simple.
Hi,
No, server side cursors are regular result sets. Server side cursors will
be much easier to implement with the MVStore engine, so this will be done
first.
H2 does not implement row sets.
But anyway, what issues did you see? If the issues are not fully related to
H2, I guess it makes sense
Hi,
Sorry, that was my mistake, I added a feature and (partially) committed it
without running all tests. I hope things will get more stable in the next
days.
Regards,
Thomas
On Tuesday, April 1, 2014, Roger Thomas rithomas68...@gmail.com wrote:
Any ideas/comments?
On Friday, March 28,
Hi,
Your patch is now committed. (I had to change it a bit because I couldn't
apply it directly).
Regards,
Thomas
On Fri, Mar 28, 2014 at 9:15 AM, Nicolas Fortin (OrbisGIS)
nico.de...@gmail.com wrote:
Hi,
We were stuck on a failing unit test for two days on H2GIS. Then we
understood
Hi,
The problem is that you are using a database URL that is relative to the
current working directory (jdbc:h2:test instead of jdbc:h2:/test/data). I
guess sometimes the current working directory of your application is in F:\
or C:\.
Regards,
Thomas
On Thursday, February 27, 2014, Facundo
Hi,
drop schema and drop all objects now work according to my test.
drop table with cascade doesn't work; you still have to drop the objects
manually.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To unsubscribe from this
Hi,
In future versions of H2, the stack trace of this exception will no longer
be logged by default.
Regards,
Thomas
On Monday, February 10, 2014, Thomas Mueller thomas.tom.muel...@gmail.com
wrote:
Hi,
with the exception that they do not log exceptions
Yes. Creating exceptions is very
Hi,
The file for the LOB object was not found. This can have multiple reasons,
for example a bug in the database engine, or the file was removed or not
restored on the file system.
Since quite a long time, H2 no longer stores LOB objects in separate files
by default. One of the reasons is to
Hi,
Server.createTcpServer(new String[]{-tcpPort, 1234, -baseDir,
/patgh/to/db/file/dir/, -key, databasename}).start();
If I try that I get an ArrayIndexOutOfBoundsException, because the
parameter -key expects another parameter. Could you try this instead:
Server.createTcpServer(-tcpPort,
Hi,
define a resultset-returning function
Yes, that's a good solution.
Is there anyway to feed meta data manually to avoid T WHERE 1=0 call?
Just wondering, how expensive is this call for your case? It should be very
fast, as it doesn't fetch any data (WHERE 1=0 means no data is read, just
in H2GIS.
Regards,
Nicolas Fortin
RISING team
CNRS - Ecole Centrale de Nantes
BP 92101
1 rue de la Noë, 44321 NANTES Cedex 3
France
http://www.ec-nantes.fr/
Le jeudi 20 mars 2014 07:53:27 UTC+1, Thomas Mueller a écrit :
Hi,
You are adding -SNAPSHOT to the version. Was there any other
Hi,
To analyze such problems, usually one would look at the line of code that
throws the exception:
Caused by: java.lang.NullPointerException
at com.auctorizium.database.server.TestTrigger.fire(TestTrigger.java:41)
at org.h2.schema.TriggerObject.fireRow(TriggerObject.java:201)
Regards,
Thomas
Hi,
I think the problem is not the database, but how you use the JDBC API. If
you share a connection and run this in parallel, then the following
sequence may occur:
insertTree executeUpdate
insertTree executeUpdate
keys = insertTree.getGeneratedKeys
keys = insertTree.getGeneratedKeys
Hi,
This is a bug. The problem is that internally, the result of the first
query is re-used, and at the same time, a SimpleResultSet is used, which is
automatic closed when displaying the result of the first query. So it is
closed the second time. The SimpleResultSet shouldn't be auto-closed. I
Hi,
I'm not using temporary tables
I think there are some cases where Hibernate creates temporary tables, and
for some queries (those that return many rows) the database itself creates
temporary tables.
If you still have the database file, could you send it to me please? I
would like to
Hi,
You are adding -SNAPSHOT to the version. Was there any other change? I
will try to change the build so that all h2-latest are automatically
snapshot versions.
Regards,
Thomas
On Friday, March 14, 2014, Nicolas Fortin (OrbisGIS) nico.de...@gmail.com
wrote:
Hi,
I work on how to define a
I am loading around 100 tables and memory goes more than 150G.
This error is not consistent, sometime throws for different tables too.
I do not have full stack trace. I will add stack trace and send you full
details If I get any.
Thanks
Vishwa
On Monday, March 17, 2014 10:34:51 PM UTC-7, Thomas
Hi,
Could you tell us, what database URL do you or did you use? It looks like a
corruption of some kind, but I'm not sure.
Regards,
Thomas
On Mon, Mar 17, 2014 at 8:11 AM, Dieter Cailliau
dieter.caill...@gmail.comwrote:
With 1.3.175 the error message is a bit longer:
, Mar 18, 2014 at 6:31 AM, Thomas Mueller
thomas.tom.muel...@gmail.com wrote:
Hi,
Could you tell us, what database URL do you or did you use? It looks like
a corruption of some kind, but I'm not sure.
Regards,
Thomas
On Mon, Mar 17, 2014 at 8:11 AM, Dieter Cailliau
dieter.caill
Hi,
Could you tell us what database URL you are using, and post the complete
stack trace please?
Regards,
Thomas
On Tue, Mar 18, 2014 at 5:58 AM, Vishwanatha Sundarappa
vishwas...@gmail.com wrote:
I am randomly getting RuntimeException when I am loading data through
table link. (Note:
Hi,
1- have a jdbc connect url like: jdbc:h2:mem
You have a typo, it should be: jdbc:h2:mem:. The last : is important.
Regards,
Thomas
On Thu, Feb 27, 2014 at 10:59 AM, the blue mountain
thebluemount...@gmail.com wrote:
Hi,
I am using h2 in-memory for junit (4.x) tests.
Basically, i'm
Hi,
Sorry for the delay. I have now committed your patch (I changed the
formatting slightly).
Regards,
Thomas
On Thu, Mar 13, 2014 at 9:02 AM, Nicolas Fortin (OrbisGIS)
nico.de...@gmail.com wrote:
Hi,
Any feedback about the patch ?
Thanks
-Nicolas Fortin
Atelier SIG, IRSTV CNRS FR
wesona...@gmail.com wrote:
Should I wait for the next build? Will this be fixed in I fall back
to Version 1.3.174?
On Thursday, March 6, 2014 10:10:14 AM UTC-8, Thomas Mueller wrote:
Hi,
I think this is already fixed in the current trunk (The method
org.h2.expression.Function.getCost could
Hi,
To find out what version of H2 you are using, could you post the complete
stack trace including error message and error codes?
Regards,
Thomas
On Thu, Mar 13, 2014 at 11:15 PM, Wes Clark wesona...@gmail.com wrote:
The JDBC URL being used is
Hi,
In Oracle the order will be:
a124sb
bb1234
1bbe42
This is not what I get when testing with http://sqlfiddle.com. I get the
same order as H2 (and all other databases I tested with). Maybe you are
using EBCDIC encoding?
Regards,
Thomas
On Fri, Mar 14, 2014 at 8:24 AM, Noel Grandin
Hi,
I'm afraid H2 doesn't support this syntax. For the supported syntax, see
http://h2database.com/html/grammar.html#update
Regards,
Thomas
On Wed, Mar 12, 2014 at 10:05 AM, h2newbie pelegk...@gmail.com wrote:
i tried to do update using inner join with no luck, i always get sql
syntax
Hi,
See http://h2database.com/html/features.html#user_defined_functions
Regards,
Thomas
On Wed, Mar 12, 2014 at 8:43 AM, h2newbie pelegk...@gmail.com wrote:
in sql server its possible to create functions and call them from the
query,
how its done in h2?
some one can refer to article
Hi,
Looking at the stack trace, the problem could also be related to using a
old version of H2 together with a database created by a newer version. To
find out what version of H2 you are using, could you post the complete
stack trace including error message and error codes?
Regards,
Thomas
On
Hi,
The reason why you got the exception invalid database address: from the
SQLite JDBC driver is that the SQLite JDBC driver does not follow the JDBC
specification. That means it is a bug in the SQLite JDBC driver. According
to the JDBC specification, Driver.connect should return null for JDBC
Hi,
I think this is already fixed in the current trunk (The method
org.h2.expression.Function.getCost could throw a NullPointException).
Regards,
Thomas
On Thu, Mar 6, 2014 at 6:38 PM, Wes Clark wesona...@gmail.com wrote:
Here is the complete stack trace
[exec] [junit]
Hi,
Is the problem still reproducible if you build H2 yourself from the trunk?
The code is available at
https://code.google.com/p/h2database/source/checkout - see also
http://h2database.com/html/build.html
Regards,
Thomas
On Wed, Mar 5, 2014 at 6:16 PM, Frederic Brégier
Hi,
Yes, or maybe no quotes at all, as in:
UPDATE Tbl1 SET Called1 = '0'
Regards,
Thomas
On Tue, Mar 4, 2014 at 1:40 PM, Noel Grandin noelgran...@gmail.com wrote:
You want double quotes not single quotes.
i.e.
sql.execute(update Tbl1 set \Called1\='0');
On 2014-03-04 09:52,
Hi,
This question was migrated to StackOverflow:
http://stackoverflow.com/questions/22070579/c-sharp-net-connect-to-h2-database/22124949
Regards,
Thomas
On Fri, Feb 28, 2014 at 3:04 AM, Chen Wei loong longza...@gmail.com wrote:
By the way my H2 version is 1.3.175
--
You received this
Hi,
If you get a file named test.data.db, then you are using a _very_ old
version of H2 (version 1.1.x., from 2009 I believe).
Regards,
Thomas
On Thu, Feb 27, 2014 at 9:24 AM, Chen Wei loong
longza...@gmail.comjavascript:_e(%7B%7D,'cvml','longza...@gmail.com');
wrote:
Given that JDBC URL
Hi,
Yes, I would need a complete test case, if possible in the form of a
script, similar to this:
create table test(id int primary key, name varchar(255));
insert into test select x, 'hello ' || x from system_range(1, 10);
select id, count(*) from test group by id;
Regards,
Thomas
On
Hi,
If you get a file named test.data.db, then you are using a _very_ old
version of H2 (version 1.1.x., from 2009 I believe).
Regards,
Thomas
On Thu, Feb 27, 2014 at 10:01 AM, Chen Wei loong
longza...@gmail.comjavascript:_e(%7B%7D,'cvml','longza...@gmail.com');
wrote:
From H2 database file
Hi,
Yes, this looks like a bug. Thanks a lot for reporting it! It looks like
additions to existing rights are not persisted. I have a potential patch,
but I will first need to write a complete unit test:
--- src/main/org/h2/command/ddl/GrantRevoke.java (revision 5422)
+++
Hi,
I think setting the system property h2.bindAddress should help in this
case. See als the javadocs (SysProperties / field BIND_ADDRESS).
Regards,
Thomas
On Tuesday, February 25, 2014, Davide De Paoli davide@gmail.com wrote:
I've installed H2 on a machine with 2 network interfaces, on
Hi,
Yes, there are a number of tools listed in the links section. For example:
* SQuirreL DB Copy Plugin (Tool to copy data from one database to another)
- http://dbcopyplugin.sf.net
* Flyway (The agile database migration framework for Java) -
http://flywaydb.org
Regards,
Thomas
On Wednesday,
Hi,
I think the spatial intersect is not properly handled in views. This
might solve the problem (but I would need a proper test case):
Index: src/main/org/h2/index/ViewIndex.java
===
--- src/main/org/h2/index/ViewIndex.java
Hi,
It might be something like this:
http://stackoverflow.com/questions/1881546/inetaddress-getlocalhost-throws-unknownhostexception
Regards,
Thomas
On Tue, Feb 25, 2014 at 9:57 AM, Noel Grandin noelgran...@gmail.com wrote:
Your network configuration is broken somehow, because Java is
Hi,
I see, so currently views can not use a spatial index. That's sad. I think
the problem is that a view index isn't a spatial index. I will try to fix
this problem.
About ValueGeometry.toSQL: I think we see more and more the limitations of
the JTS library. There is also
901 - 1000 of 4281 matches
Mail list logo