ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: PL/pgSQL function not working in <select> (more info)
Date Sun, 08 May 2005 03:49:49 GMT
OH! I missed the "pg" part of your subject line. :-) I thought it said 
PL/SQL.

The reason your JDBC test worked is that you used a normal statement. Try 
that with a PreparedStatement.

iBATIS uses PreparedStatements exclusively.

Clinton


On 5/7/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