Re: How to print SQL statement execute by Delegator

Hi, Checking GenericDAO.java out, could find sql sentences there. Cheers, Rise 2012/7/30 李明洋 > Hello everybody: > Is there an option to print SQL statement executed by Delegator for debug ? > > > thanks >

OFBiz theme reused by other Apache project s:o)

Hi, Paul Piper from ilScipio just told me that other Apache projects are reusing the OFBiz theme Kudos to the authors! At least http://mahout.apache.org/ BTW, I'd be interest to know if other Apache projects are using it Thanks Jacques

Re: OFBiz theme reused by other Apache project s:o)

lucene too http://lucene.apache.org 2012/8/10 Jacques Le Roux : > Hi, > > Paul Piper from ilScipio just told me that other Apache projects are reusing > the OFBiz theme > Kudos to the authors! > > At least http://mahout.apache.org/ > > BTW, I'd be interest to know if other Apache projects are usin

Re: How to print SQL statement execute by Delegator

That's it Jacques Rise wrote: Hi, Checking GenericDAO.java out, could find sql sentences there. Cheers, Rise 2012/7/30 李明洋 Hello everybody: Is there an option to print SQL statement executed by Delegator for debug ? thanks

Re: Auto Set unique.instanceId

Thanks for the tips. Scott I never knew that the jobs worked that way. The use case I am working towards is where I can scale up and down the amount of OFBiz application servers running depending on load i.e. number of visitors on the website and I was trying to totally automate the scaling pr

Re: ant build fail

Hi Ashutosh, This error might be occurring because of 'bsf jar'.Look into you ofbiz/framework/base/lib/scripting folder. If not present put this jar into scripting folder. You can download this jar from following link: http://www.java2s.com/Code/Jar/b/Downloadbsfjar.htm Regards Mayank Sheth

Re: Inventory QOH/ATP always 0

Hi, Sorry I forgot to mention that I'm using 10.04.02. It looks kind of similar to: http://markmail.org/message/lnyki6w2vmrmhgup http://markmail.org/message/ldbyr5sm5jpthcea I compared the patch from that mentioned thread to the 10.04.02, as far as I can tell, the changes are included in 10.04.

Re: Inventory QOH/ATP always 0

Just curious. Have you tried the 10.04.02 version with just "cache=false"? On Fri, Aug 10, 2012 at 9:14 AM, Leonard Lin wrote: > Hi, > > Sorry I forgot to mention that I'm using 10.04.02. > It looks kind of similar to: > http://markmail.org/message/**lnyki6w2vmrmhgup

Re: Inventory QOH/ATP always 0

I have hardcoded the line like this: list="inventoryItems" use-iterator="true" use-cache="false"/> no change after restart, flushed cache. Is it maybe a db thing? I use on the 10.04.02 version mysql for the trunk I use derby. On 8/10/2012 09:20, Mike wrote: Just curious. Have you tried the 1

Re: Inventory QOH/ATP always 0

I changed my 10.04.02 version to back to derby and see there the inventory shows up correctly. I'm using MySQL 5.5 on Windows with latest java connector 5.1.21.jar are there any known configuration issues with MySQL that may lead to this problem? On 8/10/2012 09:34, Leonard Lin wrote: I hav

Re: Auto Set unique.instanceId

From: "Sam Hamilton" Thanks for the tips. Scott I never knew that the jobs worked that way. Most things depends on DB in OFBiz, so are jobs. They are picked from DB to be run. The use case I am working towards is where I can scale up and down the amount of OFBiz application servers runnin

Re: Auto Set unique.instanceId

On 8/10/2012 7:33 PM, Jacques Le Roux wrote: From: "Sam Hamilton" Thanks for the tips. Scott I never knew that the jobs worked that way. Most things depends on DB in OFBiz, so are jobs. They are picked from DB to be run. The use case I am working towards is where I can scale up and down

Re: Inventory QOH/ATP always 0

Not sure about it, but could related to MySQL 5.5 see http://markmail.org/message/r27vavebgy3rnp2s http://markmail.org/message/4be7wsehyxpddnrv You can find more using http://ofbiz.markmail.org/search/?q=MySQL+milliseconds Jacques From: "Leonard Lin" I changed my 10.04.02 version to back to d

Re: Inventory QOH/ATP always 0

Thanks for the hint. I just checked. -I'm not getting any sql exception -timestamp is not part of the key in inventory_item however it might be query relying on getting only 1 item. - Just to make sure I installed Mysql 5.6, unfortunately it didn't help. I'm thinking it is a writing issue of col

Re: Inventory QOH/ATP always 0

Hi Leonard: It doesn't have to be part of the primary-key to be a problem. If your query includes any Timestamp fields, it could fail to retrieve the correct values. For example, if the query is searching on INVENTORY_ITEM.expireDate, (which is a Timestamp field) it could fail to find the corr