Bug #85: ECos Batch - Between STARTRANGE and ENDRANGE - Order ID migration - Collaboration Platform for eCosway

Actions

Copy link

Bug #85

closed

ECos Batch - Between STARTRANGE and ENDRANGE

Added by Chooi-Mey over 13 years ago. Updated over 13 years ago.

Status:

Closed

Priority:

Urgent

Assignee:

Chee-Hoong

Category:

offline batches

Target version:

1.0

Start date:

02/17/2011

Due date:

% Done:

100%

Estimated time:

Resolution:

Fixed

Description

For those Sql query with "Between ? and ?" that if using preparedstatment, the set In parameter value do not require single quote (') anymore for the value. For example:

DailyReportECos.java:

private static final String STARTRANGE = "'400000000'";
private static final String ENDRANGE = "'419999999'";

The single quote defined above has been interpreted as part of the value in the SetString(1, STARTRANGE) case. Therefore no records is being found.

SO do not need single quote in this case.

Fix for all impacted program, and perform testing by compare the result with output of before migrated version.

Actions

Copy link

Updated by Chooi-Mey over 13 years ago

Pls be aware that current migStore, order no has been appended with prefix 'SUF', so adjust accordingly for the testing range.

Actions

Copy link

Updated by chin-yeh over 13 years ago

Assignee changed from chin-yeh to Chee-Hoong
Priority changed from Normal to Urgent

give this issue a higher priority as it's affecting the test result

Actions

Copy link

Updated by Chee-Hoong over 13 years ago

single quote removed.
please list down the other related programs.

Actions

Copy link

Updated by Chee-Hoong over 13 years ago

Status changed from New to Feedback
Assignee changed from Chee-Hoong to chin-yeh

Actions

Copy link

Updated by Chooi-Mey over 13 years ago

Search thru the entire project, by using File Search with keyword "400000000", browse thru the search result, and find out any code with 'xxxRANGE' and single quote value assigned.

Actions

Copy link

Updated by chin-yeh over 13 years ago

Status changed from Feedback to In Progress
Assignee changed from chin-yeh to Chee-Hoong

do search through all the files and amend the similiar changes.

if fixed and tested throughly, do deploy it to development environment so the others can verify it.

Actions

Copy link

Updated by Chee-Hoong over 13 years ago

checking

Actions

Copy link

Updated by Chee-Hoong over 13 years ago

Status changed from In Progress to Resolved

ordernum 400000000 to 419999999, single quote removed for prepareStatement.
other range is stil checking

Actions

Copy link

Updated by Chee-Hoong over 13 years ago

searching order range as listed below:-
if (cntry.equals("HK"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '400000000' and '419999999'";
else if(cntry.equals("ECOS"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '0' and '400000000'";
else if (cntry.equals("AUS"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '440000000' and '449999999'";
else if (cntry.equals("IND"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '450000000' and '459999999'";
else if (cntry.equals("US"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '470000000' and '479999999'";
else if (cntry.equals("NZ"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '480000000' and '489999999'";
Please let me know if any missing