Re: Mix two different tables

2012-06-14 Thread Vicente Rico
Thanks for the code. I think is more or less what I needed. Tomorrow I will begin with the test with your code and I expect they will be fine. I've had a look into the it, and I'm glad. There are a lot of things that I didn't know (I'm a software developer but not very good with db's :-( ), so I

H2 and Lazarus?

2012-06-14 Thread Lizard Lizard
Just wondering, does anyone have any experience connecting H2 and Lazarus, the "don't call it a freeware Delphi clone, but it's a freeware Delphi clone" RAD tool? There's some generic ODBC connection components, which I suspect will probably work, but if anyone's specifically connected H2 and Laz

Re: In-memory fulltext search

2012-06-14 Thread Sergi Vladykin
Committed to trunk now. Sergi -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/GfWp0lotFosJ. To post to this group, send email to h2-database@googlegroups.com

Re: Missing LOB issue

2012-06-14 Thread Eoin Byrne
heh - tell me about it, having to wait 8 hours to see if a fix works can make things difficult :) On Thu, Jun 14, 2012 at 6:23 PM, Thomas Mueller < thomas.tom.muel...@gmail.com> wrote: > Hi, > > Is there any other info you need? >> > > Hm, a simple, reproducible test case would be great... ;-) >

Re: Missing LOB issue

2012-06-14 Thread Thomas Mueller
Hi, Is there any other info you need? > Hm, a simple, reproducible test case would be great... ;-) Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscrib

Re: Missing LOB issue

2012-06-14 Thread Eoin Byrne
The database is created from scratch at the start of the test run. The version of H2 (from the manifest) is: Export-Package: org.h2;version="1.3.167", org.h2.api;version="1.3.167", org.h2.fulltext;version="1.3.167", org.h2.jdbcx;version="1.3.167", org.h2.tools;version="1.3.167", org.h2.util;

Missing LOB issue

2012-06-14 Thread Thomas Mueller
Hi, I'm not sure (well, I don't think) the problem here is the limit on the number of LOBs per result set. It might be something completely different. Is it reproducible with a newly created database? If it's an existing database, could you find out which version was used to create the database?

Re: Missing LOB issue

2012-06-14 Thread Noel Grandin
On 2012-06-14 10:52, Eoin Byrne wrote: Is there any guidance on what the max number of lobs I can bring back per ResultSet? It it related to a cache size? The number of CLOB / BLOB values that are cached on the server is now the maximum of: 5 times the SERVER_RESULT_SET_FETCH_SIZE (which is