Hi Thomas, thanks a lot for the time and effort you put into answering and actually already fixing these issues!
Concerning "id and version of a content instance as the primary key and rely on references to the id": I was afraid that this is the expected and correct behaviour :( Do you have any suggestions how to reference an id where the version does not matter using some kind of foreign key constraint? I can not reference a specific version since it may be removed but the reference is still valid as long as *any* version exists ... a bit tricky I am afraid. >> Query timeouts: statement.setQueryTimeout(15/*seconds*/); is not working > > I can't reproduce this problem. What version of H2 do you use? Maybe > an old version of H2 is in the classpath? I use version 1.1.103 (2008-11-07) and there is only this one version in the classpath, I double checked. If I set timeouts to 15 (seconds, I tried 15000 as well guessing it could be milliseconds) I get this exception cause: "Caused by: org.h2.jdbc.JdbcSQLException: Statement was canceled or the session timed out [90051-103]" > > > Order By: ... issues if used in a subquery in the main queries where > > clause: the query parser just wont compile the query. > > I can't reproduce the problem, but I remember there were problems so > time ago. How does the query look like exactly? I'm sorry I can not give you a simpler and "cleaner" query, but this one is generated from out parser and the offending order by is commented out: SELECT filter.rownr,filter.id,filter.ver,filter.created_by ,filter.ID prop_0_0 ,filter.VER prop_0_1 ,filter.ID prop_1_0 ,(SELECT sub.FTEXT1024 FROM FX_CONTENT_DATA sub WHERE sub.id=filter.id AND sub.ver=filter.ver AND TPROP=101 AND (sub.lang=1 OR sub.ismldef=true) ORDER BY sub.ismldef LIMIT 1 ) prop_2_0 ,concat(filter.xpathPref,(SELECT sub.XPATHMULT FROM FX_CONTENT_DATA sub WHERE sub.id=filter.id AND sub.ver=filter.ver AND TPROP=101 AND (sub.lang=1 OR sub.ismldef=true) ORDER BY sub.ismldef LIMIT 1 )) propX_2_1 ,filter.prop_3_0 ,concat(filter.xpathPref,(SELECT sub.XPATHMULT FROM FX_CONTENT_DATA sub WHERE sub.id=filter.id AND sub.ver=filter.ver AND TPROP=105 AND (sub.lang=1 OR sub.ismldef=true) ORDER BY sub.ismldef LIMIT 1 )) propX_3_1 FROM (SELECT SET(@rownr,@rownr+1) rownr, * FROM (select filter.id,filter.ver,filter.created_by,concat(concat(concat(concat (concat(t.name,'[EMAIL PROTECTED]'),filter.id),'.'),filter.ver),']') xpathPref , (SELECT sub.FINT FROM FX_CONTENT_DATA sub WHERE sub.id=filter.id AND sub.ver=filter.ver AND TPROP=105 AND (sub.lang=1 OR sub.ismldef=true) / *ORDER BY sub.ismldef LIMIT 1*/ ) prop_3_0 ,null FROM FXS_SEARCHCACHE_MEMORY filter, FXS_TYPEDEF t WHERE search_id=410 AND filter.tdef=t.id AND filter.TDEF=6 ORDER BY 5 desc)) filter ORDER BY 1 > > > webfrontend ... remove a database called flexive all databases that begin > > with the term flexive and exist in the same directory are removed as well > > I can't reproduce this problem with the current version. With version 1.1.103 and removing "flexive" and having flexiveTest and flexiveConfiguration the command line you print in the webfrontend is java -cp h2.jar org.h2.tools.DeleteDbFiles -dir "~" -db "flexive" and I get this result which removes "flexive" and "flexiveTest": Processed: /home/mplesser/flexiveTest.lobs.db/245.t879.lob.db Processed: /home/mplesser/flexiveTest.lobs.db/158.t879.lob.db ..... Processed: /home/mplesser/flexiveTest.lobs.db/98.t1077.lob.db Processed: /home/mplesser/flexive.index.db Processed: /home/mplesser/flexive.6.log.db Processed: /home/mplesser/flexive.data.db Processed: /home/mplesser/flexive.lobs.db/83.t205.lob.db ... Processed: /home/mplesser/flexive.lobs.db/120.t205.lob.db Processed: /home/mplesser/flexive.lobs.db Please let me know if I can further assist you in looking at these issues. I could help you to run and setup the flexive testcases to reproduce this easily. Cheers and thanks, 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 -~----------~----~----~----~------~----~------~--~---
