Re: PL/pgSQL function not working in (more info) Michael Zurke Fri, 22 Jul 2005 06:58:56 -0700 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 <[EMAIL PROTECTED]> 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 Previous message View by thread View by date Next message Reply via email to

[Michael Zurke]

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 <[EMAIL PROTECTED]> 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