agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] IN/INOUT/OUT support in PL/JAVA
3+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] IN/INOUT/OUT support in PL/JAVA
@ 2005-04-26 11:18
0 siblings, 1 reply; 3+ messages in thread
From: @ 2005-04-26 11:18 UTC (permalink / raw)
Hello,
PL/JAVA 1.1 claims to support IN/INOUT and OUT parameters. Also it recommends to use PostgreSQL 8.0.2 as a backend database. However i could not find and support in the PostgreSQL8.0.2. Also there is no support in the 8.0.2 protocol parse message to indecate if the parameter is IN/OUT or INOUT. Am i missing something?
Also if this is supported, how can i declare a function on the server side to accept OUT or IN/OUT parameters. and how i can call them from JDBC client.
Thanks,
Altaf
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050426/fbeddd91/attachment.html;
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] IN/INOUT/OUT support in PL/JAVA
@ 2005-04-26 11:25
parent:
0 siblings, 1 reply; 3+ messages in thread
From: @ 2005-04-26 11:25 UTC (permalink / raw)
Altaf Malik wrote:
> Hello,
> PL/JAVA 1.1 claims to support IN/INOUT and OUT parameters. Also it
> recommends to use PostgreSQL 8.0.2 as a backend database. However i
> could not find and support in the PostgreSQL8.0.2. Also there is no
> support in the 8.0.2 protocol parse message to indecate if the
> parameter is IN/OUT or INOUT. Am i missing something?
The PL/Java announcement claims "The source of this version will compile
with the CVS HEAD of the PostgreSQL source (at the time of release date
that is) and IN/INOUT/OUT parameters are fully functional.". Perhaps not
crystal clear, but what I meant to say with this was that the
IN/INOUT/OUT parameters that are functional in CVS HEAD of PostgreSQL
are also supported in PL/Java. There's no way you can get it to work
using PosgreSQL 8.0.x.
> Also if this is supported, how can i declare a function on the server
> side to accept OUT or IN/OUT parameters. and how i can call them from
> JDBC client.
You need to keep up with the bleeding edge development of PostgreSQL.
When you do, you can read all about this in the documentation for the
coming 8.1 version.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] IN/INOUT/OUT support in PL/JAVA
@ 2005-04-26 11:27
parent:
0 siblings, 0 replies; 3+ messages in thread
From: @ 2005-04-26 11:27 UTC (permalink / raw)
Thomas Hallgren wrote:
> Altaf Malik wrote:
>
>> Hello,
>> PL/JAVA 1.1 claims to support IN/INOUT and OUT parameters. Also it
>> recommends to use PostgreSQL 8.0.2 as a backend database. However i
>> could not find and support in the PostgreSQL8.0.2. Also there is no
>> support in the 8.0.2 protocol parse message to indecate if the
>> parameter is IN/OUT or INOUT. Am i missing something?
>
>
> The PL/Java announcement claims "The source of this version will
> compile with the CVS HEAD of the PostgreSQL source (at the time of
> release date that is) and IN/INOUT/OUT parameters are fully
> functional.". Perhaps not crystal clear, but what I meant to say with
> this was that the IN/INOUT/OUT parameters that are functional in CVS
> HEAD of PostgreSQL are also supported in PL/Java. There's no way you
> can get it to work using PosgreSQL 8.0.x.
Also, on the front web page of the PL/Java project, it very clearly states:
5. Ability to use IN, INOUT, and OUT parameters (requires not yet
released PostgreSQL 8.1)
- thomas
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-04-26 11:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-26 11:18 [Pljava-dev] IN/INOUT/OUT support in PL/JAVA
2005-04-26 11:25 `
2005-04-26 11:27 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox