Re: set to NULL in SECAs

[Scott Gray]

So you want some of the results from CC to go into CA but not all of them?  I 
think the code only allows for an all or nothing approach, the only real 
workaround is to add another service that manually calls CC but does not return 
the unwanted fields.  You're welcome to look at the implementations yourself, 
they're in ServiceEcaAction.java and ServiceEcaSetField.java.

Perhaps ideally a SECA action would provide a bit more flexibility similar to 
what we have in the minilang call-service attribute whereby you can use child 
elements to specify exactly what should be done with each result field.

Regards
Scott

On 20/07/2010, at 5:06 PM, varun bhansaly wrote:

> The issue is with attribute name = "partyId" both CC & CA are custom
> services working fine independently.
> 
> partyId comes in the output of CC, the idea is to either
> 
> 1. reset partyId to null OR
> 2. not to send it in input to CA.
> 
> for 2. I have tried with result-map-name attribute, but it remains the same
> (as observed while context is printing in CA).
> 
> I would not want to change any of the input output params since they work
> fine independently.
> 
> Thanks
> 
> 
> 
> On Tue, Jul 20, 2010 at 10:14 AM, Scott Gray 
> wrote:
> 
>> I'm guessing here that you want service2 to be triggered before service1
>> and ultimately have it alter the value of attribute1 before it gets passed
>> to service1?
>> 
>> If so, then just define attribute1 as INOUT and then modify it inside
>> service2 and get rid of attribute2 altogether.
>> 
>> Regards
>> Scott
>> 
>> HotWax Media
>> http://www.hotwaxmedia.com
>> 
>> On 20/07/2010, at 4:26 PM, varun bhansaly wrote:
>> 
>>> Thanks Jacques, Scott, is there any other way to achieve the same w/o
>>> customizing the framework code ?
>>> 
>>> This is the actual problem
>>> http://ofbiz.135035.n4.nabble.com/query-regarding-SECAs-tt2294160.html
>>> 
>>> Thanks,
>>> 
>>> On Tue, Jul 20, 2010 at 9:34 AM, Scott Gray >> wrote:
>>> 
 Won't work, I'm pretty sure nothing will after looking at the code.
 
 Regards
 Scott
 
 HotWax Media
 http://www.hotwaxmedia.com
 
 On 20/07/2010, at 3:57 PM, Jacques Le Roux wrote:
 
> Try nullField, ie
> 
> 
> Jacques
> 
> From: "varun bhansaly" 
>> Hi,
>> I am implementing a scenario using SECAs, where in it would be
>> required
 to
>> set a field to NULL or empty string.
>> Is it possible to set a field to NULL using the set tags of eca xmls.
>> I've tried with  but this does
>> not set attribute1 to empty string
>> --
>> Regards,
>> Varun Bhansaly
>> 
> 
 
 
>>> 
>>> 
>>> --
>>> Regards,
>>> Varun Bhansaly
>> 
>> 
> 
> 
> -- 
> Regards,
> Varun Bhansaly



smime.p7s
Description: S/MIME cryptographic signature

Re: Add created_by and updated_by to all tables ?

[Deyan Tsvetanov]

What about the entity locking and record based security ? 

1) When we enable locking for an entity and there is an exception we
would like to know who modified the data before us. 

2) Users enter data and have security permission PARTY_CREATE. They
don't have permission PARTY_UPDATE or PARTYMGR_ADMIN. However they often
make mistakes in the entered data and they would like to correct them.
This we can solve by adding a security permission
PARTY_UPDATE_SELF_CREATED or so which allows updating records created by
the same user. 

-- Deyan 

On Mon, 2010-07-19 at 23:41 -0600, David E Jones wrote:
> There's even a general auditing feature in the entity engine that saves 
> changes, who changed it, when, visitId, etc. See the EntityAuditLog entity 
> and the audit flag on the entity -> field element on an entity definition.
> 
> -David
> 
> 
> On Jul 19, 2010, at 11:36 PM, Deyan Tsvetanov wrote:
> 
> > Well for what is important there is already a changelog model -
> > party_status, party_name_history. 
> > 
> > If something else is needed we should we create it on demand. 
> > 
> > -- Deyan 
> > 
> > On Mon, 2010-07-19 at 14:57 -0700, BJ Freeman wrote:
> >> then if that ibnformaton is that important, should it not follow the 
> >> changelog model for audit, like changeprice?
> >> 
> >> Deyan Tsvetanov sent the following on 7/19/2010 9:01 AM:
> >>> Well I don't agree.
> >>> 
> >>> A classic example of entities relation is party<- person.
> >>> 
> >>> One could update only the Person entity - change the lastName. So we
> >>> update updated_by field only of the Person entity.
> >>> 
> >>> One could update only the party entity - change the status - so we
> >>> update updated_by field only of the Party entity.
> >>> 
> >>> I actually can not think of a table / entity that might not need the two
> >>> fields.
> >>> 
> >>> Even if we take ENUMERATION_TYPE - it currently has created_stamp_tx and
> >>> updated_stamp_tx - why should it not have updated_by and created_by as
> >>> well ?
> >>> 
> >>> -- Deyan
> >>> 
> >>> On Mon, 2010-07-19 at 08:50 -0700, BJ Freeman wrote:
>  an entity has a relationship with another entity.
>  so if the main entity is updated those in the relationship will be tied
>  to the main entity and don't need the two fields.
>  
>  yes those that are only updated by person should have the two fields, in
>  my opinion.
>  
>  Deyan Tsvetanov sent the following on 7/19/2010 8:42 AM:
> >> Many entities data is not created without a dependence on another one
> >> so those should not need those two fields.
> > 
> > This one i didn't understand :)
> > 
> > In general data is being updated either by a person ( user or an
> > administrator or a consultant ) or by a process ( the system account ).
> > 
> > 
> >> 
> >> 
> > On Mon, 2010-07-19 at 08:29 -0700, BJ Freeman wrote:
> >> there are many operations that are generated by the system levels, such
> >> as status change. I can see the entities that are affected solely by
> >> users having those fields.
> >> I can see some being added but not every entity.
> >> Many entities data is not created without a dependence on another one 
> >> so
> >> those should not need those two fields.
> >> 
> >> 
> >> Deyan Tsvetanov sent the following on 7/19/2010 8:03 AM:
> >>> Hi guys,
> >>> 
> >>> another suggestion: to add 2 mandatory fields created_by and 
> >>> updated_by
> >>> to all tables by default like created_stamp and updated_stamp. 
> >>> Currently
> >>> there columns are added on demand in the entity definition but they 
> >>> are
> >>> often needed.
> >>> 
> >>> Examples of usage:
> >>> 1)  status change - there is no created_by in the entity status table 
> >>> -
> >>> party_status.
> >>> In general customers would like to know who and when disabled the 
> >>> party
> >>> and who re-enabled it. The same applies to orders, invoices, etc.
> >>> 
> >>> 2) Another example for using these 2 columns is entity lock. When an
> >>> EntityLockedException is thrown it would be nice to include the
> >>> userLoginId of the user who updated the record as well as the time so 
> >>> we
> >>> can notify the user:
> >>> "The record you are trying to save has been updated by Administrator,
> >>> The priviledged 5 minutes 32 secods ago. To cancel your request and
> >>> reload the changes click reload. To go ahead and overwrite the changes
> >>> done by Administrator click "Overwrite". "
> >>> Or so ...
> >>> 
> >>> 3) Record based security - users could be allowed to modify records 
> >>> they
> >>> have created even without edit or admin permissions.
> >>> 
> >>> Therefore it would be very very helpful if these 2 columns are present
> >>> by default, even if they allow null values to preserve the current 
> >>> 

Re: Add created_by and updated_by to all tables ?

[David E Jones]

There's even a general auditing feature in the entity engine that saves 
changes, who changed it, when, visitId, etc. See the EntityAuditLog entity and 
the audit flag on the entity -> field element on an entity definition.

-David


On Jul 19, 2010, at 11:36 PM, Deyan Tsvetanov wrote:

> Well for what is important there is already a changelog model -
> party_status, party_name_history. 
> 
> If something else is needed we should we create it on demand. 
> 
> -- Deyan 
> 
> On Mon, 2010-07-19 at 14:57 -0700, BJ Freeman wrote:
>> then if that ibnformaton is that important, should it not follow the 
>> changelog model for audit, like changeprice?
>> 
>> Deyan Tsvetanov sent the following on 7/19/2010 9:01 AM:
>>> Well I don't agree.
>>> 
>>> A classic example of entities relation is party<- person.
>>> 
>>> One could update only the Person entity - change the lastName. So we
>>> update updated_by field only of the Person entity.
>>> 
>>> One could update only the party entity - change the status - so we
>>> update updated_by field only of the Party entity.
>>> 
>>> I actually can not think of a table / entity that might not need the two
>>> fields.
>>> 
>>> Even if we take ENUMERATION_TYPE - it currently has created_stamp_tx and
>>> updated_stamp_tx - why should it not have updated_by and created_by as
>>> well ?
>>> 
>>> -- Deyan
>>> 
>>> On Mon, 2010-07-19 at 08:50 -0700, BJ Freeman wrote:
 an entity has a relationship with another entity.
 so if the main entity is updated those in the relationship will be tied
 to the main entity and don't need the two fields.
 
 yes those that are only updated by person should have the two fields, in
 my opinion.
 
 Deyan Tsvetanov sent the following on 7/19/2010 8:42 AM:
>> Many entities data is not created without a dependence on another one
>> so those should not need those two fields.
> 
> This one i didn't understand :)
> 
> In general data is being updated either by a person ( user or an
> administrator or a consultant ) or by a process ( the system account ).
> 
> 
>> 
>> 
> On Mon, 2010-07-19 at 08:29 -0700, BJ Freeman wrote:
>> there are many operations that are generated by the system levels, such
>> as status change. I can see the entities that are affected solely by
>> users having those fields.
>> I can see some being added but not every entity.
>> Many entities data is not created without a dependence on another one so
>> those should not need those two fields.
>> 
>> 
>> Deyan Tsvetanov sent the following on 7/19/2010 8:03 AM:
>>> Hi guys,
>>> 
>>> another suggestion: to add 2 mandatory fields created_by and updated_by
>>> to all tables by default like created_stamp and updated_stamp. Currently
>>> there columns are added on demand in the entity definition but they are
>>> often needed.
>>> 
>>> Examples of usage:
>>> 1)  status change - there is no created_by in the entity status table -
>>> party_status.
>>> In general customers would like to know who and when disabled the party
>>> and who re-enabled it. The same applies to orders, invoices, etc.
>>> 
>>> 2) Another example for using these 2 columns is entity lock. When an
>>> EntityLockedException is thrown it would be nice to include the
>>> userLoginId of the user who updated the record as well as the time so we
>>> can notify the user:
>>> "The record you are trying to save has been updated by Administrator,
>>> The priviledged 5 minutes 32 secods ago. To cancel your request and
>>> reload the changes click reload. To go ahead and overwrite the changes
>>> done by Administrator click "Overwrite". "
>>> Or so ...
>>> 
>>> 3) Record based security - users could be allowed to modify records they
>>> have created even without edit or admin permissions.
>>> 
>>> Therefore it would be very very helpful if these 2 columns are present
>>> by default, even if they allow null values to preserve the current code
>>> working.
>>> 
>>> -- deyan
>>> 
>>> 
>>> 
> 
> 
> 
>>> 
>>> 
>>> 
> 
> 

Re: Add created_by and updated_by to all tables ?

[Deyan Tsvetanov]

Well for what is important there is already a changelog model -
party_status, party_name_history. 

If something else is needed we should we create it on demand. 

-- Deyan 

