UncategorizedSQLException with SQL Partitioning - Parallel Processing

[jef_1]

Hi,

I run a job with SQL Partitioning. I encountered the following error during execution:
org.springframework.jdbc.UncategorizedSQLException : Executing query; uncategorized SQLException for SQL [SELECT PLAYER_ID, FIRST_NAME, LAST_NAME, POSITION, DEBUT_YEAR, FINAL_YEAR,CAREER_LENGTH from PLAYER where PLAYER_ID >= #{stepExecutionContext['minValue']} and PLAYER_ID <= #{stepExecutionContext['maxValue']} ]; SQL state [null]; error code [17034]; Token SQL92 non pris en charge à l'emplacement: 142: stepExecutionContext; nested exception is java.sql.SQLException: Token SQL92 non pris en charge à l'emplacement: 142: stepExecutionContext

In the xml Spring batch job configuration file the query is declared like:
<beans:bean name="playerDBReader" id="playerDBReader" class="org.springframework.batch.item.database.Jdb cCursorItemReader" scope="step" >
<beansroperty name="dataSource" ref="CLEDS" />
<beansroperty name="sql" >
<beans:value><![CDATA[SELECT PLAYER_ID, FIRST_NAME, LAST_NAME, POSITION, DEBUT_YEAR, FINAL_YEAR,CAREER_LENGTH from PLAYER where PLAYER_ID >= #{stepExecutionContext['minValue']} and PLAYER_ID <= #{stepExecutionContext['maxValue']} ]]></beans:value>
</beansroperty>

Have an idea to fix this error ?
Thanks a lot.

[michael.lange]

please take a look into a similar problem here in the forum: Dynamic SQL in JdbcCursorItemReader

[veeseekay]

try increasing the db thread pool size