From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Joel Bernstein <joel(at)basefive(dot)com> |
Cc: | mg <marcel(dot)gsteiger(at)milprog(dot)ch>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Why does the JDBC driver not support prepareCall? |
Date: | 2001-01-22 21:21:23 |
Message-ID: | Pine.BSF.4.31.0101221721160.644-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
message resent to pgsql-jdbc(at)postgresql(dot)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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Alfred Perlstein | 2001-01-22 21:29:55 | Re: [HACKERS] Re: postgres memory management |
Previous Message | Martin A. Marques | 2001-01-22 21:19:01 | Re: is PG able to handle a >500 GB Database? |
From | Date | Subject | |
---|---|---|---|
Next Message | Alfred Perlstein | 2001-01-22 21:29:55 | Re: [HACKERS] Re: postgres memory management |
Previous Message | Peter Mount | 2001-01-22 20:45:55 | Re: ODBC gives pq_recvbuf: unexpected EOF on client connection |