On Mon, 2010-07-19 at 14:57 -0700, BJ Freeman wrote:
> then if that ibnformaton is that important, should it not follow the 
> changelog model for audit, like changeprice?
> 
> Deyan Tsvetanov sent the following on 7/19/2010 9:01 AM:
> > Well I don't agree.
> >
> > A classic example of entities relation is party<- person.
> >
> > One could update only the Person entity - change the lastName. So we
> > update updated_by field only of the Person entity.
> >
> > One could update only the party entity - change the status - so we
> > update updated_by field only of the Party entity.
> >
> > I actually can not think of a table / entity that might not need the two
> > fields.
> >
> > Even if we take ENUMERATION_TYPE - it currently has created_stamp_tx and
> > updated_stamp_tx - why should it not have updated_by and created_by as
> > well ?
> >
> > -- Deyan
> >
> > On Mon, 2010-07-19 at 08:50 -0700, BJ Freeman wrote:
> >> an entity has a relationship with another entity.
> >> so if the main entity is updated those in the relationship will be tied
> >> to the main entity and don't need the two fields.
> >>
> >> yes those that are only updated by person should have the two fields, in
> >> my opinion.
> >>
> >> Deyan Tsvetanov sent the following on 7/19/2010 8:42 AM:
>  Many entities data is not created without a dependence on another one
>  so those should not need those two fields.
> >>>
> >>> This one i didn't understand :)
> >>>
> >>> In general data is being updated either by a person ( user or an
> >>> administrator or a consultant ) or by a process ( the system account ).
> >>>
> >>>
> 
> 
> >>> On Mon, 2010-07-19 at 08:29 -0700, BJ Freeman wrote:
>  there are many operations that are generated by the system levels, such
>  as status change. I can see the entities that are affected solely by
>  users having those fields.
>  I can see some being added but not every entity.
>  Many entities data is not created without a dependence on another one so
>  those should not need those two fields.
> 
> 
>  Deyan Tsvetanov sent the following on 7/19/2010 8:03 AM:
> > Hi guys,
> >
> > another suggestion: to add 2 mandatory fields created_by and updated_by
> > to all tables by default like created_stamp and updated_stamp. Currently
> > there columns are added on demand in the entity definition but they are
> > often needed.
> >
> > Examples of usage:
> > 1)  status change - there is no created_by in the entity status table -
> > party_status.
> > In general customers would like to know who and when disabled the party
> > and who re-enabled it. The same applies to orders, invoices, etc.
> >
> > 2) Another example for using these 2 columns is entity lock. When an
> > EntityLockedException is thrown it would be nice to include the
> > userLoginId of the user who updated the record as well as the time so we
> > can notify the user:
> > "The record you are trying to save has been updated by Administrator,
> > The priviledged 5 minutes 32 secods ago. To cancel your request and
> > reload the changes click reload. To go ahead and overwrite the changes
> > done by Administrator click "Overwrite". "
> > Or so ...
> >
> > 3) Record based security - users could be allowed to modify records they
> > have created even without edit or admin permissions.
> >
> > Therefore it would be very very helpful if these 2 columns are present
> > by default, even if they allow null values to preserve the current code
> > working.
> >
> > -- deyan
> >
> >
> >
> >>>
> >>>
> >>>
> >
> >
> >

Re: PayPal Currency Issue

[aswath satrasala]

Hi Gaurav,
You have to send the currency code parameter to paypal.
Please verify if the patch is applied correctly.
or you can hardcode like this temporarily in paypalevents.java  - line:157,
function: callPayPal.
parameter.put("currency_code", "GBP").

Don't forget to do 'ant build'.

good luck,
-Aswath

On Thu, Jul 15, 2010 at 7:35 PM, kaliagaurav wrote:

>
> Hi Raj
>
> If I am not wrong "currencyuom" get configured in general.properties. I
> have
> changed
>
> currency.uom.id.default=USD
>
> to
>
> currency.uom.id.default=GBP
>
> Is there any other place where I need to configure this.
>
> Please suggest
>
> Regards
> Gaurav
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/PayPal-Currency-Issue-tp2287192p2290201.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Re: set to NULL in SECAs

[varun bhansaly]

The issue is with attribute name = "partyId" both CC & CA are custom
services working fine independently.

partyId comes in the output of CC, the idea is to either

1. reset partyId to null OR
2. not to send it in input to CA.

for 2. I have tried with result-map-name attribute, but it remains the same
(as observed while context is printing in CA).

I would not want to change any of the input output params since they work
fine independently.

Thanks



On Tue, Jul 20, 2010 at 10:14 AM, Scott Gray wrote:

> I'm guessing here that you want service2 to be triggered before service1
> and ultimately have it alter the value of attribute1 before it gets passed
> to service1?
>
> If so, then just define attribute1 as INOUT and then modify it inside
> service2 and get rid of attribute2 altogether.
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 20/07/2010, at 4:26 PM, varun bhansaly wrote:
>
> > Thanks Jacques, Scott, is there any other way to achieve the same w/o
> > customizing the framework code ?
> >
> > This is the actual problem
> > http://ofbiz.135035.n4.nabble.com/query-regarding-SECAs-tt2294160.html
> >
> > Thanks,
> >
> > On Tue, Jul 20, 2010 at 9:34 AM, Scott Gray  >wrote:
> >
> >> Won't work, I'm pretty sure nothing will after looking at the code.
> >>
> >> Regards
> >> Scott
> >>
> >> HotWax Media
> >> http://www.hotwaxmedia.com
> >>
> >> On 20/07/2010, at 3:57 PM, Jacques Le Roux wrote:
> >>
> >>> Try nullField, ie
> >>> 
> >>>
> >>> Jacques
> >>>
> >>> From: "varun bhansaly" 
>  Hi,
>  I am implementing a scenario using SECAs, where in it would be
> required
> >> to
>  set a field to NULL or empty string.
>  Is it possible to set a field to NULL using the set tags of eca xmls.
>  I've tried with  but this does
>  not set attribute1 to empty string
>  --
>  Regards,
>  Varun Bhansaly
> 
> >>>
> >>
> >>
> >
> >
> > --
> > Regards,
> > Varun Bhansaly
>
>


-- 
Regards,
Varun Bhansaly

Re: set to NULL in SECAs

[Scott Gray]

I'm guessing here that you want service2 to be triggered before service1 and 
ultimately have it alter the value of attribute1 before it gets passed to 
service1?

If so, then just define attribute1 as INOUT and then modify it inside service2 
and get rid of attribute2 altogether.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 20/07/2010, at 4:26 PM, varun bhansaly wrote:

> Thanks Jacques, Scott, is there any other way to achieve the same w/o
> customizing the framework code ?
> 
> This is the actual problem
> http://ofbiz.135035.n4.nabble.com/query-regarding-SECAs-tt2294160.html
> 
> Thanks,
> 
> On Tue, Jul 20, 2010 at 9:34 AM, Scott Gray wrote:
> 
>> Won't work, I'm pretty sure nothing will after looking at the code.
>> 
>> Regards
>> Scott
>> 
>> HotWax Media
>> http://www.hotwaxmedia.com
>> 
>> On 20/07/2010, at 3:57 PM, Jacques Le Roux wrote:
>> 
>>> Try nullField, ie
>>> 
>>> 
>>> Jacques
>>> 
>>> From: "varun bhansaly" 
 Hi,
 I am implementing a scenario using SECAs, where in it would be required
>> to
 set a field to NULL or empty string.
 Is it possible to set a field to NULL using the set tags of eca xmls.
 I've tried with  but this does
 not set attribute1 to empty string
 --
 Regards,
 Varun Bhansaly
 
>>> 
>> 
>> 
> 
> 
> -- 
> Regards,
> Varun Bhansaly



smime.p7s
Description: S/MIME cryptographic signature

Re: set to NULL in SECAs

[varun bhansaly]

Thanks Jacques, Scott, is there any other way to achieve the same w/o
customizing the framework code ?

This is the actual problem
http://ofbiz.135035.n4.nabble.com/query-regarding-SECAs-tt2294160.html

Thanks,

On Tue, Jul 20, 2010 at 9:34 AM, Scott Gray wrote:

> Won't work, I'm pretty sure nothing will after looking at the code.
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 20/07/2010, at 3:57 PM, Jacques Le Roux wrote:
>
> > Try nullField, ie
> > 
> >
> > Jacques
> >
> > From: "varun bhansaly" 
> >> Hi,
> >> I am implementing a scenario using SECAs, where in it would be required
> to
> >> set a field to NULL or empty string.
> >> Is it possible to set a field to NULL using the set tags of eca xmls.
> >> I've tried with  but this does
> >> not set attribute1 to empty string
> >> --
> >> Regards,
> >> Varun Bhansaly
> >>
> >
>
>


-- 
Regards,
Varun Bhansaly

Re: set to NULL in SECAs

[Scott Gray]

Won't work, I'm pretty sure nothing will after looking at the code.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 20/07/2010, at 3:57 PM, Jacques Le Roux wrote:

> Try nullField, ie
> 
> 
> Jacques
> 
> From: "varun bhansaly" 
>> Hi,
>> I am implementing a scenario using SECAs, where in it would be required to
>> set a field to NULL or empty string.
>> Is it possible to set a field to NULL using the set tags of eca xmls.
>> I've tried with  but this does
>> not set attribute1 to empty string
>> -- 
>> Regards,
>> Varun Bhansaly
>> 
> 



smime.p7s
Description: S/MIME cryptographic signature

Re: set to NULL in SECAs

[Jacques Le Roux]

Try nullField, ie


Jacques

From: "varun bhansaly" 

Hi,
I am implementing a scenario using SECAs, where in it would be required to
set a field to NULL or empty string.
Is it possible to set a field to NULL using the set tags of eca xmls.
I've tried with  but this does
not set attribute1 to empty string

--
Regards,
Varun Bhansaly

Re: demo-trunk site dieing lead

[Scott Gray]

No I don't forget, but I wasn't shown any of the logs that time either.  
Typically though the report is that the instance becomes unresponsive, not that 
it randomly just decides to shut down.

Regards
Scott

On 20/07/2010, at 2:38 PM, BJ Freeman wrote:

> you forget the ofbiz demo-trunk also shut down many times
> and that was in less than 24 hours for a few weeks
> I don't know if the reason is stopped.
> 
> 
> Scott Gray sent the following on 7/19/2010 7:30 PM:
>> I still don't see anything that indicates why OFBiz was stopped and I've 
>> never heard a single bug report from anyone describing random shutdowns.  
>> This really isn't the type of thing where you can play guessing games and 
>> hope to come up with a solution.
>> 
>> Regards
>> Scott
>> 
>> On 20/07/2010, at 1:50 PM, BJ Freeman wrote:
>> 
>>> from the apache logs you will see it was hitting ofbiz even after it 
>>> stopped.
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:24:31 -0700] "GET 
>>> /humanres/control/setSessionLocale?newLocale=no_NO_NY HTTP/1.1" 200 6525 
>>> "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:24:49 -0700] "GET 
>>> /humanres/control/setSessionTimeZone?tzId=Europe%2FCopenhagen&trail= 
>>> HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:27:47 -0700] "GET 
>>> /catalog/control/setSessionTimeZone?tzId=America%2FGrand_Turk&ProductKeywordsPanel_collapsed=false
>>>  HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:27:57 -0700] "GET 
>>> /humanres/control/setSessionLocale?newLocale=de_DE HTTP/1.1" 503 448 "-" 
>>> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:31:14 -0700] "GET 
>>> /catalog/control/setSessionTimeZone?tzId=Atlantic%2FJan_Mayen&ProductBrowseCatalogsPanel_collapsed=false
>>>  HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:31:24 -0700] "GET 
>>> /humanres/control/setSessionLocale?newLocale=en_PH HTTP/1.1" 503 448 "-" 
>>> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:14 -0700] "GET 
>>> /googlecheckout/control/setSessionTimeZone?tzId=Brazil%2FAcre&add-gc-configuration_collapsed=false
>>>  HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:24 -0700] "GET 
>>> /marketing/control/checkLogin/main?tzId=Australia%2FDarwin HTTP/1.1" 503 
>>> 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:34 -0700] "GET 
>>> /partymgr/control/checkLogin/main?tzId=America%2FMonterrey HTTP/1.1" 503 
>>> 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:45 -0700] "GET 
>>> /humanres/control/checkLogin/main?newLocale=lv HTTP/1.1" 503 448 "-" 
>>> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:36:05 -0700] "GET 
>>> /googlebase/control/checkLogin/main?tzId=America%2FIqaluit HTTP/1.1" 503 
>>> 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:37:58 -0700] "GET 
>>> /humanres/control/setSessionLocale?newLocale=cs_CZ HTTP/1.1" 503 448 "-" 
>>> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:38:11 -0700] "GET 
>>> /humanres/control/setSessionTimeZone?tzId=Pacific%2FMarquesas&trail= 
>>> HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:40:20 -0700] "GET 
>>> /facility/control/checkLogin/main?tzId=Pacific%2FGalapagos HTTP/1.1" 503 
>>> 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:41:20 -0700] "GET 
>>> /humanres/control/setSessionLocale?newLocale=es_GT HTTP/1.1" 503 448 "-" 
>>> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:42:38 -0700] "GET 
>>> /marketing/control/checkLogin/main?tzId=America%2FMontreal HTTP/1.1" 503 
>>> 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
>>> +http://www.google.com/bot.html)"
>>> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:44:45 -0700] "GET 
>>> /hum

