[Opensource] DBMaint fails on second search

[Luis Martin]

Michael,

I've made a new & fresh installation on W2K+SP2 with:

- j2sdk1.4.0_01 binary distribution
- jakarta-tomcat-4.0.4 final release, binary distribution
- expresso4-1-ea3-bin binary distribution

An initial out of memory condition was cleared setting environment variable
JAVA_OPTS="-Xms64m -Xmx64m".

After login into expresso as "Admin" with the Hypersonic Database I've
executed "Setup" -> "Create/Verify Database Structure & Perform Initial
Setup" -> and performed database initialization With all options checked for
the Hypersonic DB. Everything went OK.

Now ...

Possible DBMaint BUG: Search with no parameter retrieves the same result as
previous parametrized search.

 - Run: http://localhost:8080/expresso4-1-ea3-bin/DBMaint.do
 - Choose Schema: General
 - Choose Database Object: MIME Types
 - List Records

   List finds 54 records and shows first 50. This is ok.

 - Click binoculars to perform a new search.
 - We want to find records with "MIME Type" with a leading lowercase "a".
 - fill fields: "MIME Type"="a%",
                 "MIME Type Description"=""
                 "MIME Type Icon"="All Values"
 - Click "Display records found by search"

   Searchlist finds 35 records and shows first 35. This is ok.

 - Click binoculars to perform a new search.
 - We want to find all records.
 - fill fields: "MIME Type"="",
                 "MIME Type Description"=""
                 "MIME Type Icon"="All Values"
 - Click "Display records found by search"

   Searchlist finds 35 records and shows first 35. This is wrong.
   Searchlist should find 54 records and show first 50.

Same results with expresso4-1-ea3-src source distribution

I've seen that the "showOptions" method in "DynamicCmd.java" adds parameters
"fields" and "search" for transitions "prevSet","List","Add", "Search" and
"nextSet".

I think that parameters "fields" and "search" should not be added to
transitions "Add" and "Search". They should only be present at most for
transitions whose destination state is "List" or "SearchList".

Possible BUG FIX:

Modify "showOptions" method in "DynamicCmd.java" so that parameters "fields"
and "search" are not added to transitions "Add" and "Search".

I've deleted following lines from the building of "Add" and "Search"
transitions:

tempParam = getFieldsParam();
if (tempParam.length() > 0) {
    addAction.addParam("fields", URLUTF8Encoder.encode(tempParam));
}
tempParam = getSearchParam();
if (tempParam.length() > 0) {
    addAction.addParam("search", URLUTF8Encoder.encode(tempParam));
}

I've tested the modification and everything seems to work Ok.

If you are able to initially reproduce the bug and think that the fix is ok,
could you include it in CVS ?

Any comments are most welcome.

Best regards,
Luis Martin


----- Original Message -----
From: "Michael Rimov" <rimovm at centercomp.com>
To: <opensource at jcorporate.com>
Sent: Friday, June 14, 2002 6:03 AM
Subject: Re: [Opensource] DBMaint fails on second search


At 08:29 PM 6/10/2002 +0200, you wrote:
>Hello,
>
>DBMaint fails on second search.
>
>I'm very new to the Expresso framework, and DBMaint is still far to big for
>me to locate the bug. But it can be reproduced taking the following steps:
>
>1) Using DBMaint select table "MIME TYPES" from the General schema.
>2) Click on "Prompt for search criteria"
>3) Use "audio%" as filter for the MIME TYPE column and click"Display
records
>found by search"
>4) A listing of 6 records appears.
>5) Click on the binoculars to perform another search.
>6) Leave all fields empty and click"Display records found by search" ...
>Boom
>No record is selected at all, when it should be retrieving all records.

Luis,

I tried duplicating your bug by following your steps on both MySQL and
Postgres.  I couldn't get it to blow up like you described.  It's possible
that in some of the rework that has been going on that it got
'accidentally' fixed in rewrites.

I encourage you to download the ea-3 when it becomes available and see if
you still have the problem.  If so, can you please post exactly what
database you're using?  Thanks!

-Mike (R)



_______________________________________________
Opensource mailing list
Opensource at jcorporate.com
http://mail.jcorporate.com/mailman/listinfo/opensource
Archives: http://mail.jcorporate.com/pipermail/opensource/