Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Jacques Le Roux
From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On May 23, 2012, at 9:25 PM, Adam Heath wrote: On 05/23/2012 01:13 PM, Jacopo Cappellato wrote: Using count() was simply a trick to be sure to get a record back even if the entity is empty... but if we use an entity that we are sure is

using subquery in drop down list for two entities..

2012-05-24 Thread pravin
this is my sql query.. this answer i need to show in a drop down list.. select * from hello_hobby where hello_hobby_id NOT IN (select hello_hobby_id from hello_person_hobby where hello_person_id='1') Am using the following code to display the query select hello_hobby_id from

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Jacopo Cappellato
On May 24, 2012, at 9:04 AM, Jacques Le Roux wrote: From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On May 23, 2012, at 9:25 PM, Adam Heath wrote: On 05/23/2012 01:13 PM, Jacopo Cappellato wrote: Using count() was simply a trick to be sure to get a record back even if the

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Jacques Le Roux
From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On May 24, 2012, at 9:04 AM, Jacques Le Roux wrote: From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On May 23, 2012, at 9:25 PM, Adam Heath wrote: On 05/23/2012 01:13 PM, Jacopo Cappellato wrote: Using count() was simply a

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Jacopo Cappellato
On May 24, 2012, at 10:37 AM, Jacques Le Roux wrote: select 1 works on Postgres this is interesting, thanks for testing it. Unfortunately it doesn't seem to work on Derby and I didn't test on other dbs... but if we could find a similar solution that works everywhere it would be great.

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Jacques Le Roux
SELECT 1 FROM SYSIBM.SYSDUMMY1 works for Derby. If all others work with SELECT 1 we could set a property in entityengine.xml (by DB)With SELECT 1 for all but Derby and SELECT 1 FROM SYSIBM.SYSDUMMY1 for Derby. We could also use the same trick for other DBs if SELECT 1 does not work for them (eg

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Jacopo Cappellato
Thanks Jacques. However values 1 works in Derby (but not from the Webtools, because of a limitation in the data prep script). Jacopo On May 24, 2012, at 11:33 AM, Jacques Le Roux wrote: SELECT 1 FROM SYSIBM.SYSDUMMY1 works for Derby. If all others work with SELECT 1 we could set a property

Re: using subquery in drop down list for two entities..

2012-05-24 Thread Venkat Mangudi
Pravin, Please do not use this list for learning how to do development in ofbiz. This list is for developers of Ofbiz. --Venkat On Thu, May 24, 2012 at 12:25 PM, pravin pravin.ku...@venkatmangudi.comwrote: this is my sql query.. this answer i need to show in a drop down list.. select * from

Re: Slim-down continue [was Re: svn commit: r1340414 - ...]

2012-05-24 Thread Adrian Crum
On 5/20/2012 10:01 AM, Jacques Le Roux wrote: Quick questions (seems that there is a lack of internal documentation to say the least), there are not only addressed to Adam... About javacc dependency do we really need it *OOTB*? Can't we use rather externally maintained ant targets like in

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Adam Heath
On 05/24/2012 03:22 AM, Jacopo Cappellato wrote: On May 24, 2012, at 9:04 AM, Jacques Le Roux wrote: From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On May 23, 2012, at 9:25 PM, Adam Heath wrote: On 05/23/2012 01:13 PM, Jacopo Cappellato wrote: Using count() was simply a trick

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Jacopo Cappellato
On May 24, 2012, at 5:06 PM, Adam Heath wrote: On 05/24/2012 03:22 AM, Jacopo Cappellato wrote: On May 24, 2012, at 9:04 AM, Jacques Le Roux wrote: From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On May 23, 2012, at 9:25 PM, Adam Heath wrote: On 05/23/2012 01:13 PM, Jacopo

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Jacopo Cappellato
On May 24, 2012, at 5:06 PM, Adam Heath wrote: select 1 from entity_key_store where key_name = '' limit 1; ouch, I am getting an error on Derby for the limit 1 syntax... since it is currently used in the validation query based on Example I am now wondering if it is actually used at all. I

Re: Slim-down continue [was Re: svn commit: r1340414 - ...]

2012-05-24 Thread Adam Heath
On 05/24/2012 08:15 AM, Adrian Crum wrote: On 5/20/2012 10:01 AM, Jacques Le Roux wrote: Quick questions (seems that there is a lack of internal documentation to say the least), there are not only addressed to Adam... About javacc dependency do we really need it *OOTB*? Can't we use rather

Re: Slim-down continue [was Re: svn commit: r1340414 - ...]

2012-05-24 Thread Adam Heath
On 05/24/2012 10:18 AM, Adam Heath wrote: On 05/24/2012 08:15 AM, Adrian Crum wrote: On 5/20/2012 10:01 AM, Jacques Le Roux wrote: Quick questions (seems that there is a lack of internal documentation to say the least), there are not only addressed to Adam... About javacc dependency do we

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Jacques Le Roux
From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On May 24, 2012, at 5:06 PM, Adam Heath wrote: On 05/24/2012 03:22 AM, Jacopo Cappellato wrote: On May 24, 2012, at 9:04 AM, Jacques Le Roux wrote: From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com On May 23, 2012, at 9:25

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Rajbir Saini
How about defining a test sql statement in entityegine.xml which could be specific to DBMS. For example 'select * from dual in oracle and MySQL, Select 1 in PostgreSQL. Idea is to use the DBMS specific SQL and make it configurable in the entityengine.xml so that it can be configured while

buildbot failure in ASF Buildbot on ofbiz-trunk

2012-05-24 Thread buildbot
The Buildbot has detected a new failure on builder ofbiz-trunk while building ASF Buildbot. Full details are available at: http://ci.apache.org/builders/ofbiz-trunk/builds/3101 Buildbot URL: http://ci.apache.org/ Buildslave for this Build: portunus_ubuntu Build Reason: scheduler Build Source

Re: [CVE-2012-2098] Apache Commons Compress and Apache Ant denial of service vulnerability

2012-05-24 Thread Jacopo Cappellato
I did the upgrade in rev. 1342326; tests pass and the system seems to work properly (but I did a cursory review of applications). Please let me know if you see/experience any issues and I will fix them. Regards, Jacopo On May 23, 2012, at 6:12 PM, Jacopo Cappellato wrote: Yeah I got it

buildbot success in ASF Buildbot on ofbiz-trunk

2012-05-24 Thread buildbot
The Buildbot has detected a restored build on builder ofbiz-trunk while building ASF Buildbot. Full details are available at: http://ci.apache.org/builders/ofbiz-trunk/builds/3102 Buildbot URL: http://ci.apache.org/ Buildslave for this Build: portunus_ubuntu Build Reason: scheduler Build

Re: Dependency of DBCPConnectionFactory on ExampleType entity

2012-05-24 Thread Jacques Le Roux
Hi Raj, Good idea, I had the same, please re-read the thread ;o) Cheers Jacques From: Rajbir Saini rajbsa...@yahoo.com How about defining a test sql statement in entityegine.xml which could be specific to DBMS. For example 'select * from dual in oracle and MySQL, Select 1 in PostgreSQL. Idea