Re: demo-trunk site dieing lead

[BJ Freeman]

Note: this is using derby
I have the same code using postgresql but it also does not have the 
traffic that the demo has.


BJ Freeman sent the following on 7/19/2010 7:38 PM:

you forget the ofbiz demo-trunk also shut down many times
and that was in less than 24 hours for a few weeks
I don't know if the reason is stopped.


Scott Gray sent the following on 7/19/2010 7:30 PM:

I still don't see anything that indicates why OFBiz was stopped and
I've never heard a single bug report from anyone describing random
shutdowns. This really isn't the type of thing where you can play
guessing games and hope to come up with a solution.

Regards
Scott

On 20/07/2010, at 1:50 PM, BJ Freeman wrote:


from the apache logs you will see it was hitting ofbiz even after it
stopped.
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:24:31 -0700]
"GET /humanres/control/setSessionLocale?newLocale=no_NO_NY HTTP/1.1"
200 6525 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:24:49 -0700]
"GET
/humanres/control/setSessionTimeZone?tzId=Europe%2FCopenhagen&trail=
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:27:47 -0700]
"GET
/catalog/control/setSessionTimeZone?tzId=America%2FGrand_Turk&ProductKeywordsPanel_collapsed=false
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:27:57 -0700]
"GET /humanres/control/setSessionLocale?newLocale=de_DE HTTP/1.1" 503
448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:31:14 -0700]
"GET
/catalog/control/setSessionTimeZone?tzId=Atlantic%2FJan_Mayen&ProductBrowseCatalogsPanel_collapsed=false
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:31:24 -0700]
"GET /humanres/control/setSessionLocale?newLocale=en_PH HTTP/1.1" 503
448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:14 -0700]
"GET
/googlecheckout/control/setSessionTimeZone?tzId=Brazil%2FAcre&add-gc-configuration_collapsed=false
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:24 -0700]
"GET /marketing/control/checkLogin/main?tzId=Australia%2FDarwin
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:34 -0700]
"GET /partymgr/control/checkLogin/main?tzId=America%2FMonterrey
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:45 -0700]
"GET /humanres/control/checkLogin/main?newLocale=lv HTTP/1.1" 503 448
"-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:36:05 -0700]
"GET /googlebase/control/checkLogin/main?tzId=America%2FIqaluit
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:37:58 -0700]
"GET /humanres/control/setSessionLocale?newLocale=cs_CZ HTTP/1.1" 503
448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:38:11 -0700]
"GET
/humanres/control/setSessionTimeZone?tzId=Pacific%2FMarquesas&trail=
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:40:20 -0700]
"GET /facility/control/checkLogin/main?tzId=Pacific%2FGalapagos
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:41:20 -0700]
"GET /humanres/control/setSessionLocale?newLocale=es_GT HTTP/1.1" 503
448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:42:38 -0700]
"GET /marketing/control/checkLogin/main?tzId=America%2FMontreal
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:44:45 -0700]
"GET /humanres/control/setSessionLocale?newLocale=es_PY HTTP/1.1" 503
448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:44:55 -0700]
"GET /marketing/control/checkLogin/main?tzId=Europe%2FCopenhagen
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/20

Re: demo-trunk site dieing lead

[BJ Freeman]

you forget the ofbiz demo-trunk also shut down many times
and that was in less than 24 hours for a few weeks
I don't know if the reason is stopped.


Scott Gray sent the following on 7/19/2010 7:30 PM:

I still don't see anything that indicates why OFBiz was stopped and I've never 
heard a single bug report from anyone describing random shutdowns.  This really 
isn't the type of thing where you can play guessing games and hope to come up 
with a solution.

Regards
Scott

On 20/07/2010, at 1:50 PM, BJ Freeman wrote:


from the apache logs you will see it was hitting ofbiz even after it stopped.
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:24:31 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=no_NO_NY HTTP/1.1" 200 6525 "-" "Mozilla/5.0 
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:24:49 -0700] "GET 
/humanres/control/setSessionTimeZone?tzId=Europe%2FCopenhagen&trail= HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:27:47 -0700] "GET 
/catalog/control/setSessionTimeZone?tzId=America%2FGrand_Turk&ProductKeywordsPanel_collapsed=false 
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:27:57 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=de_DE HTTP/1.1" 503 448 "-" "Mozilla/5.0 
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:31:14 -0700] "GET 
/catalog/control/setSessionTimeZone?tzId=Atlantic%2FJan_Mayen&ProductBrowseCatalogsPanel_collapsed=false 
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:31:24 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=en_PH HTTP/1.1" 503 448 "-" "Mozilla/5.0 
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:14 -0700] "GET 
/googlecheckout/control/setSessionTimeZone?tzId=Brazil%2FAcre&add-gc-configuration_collapsed=false 
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:24 -0700] "GET 
/marketing/control/checkLogin/main?tzId=Australia%2FDarwin HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:34 -0700] "GET 
/partymgr/control/checkLogin/main?tzId=America%2FMonterrey HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:45 -0700] "GET 
/humanres/control/checkLogin/main?newLocale=lv HTTP/1.1" 503 448 "-" "Mozilla/5.0 
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:36:05 -0700] "GET 
/googlebase/control/checkLogin/main?tzId=America%2FIqaluit HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:37:58 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=cs_CZ HTTP/1.1" 503 448 "-" "Mozilla/5.0 
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:38:11 -0700] "GET 
/humanres/control/setSessionTimeZone?tzId=Pacific%2FMarquesas&trail= HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:40:20 -0700] "GET 
/facility/control/checkLogin/main?tzId=Pacific%2FGalapagos HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:41:20 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=es_GT HTTP/1.1" 503 448 "-" "Mozilla/5.0 
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:42:38 -0700] "GET 
/marketing/control/checkLogin/main?tzId=America%2FMontreal HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:44:45 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=es_PY HTTP/1.1" 503 448 "-" "Mozilla/5.0 
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:44:55 -0700] "GET 
/marketing/control/checkLogin/main?tzId=Europe%2FCopenhagen HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:46:53 -0700] "GET 
/humanres/control/setSessionTimeZone?tzId=America%2FGoose_Bay&trail= HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (com

Re: demo-trunk site dieing lead

[Scott Gray]

I still don't see anything that indicates why OFBiz was stopped and I've never 
heard a single bug report from anyone describing random shutdowns.  This really 
isn't the type of thing where you can play guessing games and hope to come up 
with a solution.

Regards
Scott

On 20/07/2010, at 1:50 PM, BJ Freeman wrote:

> from the apache logs you will see it was hitting ofbiz even after it stopped.
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:24:31 -0700] "GET 
> /humanres/control/setSessionLocale?newLocale=no_NO_NY HTTP/1.1" 200 6525 "-" 
> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:24:49 -0700] "GET 
> /humanres/control/setSessionTimeZone?tzId=Europe%2FCopenhagen&trail= 
> HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
> +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:27:47 -0700] "GET 
> /catalog/control/setSessionTimeZone?tzId=America%2FGrand_Turk&ProductKeywordsPanel_collapsed=false
>  HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
> +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:27:57 -0700] "GET 
> /humanres/control/setSessionLocale?newLocale=de_DE HTTP/1.1" 503 448 "-" 
> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:31:14 -0700] "GET 
> /catalog/control/setSessionTimeZone?tzId=Atlantic%2FJan_Mayen&ProductBrowseCatalogsPanel_collapsed=false
>  HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
> +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:31:24 -0700] "GET 
> /humanres/control/setSessionLocale?newLocale=en_PH HTTP/1.1" 503 448 "-" 
> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:14 -0700] "GET 
> /googlecheckout/control/setSessionTimeZone?tzId=Brazil%2FAcre&add-gc-configuration_collapsed=false
>  HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
> +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:24 -0700] "GET 
> /marketing/control/checkLogin/main?tzId=Australia%2FDarwin HTTP/1.1" 503 448 
> "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:34 -0700] "GET 
> /partymgr/control/checkLogin/main?tzId=America%2FMonterrey HTTP/1.1" 503 448 
> "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:45 -0700] "GET 
> /humanres/control/checkLogin/main?newLocale=lv HTTP/1.1" 503 448 "-" 
> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:36:05 -0700] "GET 
> /googlebase/control/checkLogin/main?tzId=America%2FIqaluit HTTP/1.1" 503 448 
> "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:37:58 -0700] "GET 
> /humanres/control/setSessionLocale?newLocale=cs_CZ HTTP/1.1" 503 448 "-" 
> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:38:11 -0700] "GET 
> /humanres/control/setSessionTimeZone?tzId=Pacific%2FMarquesas&trail= 
> HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
> +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:40:20 -0700] "GET 
> /facility/control/checkLogin/main?tzId=Pacific%2FGalapagos HTTP/1.1" 503 448 
> "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:41:20 -0700] "GET 
> /humanres/control/setSessionLocale?newLocale=es_GT HTTP/1.1" 503 448 "-" 
> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:42:38 -0700] "GET 
> /marketing/control/checkLogin/main?tzId=America%2FMontreal HTTP/1.1" 503 448 
> "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:44:45 -0700] "GET 
> /humanres/control/setSessionLocale?newLocale=es_PY HTTP/1.1" 503 448 "-" 
> "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:44:55 -0700] "GET 
> /marketing/control/checkLogin/main?tzId=Europe%2FCopenhagen HTTP/1.1" 503 448 
> "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
> crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:46:53 -0700] "GET 
> /humanres/control/setSessionTimeZone?tzId=America%2FGoose_Bay&trail= 
> HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
> +http://www.google.com/bot.html)"
> crawl-66-249-7

Re: demo-trunk site dieing lead

[BJ Freeman]

