Re: MVCC and BaseIndex.compareRows()

2012-03-19 Thread Noel Grandin
Committed your optimisation. On 2012-03-16 14:08, rkrijgsheld wrote: I agree. But my english was also not very clear :) What I meant to say was that after profiling, I attached the debugger and noticed that the compareRows() method is called a lot of times with the same row. These rows are now

Re: How to globally set unique contraints to allow NULL values?

2012-03-19 Thread M. Walter
No idea? Anybody? :-( We use H2 for unit tests. The constraints are defined on the JPA entities. While Oracle allows NULL values for contraint fields, H2 initialises strings with , integers with 0 and so on per default. How can I change this behaviour? -- You received this message because

Re: How to globally set unique contraints to allow NULL values?

2012-03-19 Thread Noel Grandin
It looks like we currently don't support that feature. Patches are welcome :-) On 2012-03-19 10:25, M. Walter wrote: No idea? Anybody? :-( We use H2 for unit tests. The constraints are defined on the JPA entities. While Oracle allows NULL values for contraint fields, H2 initialises strings

Re: How to globally set unique contraints to allow NULL values?

2012-03-19 Thread M. Walter
Okay, so do I have to create a JIRA ticket or something like that to get the feature? -- 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/-/xIbvH8mgWOYJ. To post to

Re: How to globally set unique contraints to allow NULL values?

2012-03-19 Thread Noel Grandin
You're welcome to log a feature request at code.google.com/h/h2database But we're all pretty busy right now, so feature requests are a little priority. On 2012-03-19 10:45, M. Walter wrote: Okay, so do I have to create a JIRA ticket or something like that to get the feature? -- You received

Re: How to globally set unique contraints to allow NULL values?

2012-03-19 Thread M. Walter
Okay done: http://code.google.com/p/h2database/issues/detail?id=385 -- 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/-/yzG5EDlG8CoJ. To post to this group, send

Re: Programmatically handling error H2 codes in Eclipse/OSGi

2012-03-19 Thread András Péteri
Thomas, Thank you for the response! With respect to the enhancement request in CDO, a moderate amount of discussion has been going on there, so if you have some additional time to spend, please go through the comments. Key points are: * The Eclipse Orbit-maintained bundle of h2 (version 1.1.117)

Re: Errors in trace.db when closing Database

2012-03-19 Thread Thomas Mueller
Hi, This should not occur. It doesn't look like it would corrupt the database, but really such errors should not occur. Could you send me the database file? I would like to better understand the problem. Regards, Thomas On Wednesday, March 7, 2012, Uli wrote: I get the NullPointerException

Re: slow opening of database

2012-03-19 Thread Thomas Mueller
Hi, On Wednesday, March 14, 2012, david wrote: I see, and there is no way I can now commit any pending commands? I mean the database was once compiled and now is supposed to be read- only. Can I somehow force all commits to close and make it read-only? You could use the SQL statement

Re: subquery using WHERE clause of outer query?

2012-03-19 Thread Thomas Mueller
Hi, Shouldn't sub-query results be independent of outer-queries? I understand the optimization and why it is useful - in some cases. However, when SET(@variable, value) is in the selectExpression, the order and number of rows SET(...) is applied to, are critical for correct results. It

Re: Linked Table on Access ODBC limited to 62 Characters

2012-03-19 Thread Thomas Mueller
Hi, The exception seems to come from Microsoft Access, so I'm afraid there is nothing we could do within the H2 database to solve this problem. I don't know what SQLworkbench does differently to make it work there. Regards, Thomas On Wednesday, March 14, 2012, Josef Hopfgartner wrote: Has

Re: H2 database in Railo

2012-03-19 Thread Thomas Mueller
Hi, any idea why an insert from within a web application will take about a minute while the same insert runs extremely fast from the console? No. any idea how to trace the source of this problem? Yes, I suggest to use the built-in profiling tool, or any other profiling tool, so see what

Program hangs after retrieving 100 rows containing CLOB when using tcp

2012-03-19 Thread Ron Aaronson
I am retrieving one text column (CLOB) from a table in a remote H2 database (actually on a local drive, but using Server, i.e. tcp/ip, to access it) and after retrieving the first 100 rows the program hangs on retrieving the next row of the result set. If, on the other hand, I access the same

Reading csv files from S3?

2012-03-19 Thread Dallan
I'd like to extend the H2 source to read csv files from S3. Specifically, I'd like to implement a streaming interface (as SimpleRowSource?) so that a query could process the csv file one row at a time without needing to read the entire file into memory. Ideally, I'd like to have something like