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.
