ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Zurke <mis...@zurke.info>
Subject Re: PL/pgSQL function not working in <select> (more info)
Date Fri, 22 Jul 2005 13:54:43 GMT
put




hi eric,

probably out of date. just in case:
try this in your config

  <transactionManager type="JDBC" commitRequired="true">

mischa


Peng Wang wrote:
> try this
> <select id="getSilly" resultClass="int" parameterClass="string">
>             select silly(#value#) from dual
>  </select>
> 
> I think it can work.
> 
> On 5/8/05, Wolf <coyo@irresponsiblecybernetics.com> wrote:
> 


>>Hi Clinton,
>>
>>  Thanks for the response.  I have tried this through raw JDBC :
>>          con = DriverManager.getConnection("jdbc:postgresql:wiki");
>>          stat = con.createStatement();
>>          stat.executeQuery("select silly('foo')");
>>  and that works as expected.
>>
>>  I am using the same jdbc driver on both occasions.
>>
>>  I did try select('foo') from dual but I got  ERROR: relation "dual"
>>does not exist. I think DUAL is an oracle only psuedo-table.
>>
>>-Wolf
>>
>>On May 7, 2005, at 7:39 PM, Clinton Begin wrote:
>>
>>
>>> Try select silly(text) from dual.
>>>
>>> Cheers,
>>> Clinton
>>>
>>
>>
> 


Mime
View raw message