from the apache logs you will see it was hitting ofbiz even after it 
stopped.
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:24:31 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=no_NO_NY HTTP/1.1" 200 6525 
"-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:24:49 -0700] "GET 
/humanres/control/setSessionTimeZone?tzId=Europe%2FCopenhagen&trail= 
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:27:47 -0700] "GET 
/catalog/control/setSessionTimeZone?tzId=America%2FGrand_Turk&ProductKeywordsPanel_collapsed=false 
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:27:57 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=de_DE HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:31:14 -0700] "GET 
/catalog/control/setSessionTimeZone?tzId=Atlantic%2FJan_Mayen&ProductBrowseCatalogsPanel_collapsed=false 
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:31:24 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=en_PH HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:14 -0700] "GET 
/googlecheckout/control/setSessionTimeZone?tzId=Brazil%2FAcre&add-gc-configuration_collapsed=false 
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:24 -0700] "GET 
/marketing/control/checkLogin/main?tzId=Australia%2FDarwin HTTP/1.1" 503 
448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:34 -0700] "GET 
/partymgr/control/checkLogin/main?tzId=America%2FMonterrey HTTP/1.1" 503 
448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:34:45 -0700] "GET 
/humanres/control/checkLogin/main?newLocale=lv HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:36:05 -0700] "GET 
/googlebase/control/checkLogin/main?tzId=America%2FIqaluit HTTP/1.1" 503 
448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:37:58 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=cs_CZ HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:38:11 -0700] "GET 
/humanres/control/setSessionTimeZone?tzId=Pacific%2FMarquesas&trail= 
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:40:20 -0700] "GET 
/facility/control/checkLogin/main?tzId=Pacific%2FGalapagos HTTP/1.1" 503 
448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:41:20 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=es_GT HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:42:38 -0700] "GET 
/marketing/control/checkLogin/main?tzId=America%2FMontreal HTTP/1.1" 503 
448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:44:45 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=es_PY HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:44:55 -0700] "GET 
/marketing/control/checkLogin/main?tzId=Europe%2FCopenhagen HTTP/1.1" 
503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:46:53 -0700] "GET 
/humanres/control/setSessionTimeZone?tzId=America%2FGoose_Bay&trail= 
HTTP/1.1" 503 448 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 
+http://www.google.com/bot.html)"
crawl-66-249-71-66.googlebot.com - - [19/Jul/2010:13:48:03 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=fr_LU HTTP/1.1" 503 448 "-" 
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"


this is mimick in ofbiz logs right up till the shutdown.
66.249.71.66 - - [19/Jul/2010:13:14:26 -0700] "GET 
/humanres/control/setSessionLocale?newLocale=ar_IQ&trail= HTTP/1.1" 200 
6565 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; 

Re: demo-trunk site dieing lead

[Scott Gray]

That log is just reporting threads that some of the web apps started but failed 
to shutdown on their own, it is a new "feature" that came with Tomcat 6.

The log you've sent contains nothing of value and looks exactly the same as 
what I see every time I stop OFBiz.  You've got obviously got some mystery 
about why OFBiz was stopped but I don't think what you've given us is 
indicative of any problems and I've never seen OFBiz stop itself without first 
crashing with a lot of noise.

Regards
Scott

On 20/07/2010, at 1:07 PM, BJ Freeman wrote:

> from your reply I assume I am in an area of I don't know I don't know.
> but to forge forward blindly.
> at the time it died google was going through the backend
> it has been for the last two days the only user.
> when I saw the
> ExecutionPoolPulseWorker I figured a new thread was introduced based on a 
> schedule service.
> so I will restate that there was not a manual shutdown done from all the 
> server logs
> that something in ofbiz initiated the shutdown.
> 
> and apparently I don't know what might have caused it.
> 
> Scott Gray sent the following on 7/19/2010 5:45 PM:
>> That's just the log of a standard shutdown, where do you get the "service is 
>> run from webtools that shuts down the server" part of your statement?
>> 
>> Regards
>> Scott
>> 
>> HotWax Media
>> http://www.hotwaxmedia.com
>> 
>> On 20/07/2010, at 12:40 PM, BJ Freeman wrote:
>> 
>>> well a more direct cause of the demo-trunk dying is a service is run from 
>>> webtools that shuts down the server.
>>> 
>>> from ofbiz.log
>>> 2010-07-19 13:24:41,947 (OFBiz_Shutdown_Hook) [Container 
>>> Loader.java:113:INFO ] Shutting down containers
>>> 2010-07-19 13:24:42,008 (OFBiz_Shutdown_Hook) [ 
>>> Http11Protocol.java:236:INFO ] Stopping Coyote HTTP/1.1 on http-0.0.0.0-
>>> 2010-07-19 13:24:42,009 (OFBiz_Shutdown_Hook) [ 
>>> Http11Protocol.java:236:INFO ] Stopping Coyote HTTP/1.1 on http-0.0.0.0-
>>> 2010-07-19 13:24:42,093 (OFBiz_Shutdown_Hook) [ 
>>> ServiceDispatcher.java:191:INFO ] De-Registering dispatcher: oagismgr
>>> 2010-07-19 13:24:42,132 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [ExecutionPoolPulseWorker(0)] but has failed to stop 
>>> it. This is very likely to create a memory leak.
>>> 2010-07-19 13:24:42,133 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [ExecutionPoolPulseWorker(1)] but has failed to stop 
>>> it. This is very likely to create a memory leak.
>>> 
>>> 
>>> from error log
>>> 
>>> 2010-07-19 13:24:42,132 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [ExecutionPoolPulseWorker(0)] but has failed to stop 
>>> it. This is very likely to create a memory leak.
>>> 2010-07-19 13:24:42,133 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [ExecutionPoolPulseWorker(1)] but has failed to stop 
>>> it. This is very likely to create a memory leak.
>>> 2010-07-19 13:24:42,549 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [ReferenceCleaner] but has failed to stop it. This 
>>> is very likely to create a memory leak.
>>> 2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [TTLObject(0) pulse] but has failed to stop it. This 
>>> is very likely to create a memory leak.
>>> 2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [TTLObject(1) pulse] but has failed to stop it. This 
>>> is very likely to create a memory leak.
>>> 2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [ThreadPool-0] but has failed to stop it. This is 
>>> very likely to create a memory leak.
>>> 2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [ThreadPool-1] but has failed to stop it. This is 
>>> very likely to create a memory leak.
>>> 2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [ThreadPool-2] but has failed to stop it. This is 
>>> very likely to create a memory leak.
>>> 2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web application appears to have 
>>> started a thread named [ThreadPool-3] but has failed to stop it. This is 
>>> very likely to create a memory leak.
>>> 2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
>>> WebappClassLoader.java:1998:ERROR] A web applic

Re: demo-trunk site dieing lead

[BJ Freeman]

from your reply I assume I am in an area of I don't know I don't know.
but to forge forward blindly.
at the time it died google was going through the backend
it has been for the last two days the only user.
when I saw the
ExecutionPoolPulseWorker I figured a new thread was introduced based on 
a schedule service.
so I will restate that there was not a manual shutdown done from all the 
server logs

that something in ofbiz initiated the shutdown.

and apparently I don't know what might have caused it.

Scott Gray sent the following on 7/19/2010 5:45 PM:

That's just the log of a standard shutdown, where do you get the "service is run 
from webtools that shuts down the server" part of your statement?

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 20/07/2010, at 12:40 PM, BJ Freeman wrote:


well a more direct cause of the demo-trunk dying is a service is run from 
webtools that shuts down the server.

from ofbiz.log
2010-07-19 13:24:41,947 (OFBiz_Shutdown_Hook) [Container 
Loader.java:113:INFO ] Shutting down containers
2010-07-19 13:24:42,008 (OFBiz_Shutdown_Hook) [ Http11Protocol.java:236:INFO ] 
Stopping Coyote HTTP/1.1 on http-0.0.0.0-
2010-07-19 13:24:42,009 (OFBiz_Shutdown_Hook) [ Http11Protocol.java:236:INFO ] 
Stopping Coyote HTTP/1.1 on http-0.0.0.0-
2010-07-19 13:24:42,093 (OFBiz_Shutdown_Hook) [ ServiceDispatcher.java:191:INFO 
] De-Registering dispatcher: oagismgr
2010-07-19 13:24:42,132 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [ExecutionPoolPulseWorker(0)] but has failed to stop it. This is 
very likely to create a memory leak.
2010-07-19 13:24:42,133 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [ExecutionPoolPulseWorker(1)] but has failed to stop it. This is 
very likely to create a memory leak.


from error log

2010-07-19 13:24:42,132 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [ExecutionPoolPulseWorker(0)] but has failed to stop it. This is 
very likely to create a memory leak.
2010-07-19 13:24:42,133 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [ExecutionPoolPulseWorker(1)] but has failed to stop it. This is 
very likely to create a memory leak.
2010-07-19 13:24:42,549 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [ReferenceCleaner] but has failed to stop it. This is very likely 
to create a memory leak.
2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [TTLObject(0) pulse] but has failed to stop it. This is very 
likely to create a memory leak.
2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [TTLObject(1) pulse] but has failed to stop it. This is very 
likely to create a memory leak.
2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [ThreadPool-0] but has failed to stop it. This is very likely to 
create a memory leak.
2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [ThreadPool-1] but has failed to stop it. This is very likely to 
create a memory leak.
2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [ThreadPool-2] but has failed to stop it. This is very likely to 
create a memory leak.
2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [ThreadPool-3] but has failed to stop it. This is very likely to 
create a memory leak.
2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [TTLObject(async-update)-0] but has failed to stop it. This is 
very likely to create a memory leak.
2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [TTLObject(async-update)-1] but has failed to stop it. This is 
very likely to create a memory leak.
2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [TTLObject(async-update)-2] but has failed to stop it. This is 
very likely to create a memory leak.
2010-07-19 13:24:42,552 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have started a 
thread named [TTLObject(async-update)-3] but has failed to stop it. This is 
very likely to cr

Re: demo-trunk site dieing lead

[Scott Gray]

That's just the log of a standard shutdown, where do you get the "service is 
run from webtools that shuts down the server" part of your statement?

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 20/07/2010, at 12:40 PM, BJ Freeman wrote:

> well a more direct cause of the demo-trunk dying is a service is run from 
> webtools that shuts down the server.
> 
> from ofbiz.log
> 2010-07-19 13:24:41,947 (OFBiz_Shutdown_Hook) [Container 
> Loader.java:113:INFO ] Shutting down containers
> 2010-07-19 13:24:42,008 (OFBiz_Shutdown_Hook) [ Http11Protocol.java:236:INFO 
> ] Stopping Coyote HTTP/1.1 on http-0.0.0.0-
> 2010-07-19 13:24:42,009 (OFBiz_Shutdown_Hook) [ Http11Protocol.java:236:INFO 
> ] Stopping Coyote HTTP/1.1 on http-0.0.0.0-
> 2010-07-19 13:24:42,093 (OFBiz_Shutdown_Hook) [ 
> ServiceDispatcher.java:191:INFO ] De-Registering dispatcher: oagismgr
> 2010-07-19 13:24:42,132 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [ExecutionPoolPulseWorker(0)] but has failed to stop it. This 
> is very likely to create a memory leak.
> 2010-07-19 13:24:42,133 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [ExecutionPoolPulseWorker(1)] but has failed to stop it. This 
> is very likely to create a memory leak.
> 
> 
> from error log
> 
> 2010-07-19 13:24:42,132 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [ExecutionPoolPulseWorker(0)] but has failed to stop it. This 
> is very likely to create a memory leak.
> 2010-07-19 13:24:42,133 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [ExecutionPoolPulseWorker(1)] but has failed to stop it. This 
> is very likely to create a memory leak.
> 2010-07-19 13:24:42,549 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [ReferenceCleaner] but has failed to stop it. This is very 
> likely to create a memory leak.
> 2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [TTLObject(0) pulse] but has failed to stop it. This is very 
> likely to create a memory leak.
> 2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [TTLObject(1) pulse] but has failed to stop it. This is very 
> likely to create a memory leak.
> 2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [ThreadPool-0] but has failed to stop it. This is very likely 
> to create a memory leak.
> 2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [ThreadPool-1] but has failed to stop it. This is very likely 
> to create a memory leak.
> 2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [ThreadPool-2] but has failed to stop it. This is very likely 
> to create a memory leak.
> 2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [ThreadPool-3] but has failed to stop it. This is very likely 
> to create a memory leak.
> 2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [TTLObject(async-update)-0] but has failed to stop it. This is 
> very likely to create a memory leak.
> 2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [TTLObject(async-update)-1] but has failed to stop it. This is 
> very likely to create a memory leak.
> 2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [TTLObject(async-update)-2] but has failed to stop it. This is 
> very likely to create a memory leak.
> 2010-07-19 13:24:42,552 (OFBiz_Shutdown_Hook) [ 
> WebappClassLoader.java:1998:ERROR] A web application appears to have started 
> a thread named [TTLObject(async-update)-3] but has failed to stop it. This is 
> very likely to create a memory leak.
> 
> BJ Freeman sent the following on 7/15/2010 6:17 PM:
>> as I get time will go through about a  month worth of console logs
>> looking for when ofbiz lost connection to derby.
>> 
>> 
>> james_sg sent the following on 7/15/2010 6:08 PM:
>>> 
>>> It may be helpful to show some error log...
>>> 
>>> 
>>> BJ Freeman wrote:
 
 I been running the trunk as a demo-site and it finally

Re: demo-trunk site dieing lead

[BJ Freeman]

well a more direct cause of the demo-trunk dying is a service is run 
from webtools that shuts down the server.


from ofbiz.log
2010-07-19 13:24:41,947 (OFBiz_Shutdown_Hook) [Container 
Loader.java:113:INFO ] Shutting down containers
2010-07-19 13:24:42,008 (OFBiz_Shutdown_Hook) [ 
Http11Protocol.java:236:INFO ] Stopping Coyote HTTP/1.1 on http-0.0.0.0-
2010-07-19 13:24:42,009 (OFBiz_Shutdown_Hook) [ 
Http11Protocol.java:236:INFO ] Stopping Coyote HTTP/1.1 on http-0.0.0.0-
2010-07-19 13:24:42,093 (OFBiz_Shutdown_Hook) [ 
ServiceDispatcher.java:191:INFO ] De-Registering dispatcher: oagismgr
2010-07-19 13:24:42,132 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [ExecutionPoolPulseWorker(0)] but has failed to 
stop it. This is very likely to create a memory leak.
2010-07-19 13:24:42,133 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [ExecutionPoolPulseWorker(1)] but has failed to 
stop it. This is very likely to create a memory leak.



from error log

