Re: Apachecon EU 2012

2012-06-21 Thread Christian Geisert
Pierre Smits schrieb: Dear All, ApacheCON EU 2012 will be held in Sinsheim , Germany on November, 5th till 9th. I was wondering if there intentions to participate and/or hold some presentations or get-togethers. As I'm living less than 100 km away from the location I'll be there (if time

Re: Deal product / promotion for a time period with counddown timer

2012-06-21 Thread Robert G.
btw. I tried to define a price rule for a product, but I cannot see the price change in my webstore. I use Euro currency, but I also try to applie this rule to the currency and the product, still the standard price visible. Do you know anything about that? Thanks :) -- View this message in

Re: How to include ftl from another module using a variable?

2012-06-21 Thread Atul Vani
Try this #include StringUtil.wrapString(myTemplate) Thanks Regards Atul Vani Enterprise Software Developer HotWax Media Pvt. Ltd. http://www.hotwaxmedia.com/ We are the Global Leaders in Apache OFBiz, Google 'ofbiz' and see for yourself. On 06/21/2012 01:28 AM, Colin Rooney wrote: hint: look

Ilscipio - still hiring

2012-06-21 Thread Paul Piper
Hello guys, A few months ago we asked for OFBiz experts to join our small but growing eCommerce Agency team. Fortunately today we’re again in the position to hire additional team members. So we are on the lookout for new developers for permanent employment and freelancers as well to meet the

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
What are the java memory settings for starting OFBiz? Mine: JAVA_VMOPTIONS=-Xms1280M -Xmx1524M -server -Xincgc On Thu, Jun 21, 2012 at 8:14 AM, Deepak Agarwal dagarwa...@gmail.comwrote: We are expereicing frequent table locks for Shipping table , visit and server_hit table. Even with 3-4

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
-Xms2048M -Xmx2048M -XX:MaxPermSize=1024m -server On Thu, Jun 21, 2012 at 9:03 PM, Mike mz4whee...@gmail.com wrote: What are the java memory settings for starting OFBiz? Mine: JAVA_VMOPTIONS=-Xms1280M -Xmx1524M -server -Xincgc On Thu, Jun 21, 2012 at 8:14 AM, Deepak Agarwal

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
What does the Memory Total line say on the WebToosl/Cache Maintenance menu? On Thu, Jun 21, 2012 at 8:38 AM, Deepak Agarwal dagarwa...@gmail.comwrote: -Xms2048M -Xmx2048M -XX:MaxPermSize=1024m -server On Thu, Jun 21, 2012 at 9:03 PM, Mike mz4whee...@gmail.com wrote: What are the java

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Memory and CPU remain good. memory hardly reaches 1 GB and cpu few percentage. On Thu, Jun 21, 2012 at 9:14 PM, Mike mz4whee...@gmail.com wrote: What does the Memory Total line say on the WebToosl/Cache Maintenance menu? On Thu, Jun 21, 2012 at 8:38 AM, Deepak Agarwal dagarwa...@gmail.com

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
Sounds like classic garbage collection. Java freezes while it sifts through memory looking for stuff to delete. The larger the memory, the longer it takes. -Xms2048M -Xmx2048M -server -Xincgc Try the above. The -Xincgc will continuously GC on a separate, slow running thread. Also, run a

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Adrian Crum
That might have been true for JRE 1.4, but newer versions have multi-generation garbage collectors that seldom cause program pauses. It sounds to me like there is a problem in the connection pool or in the database itself. -Adrian On 6/21/2012 4:52 PM, Mike wrote: Sounds like classic

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
Take a look at visit, server_hit, and communication_event tables. select count(*) from visit; select count(*) from server_hit; select count(*) from communication_event; What do yo get? On Thu, Jun 21, 2012 at 9:02 AM, Deepak Agarwal dagarwa...@gmail.comwrote: Alright. I will try this.

Re: Extract parameters from external call

2012-06-21 Thread bhargav.tri
Thanks for the reply Raj. I was under the same impression and I was not able to fetch the parameters using getparameter. But I was able to retrieve them using the Utility class (UtilHttp). That was helpful. Thank you, Bhargav -- View this message in context:

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
visit: 7400 server_hit: 94000 communication_event: 51 On Thu, Jun 21, 2012 at 10:44 PM, Mike mz4whee...@gmail.com wrote: Take a look at visit, server_hit, and communication_event tables. select count(*) from visit; select count(*) from server_hit; select count(*) from communication_event;

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
Here is what I would do: Update framework/webapp/config/serverstats.properties stats.persist.visit=false stats.persist.visitor=false I have ALL of the 'stats' set to 'false'. Restart ofbiz, and blow away the contents of server_hit and optionally visit: delete from server_hit; delete from

Re: Has anyone implemented Faceted Search using SOLR?

2012-06-21 Thread Sanjeev Gupta
Hi Rajbir, I spent a couple of days trying to play around with the approach you recommended but couldn't get it to work for me. So finally gave it up. Will probably wait for someone to contribute the feature to the trunk. - Rgds Sanjeev www.sanjeevg.com @sanjeevgcom -- View this message

Ofbiz with MySQL or PostgreSQL

2012-06-21 Thread Sanjeev Gupta
I'm looking to decide on the database to be used with OfBiz in the production environment. Any thoughts on which database works well with Ofbiz - MySQL or PostgreSQL and why ? - Rgds Sanjeev www.sanjeevg.com @sanjeevgcom -- View this message in context:

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
I actually did that. But, now I am facing issue while quickly removing/adding items from/to shopping cart. May be I need to look database closely. On Thu, Jun 21, 2012 at 11:32 PM, Mike mz4whee...@gmail.com wrote: Here is what I would do: Update framework/webapp/config/serverstats.properties

