Yes, i am using a different database, PostgreSQL 8.2.11 on fedora FC 8. I am not a database expert, but issue seems to be with some 'nested queries' that ofbiz was making after this commit. I noticed in logs that select query for the keywords that caused the error was different from that of the keywords which did not cause any problem.
I am unsure but should i open a Jira issue for it, i assume that ofbiz is made to support multiple database software. Rohit David E Jones-4 wrote: > > > This is probably true. I apologize that I haven't been able to look into > your report more... > > Which database are you using Rohit? > > -David > > > On Jan 14, 2010, at 9:10 PM, Scott Gray wrote: > >> My guess is that the commit introduced a problem for some databases but >> not for others, so it works on the demo instance (Derby) but not on your >> instance which I assume is running a different database server. >> >> Regards >> Scott >> >> On 14/01/2010, at 8:00 PM, rohit wrote: >> >>> >>> I did not recreate the database. but i briefly checked it was working on >>> ofbiz demo server, which i assume is started up afresh everyday >>> including the database. >>> I faced the problem in the following situations: >>> if multiple keywords are used and the keywords were already in the >>> database in productkeyword table and other tables, ofbiz throws the >>> error. the unique thing i noticed that the error did not occur for sets >>> of keywords used for the first time and not already existing in the >>> database. >>> I hope it helps, but i am sure there is some issue with this commit. >>> Rohit >>> >>> >>> --- On Fri, 1/15/10, Scott Gray-2 [via OFBiz] >>> <[email protected]> wrote: >>> >>> From: Scott Gray-2 [via OFBiz] >>> <[email protected]> >>> Subject: Re: svn commit: r897605 - in >>> /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: >>> datasource/GenericDAO.java util/EntityListIterator.java >>> To: "rohit" <[email protected]> >>> Date: Friday, January 15, 2010, 5:21 AM >>> >>> >>> >>> Hi Rohit, >>> >>> >>> Are you sure that it works if the database is recreated? I can't see >>> >>> anything in the commit that would cause or require the database >>> >>> structure to change. >>> >>> >>> Regards >>> >>> Scott >>> >>> >>> HotWax Media >>> >>> http://www.hotwaxmedia.com >>> >>> On 13/01/2010, at 3:44 PM, rohit wrote: >>> >>> >>>> >>> >>>> Hi, >>> >>>> >>> >>>> I don't think this commit is compatible with older database created by >>> >>>> ofbiz. >>> >>>> >>> >>>> For eg. if you update the code without recreating the ofbiz database >>> >>>> you get >>> >>>> error as in >>> >>>> >>> >>>> http://n4.nabble.com/Error-in-product-search-result-when-using-multiple-keywords-td1012687.html#a1012687 >>>> >>> >>>> I had to reverse this commit to remove the error. >>> >>>> >>> >>>> I guess there might be a better way to do this than to drop and >>> >>>> recreate the >>> >>>> tables for this commit to work. >>> >>>> >>> >>>> Rohit >>> >>>> -- >>> >>>> View this message in context: >>>> http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1013432.html >>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >>> >>> smime.p7s (3K) Download Attachment >>> >>> >>> >>> >>> >>> View message @ >>> http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1014358.html >>> >>> >>> To unsubscribe from RE: svn commit: r897605 - in >>> /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: >>> datasource/GenericDAO.java util/EntityListIterator.java, click here. >>> >>> >>> >>> >>> -- >>> View this message in context: >>> http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1014471.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >> > > > -- View this message in context: http://n4.nabble.com/RE-svn-commit-r897605-in-ofbiz-trunk-framework-entity-src-org-ofbiz-entity-datasource-GenericDAO-java-tp1013432p1014484.html Sent from the OFBiz - User mailing list archive at Nabble.com.
