[#BATCH-568] Return Object[] if cursor.get() return Object array size > 0

Spring Batch

Return Object[] if cursor.get() return Object array size > 0

Created: 08/Apr/08 03:35 AM Updated: 07/Aug/08 10:07 AM

Component/s:

Infrastructure

Affects Version/s:

1.0.0

Fix Version/s:

1.0.1

Time Tracking:

Original Estimate:

0.04d

Remaining Estimate:

0.04d

Time Spent:

Not Specified

Description

« Hide

public Object read() {
if (!initialized) {
open(new ExecutionContext());
}
if (cursor.next()) {
currentProcessedRow++;
Object data = cursor.get(0);
return data;
}
return null;
}

If we use HQL with group by clause, it will return more than 1 column.

All

Comments

Work Log

Change History

FishEye

Builds

Sort Order:

[ Permlink | « Hide ]

Dave Syer added a comment - 08/Apr/08 03:42 AM

This is the HibernateCursorItemReader right? Do you mean "if we use HQL with projection"? What happens if you do that (how is it broken)?

[ Permlink | « Hide ]

Tan Khai Shen added a comment - 08/Apr/08 03:52 AM

My HQL is:

select o.field1, o.field2, count(field1)
from PO o
and o.field1<> null
group by o.field1, o.field2

I want these 3 fields in my ItemWriter

So, instead of

Object data = cursor.get(0);
return data;

Can we change to:

Object[] datas = cursor.get();
if ( datas.length == 1){
return datas[0];
}
return datas;

So, in my ItemWriter:
public void write(Object data) throws Exception {
        Object[] results = (Object[])data;
        String field1 = (String)results[0];
        String field2 = (String)results[1];
        Integer field3 = (Integer)results[2];
}

What do you think?

[ Permlink | « Hide ]

Dave Syer added a comment - 08/Apr/08 06:41 AM

Makes sense. Fixed for 1.0.1.

[ Permlink | « Hide ]

Dave Syer added a comment - 07/Aug/08 10:07 AM

Assume closed as resolved and released