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. >
