Re: [h2] Release 1.4.178 Beta

Hi there, My bad. With all the third-digit increments, I hadn't even noticed that you also incremented 1.3 to 1.4 :-) Is there a documented numbering strategy, somewhere? Is it a problem that the y doesn't start with 0 or 1? Well, we've moved from our own arbitrary version numbering scheme to

[h2] DataBaseMetaData#getProcedureColumns missing return column

Hi, In the current state of H2 1.4.17, there is no way to retrieve procedure return type. However JDBC Api of DataBaseMetaData#getProcedureColumns specify that *ORDINAL_POSITION* at 0 mean return value of procedure. PostGreSQL follow JDBC Api for this point. Here the patch in order to return

Re: [h2] DataBaseMetaData#getProcedureColumns missing return column

Thank you for your patch, it has been applied. In future, please try to (a) run TestAll before and after your patch and verify that you have not introduced any new errors. In this case I had to modify another unit-test. (b) provide an entry in the changelog.html file. Regards, Noel. On

[h2] using alias in ORDER BY clause

Hi everyone, I try to use column alias in IOREDR BY clause but without much success. I try to test my query that I am using in MySQL DB my query is follow: select a.name as name, b.code from t1 where t1.total50 order by UPPER(name) but I've got exception that Column name not found If I use the

Re: [h2] got exception after update to 1.4.178

Hi Thomas, No, I have no test-case right now. I got the error message in real app., but am trying to prepare a simple test-case. Thank you On Monday, May 5, 2014 8:46:40 AM UTC+3, Thomas Mueller wrote: Hi, According to the error code you are using version 1.3.176 on one end. You are

[h2] Excessive amount of time spent in org.h2.util.DateTimeUtils.getTimeTry()

Hello, I was profiling a performance issue in our own software, when I noticed an excessive amount of time being spent in org.h2.util.DateTimeUtils.getTimeTry(), even if the benchmark selected only one timestamp column with dozens of other columns: http://i.imgur.com/KJdXEWB.png I am a bit

[h2] got exception after update to 1.4.178

Hi, Maybe appending ;trace_level_system_out=3 to the database URL can help creating a test case. This setting will show you all the JDBC API calls made. Regards, Thomas On Mon, May 5, 2014 at 12:45 PM, sim sim...@mail.rujavascript:_e(%7B%7D,'cvml','sim...@mail.ru'); wrote: Hi Thomas, No,

[h2] using alias in ORDER BY clause

Hi, To answer or see the answer, go to http://stackoverflow.com/questions/23469186/using-alias-in-order-by-clause-in-h2db Regards, Thomas On Mon, May 5, 2014 at 10:44 AM, Александр Салтыков alexandrsalty...@gmail.comjavascript:_e(%7B%7D,'cvml','alexandrsalty...@gmail.com'); wrote: Hi

Re: [h2] Row disappears within the same transaction after a failed update (constraint violation)

Hi, This should be fixed with the latest version of H2. Regards, Thomas On Thursday, April 17, 2014, Thomas Mueller thomas.tom.muel...@gmail.com wrote: 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

Re: [h2] Excessive amount of time spent in org.h2.util.DateTimeUtils.getTimeTry()

Hi, Yes, this is potentially a problem. It can be fixed in multiple ways (always use a new Calendar, use a ThreadLocal,...). So far it didn't show up in my tests, and so far nobody complained. Wouldn't it be sufficient to just call new Timestamp(time)? Well, the problem is what is the value of

Re: [h2] Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

Same problem here. I can add that my application is widely deployed, and each instance created a db for its internal configuration. Now everyone of them is failing, so I think it's not a problem of corruption... maybe the start parameters? The jdbc url with which it was created is:

Re: [h2] Excessive amount of time spent in org.h2.util.DateTimeUtils.getTimeTry()

I'm curious - why do we not simply store date and time in UTC format? i.e. in milliseconds since 1 Jan 1970? That's pretty much a universal format these days, and then we can convert to whatever the local time zone is when we convert the value to string. If necessary, I could create an extra data

[h2] Re: Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

mano wrote Opening it with version 1.3.168 will give the error. Sorry, I meant 1.3.176. -- View this message in context: http://h2-database.66688.n3.nabble.com/Unique-index-or-primary-key-violation-SYS-ID-ON-PUBLIC-SYS-ID-23505-168-using-1-3-168-tp4028700p4029078.html Sent from the H2

[h2] delete (nioMapped,embedded), creates temp table

Hi folks first post here..bare with me.. I have noticed when we do a delete from blah where date xxx'' limit y A temp table is always being generated..regardless if the limit is say 100 or 1. Is there anyways around this? (given this delete statement will never be rolled back?..can

[h2] Re: Unique index or primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23505-168] (using 1.3.168)

Same problem here. I can add that my application is widely deployed, and each instance created a db for its internal configuration. Now everyone of them is failing, so I think it's not a problem of corruption... maybe the start parameters? The jdbc url with which it was created is:

Re: [h2] Release 1.4.178 Beta

Hi, Is there a documented numbering strategy, somewhere? Yes, higher numbers are better :-) Maybe H2 should not be at version 2.x or 3.x according to Semver. But for normal users, there are actually no API changes. The JDBC API is still the same, and SQL didn't change either. The biggest

Re: [h2] Excessive amount of time spent in org.h2.util.DateTimeUtils.getTimeTry()

Hi, There are various problems when using java.util.Data / java.sql.Date / Time / Timestamp and java.util.Calendar, mainly because of the daylight time saving changes. For example, you can't assume a certain date (if you don't care about the time) is midnight, because in some timezones, for some

[h2] delete (nioMapped,embedded), creates temp table

Hi, I can't say what the problem could be. We would need a simple, complete, reproducible test case. Regards, Thomas On Tuesday, May 6, 2014, Daniel Hopins danhopk...@gmail.comjavascript:_e(%7B%7D,'cvml','danhopk...@gmail.com'); wrote: Hi folks first post here..bare with me.. I have