try this
select silly(#value#) from dual
I think it can work.
On 5/8/05, Wolf <[EMAIL PROTECTED]> wrote:
> Hi Clinton,
>
> Thanks for the response. I have tried this through raw JDBC :
> con = DriverManager.getConnection("jdbc:postgresql:wiki");
> stat = con
Hi Clinton,
I tried it with a Prepared statement :
Connection con = DriverManager.getConnection("jdbc:postgresql:wiki");
PreparedStatement stat = con.prepareStatement("select silly('foo')");
stat.execute();
and it did work. I'm confused now. I'm going through the SqlM
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 <[EMAIL PROTECTED]> wrote:
Hi Clinton,
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
Try select silly(text) from dual.
Cheers,
Clinton
On 5/5/05, Wolf <[EMAIL PROTECTED]> wrote:
Hi folks,Thansk for SqlMap, it is making life easier. I am having a problemwithPL/pgSQL functions called from a . I can get around this by notusing the function, but wanted tocall this issue to atten
Hi folks,
Thansk for SqlMap, it is making life easier. I am having a problem with
PL/pgSQL functions called from a . I can get around this by not using the function, but wanted to
call this issue to attention (and see if it really is an issue).
I have a problem with a very simple PL/pgSQL funct
6 matches
Mail list logo