2010-07-19 13:24:42,132 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [ExecutionPoolPulseWorker(0)] but has failed to 
stop it. This is very likely to create a memory leak.
2010-07-19 13:24:42,133 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [ExecutionPoolPulseWorker(1)] but has failed to 
stop it. This is very likely to create a memory leak.
2010-07-19 13:24:42,549 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [ReferenceCleaner] but has failed to stop it. 
This is very likely to create a memory leak.
2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [TTLObject(0) pulse] but has failed to stop it. 
This is very likely to create a memory leak.
2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [TTLObject(1) pulse] but has failed to stop it. 
This is very likely to create a memory leak.
2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [ThreadPool-0] but has failed to stop it. This is 
very likely to create a memory leak.
2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [ThreadPool-1] but has failed to stop it. This is 
very likely to create a memory leak.
2010-07-19 13:24:42,550 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [ThreadPool-2] but has failed to stop it. This is 
very likely to create a memory leak.
2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [ThreadPool-3] but has failed to stop it. This is 
very likely to create a memory leak.
2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [TTLObject(async-update)-0] but has failed to 
stop it. This is very likely to create a memory leak.
2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [TTLObject(async-update)-1] but has failed to 
stop it. This is very likely to create a memory leak.
2010-07-19 13:24:42,551 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [TTLObject(async-update)-2] but has failed to 
stop it. This is very likely to create a memory leak.
2010-07-19 13:24:42,552 (OFBiz_Shutdown_Hook) [ 
WebappClassLoader.java:1998:ERROR] A web application appears to have 
started a thread named [TTLObject(async-update)-3] but has failed to 
stop it. This is very likely to create a memory leak.


BJ Freeman sent the following on 7/15/2010 6:17 PM:

as I get time will go through about a  month worth of console logs
looking for when ofbiz lost connection to derby.


james_sg sent the following on 7/15/2010 6:08 PM:


It may be helpful to show some error log...


BJ Freeman wrote:


I been running the trunk as a demo-site and it finally crashed.
I have not plowed through the logs to see the orgin of the error but it
lost its connection to derby.
getting a lot of can not connect errors.

=
BJ Freeman
Strategic Power Office with Supplier Automation

Specialtymarket.com
Systems Integrator-- Glad to Assist

Chat Y! messenger: bjfr3

Entity Engine: GenericDuplicateKeyException

[Deyan Tsvetanov]

Hi guys, 

there is a problem in entity engine which I would like to fix. 

Reproduction:

I am trying to create a party with a duplicate partyId. 

In general I thought I have to expect a GenericDuplicateKeyException. 

However the exception that I get is a regular GenericEntityException
with a nested GenericDateSourceException one with nested PSQLException
inside. The exception  message is: ERROR: duplicate key value violates
unique constraint "pk_party"

I believe it should be expected that a
GenericDuplicateKeyException will be thrown in case of a duplicate
primary key.



The solution for that would be to handle not only SQLException in
org.ofbiz.entity.jdbc.SQLProcessor 
but it's subclasses as well and throw the corresponding entity engine
exceptions. 

So the code: 

} catch (SQLException sqle) {
   throw new GenericDataSourceException("SQL Exception while
executing the following:" + sql, sqle);
}

would be changed to :


} catch ( SQLIntegrityConstraintViolationException icvEx ) {
   throw new GenericDuplicateKeyException( "Duplicate key exception
while executing the following: " + sql , icvEx );
} catch (SQLException sqle) {
   throw new GenericDataSourceException("SQL Exception while
executing the following:" + sql, sqle);
} 

on all occurances of catching a SQLException where insert or update is
executed. 

-- deyan 

Question on ofbiz seca

[Pradipta Ghosh]

Hi.
I am facing issues with atrribute result-map-name in my SECA definition

Listed below is the scenario i am trying to implement

Service definitions -














SECA definition -






The problem -
For each invocation of service "CA", same result map "result" remains the
same until & unless server is restarted. Is there any thing wrong with the
SECA definition ?

Also, Is there any way to set a field name as null in SECA set tags -
I've tried with  but this does not
set attribute1 to empty string

Thanks..

Re: Add created_by and updated_by to all tables ?

[BJ Freeman]

then if that ibnformaton is that important, should it not follow the 
changelog model for audit, like changeprice?


Deyan Tsvetanov sent the following on 7/19/2010 9:01 AM:

Well I don't agree.

A classic example of entities relation is party<- person.

One could update only the Person entity - change the lastName. So we
update updated_by field only of the Person entity.

One could update only the party entity - change the status - so we
update updated_by field only of the Party entity.

I actually can not think of a table / entity that might not need the two
fields.

Even if we take ENUMERATION_TYPE - it currently has created_stamp_tx and
updated_stamp_tx - why should it not have updated_by and created_by as
well ?

-- Deyan

On Mon, 2010-07-19 at 08:50 -0700, BJ Freeman wrote:

an entity has a relationship with another entity.
so if the main entity is updated those in the relationship will be tied
to the main entity and don't need the two fields.

yes those that are only updated by person should have the two fields, in
my opinion.

Deyan Tsvetanov sent the following on 7/19/2010 8:42 AM:

Many entities data is not created without a dependence on another one
so those should not need those two fields.


This one i didn't understand :)

In general data is being updated either by a person ( user or an
administrator or a consultant ) or by a process ( the system account ).






On Mon, 2010-07-19 at 08:29 -0700, BJ Freeman wrote:

there are many operations that are generated by the system levels, such
as status change. I can see the entities that are affected solely by
users having those fields.
I can see some being added but not every entity.
Many entities data is not created without a dependence on another one so
those should not need those two fields.


Deyan Tsvetanov sent the following on 7/19/2010 8:03 AM:

Hi guys,

another suggestion: to add 2 mandatory fields created_by and updated_by
to all tables by default like created_stamp and updated_stamp. Currently
there columns are added on demand in the entity definition but they are
often needed.

Examples of usage:
1)  status change - there is no created_by in the entity status table -
party_status.
In general customers would like to know who and when disabled the party
and who re-enabled it. The same applies to orders, invoices, etc.

2) Another example for using these 2 columns is entity lock. When an
EntityLockedException is thrown it would be nice to include the
userLoginId of the user who updated the record as well as the time so we
can notify the user:
"The record you are trying to save has been updated by Administrator,
The priviledged 5 minutes 32 secods ago. To cancel your request and
reload the changes click reload. To go ahead and overwrite the changes
done by Administrator click "Overwrite". "
Or so ...

3) Record based security - users could be allowed to modify records they
have created even without edit or admin permissions.

Therefore it would be very very helpful if these 2 columns are present
by default, even if they allow null values to preserve the current code
working.

-- deyan

Re: Entity Engine: GenericDuplicateKeyException

[Scott Gray]

Also worth noting is that a SQLIntegrityConstraintViolationException is not 
necessarily indicative of a duplicate primary key error, it could be also be a 
foreign or unique key violation.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 20/07/2010, at 1:46 AM, Adrian Crum wrote:

> PreparedStatement.execute throws SQLException:
> 
> http://download.oracle.com/docs/cd/E17409_01/javase/6/docs/api/java/sql/PreparedStatement.html#execute()
> 
> If a database vendor chooses to add meaning to that exception by using a 
> subclass of SQLException, then they are welcome to do so - but they are not 
> *required* to do so.
> 
> SQLIntegrityConstraintViolationException was added in Java 6. Any JDBC 
> drivers written before Java 6 will not use it.
> 
> -Adrian
> 
> --- On Mon, 7/19/10, Deyan Tsvetanov  wrote:
> 
>> From: Deyan Tsvetanov 
>> Subject: Re: Entity Engine: GenericDuplicateKeyException
>> To: user@ofbiz.apache.org
>> Date: Monday, July 19, 2010, 6:22 AM
>> The benefit here would be that
>> developers will not have to invoke
>> delegator.findOne() to check if a record with the same ID
>> exists before
>> trying create a new one. Saves one database call,
>> postresql, mysql,
>> oracle and mssql support it. If other databases or drivers
>> do not than
>> their drivers should not be labeled as JDBC compatible :)
>> 
>> Anyway if the code bellow will catch the SQLException and
>> re-throw
>> GenericEntityException if the current DB driver is buggy
>> and does not
>> throw SQLIntegrityConstraintViolationException.
>> 
>> -- Deyan 
>> 
>> On Mon, 2010-07-19 at 06:15 -0700, Adrian Crum wrote:
>>> I agree that better mapping of SQL exception causes
>> would be helpful in debugging and it could help in certain
>> algorithms. For example, testing for a primary key violation
>> could be used as an alternate way to get the next invoice
>> number.
>>> 
>>> The problem with using
>> SQLIntegrityConstraintViolationException is that not all
>> JDBC drivers will support it, so it might not get caught.
>>> 
>>> -Adrian
>>> 
>>> --- On Mon, 7/19/10, Deyan Tsvetanov 
>> wrote:
>>> 
 From: Deyan Tsvetanov 
 Subject: Entity Engine:
>> GenericDuplicateKeyException
 To: user@ofbiz.apache.org
 Date: Monday, July 19, 2010, 5:43 AM
 
 Hi guys, 
 
 there is a problem in entity engine which I would
>> like to
 fix. 
 
 Reproduction:
 
 I am trying to create a party with a duplicate
>> partyId. 
 
 In general I thought I have to expect a
 GenericDuplicateKeyException. 
 
 However the exception that I get is a regular
 GenericEntityException
 with a nested GenericDateSourceException one with
>> nested
 PSQLException
 inside. The exception  message is: ERROR:
>> duplicate
 key value violates
 unique constraint "pk_party"
 
 I believe it should be expected that a
 GenericDuplicateKeyException will be thrown in
>> case of a
 duplicate
 primary key.
 
 
 
 The solution for that would be to handle not
>> only
 SQLException in
>> org.ofbiz.entity.jdbc.SQLProcessor 
 but it's subclasses as well and throw the
>> corresponding
 entity engine exceptions. 
 
 So the code: 
 
 } catch (SQLException sqle) {
 throw
>> new
 GenericDataSourceException("SQL Exception while
>> executing
 the following:" + sql, sqle);
 }
 
 would be changed to :
 
 
 } catch (
>> SQLIntegrityConstraintViolationException icvEx )
 {
 throw new
>> GenericDuplicateKeyException(
 "Duplicate key exception while executing the
>> following: " +
 sql , icvEx );
 } catch (SQLException sqle) {
 throw
>> new
 GenericDataSourceException("SQL Exception while
>> executing
 the following:" + sql, sqle);
 } 
 
 on all occurances of catching a SQLException
>> where insert
 or update is executed. 
 
 -- deyan 
 
 
 
 
 
 
>>> 
>>> 
>>>
>> 
>> 
>> 
> 
> 
> 



smime.p7s
Description: S/MIME cryptographic signature

Re: PayPal Currency Issue

[BJ Freeman]

it helps if you include the complete thread
I don't know if you answered this yet.
what branch/release of ofbiz are you using.
if it is svn what version.


kaliagaurav sent the following on 7/19/2010 8:53 AM:


Hi BJ Freeman

I have also configured "GBP" in general.properties and i have configured
CurrencyUom to "GBP" in store setting where it say "Localisation"  but still
not working :(

Please suggest

Thanks

gaurav

set to NULL in SECAs

[varun bhansaly]

Hi,
I am implementing a scenario using SECAs, where in it would be required to
set a field to NULL or empty string.
Is it possible to set a field to NULL using the set tags of eca xmls.
I've tried with  but this does
not set attribute1 to empty string

-- 
Regards,
Varun Bhansaly

Re: Add created_by and updated_by to all tables ?

[Deyan Tsvetanov]

Well I don't agree. 

A classic example of entities relation is party <- person. 

One could update only the Person entity - change the lastName. So we
update updated_by field only of the Person entity. 

One could update only the party entity - change the status - so we
update updated_by field only of the Party entity. 

I actually can not think of a table / entity that might not need the two
fields. 

Even if we take ENUMERATION_TYPE - it currently has created_stamp_tx and
updated_stamp_tx - why should it not have updated_by and created_by as
well ?

-- Deyan 

On Mon, 2010-07-19 at 08:50 -0700, BJ Freeman wrote:
> an entity has a relationship with another entity.
> so if the main entity is updated those in the relationship will be tied 
> to the main entity and don't need the two fields.
> 
> yes those that are only updated by person should have the two fields, in 
> my opinion.
> 
> Deyan Tsvetanov sent the following on 7/19/2010 8:42 AM:
> >> Many entities data is not created without a dependence on another one
> >> so those should not need those two fields.
> >
> > This one i didn't understand :)
> >
> > In general data is being updated either by a person ( user or an
> > administrator or a consultant ) or by a process ( the system account ).
> >
> >
> >>
> >>
> > On Mon, 2010-07-19 at 08:29 -0700, BJ Freeman wrote:
> >> there are many operations that are generated by the system levels, such
> >> as status change. I can see the entities that are affected solely by
> >> users having those fields.
> >> I can see some being added but not every entity.
> >> Many entities data is not created without a dependence on another one so
> >> those should not need those two fields.
> >>
> >>
> >> Deyan Tsvetanov sent the following on 7/19/2010 8:03 AM:
> >>> Hi guys,
> >>>
> >>> another suggestion: to add 2 mandatory fields created_by and updated_by
> >>> to all tables by default like created_stamp and updated_stamp. Currently
> >>> there columns are added on demand in the entity definition but they are
> >>> often needed.
> >>>
> >>> Examples of usage:
> >>> 1)  status change - there is no created_by in the entity status table -
> >>> party_status.
> >>> In general customers would like to know who and when disabled the party
> >>> and who re-enabled it. The same applies to orders, invoices, etc.
> >>>
> >>> 2) Another example for using these 2 columns is entity lock. When an
> >>> EntityLockedException is thrown it would be nice to include the
> >>> userLoginId of the user who updated the record as well as the time so we
> >>> can notify the user:
> >>> "The record you are trying to save has been updated by Administrator,
> >>> The priviledged 5 minutes 32 secods ago. To cancel your request and
> >>> reload the changes click reload. To go ahead and overwrite the changes
> >>> done by Administrator click "Overwrite". "
> >>> Or so ...
> >>>
> >>> 3) Record based security - users could be allowed to modify records they
> >>> have created even without edit or admin permissions.
> >>>
> >>> Therefore it would be very very helpful if these 2 columns are present
> >>> by default, even if they allow null values to preserve the current code
> >>> working.
> >>>
> >>> -- deyan
> >>>
> >>>
> >>>
> >
> >
> >

