Why does the JDBC driver not support prepareCall?

the interfaces.jdbc forum is brand new, and ppl have been flocking to it
quite quickly ... :)

On Fri, 19 Jan 2001, mg wrote:

I have troubles with jsp-based websites that have been generated by
Macromedia DreamWeaver UltraDev 1.0. My analysis revealed that the
problem lies in the JDBC driver not supporting prepareCall (prepareCall
throws the PSQLException "postgresql.con.call" instead).
Is there any workaround or intermediate solution? Is there anybody
working to fill this gap, and when can a solution be expected? Is there
anybody working on this subject?

I already posted this question in the interfaces.jdbc forum, but since
there are no other messages in that forum, I thought that probably
nobody would see it there...

Thank you for any answer.

Regards
--Marcel Gsteiger

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

On Fri, 19 Jan 2001, mg wrote:

I have troubles with jsp-based websites that have been generated by
Macromedia DreamWeaver UltraDev 1.0. My analysis revealed that the
problem lies in the JDBC driver not supporting prepareCall (prepareCall
throws the PSQLException "postgresql.con.call" instead).
Is there any workaround or intermediate solution? Is there anybody
working to fill this gap, and when can a solution be expected? Is there
anybody working on this subject?

prepareCall is reportedly going to be implemented in 7.1.

-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
"Mach was the greatest intellectual fraud in the last ten years."
"What about X?"
"I said `intellectual'."
;login, 9/1990

Quoting "Brett W. McCoy" <bmccoy@chapelperilous.net>:

On Fri, 19 Jan 2001, mg wrote:

I have troubles with jsp-based websites that have been generated by
Macromedia DreamWeaver UltraDev 1.0. My analysis revealed that the
problem lies in the JDBC driver not supporting prepareCall

(prepareCall

throws the PSQLException "postgresql.con.call" instead).
Is there any workaround or intermediate solution? Is there anybody
working to fill this gap, and when can a solution be expected? Is

there

anybody working on this subject?

prepareCall is reportedly going to be implemented in 7.1.

It depends on how I get on this weekend (although at the rate I've been
catching up over the last few days, its pretty good so far). It's mainly a
hardware issue for me at the moment...

Peter

--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

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

message resent to pgsql-jdbc@postgresql.org

On Fri, 19 Jan 2001, Joel Bernstein wrote:

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

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org