Sorry! h2-1.1.100 is available in central maven. Thanks, Prashant
On Oct 13, 12:24 pm, Prashant Bhat <[EMAIL PROTECTED]> wrote: > Hi Thomas, > > I've uploaded a sample test project that uses Spring-2.5.5, OpenJpa > and H2 > here:http://groups.google.com/group/h2-database/web/openjpa-tests.tar.gz > > Just running 'mvn' should be ok, BTW h2-1.1.100 is not published to > maven repo, so should be locally installed. > CityDaoTests works with 1.0.79 but not with 1.1.100. I couldn't find > the exact issue as the database/openjpa doesn't throw any exceptions. > > I noticed that if the first WHERE clause has only one condition then > it works but not if one more condition is added. > works: 'WHERE x.state.id IN (SELECT y.id FROM State AS y WHERE > y.country.id = ?1) ORDER BY x.cityCode' > but not this: 'WHERE x.active = ?1 AND x.state.id IN (SELECT y.id FROM > State AS y WHERE y.country.id = ?2) ORDER BY x.cityCode' > > Thanks, > Prashant > > On Oct 10, 8:07 pm, "Thomas Mueller" <[EMAIL PROTECTED]> > wrote: > > > Hi, > > > In version 1.1.x, the optimization for IN(SELECT...) is enabled by > > default, while it was disabled in version 1.0.x. So far I couldn't > > find a problem. Could you post some more details please (the query, > > the tables, the indexes)? Or if possible, could you post a > > reproducible test case? > > > To disable the optimization, set the system property h2.optimizeInJoin > > to false before loading the H2 JDBC driver. > > > 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 [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
