Announcement Announcement Module
Collapse
No announcement yet.
UncategorizedSQLException with SQL Partitioning - Parallel Processing Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • UncategorizedSQLException with SQL Partitioning - Parallel Processing

    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.

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

    Comment


    • #3
      try increasing the db thread pool size

      Comment

      Working...
      X