Re: Slim-down continue [was Re: svn commit: r1340414 - ...]

2012-05-24 Thread Jacques Le Roux
Thanks Adrian Jacques From: Adrian Crum adrian.c...@sandglass-software.com On 5/20/2012 10:01 AM, Jacques Le Roux wrote: Quick questions (seems that there is a lack of internal documentation to say the least), there are not only addressed to Adam... About javacc dependency do we really need

Re: Slim-down continue [was Re: svn commit: r1340414 - ...]

2012-05-24 Thread Jacques Le Roux
From: Adam Heath doo...@brainfood.com On 05/24/2012 10:18 AM, Adam Heath wrote: On 05/24/2012 08:15 AM, Adrian Crum wrote: On 5/20/2012 10:01 AM, Jacques Le Roux wrote: Quick questions (seems that there is a lack of internal documentation to say the least), there are not only addressed to

Re: Slim-down continue [was Re: svn commit: r1340414 - ...]

2012-05-24 Thread Adam Heath
On 05/24/2012 04:05 PM, Jacques Le Roux wrote: From: Adam Heath doo...@brainfood.com On 05/24/2012 10:18 AM, Adam Heath wrote: On 05/24/2012 08:15 AM, Adrian Crum wrote: On 5/20/2012 10:01 AM, Jacques Le Roux wrote: Quick questions (seems that there is a lack of internal documentation to say

Re: Slim-down continue [was Re: svn commit: r1340414 - ...]

2012-05-24 Thread Jacques Le Roux
From: Adam Heath doo...@brainfood.com On 05/24/2012 04:05 PM, Jacques Le Roux wrote: From: Adam Heath doo...@brainfood.com On 05/24/2012 10:18 AM, Adam Heath wrote: On 05/24/2012 08:15 AM, Adrian Crum wrote: On 5/20/2012 10:01 AM, Jacques Le Roux wrote: Quick questions (seems that there is

Re: Slim-down continue [was Re: svn commit: r1340414 - ...]

2012-05-24 Thread Jacques Le Roux
From: Jacques Le Roux jacques.le.r...@les7arts.com From: Adam Heath doo...@brainfood.com On 05/24/2012 04:05 PM, Jacques Le Roux wrote: From: Adam Heath doo...@brainfood.com On 05/24/2012 10:18 AM, Adam Heath wrote: On 05/24/2012 08:15 AM, Adrian Crum wrote: On 5/20/2012 10:01 AM, Jacques