Re: PayPal Currency Issue

[kaliagaurav]

Hi BJ Freeman

I have also configured "GBP" in general.properties and i have configured
CurrencyUom to "GBP" in store setting where it say "Localisation"  but still
not working :(

Please suggest

Thanks

gaurav
-- 
View this message in context: 
http://ofbiz.135035.n4.nabble.com/PayPal-Currency-Issue-tp2287192p2294236.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Add created_by and updated_by to all tables ?

[BJ Freeman]

an entity has a relationship with another entity.
so if the main entity is updated those in the relationship will be tied 
to the main entity and don't need the two fields.


yes those that are only updated by person should have the two fields, in 
my opinion.


Deyan Tsvetanov sent the following on 7/19/2010 8:42 AM:

Many entities data is not created without a dependence on another one
so those should not need those two fields.


This one i didn't understand :)

In general data is being updated either by a person ( user or an
administrator or a consultant ) or by a process ( the system account ).






On Mon, 2010-07-19 at 08:29 -0700, BJ Freeman wrote:

there are many operations that are generated by the system levels, such
as status change. I can see the entities that are affected solely by
users having those fields.
I can see some being added but not every entity.
Many entities data is not created without a dependence on another one so
those should not need those two fields.


Deyan Tsvetanov sent the following on 7/19/2010 8:03 AM:

Hi guys,

another suggestion: to add 2 mandatory fields created_by and updated_by
to all tables by default like created_stamp and updated_stamp. Currently
there columns are added on demand in the entity definition but they are
often needed.

Examples of usage:
1)  status change - there is no created_by in the entity status table -
party_status.
In general customers would like to know who and when disabled the party
and who re-enabled it. The same applies to orders, invoices, etc.

2) Another example for using these 2 columns is entity lock. When an
EntityLockedException is thrown it would be nice to include the
userLoginId of the user who updated the record as well as the time so we
can notify the user:
"The record you are trying to save has been updated by Administrator,
The priviledged 5 minutes 32 secods ago. To cancel your request and
reload the changes click reload. To go ahead and overwrite the changes
done by Administrator click "Overwrite". "
Or so ...

3) Record based security - users could be allowed to modify records they
have created even without edit or admin permissions.

Therefore it would be very very helpful if these 2 columns are present
by default, even if they allow null values to preserve the current code
working.

-- deyan

Re: Entity Engine: GenericDuplicateKeyException

[Deyan Tsvetanov]

ok , 

thanks :)

On Mon, 2010-07-19 at 08:27 -0700, Adrian Crum wrote:
> Then create a Jira issue and attach a patch.
> 
> We might need to support both specs by having them specified in the 
> entitytengine datasource element.
> 
> -Adrian
> 
> On 7/19/2010 8:19 AM, Deyan Tsvetanov wrote:
> > Right,
> >
> > before that we had to use the sql state to check the type of the
> > SQLException.
> >
> > Still sql state has 2 specs - xopen and sql2003 identifying the type of
> > the error. Entity Engine should support that level of abstraction and
> > throw the DuplicateKeyException.
> >
> > I am willing to implement it because I actually need it :)
> >
> >
> > -- deyan
> >
> > On Mon, 2010-07-19 at 06:46 -0700, Adrian Crum wrote:
> >> PreparedStatement.execute throws SQLException:
> >>
> >> http://download.oracle.com/docs/cd/E17409_01/javase/6/docs/api/java/sql/PreparedStatement.html#execute()
> >>
> >> If a database vendor chooses to add meaning to that exception by using a 
> >> subclass of SQLException, then they are welcome to do so - but they are 
> >> not *required* to do so.
> >>
> >> SQLIntegrityConstraintViolationException was added in Java 6. Any JDBC 
> >> drivers written before Java 6 will not use it.
> >>
> >> -Adrian
> >>
> >> --- On Mon, 7/19/10, Deyan Tsvetanov  wrote:
> >>
> >>> From: Deyan Tsvetanov
> >>> Subject: Re: Entity Engine: GenericDuplicateKeyException
> >>> To: user@ofbiz.apache.org
> >>> Date: Monday, July 19, 2010, 6:22 AM
> >>> The benefit here would be that
> >>> developers will not have to invoke
> >>> delegator.findOne() to check if a record with the same ID
> >>> exists before
> >>> trying create a new one. Saves one database call,
> >>> postresql, mysql,
> >>> oracle and mssql support it. If other databases or drivers
> >>> do not than
> >>> their drivers should not be labeled as JDBC compatible :)
> >>>
> >>> Anyway if the code bellow will catch the SQLException and
> >>> re-throw
> >>> GenericEntityException if the current DB driver is buggy
> >>> and does not
> >>> throw SQLIntegrityConstraintViolationException.
> >>>
> >>> -- Deyan
> >>>
> >>> On Mon, 2010-07-19 at 06:15 -0700, Adrian Crum wrote:
>  I agree that better mapping of SQL exception causes
> >>> would be helpful in debugging and it could help in certain
> >>> algorithms. For example, testing for a primary key violation
> >>> could be used as an alternate way to get the next invoice
> >>> number.
> 
>  The problem with using
> >>> SQLIntegrityConstraintViolationException is that not all
> >>> JDBC drivers will support it, so it might not get caught.
> 
>  -Adrian
> 
>  --- On Mon, 7/19/10, Deyan Tsvetanov
> >>> wrote:
> 
> > From: Deyan Tsvetanov
> > Subject: Entity Engine:
> >>> GenericDuplicateKeyException
> > To: user@ofbiz.apache.org
> > Date: Monday, July 19, 2010, 5:43 AM
> >
> > Hi guys,
> >
> > there is a problem in entity engine which I would
> >>> like to
> > fix.
> >
> > Reproduction:
> >
> > I am trying to create a party with a duplicate
> >>> partyId.
> >
> > In general I thought I have to expect a
> > GenericDuplicateKeyException.
> >
> > However the exception that I get is a regular
> > GenericEntityException
> > with a nested GenericDateSourceException one with
> >>> nested
> > PSQLException
> > inside. The exception  message is: ERROR:
> >>> duplicate
> > key value violates
> > unique constraint "pk_party"
> >
> > I believe it should be expected that a
> > GenericDuplicateKeyException will be thrown in
> >>> case of a
> > duplicate
> > primary key.
> >
> >
> >
> > The solution for that would be to handle not
> >>> only
> > SQLException in
> >>> org.ofbiz.entity.jdbc.SQLProcessor
> > but it's subclasses as well and throw the
> >>> corresponding
> > entity engine exceptions.
> >
> > So the code:
> >
> > } catch (SQLException sqle) {
> > throw
> >>> new
> > GenericDataSourceException("SQL Exception while
> >>> executing
> > the following:" + sql, sqle);
> > }
> >
> > would be changed to :
> >
> >
> > } catch (
> >>> SQLIntegrityConstraintViolationException icvEx )
> > {
> > throw new
> >>> GenericDuplicateKeyException(
> > "Duplicate key exception while executing the
> >>> following: " +
> > sql , icvEx );
> > } catch (SQLException sqle) {
> > throw
> >>> new
> > GenericDataSourceException("SQL Exception while
> >>> executing
> > the following:" + sql, sqle);
> > }
> >
> > on all occurances of catching a SQLException
> >>> where insert
> > or update is executed.
> >
> > -- deyan
> >
> >
> >
> >
> >
> >
> 
> 
> 
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >
> >
> >

Re: Add created_by and updated_by to all tables ?

[Deyan Tsvetanov]

> Many entities data is not created without a dependence on another one
> so those should not need those two fields.

This one i didn't understand :)

In general data is being updated either by a person ( user or an
administrator or a consultant ) or by a process ( the system account ). 


> 
> 
On Mon, 2010-07-19 at 08:29 -0700, BJ Freeman wrote:
> there are many operations that are generated by the system levels, such 
> as status change. I can see the entities that are affected solely by 
> users having those fields.
> I can see some being added but not every entity.
> Many entities data is not created without a dependence on another one so 
> those should not need those two fields.
> 
> 
> Deyan Tsvetanov sent the following on 7/19/2010 8:03 AM:
> > Hi guys,
> >
> > another suggestion: to add 2 mandatory fields created_by and updated_by
> > to all tables by default like created_stamp and updated_stamp. Currently
> > there columns are added on demand in the entity definition but they are
> > often needed.
> >
> > Examples of usage:
> > 1)  status change - there is no created_by in the entity status table -
> > party_status.
> > In general customers would like to know who and when disabled the party
> > and who re-enabled it. The same applies to orders, invoices, etc.
> >
> > 2) Another example for using these 2 columns is entity lock. When an
> > EntityLockedException is thrown it would be nice to include the
> > userLoginId of the user who updated the record as well as the time so we
> > can notify the user:
> > "The record you are trying to save has been updated by Administrator,
> > The priviledged 5 minutes 32 secods ago. To cancel your request and
> > reload the changes click reload. To go ahead and overwrite the changes
> > done by Administrator click "Overwrite". "
> > Or so ...
> >
> > 3) Record based security - users could be allowed to modify records they
> > have created even without edit or admin permissions.
> >
> > Therefore it would be very very helpful if these 2 columns are present
> > by default, even if they allow null values to preserve the current code
> > working.
> >
> > -- deyan
> >
> >
> >

Re: PayPal Currency Issue

[BJ Freeman]

looking at the code paypal currency is gotten from the cart.
the cart gets it from general.properties
"currency.uom.id.default"
which defaults to USD if none is set.


kaliagaurav sent the following on 7/19/2010 8:27 AM:


Hi All

I have checked the logs and in logs the currency getting passed to paypal is
USD instead of GBP and there is some reference to baseCurrencyUomId as well.

Please suggest

regards
Gaurav

Re: Add created_by and updated_by to all tables ?

[BJ Freeman]

there are many operations that are generated by the system levels, such 
as status change. I can see the entities that are affected solely by 
users having those fields.

I can see some being added but not every entity.
Many entities data is not created without a dependence on another one so 
those should not need those two fields.



Deyan Tsvetanov sent the following on 7/19/2010 8:03 AM:

Hi guys,

another suggestion: to add 2 mandatory fields created_by and updated_by
to all tables by default like created_stamp and updated_stamp. Currently
there columns are added on demand in the entity definition but they are
often needed.

Examples of usage:
1)  status change - there is no created_by in the entity status table -
party_status.
In general customers would like to know who and when disabled the party
and who re-enabled it. The same applies to orders, invoices, etc.

2) Another example for using these 2 columns is entity lock. When an
EntityLockedException is thrown it would be nice to include the
userLoginId of the user who updated the record as well as the time so we
can notify the user:
"The record you are trying to save has been updated by Administrator,
The priviledged 5 minutes 32 secods ago. To cancel your request and
reload the changes click reload. To go ahead and overwrite the changes
done by Administrator click "Overwrite". "
Or so ...

