HibernateCursorItemReader queryName parameters

[Ams44]

Hi,

I'm experiencing problems using HibernateCursorItemReader and trying to add parameters to my queryName.

I thought I found a solution on the following thread : http://forum.springsource.org/showthread.php?t=73562

I tried the last solution but I got the following error :

org.hibernate.QueryException: unexpected char: '#' [

My query :

<query name="B_Auto">			
<![CDATA[
	From AutomateED a
	where a.dat < trunc(sysdate - 15/1440)
	and not exists (select 1 from EtatED e
	where e.autoED.idauto = a.idauto
	and e.compED.idcomp = #{jobParameters[idcomp]}
	and e.gravED.idgrav = #{jobParameters[idgrav]})
]]></query>

I add the parameters like that :

JobParameters params = new JobParametersBuilder().
addLong("idcompagt", new Long(42)).
addLong("idgraval", new Long(2)).
toJobParameters();
setJobParameters(params);

I'm using Spring Batch 2.0.4.

Thanks in advance for your help.

Yann

[Marten Deinum]

It is not a valid HQL or JQL for that matter. The placeholders ONLY work if they are specified in the applicationContext NOT if they are part of the hbm file.

[Ams44]

Thanks Marten. In fact, I already tried to put my HQL in the application context and I got the same error.

Doing that for example :

<bean id="hibernateAutoReader" class="org.springframework.batch.item.database.HibernateCursorItemReader">
<property name="queryString">
	<value>
        <![CDATA[
        From AutomateED a
	where a.dat < trunc(sysdate - 15/1440)
	and not exists (select 1 from EtatED e
	where e.autoED.idauto = a.idauto
	and e.compED.idcomp = #{jobParameters[idcomp]}
	and e.gravED.idgrav = #{jobParameters[idgrav]})
        ]]>
	</value>
</property>
<property name="sessionFactory" ref="sessionFactory" />
</bean>

[Marten Deinum]

For that I suggest you read the full thread you initially pointed to... The answer is here.

[Ams44]

Thank you but the example on FlatFileItemReader doesn't really help me.

Could it be an incompatibility between Spring and Spring Batch ? I'm using spring 2.5.6 and spring batch 2.0.4.

My application context header might be wrong ?

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="
			http://www.springframework.org/schema/batch http://www.springframework.org/schema/batch/spring-batch-2.0.xsd
			http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

Maybe the only solution is to use a property file instead of parameters ?

[Marten Deinum]

Sigh... I gave you the post with the answer as I suggest read that thread, which you used yourself also.

Your reader needs to be in step scope.

[Ams44]

Thanks ... I put this scope in another configuration (adding quote etc...) and it didn't work. See you next time

[Marten Deinum]

I really suggest you read the reference guide on using step scope and how to configure it, also make sure that the step scope is available and that you use a scoped-proxy (only specifing scope="step" isn't enough!).

[Ams44]

In fact, you were right yesterday. This problem is solved thanks to you.