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.

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to