[OFBiz] Dev - Content->DataResource bug - Solved

[Kasubaski, Matt]

To make a long story short, I solved the problem by updating the
PostGreSQL JDBC driver to version 8.0 (build 311).
(http://jdbc.postgresql.org/download.html) 

I tested the new driver against both a 7.4.3 server and a 8.0.3 server
and both worked when I navigated to the Content->DataResource->Find tab.
When I switched the new driver for the stock OfBiz version (7.5devel
JDBC3 with SSL build 301), both the 7.4.3 server and the 8.0.3 server
displayed the problem on that page.

Would it be possible to update the PostGreSQL JDBC driver in SVN?  The
one that's there now looks to be a development version.

On a side note, I tested the stock OfBiz against the Derby database and
it did not have the problems which lead me to try updating the JDBC.

Matt


-----Original Message-----
From: dev-bounces at lists.ofbiz.org [mailto:dev-bounces at lists.ofbiz.org]
On Behalf Of David E. Jones
Sent: Saturday, July 02, 2005 7:14 PM
To: OFBiz Project Development Discussion
Subject: Re: [OFBiz] Dev - Content->DataResource bug


No, it is still pretty far from the top of the list of outstanding  
bugs to review and improvements to implement, so if you want to look  
into it go for it. I recommend reading the exception and interpreting  
it very literally and doing whatever tests are necessary to narrow  
down the exact problem, and then fix it. In other words, guess at the  
problem and do tests to prove that is the problem rather than trying  
to throw in fixes based on the guess.

Okay, I know that's very general advice, but about all I have to  
offer in the time I want to spend replying to this email...

-David



On Jul 1, 2005, at 11:47 AM, Kasubaski, Matt wrote:

> David,
>
> Were you able to reproduce this?
>
> I have some spare time and was going to look into this again.  Any
> pointers you could give me on where to look would help greatly.
>
> Thanks,
>
> Matt
>
> -----Original Message-----
> From: dev-bounces at lists.ofbiz.org [mailto:dev-bounces at lists.ofbiz.org]
> On Behalf Of David E. Jones
> Sent: Thursday, June 16, 2005 10:43 PM
> To: OFBiz Project Development Discussion
> Subject: Re: [OFBiz] Dev - Content->DataResource bug
>
>
> Thanks Hans, that's what I'll use then to try to reproduce this...
>
> -David
>
>
> On Jun 16, 2005, at 6:34 PM, Hans Bakker wrote:
>
>
>> The opentravel demo is using the inbuilt Derby database....
>>
>> On Friday 17 June 2005 04:01, David E. Jones wrote:
>>
>>
>>> He must mean the demo that Hans Bakker is running since the other is
>>> no longer there, and I'm not sure what database that is on...
>>>
>>> -David
>>>
>>> On Jun 16, 2005, at 2:59 PM, bjfree at free-man.net wrote:
>>>
>>>
>>>> I believe it is the ofbiz.org demo site he is referring to.
>>>>
>>>> -----Original Message-----
>>>> From: David E. Jones [mailto:jonesde at ofbiz.org]
>>>> Sent: Thursday, June 16, 2005 8:53 PM
>>>> To: OFBiz Project Development Discussion
>>>> Subject: Re: [OFBiz] Dev - Content->DataResource bug
>>>>
>>>> Which database are you using when this happens?
>>>>
>>>> -David
>>>>
>>>> On Jun 16, 2005, at 2:42 PM, Kasubaski, Matt wrote:
>>>>
>>>>
>>>>> There seems to have been an unannounced "feature" added sometime
>>>>> between May 5 and the 24th which is causing some of the Content
>>>>> DataResource tabs in the admin interface to not function  
>>>>> correctly.
>>>>>
>>>>>
>>>>>
>>>>> To reproduce the error, log in to the admin interface (the demo
>>>>> site has this bug), click on the "content" tab, then on the
>>>>> DataResource sub tab.  The subtabs which I found exhibit this are:
>>>>> Find, Attribute, Role and ProductFeatures.  The Content- 
>>>>> >Template->
>>>>> List and Find tabs also have this problem.
>>>>>
>>>>>
>>>>>
>>>>> The error displayed on the screen is:
>>>>>
>>>>> Error: Expression listWrapper is undefined on line 3, column 3 in
>>>>> repository:pages:///data/FindDataResource.ftl.
>>>>>
>>>>>
>>>>>
>>>>> Which is a side effect of listWrapper not being defined.
>>>>>
>>>>>
>>>>>
>>>>> Which was caused by pagelistprep.bsh throwing an exception before
>>>>> listWrapper could be defined.
>>>>>
>>>>> The exception is throw on execution of:
>>>>>
>>>>>       try {
>>>>>
>>>>>             listIt.last();
>>>>>
>>>>> ...
>>>>>
>>>>> }
>>>>>
>>>>> with an error message of:
>>>>>
>>>>> "Error setting the cursor to last (ERROR: cursor "jdbc_curs_96"
>>>>> does not exist)"
>>>>>
>>>>>
>>>>>
>>>>> To try to isolate when this change was put in, I tried the stock
>>>>> demo on a clean database, and a clean build.
>>>>>
>>>>> The code I had checked out from May 5th did not have this problem,
>>>>> but the code from a checkout on May 24th did.
>>>>>
>>>>>
>>>>>
>>>>> I hope this jogs someone's memory as to what could be causing  
>>>>> this.
>>>>>
>>>>>
>>>>>
>>>>> I was going to put this in Jira, but thought I would try here  
>>>>> first
>>>>> in case there was an easy fix.
>>>>>
>>>>>
>>>>>
>>>>> Matt
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Dev mailing list
>>>>> Dev at lists.ofbiz.org
>>>>> http://lists.ofbiz.org/mailman/listinfo/dev
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Dev mailing list
>>>> Dev at lists.ofbiz.org
>>>> http://lists.ofbiz.org/mailman/listinfo/dev
>>>>
>>>> _______________________________________________
>>>> Dev mailing list
>>>> Dev at lists.ofbiz.org
>>>> http://lists.ofbiz.org/mailman/listinfo/dev
>>>>
>>>>
>>
>> -- 
>> Regards,
>> Hans Bakker
>> ANT Websystems Ltd (www.antwebsystems.com)
>>
>> _______________________________________________
>> Dev mailing list
>> Dev at lists.ofbiz.org
>> http://lists.ofbiz.org/mailman/listinfo/dev
>>
>>
>
>
> _______________________________________________
> Dev mailing list
> Dev at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/dev
>

 
_______________________________________________
Dev mailing list
Dev at lists.ofbiz.org
http://lists.ofbiz.org/mailman/listinfo/dev