Product Search Error when using Postgres database.

2010-06-13 Thread rohit
Hi, I am using the latest SVN with postgres database 8.2.11. When searching for products for certain keyword, its throwing the below error. Did anyone notice such error? Its best to try some random keywords to reproduce the error. Any help will be appreciated. Thanks, Rohit 010-06-13

Re: Product Search Error when using Postgres database.

2010-06-13 Thread Jacques Le Roux
I can' reproduce on the trunk demo (Derby on Ubuntu) nor locally (Postgres 8.4 on XP) Have you a specific reproductible keyword? Jacques rohit wrote: Hi, I am using the latest SVN with postgres database 8.2.11. When searching for products for certain keyword, its throwing the below error.

Re: Product Search Error when using Postgres database.

2010-06-13 Thread rohit
it was showing for the keyword 'giz'. u mentioned that you are using postgres 8.4, do we necessarily have to use 8.4. I am getting the error when using 8.2. Does the SQL generated as shown in the error seem correct to you. Thanks, Rohit -- View this message in context:

Re: Product Search Error when using Postgres database.

2010-06-13 Thread Jacques Le Roux
No, it's only that I'm using 8.4 locally giz returns results here and on trunk demo (and stable), just tested Jacques rohit wrote: it was showing for the keyword 'giz'. u mentioned that you are using postgres 8.4, do we necessarily have to use 8.4. I am getting the error when using 8.2.

Re: Trund demo

2010-06-13 Thread BJ Freeman
what it achieves as I have said all along is that it stops the error from happening so I can see the real error. you seem stuck on the fact it is a not in ofbiz. so I don't see how we will come to a consensus. bottom line is I have used the patch it solve a problem I am happy. I shared this

Re: Trund demo

2010-06-13 Thread BJ Freeman
to follow up on it is my configiration. you will note the orginal email was about the trunk demo having a error of broken pipes. so you have a test bed to figure out what was misconfigured, or caused that error. = BJ Freeman http://bjfreeman.elance.com Strategic Power

Re: userLogin - Cannot find requested service

2010-06-13 Thread Muhammad Aamir
ok I will try it. I didn't try earlier thinking it might be incorrect and there might be some reason behind keeping it non-exportable. Regards On Sun, Jun 13, 2010 at 8:14 AM, Scott Gray scott.g...@hotwaxmedia.comwrote: On 13/06/2010, at 4:27 PM, Muhammad Aamir wrote: Hello, I am trying

Re: Product Search Error when using Postgres database.

2010-06-13 Thread rohit
does the error log, provide any help or point to any potential problem. I spent the whole day today to resolve this but no success yet. I also updated postgres to 8.4 and the jdbc driver and did the ant run-install. to freshly populate the database but no help. I guess its more of an

Re: Product Search Error when using Postgres database.

2010-06-13 Thread Jacques Le Roux
I'd try with the same instance but with another DB: Derby is at hand Jacques From: rohit rohitksur...@yahoo.com does the error log, provide any help or point to any potential problem. I spent the whole day today to resolve this but no success yet. I also updated postgres to 8.4 and the jdbc

Re: Redirection after checking browser url

2010-06-13 Thread eric
response.sendRedirect(newUrl) it works fine, on condition to put this call into a groovy file before all freemarker files Eric On Tue, 2010-06-08 at 11:44 +0200, Jacques Le Roux wrote: http://tuckey.org/urlrewrite/ ? Jacques From: eric eric...@free.fr Thanks Adrian BJ, I use

getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

2010-06-13 Thread BJ Freeman
if I run it with derby it works fine. I changed to localpostnew using 8.4.4 and it working fine with a 9.04 install I was able to log into the db with psql so that all works. get the following error when it is trying to connect to db. [java] 2010-06-13 12:02:52,088 (main) [

Re: getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

2010-06-13 Thread BJ Freeman
just did a install of 10.4 using postresql and it is working fine. so what ever it is has to do with changes since 10.04 and June 10th. can you help Scott? BJ Freeman sent the following on 6/13/2010 12:50 PM: = BJ Freeman http://bjfreeman.elance.com Strategic Power

Re: getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

2010-06-13 Thread Scott Gray
No sorry I can't help, I don't have the time right now to setup a local postgres instance and figure what is going on. I highly doubt the problem, if there is one, is related to anything I've committed recently. Regards Scott HotWax Media http://www.hotwaxmedia.com On 14/06/2010, at 11:12

Re: getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

2010-06-13 Thread BJ Freeman
I was hoping since you had worked with the code in this area you could point me in what it was looking for and did not find. saves me having to put debug.info in to find out. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation

Re: getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

2010-06-13 Thread Scott Gray
There isn't much code I haven't worked on or dug through now by this point :-) I'm certainly not instantly familiar with all of it though. I cringe every time someone mentions using debug statements to identify the source of a problem. I would suggest that you learn how to perform remote

Re: getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

2010-06-13 Thread BJ Freeman
thanks guess I have to figure out how to install eclipse on my centos box. can't do remote debug through the boxes firewall. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation

Re: getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

2010-06-13 Thread Scott Gray
You can if you open up the port for access. Or you can just replicate the problem locally and deal with it there. Regards Scott On 14/06/2010, at 12:53 PM, BJ Freeman wrote: thanks guess I have to figure out how to install eclipse on my centos box. can't do remote debug through the boxes

Re: getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

2010-06-13 Thread BJ Freeman
does not seem to what to work on boot up. this is what started this thread. 2010-06-13 18:23:58,531 (main) [ModelReader.java:389:INFO ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=848 #ViewEntities=269 #Fields=8859 #Relationships=2927 #AutoRelationships=2159 2010-06-13

Re: getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

2010-06-13 Thread BJ Freeman
I have a pretty standard way of installing. do the svn compile change the ofbiz-container so ports don't conflict make the /etc/init.d/scriptname set the user and group ./ant run-install su username /etc/init.d/scriptname start check it runs under derby and I can access both http and https su

how to execute my own sql by OFBiz delegator

2010-06-13 Thread sheng
Hello everyone, I have an entity defined as: entity entity-name=Commodity field name=quantity type=long/ field name=price type=long/ /entity How can l get the following sql execution result by OFBiz delegator? SELECT (quantity*price)/SUM(quantity) average FROM commodity WHERE

Re: how to execute my own sql by OFBiz delegator

2010-06-13 Thread Atul Vani
hi Sheng, one way could be executing the raw SQL query, like stmt = connection.createStatement(); sql = SELECT ...; rs = stmt.executeQuery(sql); but i would rether prefer use of ComplexAlias, you can find an example in CountFacilityInventoryByProduct.groovy qohDiffComplexAlias = new

Re: getEntityFieldType(GenericDelegator.java:555) June 10th nightly builds localpostnew

2010-06-13 Thread Jacques Le Roux
You can debug in Eclipse without going through the boxes firewall. https://cwiki.apache.org/confluence/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse#RunningandDebuggingOFBizinEclipse-Debugging(orrunning)OFBizinEclipse Jacques From: BJ Freeman bjf...@free-man.net thanks guess I have to