|
Home > Archive > PostgreSQL JDBC > November 2005 > Getting param names
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Getting param names
|
|
| Srivats 2005-11-10, 3:23 am |
| Hi All,
Is there anyway of getting all the IN Parameters of a particular Stored
Procedure in JAVA.
Thks
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| Kris Jurka 2005-11-10, 8:24 pm |
|
On Thu, 10 Nov 2005, Srivats wrote:
> Is there anyway of getting all the IN Parameters of a particular Stored
> Procedure in JAVA.
>
As was suggested earlier, see DatabaseMetaData. getProcedureColumns:
http://java.sun.com/j2se/1.5.0/docs...eCol
umns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String)
Although the postgresql driver hasn't been updated to handle the new out
parameters in 8.1.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
| |
| Dave Cramer 2005-11-10, 8:24 pm |
| Kris,
What new out parameters are you referring to ?
Dave
On 10-Nov-05, at 11:20 AM, Kris Jurka wrote:
>
>
> On Thu, 10 Nov 2005, Srivats wrote:
>
>
> As was suggested earlier, see DatabaseMetaData. getProcedureColumns:
>
> http://java.sun.com/j2se/1.5.0/docs/api/java/sql/
> DatabaseMetaData. html#getProcedureCol
umns(java.lang.String,%
> 20java.lang.String,%20java.lang.String,%20java.lang.String)
>
> Although the postgresql driver hasn't been updated to handle the
> new out parameters in 8.1.
>
> Kris Jurka
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
| |
| Kris Jurka 2005-11-10, 8:24 pm |
|
On Thu, 10 Nov 2005, Dave Cramer wrote:
> What new out parameters are you referring to ?
>
I'm speaking specifically in the context of
DatabaseMetaData. getProcedureColumns(
)'s COLUMN_TYPE column.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
|
|
|
|