Re: Ofbiz with MySQL or PostgreSQL

2012-06-21 Thread Ruth Hoffman
Hi Sanjeev: If you use MySQL in its current state, be aware of Timestamp truncation. Since OFBiz uses timestamps in many places as part of a primary-key, you can (and do) loose precision and ultimately you may not be able to find records. You may not even know this is happening until it is too

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
Postgresql/mysql? On Thu, Jun 21, 2012 at 12:04 PM, Deepak Agarwal dagarwa...@gmail.comwrote: I actually did that. But, now I am facing issue while quickly removing/adding items from/to shopping cart. May be I need to look database closely. On Thu, Jun 21, 2012 at 11:32 PM, Mike

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
mysql latest version. On Fri, Jun 22, 2012 at 1:18 AM, Mike mz4whee...@gmail.com wrote: Postgresql/mysql? On Thu, Jun 21, 2012 at 12:04 PM, Deepak Agarwal dagarwa...@gmail.com wrote: I actually did that. But, now I am facing issue while quickly removing/adding items from/to shopping

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Latest mysql with timestamp truncation problem. On Fri, Jun 22, 2012 at 1:31 AM, Deepak Agarwal dagarwa...@gmail.comwrote: mysql latest version. On Fri, Jun 22, 2012 at 1:18 AM, Mike mz4whee...@gmail.com wrote: Postgresql/mysql? On Thu, Jun 21, 2012 at 12:04 PM, Deepak Agarwal

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
Have you tried the mysql tuning primer script? https://launchpad.net/mysql-tuning-primer Download, execute, and double any recommendations. On Thu, Jun 21, 2012 at 1:06 PM, Deepak Agarwal dagarwa...@gmail.comwrote: Latest mysql with timestamp truncation problem. On Fri, Jun 22, 2012 at

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Yes. All set. On Fri, Jun 22, 2012 at 2:21 AM, Mike mz4whee...@gmail.com wrote: Have you tried the mysql tuning primer script? https://launchpad.net/mysql-tuning-primer Download, execute, and double any recommendations. On Thu, Jun 21, 2012 at 1:06 PM, Deepak Agarwal dagarwa...@gmail.com

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Will run it again. Had done it before getting load on mysql. On Fri, Jun 22, 2012 at 2:22 AM, Deepak Agarwal dagarwa...@gmail.comwrote: Yes. All set. On Fri, Jun 22, 2012 at 2:21 AM, Mike mz4whee...@gmail.com wrote: Have you tried the mysql tuning primer script?

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Mike
If you run iostat -x 5, for about 1 minute, what is the %util value? On Thu, Jun 21, 2012 at 1:53 PM, Deepak Agarwal dagarwa...@gmail.comwrote: Will run it again. Had done it before getting load on mysql. On Fri, Jun 22, 2012 at 2:22 AM, Deepak Agarwal dagarwa...@gmail.com wrote: Yes. All

Re: Tables getting locked even for 3-4 users

2012-06-21 Thread Deepak Agarwal
Ok. Thanks. I will do that and paste the results here tomorrow. On Fri, Jun 22, 2012 at 2:31 AM, Mike mz4whee...@gmail.com wrote: If you run iostat -x 5, for about 1 minute, what is the %util value? On Thu, Jun 21, 2012 at 1:53 PM, Deepak Agarwal dagarwa...@gmail.com wrote: Will run it

Re: Deal product / promotion for a time period with counddown timer

2012-06-21 Thread Robert G.
ok, this I got now...in documentation I read: * .2.3.11.3.3 IMPORTANT: Price rules will only be run if an item has a List Price associated with it.* Dont know understand why, but ok it works :) Robert G. wrote btw. I tried to define a price rule for a product, but I cannot see the price

Re: Deal product / promotion for a time period with counddown timer

2012-06-21 Thread Robert G.
do someone know, how I can check on productdetail site (ecommerce) if a ProductPriceCond entity exists for this product id? and than find the From and thrudate, that I can create the countdown timer? would be great, thanks -- View this message in context:

Re: Has anyone implemented Faceted Search using SOLR?

2012-06-21 Thread Rajbir Saini
Hello Sanjeev, What is that did not work? I will be happy to help if you can share the problems you had faced. Regards, Raj On Friday 22 June 2012 12:10 AM, Sanjeev Gupta wrote: Hi Rajbir, I spent a couple of days trying to play around with the approach you recommended but couldn't get it

Re: Ofbiz with MySQL or PostgreSQL

2012-06-21 Thread Sanjeev Gupta
Thanks Ruth. I've also been told that the demo data upload in Postgres takes half as time as MySQL - so I'm guessing that the production env performance should also be better with Postgres. - Rgds Sanjeev www.sanjeevg.com @sanjeevgcom -- View this message in context:

Re: Deal product / promotion for a time period with counddown timer

2012-06-21 Thread Robert G.
k got it... found the related class PriceServices -- View this message in context: http://ofbiz.135035.n4.nabble.com/Deal-product-promotion-for-a-time-period-with-counddown-timer-tp4633849p4633908.html Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Ofbiz with MySQL or PostgreSQL

2012-06-21 Thread Brett Palmer
Sanjeev, We've used MySQL for several years now. I think most ofbiz user prefer Postgres. We like Postgres but the one feature that keeps us with MySQL is its replication feature. Replication in MySQL is very good and easy to administer. We use them for running reports which helps us scale