If the invoked stored procedure gives multiple resultsets, will StoredProcedureItemReader return items of the first resultset, or will it return nothing?
Type: Posts; User: hyjshanghai; Keyword(s):
If the invoked stored procedure gives multiple resultsets, will StoredProcedureItemReader return items of the first resultset, or will it return nothing?
If StoredProcedureItemReader invokes a stored procedure which returns multiple result sets, will all items in all these result sets be passed through the same processor and the same writer of the...
Hi all,
This could be an old question:
http://forum.springsource.org/showthread.php?t=63062
But I failed to find an answer with my Spring Batch 2.1.1.
I want to fetch data from a stored...
One thing to notice is that Spring Batch writer writes a list of items as a batch, rather than a single item at a time.
So the "write->read (some of the previously written data)->transform->write"...
Thanks for your reply.
We want to add more processing logic while keeping the chunk oriented fashion.
With StepExecutionListener.afterStep(), there are two problems:
(1) The data to process...
We want a chunk-oriented step to implement this pattern:
Reader->Processor->Writer->Another Processor
Per Spring Batch document, a chunk-oriented step is in a Reader->Processor->Writer fashion....
Failure executions referenced by Job / StepExecution objects are available only before the Spring Batch job ends.
In our case, the Spring Batch job is just one stage of our whole main program. It...
The JobListener is able to catch any exception thrown in a job, as step/jobExecution.failureException.
For integration purposes, I want the client who loads and starts the Spring Batch job to...
Suppose I have a batch update whose batch size is Integer.MAX_VALUE, to execute in a transactional method.
When the transactional method returns, that is, when the transaction commits, will Spring...
I think you misunderstand me.
I don't want to change the quote character from the default double quotation to another.
Instead, I want to change the way how the double quotation character is...
Yes, Spring Batch suits, if you sequentially parse XML by SAX and process data in XML item by item. In this case, you benefit from Spring Batch's chunk-oriented processing.
Otherwise, Spring Batch...
By default, DelimitedLineTokenizer interprets quote character as follows: inside a quoted token the quote character can be used to escape itself, thus "a""b""c" is tokenized to a"b"c.
How can I...
You simply need to define a transaction manager for your tasklet in the step.
<tasklet transaction-manager="transactionManager">
...
</tasklet>
<bean id="transactionManager"
...
This is exactly what I am doing now in jobExecutionListener.afterJob():
1. Collect all failure exceptions from jobExecution.getFailureExceptions().
2. For each stepExecution in...
Then, what is the recommended way to catch any Java exception (both checked and runtime ones, either thrown by Spring Batch framework or by business logic) that occurred during job execution?
...
Should we test ExitStatus by "==" or by equals()?
If a job completes successfully, in afterJob() of JobExecutionListener,...
My scenario is that writing items to backup database should be the first stage of the whole job - other components such as writers and processors for business purposes should be executed AFTER backup...
So instead of "stepContext.put("profilesToArchive", items);", you are now saving the items in the job context, rather than in the step context, right?
Could you tell me what's that reason?
I have to make a readerListener write the items into a backup database using jdbcTemplate.batchUpdate(). I want the batch size to be exactly the same as the...
In a step's reader, processor, writer or any listener, how can I get the commit-interval of the current step in the program code?
I have several beans who need to execute similar update SQLs.
These SQLs differ only in the name of the DB table to update.
What are your solutions to re-use part of a Sql in this case? Is the...
In a chunk-based step, as far as I understand, any exception not explicitly categorized as <skippable-exception-classes/> or <retryable-exception-classes/> will cause the step to fail, which in turn...
Ideally, I want to monitor the job by watching the current step, the number of chunks processed and so on in real time, with something like progress bars.
I know Spring Batch Admin, a web-based...
The only way I know in Sybase to lock read data by exclusive lock is "lock table in exclusive mode", which locks the whole table, not only the selected data.
I do want "select .... for update" in...
I want to start a job only after all the other executions of the same job are complete or stopped, in order to forbid concurrent job executions.
So, before starting the same job, how can I...