Thread: Antw: Re: Why does the JDBC driver not support prepareCall?

Antw: Re: Why does the JDBC driver not support prepareCall?

From
"Marcel Gsteiger"
Date:
thanks for the response, with UltraDEV 4.0 the problem seems to be solved.

>>> Joel Bernstein <joel@basefive.com> 19.01.2001  16.49 Uhr >>>

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
{

}

---------------------------------------

I have heard talk of an EXECUTE commad that was added for function
calls but I'm not sure is works like the EXEC for stored procedures
does in MS SQLserver and other databases.  If it does then prepareCall
could be used.

Anybody have comments on EXECUTE.

Joel



Future of PQprint

From
KuroiNeko
Date:
 Will  PQprint() remain  in future  versions?  Doc sayeth  it's `no  longer
actively supported,' so I'm feeling clewless about its future.

 Thx

 Ed


--

 ������������������