[h2] tochar alias problem in h2 1.3.175 version

hi I`ve a query which works perfectly in Oracle , Query q = session.createQuery(select new TESTPOJO(c.name, c.phoneNumber, to_char(c.dateofBirth, '') from STUDENT c where c.gender= :gender group by to_char(c.dateofBirth, 'YY') ); q.setString(gender, Male); result = q.list(); I `m facing

[h2] File corruption with MVCC

For a personal project I am using H2 database (1.3.175) with Datanucleus JPA (3.2) provider and I faced systematically file corruption when I reboot my server. I cannot use server mode because my server is an embedded device with very low resources so I am using file mode with MVCC=TRUE. My

[h2] Join slow on Windows XP, but fast on Windows 7

Hi, I have the following problem. My Application uses a H2 database (1.3.171) stored to the hardisk. I am running a full outer join (implemented by RIGHT OUTER, UNION , LEFT OUTER) between of 2 tables (30 columns each, 1.1 million records each). On my Windows 7 Test machine, the join completes

[h2] Re: Create LINKED TABLE performance issue

Thank you very much. Looks like interesting, may helps a lot. On Wednesday, March 19, 2014 10:29:54 AM UTC-7, Vishwanatha Sundarappa wrote: Hi All, I need to create Linked table to my mysql view which internally joined larger tables(direct query execution takes more than 10mins). I am