Ibatis returner null
I've been trying to get IBATIS to execute a complex query and null is returned every time. I've tried to locate the error by using simpler queries and so far this is what I have discovered.This query works:
select 1 as value from dual
And this one fails:
select distinct 4 as value from campaign
Needles to say both queries works fine when executed by hand in SQL-plus for oracle.
My xml setup for this query is:
<select id="getActiveCampaignId" resultClass="int" parameterClass="string">
select distinct 4 as value from campaign
</select>
Where the parameter is used in the complex query which doesn't work either.
Can anyone shed a little ligt on this problem ?
