hi
I read this sometime back in the postgresql mailing list. Thought it
fits ur problem
*** SNIP ***
I have not tried prepareCall with postgreSQL but it makes sense
that it would not be implemented.
prepareCall is a JDBC method used to call stored procedures in a
database.
postgreSQL implements stored procedures as function calls.
So up to now the prepareCall method has not been needed because to call
a function you just would use a Statement or PreparedStatement like
this:
-----------------------------------
PreparedStatement pstmt = null;
/*
* deleteUser() is the function call.
*/
String sql = "select deleteUser()";
try
{
pstmt = con.prepareStatment(sql);
pstmt.executeQuery();
}
catch(Exception e)
{
}
finally
{
}
---------------------------------------
*** SNIP ENDS ***
Hope this helps
Anand
On Sun, Mar 04, 2001 at 01:00:02AM -0600, Qiqi Dong wrote:
>I'm using the same JDBC driver. The problem I got is that it doesn't support
>CallableStatement. Also, PostgreSQL's function won't return Recordset. So,
>if you plan to use stored procedure for query and call it from your java
>application, you are out of luck. I don't know when there will be fixes.
>
>Qiqi
>
>----- Original Message -----
>From: "Markus Keller OrcaSoft" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, March 03, 2001 2:29 AM
>Subject: Re: PostgreSQL
>
>
>> Hello Mikhail
>>
>>
>> >I am compiling PostgreSQL 7.0.3 to be used with the Tomcat 3.2.1 web
>> >application. Does anyone have any success stories or nightmares about
>> >postgresql and java connectivity. What drivers did you use and why?
>> >Please share.
>>
>>
>> I use the JDBC Java 2 driver which comes with the postgresql source
>> src/interfaces/jdbc ). Until now I have no problems. But at the moment i
>> run only some tests. I plane to publish my first application in november.
>>
>> Markus
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, email: [EMAIL PROTECTED]
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
