Hi Thomas, thanks again for your excellent support!
> > even if i manually set the timeout to 10000000 the exception occurs. > > I can not provide you with a simple test case for this since the > > process involved is non trivial. > > If you want I could provide you with instructions how to reproduce > > this behaviour using our test cases - please let me know. > > That would be great... So far I can't reproduce this problem. I wrote a short HowTo at http://wiki.flexive.org/confluence/display/FX/Running+Unit+Tests specifically for running H2 unit tests. To get the timeout error just edit the file src/framework/java/com/ flexive/core/search/H2/H2SQLDataFilter.java and change line 65 (method isQueryTimeoutSupported()) to "return true;" Please run the first test run like explained in the wiki, for subsequent you can just issue "ant db.noupdate tests.groups - Dtests.groups=search" to avoid re-creating the database. The timeouts are then set in files src/framework/java/com/flexive/core/ search/SqlSearch.java line 267 and src/framework/java/com/flexive/core/ search/genericSQL/GenericSQLDataFilter.java line 197. The default value used is 15. To test higher values just change the 2 mentioned lines to a higher value replacing search.getParams().getQueryTimeout() with numeric values. > > > Here are the create table statements without any constraints, etc. > > needed to produce a test case. > > Hm, I still can't reproduce it... I tried with your query and no data, > and with one row for each table, but it works for me (however the > result was zero rows). Zero rows is the expected result. However I can no longer reproduce this issue using version 105. Reverting back to 103 I still get this error: "Order by expression 2 must be in the result list in this case" > > Sure! Already done, seehttp://www.h2database.com/html/links.html > Thanks a lot! :-) Cheers, Markus --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
