Re: What version of Lucene is required to build h2?

2010-11-16 Thread Wildam Martin
On Tue, Nov 16, 2010 at 07:50, Sergi Vladykin sergi.vlady...@gmail.com wrote: Yes current build.xml is broken. You should manually download lucene 3.0 and add it to the class path instead of 2.2 version. Ah, thanks for the notice. BTW: Anybody knows if Lucene 3.0 still has issues with words not

Re: What happens with future versions of JREs

2010-11-12 Thread Wildam Martin
On Fri, Nov 12, 2010 at 18:52, Thomas Mueller thomas.tom.muel...@gmail.com wrote: In case you missed the news: Oracle and Apple Announce OpenJDK Project for Mac OS X http://www.apple.com/pr/library/2010/11/12openjdk.html http://blogs.sun.com/theaquarium/entry/apple_joins_openjdk

Re: Performance dramatically slower on left join

2010-11-10 Thread Wildam Martin
On Wed, Nov 10, 2010 at 08:16, Thomas Mueller thomas.tom.muel...@gmail.com wrote: You are right, I think it's a bug. There is a workaround, instead of: I am not the OP, but in the long discussion you showed the will to examine and really understand - to finally identify a bug which you also

Re: What happens with future versions of JREs

2010-11-10 Thread Wildam Martin
On Tue, Nov 9, 2010 at 13:47, RICCARD riccardmon...@msn.com wrote: Thanks for info. I heared (=rumours) that discussions for a JRE 2.0 started and is planned for next year. My source works wit MAC if that could explain anything. As a Mac user you might be getting a problem in general with Java

Re: JDBCConnectionPool : Login Timeout

2010-08-06 Thread Wildam Martin
On Fri, Aug 6, 2010 at 05:04, Joe joe.w...@gmail.com wrote: However, I'm still concerned about the mechanism for waiting.  It is 30 'wait cycles' where each wait cycle would complete from one of the following conditions: 1) the connection becomes available 2) the 1000ms wait call completes

Re: Login Timeout

2010-08-05 Thread Wildam Martin
On Thu, Aug 5, 2010 at 06:51, Joe joe.w...@gmail.com wrote: Couple of thoughts: 1) The JDBCConnectionPool setLoginTimeout method says the default timeout is 5 minutes.  However, the default is actually set to '30' in the code.  That appears that is supposed to be '30' seconds. The default

Re: .lobs.db on Windows Vista

2010-06-23 Thread Wildam Martin
On Wed, Jun 23, 2010 at 10:49, Jussi jussi.h.nyka...@gmail.com wrote: [...] When application is closed and started again, everything works ok. However, there appears to be .lobs.db under Program Files\Application folder. [...] I wonder why this .lobs.db is written under Program Files and not

Re: Commercial Support?

2010-05-26 Thread Wildam Martin
On Mon, May 24, 2010 at 10:06, Thomas Mueller thomas.tom.muel...@gmail.com wrote: if you are thinking to add commercial support offerings for H2 and if so when? Yes, this is the plan. The question is how such a commercial support should look like. One option could be to sell support hour

Re: JdbcConnectionPool, setMaxConnections() and getConnection()

2010-05-24 Thread Wildam Martin
On Mon, May 24, 2010 at 10:06, Thomas Mueller thomas.tom.muel...@gmail.com wrote: 15 seconds: http://www.15seconds.com/issue/040830.htm 15 seconds can be reached for slow connection (e.g. mobile internet connection) and busy server (e.g. backup running) at server side for a smaller company

Re: JdbcConnectionPool, setMaxConnections() and getConnection()

2010-05-24 Thread Wildam Martin
On Tue, May 25, 2010 at 01:09, Kerry Sainsbury ke...@fidelma.com wrote: ... and I guess if the timeout is configurable, it doesn't matter too much what the default is :-) A good default does matter as mostly defaults are kept - e.g. if your application does not offer an option for setting the

Re: H2 versus Firebird for java desktop application

