RE: svn commit: r897605 - in /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: datasource/GenericDAO.java util/EntityListIterator.java

[rohit]

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

[Scott Gray-2]

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.

[rohit]

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

---

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.

[Scott Gray-2]

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.

[David E. Jones-2]

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

[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

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] <[e-mail]> wrote:
>>
>> From: Scott Gray-2 [via OFBiz] <[e-mail]>
>> Subject: Re: svn commit: r897605 - in /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: datasource/GenericDAO.java util/EntityListIterator.java
>> To: "rohit" <[e-mail]>
>> 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.
>

[rohit]

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 "

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] <[e-mail]> wrote:
>>
>> From: Scott Gray-2 [via OFBiz] <[e-mail]>
>> Subject: Re: svn commit: r897605 - in /ofbiz/trunk/framework/entity/src/org/ofbiz/entity: datasource/GenericDAO.java util/EntityListIterator.java
>> To: "rohit" <[e-mail]>
>> 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.
>