3) Record based security - users could be allowed to modify records they
have created even without edit or admin permissions.

Therefore it would be very very helpful if these 2 columns are present
by default, even if they allow null values to preserve the current code
working.

-- deyan

Re: Entity Engine: GenericDuplicateKeyException

[Adrian Crum]

Then create a Jira issue and attach a patch.

We might need to support both specs by having them specified in the 
entitytengine datasource element.


-Adrian

On 7/19/2010 8:19 AM, Deyan Tsvetanov wrote:

Right,

before that we had to use the sql state to check the type of the
SQLException.

Still sql state has 2 specs - xopen and sql2003 identifying the type of
the error. Entity Engine should support that level of abstraction and
throw the DuplicateKeyException.

I am willing to implement it because I actually need it :)


-- deyan

On Mon, 2010-07-19 at 06:46 -0700, Adrian Crum wrote:

PreparedStatement.execute throws SQLException:

http://download.oracle.com/docs/cd/E17409_01/javase/6/docs/api/java/sql/PreparedStatement.html#execute()

If a database vendor chooses to add meaning to that exception by using a 
subclass of SQLException, then they are welcome to do so - but they are not 
*required* to do so.

SQLIntegrityConstraintViolationException was added in Java 6. Any JDBC drivers 
written before Java 6 will not use it.

-Adrian

--- On Mon, 7/19/10, Deyan Tsvetanov  wrote:


From: Deyan Tsvetanov
Subject: Re: Entity Engine: GenericDuplicateKeyException
To: user@ofbiz.apache.org
Date: Monday, July 19, 2010, 6:22 AM
The benefit here would be that
developers will not have to invoke
delegator.findOne() to check if a record with the same ID
exists before
trying create a new one. Saves one database call,
postresql, mysql,
oracle and mssql support it. If other databases or drivers
do not than
their drivers should not be labeled as JDBC compatible :)

Anyway if the code bellow will catch the SQLException and
re-throw
GenericEntityException if the current DB driver is buggy
and does not
throw SQLIntegrityConstraintViolationException.

-- Deyan

On Mon, 2010-07-19 at 06:15 -0700, Adrian Crum wrote:

I agree that better mapping of SQL exception causes

would be helpful in debugging and it could help in certain
algorithms. For example, testing for a primary key violation
could be used as an alternate way to get the next invoice
number.


The problem with using

SQLIntegrityConstraintViolationException is that not all
JDBC drivers will support it, so it might not get caught.


-Adrian

--- On Mon, 7/19/10, Deyan Tsvetanov

wrote:



From: Deyan Tsvetanov
Subject: Entity Engine:

GenericDuplicateKeyException

To: user@ofbiz.apache.org
Date: Monday, July 19, 2010, 5:43 AM

Hi guys,

there is a problem in entity engine which I would

like to

fix.

Reproduction:

I am trying to create a party with a duplicate

partyId.


In general I thought I have to expect a
GenericDuplicateKeyException.

However the exception that I get is a regular
GenericEntityException
with a nested GenericDateSourceException one with

nested

PSQLException
inside. The exception  message is: ERROR:

duplicate

key value violates
unique constraint "pk_party"

I believe it should be expected that a
GenericDuplicateKeyException will be thrown in

case of a

duplicate
primary key.



The solution for that would be to handle not

only

SQLException in

org.ofbiz.entity.jdbc.SQLProcessor

but it's subclasses as well and throw the

corresponding

entity engine exceptions.

So the code:

} catch (SQLException sqle) {
throw

new

GenericDataSourceException("SQL Exception while

executing

the following:" + sql, sqle);
}

would be changed to :


} catch (

SQLIntegrityConstraintViolationException icvEx )

{
throw new

GenericDuplicateKeyException(

"Duplicate key exception while executing the

following: " +

sql , icvEx );
} catch (SQLException sqle) {
throw

new

GenericDataSourceException("SQL Exception while

executing

the following:" + sql, sqle);
}

on all occurances of catching a SQLException

where insert

or update is executed.

-- deyan

Re: PayPal Currency Issue

[kaliagaurav]

Hi All

I have checked the logs and in logs the currency getting passed to paypal is
USD instead of GBP and there is some reference to baseCurrencyUomId as well.

Please suggest

regards
Gaurav
-- 
View this message in context: 
http://ofbiz.135035.n4.nabble.com/PayPal-Currency-Issue-tp2287192p2294187.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Entity Engine: GenericDuplicateKeyException

[Deyan Tsvetanov]

Right, 

before that we had to use the sql state to check the type of the
SQLException. 

Still sql state has 2 specs - xopen and sql2003 identifying the type of
the error. Entity Engine should support that level of abstraction and
throw the DuplicateKeyException.

I am willing to implement it because I actually need it :)


-- deyan 

On Mon, 2010-07-19 at 06:46 -0700, Adrian Crum wrote:
> PreparedStatement.execute throws SQLException:
> 
> http://download.oracle.com/docs/cd/E17409_01/javase/6/docs/api/java/sql/PreparedStatement.html#execute()
> 
> If a database vendor chooses to add meaning to that exception by using a 
> subclass of SQLException, then they are welcome to do so - but they are not 
> *required* to do so.
> 
> SQLIntegrityConstraintViolationException was added in Java 6. Any JDBC 
> drivers written before Java 6 will not use it.
> 
> -Adrian
> 
> --- On Mon, 7/19/10, Deyan Tsvetanov  wrote:
> 
> > From: Deyan Tsvetanov 
> > Subject: Re: Entity Engine: GenericDuplicateKeyException
> > To: user@ofbiz.apache.org
> > Date: Monday, July 19, 2010, 6:22 AM
> > The benefit here would be that
> > developers will not have to invoke
> > delegator.findOne() to check if a record with the same ID
> > exists before
> > trying create a new one. Saves one database call,
> > postresql, mysql,
> > oracle and mssql support it. If other databases or drivers
> > do not than
> > their drivers should not be labeled as JDBC compatible :)
> > 
> > Anyway if the code bellow will catch the SQLException and
> > re-throw
> > GenericEntityException if the current DB driver is buggy
> > and does not
> > throw SQLIntegrityConstraintViolationException.
> > 
> > -- Deyan 
> > 
> > On Mon, 2010-07-19 at 06:15 -0700, Adrian Crum wrote:
> > > I agree that better mapping of SQL exception causes
> > would be helpful in debugging and it could help in certain
> > algorithms. For example, testing for a primary key violation
> > could be used as an alternate way to get the next invoice
> > number.
> > > 
> > > The problem with using
> > SQLIntegrityConstraintViolationException is that not all
> > JDBC drivers will support it, so it might not get caught.
> > > 
> > > -Adrian
> > > 
> > > --- On Mon, 7/19/10, Deyan Tsvetanov 
> > wrote:
> > > 
> > > > From: Deyan Tsvetanov 
> > > > Subject: Entity Engine:
> > GenericDuplicateKeyException
> > > > To: user@ofbiz.apache.org
> > > > Date: Monday, July 19, 2010, 5:43 AM
> > > > 
> > > > Hi guys, 
> > > > 
> > > > there is a problem in entity engine which I would
> > like to
> > > > fix. 
> > > > 
> > > > Reproduction:
> > > > 
> > > > I am trying to create a party with a duplicate
> > partyId. 
> > > > 
> > > > In general I thought I have to expect a
> > > > GenericDuplicateKeyException. 
> > > > 
> > > > However the exception that I get is a regular
> > > > GenericEntityException
> > > > with a nested GenericDateSourceException one with
> > nested
> > > > PSQLException
> > > > inside. The exception  message is: ERROR:
> > duplicate
> > > > key value violates
> > > > unique constraint "pk_party"
> > > > 
> > > > I believe it should be expected that a
> > > > GenericDuplicateKeyException will be thrown in
> > case of a
> > > > duplicate
> > > > primary key.
> > > > 
> > > > 
> > > > 
> > > > The solution for that would be to handle not
> > only
> > > > SQLException in
> > org.ofbiz.entity.jdbc.SQLProcessor 
> > > > but it's subclasses as well and throw the
> > corresponding
> > > > entity engine exceptions. 
> > > > 
> > > > So the code: 
> > > > 
> > > > } catch (SQLException sqle) {
> > > >throw
> > new
> > > > GenericDataSourceException("SQL Exception while
> > executing
> > > > the following:" + sql, sqle);
> > > > }
> > > > 
> > > > would be changed to :
> > > > 
> > > > 
> > > > } catch (
> > SQLIntegrityConstraintViolationException icvEx )
> > > > {
> > > >throw new
> > GenericDuplicateKeyException(
> > > > "Duplicate key exception while executing the
> > following: " +
> > > > sql , icvEx );
> > > > } catch (SQLException sqle) {
> > > >throw
> > new
> > > > GenericDataSourceException("SQL Exception while
> > executing
> > > > the following:" + sql, sqle);
> > > > } 
> > > > 
> > > > on all occurances of catching a SQLException
> > where insert
> > > > or update is executed. 
> > > > 
> > > > -- deyan 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > 
> > > 
> > >   
> > 
> > 
> > 
> 
> 
>   

query regarding SECAs

[varun bhansaly]

Hi,
I am facing issues with attribute "result-map-name" in my SECA definition

Listed below is the scenario i am trying to implement

Service definitions -














SECA definition -






The problem -
For each invocation of service "CA", same result map "result" remains the
same until & unless server is restarted. Is there any thing wrong with the
SECA definition ?

Also, Is there any way to set a field name as null in SECA set tags -

I've tried with  but this does not
set attribute1 to empty string

-- 
Regards,
Varun Bhansaly

Add created_by and updated_by to all tables ?

[Deyan Tsvetanov]

Hi guys, 

another suggestion: to add 2 mandatory fields created_by and updated_by
to all tables by default like created_stamp and updated_stamp. Currently
there columns are added on demand in the entity definition but they are
often needed. 

Examples of usage:
1)  status change - there is no created_by in the entity status table -
party_status. 
In general customers would like to know who and when disabled the party
and who re-enabled it. The same applies to orders, invoices, etc. 

2) Another example for using these 2 columns is entity lock. When an
EntityLockedException is thrown it would be nice to include the
userLoginId of the user who updated the record as well as the time so we
can notify the user: 
"The record you are trying to save has been updated by Administrator,
The priviledged 5 minutes 32 secods ago. To cancel your request and
reload the changes click reload. To go ahead and overwrite the changes
done by Administrator click "Overwrite". "
Or so ...

3) Record based security - users could be allowed to modify records they
have created even without edit or admin permissions. 

Therefore it would be very very helpful if these 2 columns are present
by default, even if they allow null values to preserve the current code
working. 

-- deyan 

Re: Entity Engine: GenericDuplicateKeyException

[Adrian Crum]

PreparedStatement.execute throws SQLException:

http://download.oracle.com/docs/cd/E17409_01/javase/6/docs/api/java/sql/PreparedStatement.html#execute()

If a database vendor chooses to add meaning to that exception by using a 
subclass of SQLException, then they are welcome to do so - but they are not 
*required* to do so.

SQLIntegrityConstraintViolationException was added in Java 6. Any JDBC drivers 
written before Java 6 will not use it.

-Adrian

--- On Mon, 7/19/10, Deyan Tsvetanov  wrote:

