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 |
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 |
|
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] <[hidden email] > > wrote: > > From: Scott Gray-2 [via OFBiz] <[hidden email] > > > Subject: Re: svn commit: r897605 - in /ofbiz/trunk/framework/entity/ > src/org/ofbiz/entity: datasource/GenericDAO.java util/ > EntityListIterator.java > To: "rohit" <[hidden email]> > 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. smime.p7s (3K) Download Attachment |
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] <[hidden email]> wrote: >> >> From: Scott Gray-2 [via OFBiz] <[hidden email]> >> Subject: Re: svn commit: r897605 - in /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: datasource/GenericDAO.java util/EntityListIterator.java >> To: "rohit" <[hidden email]> >> 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. > |
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
|
In reply to this post by David E. Jones-2
Hi David,
I was checking if you got the chance to check my last post. Thanks, Rohit "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 "
|
Free forum by Nabble | Edit this page |