2010-05-19 Thread Wildam Martin
We had a 3rd party project that used firebird (don't know in which version) and there were problems with it. unfortunately I do not remember more details, maybe it was some unexpected small db file size limitations and maybe something else. Is about 3 years ago, but I stopped watching that

Re: Possible database corruption

2010-05-08 Thread Wildam Martin
On May 7, 9:35 am, Thomas Mueller thomas.tom.muel...@gmail.com But now I found a much better way to test it, by using a special file system that simulates stopping a process after each write (trying to recover after each write operation). I did already have 'power failure' tests since a long

Re: delete clob tuning how to

2010-05-03 Thread Wildam Martin
On Mon, May 3, 2010 at 20:46, Thomas Mueller thomas.tom.muel...@gmail.com wrote: What is the best version of Lucene? H2 uses Lucene 2.2 by default, but version 2.9 should work as well (I didn't test it). I tested - even if not in an extensive manner. 2.9 seems to work. 3.0 does not. -- Martin

Re: Subtle inconsistency in metadata for 4/10/10.

2010-05-03 Thread Wildam Martin
On Mon, May 3, 2010 at 20:46, Thomas Mueller thomas.tom.muel...@gmail.com wrote: This is a surprisingly common question. See http://www.h2database.com/html/faq.html#column_names_incorrect Oh heck, I have implemented some common stuff testing with H2 and going to support more databases. While I

Re: performance changes introduced in 1.2.129

2010-05-03 Thread Wildam Martin
On Mon, May 3, 2010 at 20:46, Thomas Mueller thomas.tom.muel...@gmail.com wrote: There is now a re-try mechanism (up to a few seconds) because sometimes connection don't work initially (firewall, or other problems). See http://www.h2database.com/html/changelog.html - Version 1.2.129

Re: Syntax H2

2010-04-27 Thread Wildam Martin
On Tue, Apr 27, 2010 at 20:31, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Just starting to study H2. Tell me please, syntax H2 most similar to what SQL syntax? I would say MySQL is the most similar. Interesting. I would say HSQLDB and PostgreSQL. OK, you win. :-) Basically I used MS

Re: Syntax H2

2010-04-25 Thread Wildam Martin
I would say MySQL is the most similar. On Sun, Apr 25, 2010 at 08:29, Gidravlic gidrav...@gmail.com wrote: Just starting to study H2. Tell me please, syntax H2 most similar to what SQL syntax? Thank you! -- You received this message because you are subscribed to the Google Groups H2

Re: How to use H2 from PHP or Rails?

2010-04-06 Thread Wildam Martin
On Sun, Apr 4, 2010 at 19:26, george george.st...@yahoo.com wrote: (ODBC seems to be the most mentioned). This seems to work only on Windows :(. ODBC does not work out of the box on Linux - you need some additional libraries - however, I was not able to find out how myself - but did not invest

Re: Very large transactions and very slow java.io.File.lastModified under Windows

2010-04-02 Thread Wildam Martin
On Fri, Apr 2, 2010 at 10:38, Steve McLeod steve.mcl...@gmail.com wrote: I've previously had problems on Windows with code that used File.lastModified() - it seems to be a slow process on Windows. If you read file meta information under Windows through Windows APIs at least, Windows transfers

Re: Full text search question

2010-04-01 Thread Wildam Martin
On Wed, Mar 31, 2010 at 11:23, Bogdan Maryniuck b.maryni...@gmail.com wrote: 4. Now search some stuff that is there for sure: SELECT * FROM FTL_SEARCH('word', 1000, 0); I looked that now up how I do it and there is: searchSql.append(SELECT doc.* FROM FTL_SEARCH_DATA(');

Re: Full text search question

2010-03-31 Thread Wildam Martin
I did not test your sample, but I know that Lucene by default does not index a bunch of words - word is quite surely one of those. On Wed, Mar 31, 2010 at 11:23, Bogdan Maryniuck b.maryni...@gmail.com wrote: Hi. I want a full-text. Here's my steps according to the documentation, as far as I

Re: JVM to C in 1.2.132?

2010-03-23 Thread Wildam Martin
OK, I can understand the need of a C++ (and/or other) version. For me it would be important that the Java version is kept and not running out of sync with the C-Version (because my needs are Java-only). Best regards, Martin. -- Martin Wildam -- You received this message because you are

Re: H2 database and Excel VBA

2010-03-23 Thread Wildam Martin
On Tue, Mar 23, 2010 at 17:25, Paluee palme...@gmail.com wrote: Yes, I almost forgot about that. DSN-less. Actually it is due to the fact that I never fully understood the differences between ODBC (always thought that it had to have datasource), and confused DSN, DSN-less as though they were

Re: JVM to C in 1.2.132?

2010-03-22 Thread Wildam Martin
On Mon, Mar 22, 2010 at 19:47, Thomas Mueller thomas.tom.muel...@gmail.com wrote: I was curious to know why you are planning to do this? Might I say, I'm a little disappointed? :) Thanks for asking - I even overlooked that in the changelog. There are multiple reasons. First, I always wanted

Re: H2 database and Excel VBA

2010-03-22 Thread Wildam Martin
On Tue, Mar 23, 2010 at 01:02, Paluee palme...@gmail.com wrote: So I guess there is no other way than ODBC way. I am trying to avoid that. I wish to just write code and not have to do any kind of configuring, like setting up a datasource in the windows controlPanel/Administrative Tools. If

Re: Have you thought of writing a book?

2010-02-19 Thread Wildam Martin
On Fri, Feb 19, 2010 at 10:10, Thomas Mueller thomas.tom.muel...@gmail.com wrote: A few people requested a H2 book, but currently my priority is to improve the free documentation (which is also available as pdf). I would also prefer that and prefer to pay for work on the free documentation

Re: Lot of temp.lob files

2010-02-17 Thread Wildam Martin
On Wed, Feb 17, 2010 at 22:01, rmuller ronald.k.mul...@gmail.com wrote: @Kerry: I close all connections before shutting down the app. So as far as I understand it this is no problem. But you are talking about a webapp - hence multiple threads possible... The files are created on the server

Re: Trying to use Lucene throws exception

2010-02-05 Thread Wildam Martin
On Fri, Feb 5, 2010 at 12:42, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Is it possible that it depends on a particular version of Lucene? It looks like you need to use Lucene 2.9.x. Indeed, 2.9.1 works. Thanks a lot for the hint. I always heard that integrating lucene into an own

Trying to use Lucene throws exception

2010-02-04 Thread Wildam Martin
Hi, I am trying to use Lucene (latest version 3.0.0) with H2. I followed the instructions in the Tutorial. However already on attempt to create the alias I get an exception: ERROR: CREATE ALIAS IF NOT EXISTS FTL_INIT FOR org.h2.fulltext.FullTextLucene.init; CALL FTL_INIT(); Trace:

Re: Poor performance with concurrent request

2010-01-18 Thread Wildam Martin
On Mon, Jan 18, 2010 at 09:57, Ewald ewaldh...@gmail.com wrote: Now we have to get Sun to drop that darn Derby dog. Or replace it with H2. ;-) BTW: I also find H2 awesome although I did only a few tests and no real productive app that is using it. However, the combination that I can use it in