> From: Deyan Tsvetanov 
> Subject: Re: Entity Engine: GenericDuplicateKeyException
> To: user@ofbiz.apache.org
> Date: Monday, July 19, 2010, 6:22 AM
> The benefit here would be that
> developers will not have to invoke
> delegator.findOne() to check if a record with the same ID
> exists before
> trying create a new one. Saves one database call,
> postresql, mysql,
> oracle and mssql support it. If other databases or drivers
> do not than
> their drivers should not be labeled as JDBC compatible :)
> 
> Anyway if the code bellow will catch the SQLException and
> re-throw
> GenericEntityException if the current DB driver is buggy
> and does not
> throw SQLIntegrityConstraintViolationException.
> 
> -- Deyan 
> 
> On Mon, 2010-07-19 at 06:15 -0700, Adrian Crum wrote:
> > I agree that better mapping of SQL exception causes
> would be helpful in debugging and it could help in certain
> algorithms. For example, testing for a primary key violation
> could be used as an alternate way to get the next invoice
> number.
> > 
> > The problem with using
> SQLIntegrityConstraintViolationException is that not all
> JDBC drivers will support it, so it might not get caught.
> > 
> > -Adrian
> > 
> > --- On Mon, 7/19/10, Deyan Tsvetanov 
> wrote:
> > 
> > > From: Deyan Tsvetanov 
> > > Subject: Entity Engine:
> GenericDuplicateKeyException
> > > To: user@ofbiz.apache.org
> > > Date: Monday, July 19, 2010, 5:43 AM
> > > 
> > > Hi guys, 
> > > 
> > > there is a problem in entity engine which I would
> like to
> > > fix. 
> > > 
> > > Reproduction:
> > > 
> > > I am trying to create a party with a duplicate
> partyId. 
> > > 
> > > In general I thought I have to expect a
> > > GenericDuplicateKeyException. 
> > > 
> > > However the exception that I get is a regular
> > > GenericEntityException
> > > with a nested GenericDateSourceException one with
> nested
> > > PSQLException
> > > inside. The exception  message is: ERROR:
> duplicate
> > > key value violates
> > > unique constraint "pk_party"
> > > 
> > > I believe it should be expected that a
> > > GenericDuplicateKeyException will be thrown in
> case of a
> > > duplicate
> > > primary key.
> > > 
> > > 
> > > 
> > > The solution for that would be to handle not
> only
> > > SQLException in
> org.ofbiz.entity.jdbc.SQLProcessor 
> > > but it's subclasses as well and throw the
> corresponding
> > > entity engine exceptions. 
> > > 
> > > So the code: 
> > > 
> > > } catch (SQLException sqle) {
> > >            throw
> new
> > > GenericDataSourceException("SQL Exception while
> executing
> > > the following:" + sql, sqle);
> > > }
> > > 
> > > would be changed to :
> > > 
> > > 
> > > } catch (
> SQLIntegrityConstraintViolationException icvEx )
> > > {
> > >    throw new
> GenericDuplicateKeyException(
> > > "Duplicate key exception while executing the
> following: " +
> > > sql , icvEx );
> > > } catch (SQLException sqle) {
> > >            throw
> new
> > > GenericDataSourceException("SQL Exception while
> executing
> > > the following:" + sql, sqle);
> > > } 
> > > 
> > > on all occurances of catching a SQLException
> where insert
> > > or update is executed. 
> > > 
> > > -- deyan 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > 
> > 
> >       
> 
> 
> 

Re: Entity Engine: GenericDuplicateKeyException

[Deyan Tsvetanov]

The benefit here would be that developers will not have to invoke
delegator.findOne() to check if a record with the same ID exists before
trying create a new one. Saves one database call, postresql, mysql,
oracle and mssql support it. If other databases or drivers do not than
their drivers should not be labeled as JDBC compatible :)

Anyway if the code bellow will catch the SQLException and re-throw
GenericEntityException if the current DB driver is buggy and does not
throw SQLIntegrityConstraintViolationException.

-- Deyan 

On Mon, 2010-07-19 at 06:15 -0700, Adrian Crum wrote:
> I agree that better mapping of SQL exception causes would be helpful in 
> debugging and it could help in certain algorithms. For example, testing for a 
> primary key violation could be used as an alternate way to get the next 
> invoice number.
> 
> The problem with using SQLIntegrityConstraintViolationException is that not 
> all JDBC drivers will support it, so it might not get caught.
> 
> -Adrian
> 
> --- On Mon, 7/19/10, Deyan Tsvetanov  wrote:
> 
> > From: Deyan Tsvetanov 
> > Subject: Entity Engine: GenericDuplicateKeyException
> > To: user@ofbiz.apache.org
> > Date: Monday, July 19, 2010, 5:43 AM
> > 
> > Hi guys, 
> > 
> > there is a problem in entity engine which I would like to
> > fix. 
> > 
> > Reproduction:
> > 
> > I am trying to create a party with a duplicate partyId. 
> > 
> > In general I thought I have to expect a
> > GenericDuplicateKeyException. 
> > 
> > However the exception that I get is a regular
> > GenericEntityException
> > with a nested GenericDateSourceException one with nested
> > PSQLException
> > inside. The exception  message is: ERROR: duplicate
> > key value violates
> > unique constraint "pk_party"
> > 
> > I believe it should be expected that a
> > GenericDuplicateKeyException will be thrown in case of a
> > duplicate
> > primary key.
> > 
> > 
> > 
> > The solution for that would be to handle not only
> > SQLException in org.ofbiz.entity.jdbc.SQLProcessor 
> > but it's subclasses as well and throw the corresponding
> > entity engine exceptions. 
> > 
> > So the code: 
> > 
> > } catch (SQLException sqle) {
> >throw new
> > GenericDataSourceException("SQL Exception while executing
> > the following:" + sql, sqle);
> > }
> > 
> > would be changed to :
> > 
> > 
> > } catch ( SQLIntegrityConstraintViolationException icvEx )
> > {
> >throw new GenericDuplicateKeyException(
> > "Duplicate key exception while executing the following: " +
> > sql , icvEx );
> > } catch (SQLException sqle) {
> >throw new
> > GenericDataSourceException("SQL Exception while executing
> > the following:" + sql, sqle);
> > } 
> > 
> > on all occurances of catching a SQLException where insert
> > or update is executed. 
> > 
> > -- deyan 
> > 
> > 
> > 
> > 
> > 
> > 
> 
> 
>   

Re: Entity Engine: GenericDuplicateKeyException

[Deyan Tsvetanov]

Do you know a certain jdbc driver which does not support it ?

-- deyan

On Mon, 2010-07-19 at 06:15 -0700, Adrian Crum wrote:
> I agree that better mapping of SQL exception causes would be helpful in 
> debugging and it could help in certain algorithms. For example, testing for a 
> primary key violation could be used as an alternate way to get the next 
> invoice number.
> 
> The problem with using SQLIntegrityConstraintViolationException is that not 
> all JDBC drivers will support it, so it might not get caught.
> 
> -Adrian
> 
> --- On Mon, 7/19/10, Deyan Tsvetanov  wrote:
> 
> > From: Deyan Tsvetanov 
> > Subject: Entity Engine: GenericDuplicateKeyException
> > To: user@ofbiz.apache.org
> > Date: Monday, July 19, 2010, 5:43 AM
> > 
> > Hi guys, 
> > 
> > there is a problem in entity engine which I would like to
> > fix. 
> > 
> > Reproduction:
> > 
> > I am trying to create a party with a duplicate partyId. 
> > 
> > In general I thought I have to expect a
> > GenericDuplicateKeyException. 
> > 
> > However the exception that I get is a regular
> > GenericEntityException
> > with a nested GenericDateSourceException one with nested
> > PSQLException
> > inside. The exception  message is: ERROR: duplicate
> > key value violates
> > unique constraint "pk_party"
> > 
> > I believe it should be expected that a
> > GenericDuplicateKeyException will be thrown in case of a
> > duplicate
> > primary key.
> > 
> > 
> > 
> > The solution for that would be to handle not only
> > SQLException in org.ofbiz.entity.jdbc.SQLProcessor 
> > but it's subclasses as well and throw the corresponding
> > entity engine exceptions. 
> > 
> > So the code: 
> > 
> > } catch (SQLException sqle) {
> >throw new
> > GenericDataSourceException("SQL Exception while executing
> > the following:" + sql, sqle);
> > }
> > 
> > would be changed to :
> > 
> > 
> > } catch ( SQLIntegrityConstraintViolationException icvEx )
> > {
> >throw new GenericDuplicateKeyException(
> > "Duplicate key exception while executing the following: " +
> > sql , icvEx );
> > } catch (SQLException sqle) {
> >throw new
> > GenericDataSourceException("SQL Exception while executing
> > the following:" + sql, sqle);
> > } 
> > 
> > on all occurances of catching a SQLException where insert
> > or update is executed. 
> > 
> > -- deyan 
> > 
> > 
> > 
> > 
> > 
> > 
> 
> 
>   

Re: Entity Engine: GenericDuplicateKeyException

[Adrian Crum]

I agree that better mapping of SQL exception causes would be helpful in 
debugging and it could help in certain algorithms. For example, testing for a 
primary key violation could be used as an alternate way to get the next invoice 
number.

The problem with using SQLIntegrityConstraintViolationException is that not all 
JDBC drivers will support it, so it might not get caught.

-Adrian

--- On Mon, 7/19/10, Deyan Tsvetanov  wrote:

> From: Deyan Tsvetanov 
> Subject: Entity Engine: GenericDuplicateKeyException
> To: user@ofbiz.apache.org
> Date: Monday, July 19, 2010, 5:43 AM
> 
> Hi guys, 
> 
> there is a problem in entity engine which I would like to
> fix. 
> 
> Reproduction:
> 
> I am trying to create a party with a duplicate partyId. 
> 
> In general I thought I have to expect a
> GenericDuplicateKeyException. 
> 
> However the exception that I get is a regular
> GenericEntityException
> with a nested GenericDateSourceException one with nested
> PSQLException
> inside. The exception  message is: ERROR: duplicate
> key value violates
> unique constraint "pk_party"
> 
> I believe it should be expected that a
> GenericDuplicateKeyException will be thrown in case of a
> duplicate
> primary key.
> 
> 
> 
> The solution for that would be to handle not only
> SQLException in org.ofbiz.entity.jdbc.SQLProcessor 
> but it's subclasses as well and throw the corresponding
> entity engine exceptions. 
> 
> So the code: 
> 
> } catch (SQLException sqle) {
>            throw new
> GenericDataSourceException("SQL Exception while executing
> the following:" + sql, sqle);
> }
> 
> would be changed to :
> 
> 
> } catch ( SQLIntegrityConstraintViolationException icvEx )
> {
>    throw new GenericDuplicateKeyException(
> "Duplicate key exception while executing the following: " +
> sql , icvEx );
> } catch (SQLException sqle) {
>            throw new
> GenericDataSourceException("SQL Exception while executing
> the following:" + sql, sqle);
> } 
> 
> on all occurances of catching a SQLException where insert
> or update is executed. 
> 
> -- deyan 
> 
> 
> 
> 
> 
> 

Entity Engine: GenericDuplicateKeyException

[Deyan Tsvetanov]

Hi guys, 

there is a problem in entity engine which I would like to fix. 

Reproduction:

I am trying to create a party with a duplicate partyId. 

In general I thought I have to expect a GenericDuplicateKeyException. 

However the exception that I get is a regular GenericEntityException
with a nested GenericDateSourceException one with nested PSQLException
inside. The exception  message is: ERROR: duplicate key value violates
unique constraint "pk_party"

I believe it should be expected that a
GenericDuplicateKeyException will be thrown in case of a duplicate
primary key.



The solution for that would be to handle not only SQLException in 
org.ofbiz.entity.jdbc.SQLProcessor 
but it's subclasses as well and throw the corresponding entity engine 
exceptions. 

So the code: 

} catch (SQLException sqle) {
   throw new GenericDataSourceException("SQL Exception while executing 
the following:" + sql, sqle);
}

would be changed to :


} catch ( SQLIntegrityConstraintViolationException icvEx ) {
   throw new GenericDuplicateKeyException( "Duplicate key exception while 
executing the following: " + sql , icvEx );
} catch (SQLException sqle) {
   throw new GenericDataSourceException("SQL Exception while executing 
the following:" + sql, sqle);
} 

on all occurances of catching a SQLException where insert or update is 
executed. 

-- deyan 

query on SECA definition

[varun bhansaly]

Hi,
I am facing issues with attribute "result-map-name" in my SECA definition

Listed below is the scenario i am trying to implement

Service definitions -














SECA definition -






The problem -
For each invocation of service "CA", same result map "result" remains the
same until & unless server is restarted. Is there any thing wrong with the
SECA definition ?

Also, Is there any way to set a field name as null in SECA set tags -

I've tried with  but this does not
set attribute1 to empty string

-- 
Regards,
Varun Bhansaly

Internationalization of product images?

[Alexander Kahl]

Hi,
Is it possible to internationalize the images associated to a product
like it is possible for other content like description, name, ...? I
have tried to find a possibility in the database but couldn't figure
out how to do this.

Thank's for any answers
Alexander Kahl


-- 
Alexander Kahl * Software Consultant * alexander.k...@tngtech.com
TNG Technology Consulting GmbH, Betastr. 13a, 85774 Unterföhring
Geschäftsführer: Henrik Klagges, Gerhard Müller, Christoph Stock Amtsgericht 
München, HRB 135082