Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgres and Jdbc 2.0

postgres and Jdbc 2.0

From
chinni
Date:
Hi All!
Please note that the following functions are not implemented in the 
postgres driver
even though they are a part of the JDBC 2.0 standard.

Some of these may be party implemented, but may not be complete.

<differences>
Blob.java   public long position(byte[] pattern, long start) throws SQLException

Clob.java   public long position(String pattern, long start) throws SQLException   public long position(Clob pattern,
longstart) throws SQLException
 

Connection.java   public Object getObject(String type, String value) throws SQLException

DatabaseMetaData.java   public java.sql.ResultSet getUDTs(String catalog,String 
schemaPattern,String typeNamePattern,int[] types) throws SQLException

ResultSet.java   public Object getObject(int i, java.util.Map map) throws SQLException   public Ref getRef(int i)
throwsSQLException   public void setFetchDirection(int direction) throws SQLException   public boolean rowDeleted()
throwsSQLException   public boolean rowInserted() throws SQLException   public boolean rowUpdated() throws SQLException

 
Statement.java   public int getFetchDirection() throws SQLException   public void setFetchDirection(int direction)
throwsSQLException   public void setRef(int i, Ref x) throws SQLException   public Blob getBlob(int i) throws
SQLException  public Clob getClob(int i) throws SQLException   public Object getObject(int i, java.util.Map map) throws
SQLException  public Ref getRef(int i) throws SQLException   public java.sql.Date getDate(int i, java.util.Calendar
cal)throws 
 
SQLException   public Time getTime(int i, java.util.Calendar cal) throws SQLException   public Timestamp
getTimestamp(inti, java.util.Calendar cal) throws 
 
SQLException   public void registerOutParameter(int parameterIndex, int sqlType, 
String typeName) throws SQLException   public java.sql.Array getArray(int i) throws SQLException

Array.java   public Object getArray(long index, int count, Map map) throws 
SQLException   public java.sql.ResultSet getResultSet(long index, int count, 
java.util.Map map) throws SQLException

</differences>

There are a few things which I want to know.

1) Is there anything more which I am missing wrt JDBC 2.0 and postgres.

2)  If I want to add these features to JDBC driver, is there anything
that has to go to                          database itself.


thanks
naveen
                                                           
-- 
"Stand for something, or you will fall for nothing."

Re: postgres and Jdbc 2.0

From
Dave Cramer
Date:
First, there is a list for the jdbc driver.

Second, which version are you using?

I know some of these are implemented already.

getUDT's, setFetchDirection, gettime, ...

Dave
On Wed, 2004-08-04 at 10:20, chinni wrote:
> Hi All!
> Please note that the following functions are not implemented in the 
> postgres driver
> even though they are a part of the JDBC 2.0 standard.
> 
> Some of these may be party implemented, but may not be complete.
> 
> <differences>
> Blob.java
>     public long position(byte[] pattern, long start) throws SQLException
> 
> Clob.java
>     public long position(String pattern, long start) throws SQLException
>     public long position(Clob pattern, long start) throws SQLException
> 
> Connection.java
>     public Object getObject(String type, String value) throws SQLException
> 
> DatabaseMetaData.java
>     public java.sql.ResultSet getUDTs(String catalog,String 
> schemaPattern,String typeNamePattern,int[] types) throws SQLException
> 
> ResultSet.java
>     public Object getObject(int i, java.util.Map map) throws SQLException
>     public Ref getRef(int i) throws SQLException
>     public void setFetchDirection(int direction) throws SQLException
>     public boolean rowDeleted() throws SQLException
>     public boolean rowInserted() throws SQLException
>     public boolean rowUpdated() throws SQLException
>    
> Statement.java
>     public int getFetchDirection() throws SQLException
>     public void setFetchDirection(int direction) throws SQLException
>     public void setRef(int i, Ref x) throws SQLException
>     public Blob getBlob(int i) throws SQLException
>     public Clob getClob(int i) throws SQLException
>     public Object getObject(int i, java.util.Map map) throws SQLException
>     public Ref getRef(int i) throws SQLException
>     public java.sql.Date getDate(int i, java.util.Calendar cal) throws 
> SQLException
>     public Time getTime(int i, java.util.Calendar cal) throws SQLException
>     public Timestamp getTimestamp(int i, java.util.Calendar cal) throws 
> SQLException
>     public void registerOutParameter(int parameterIndex, int sqlType, 
> String typeName) throws SQLException
>     public java.sql.Array getArray(int i) throws SQLException
> 
> Array.java
>     public Object getArray(long index, int count, Map map) throws 
> SQLException
>     public java.sql.ResultSet getResultSet(long index, int count, 
> java.util.Map map) throws SQLException
> 
> </differences>
> 
> There are a few things which I want to know.
> 
> 1) Is there anything more which I am missing wrt JDBC 2.0 and postgres.
> 
> 2)  If I want to add these features to JDBC driver, is there anything
> that has to go to                          database itself.
> 
> 
> thanks
> naveen
> 
>                                                             
-- 
Dave Cramer
519 939 0336
ICQ # 14675561

Re: postgres and Jdbc 2.0

From
Kris Jurka
Date:

> 2)  If I want to add these features to JDBC driver, is there anything
> that has to go to                          database itself.
> 

Generally JDBC questions are best discussed on the 
pgsql-jdbc@postgresql.org list.  First make sure you are working with the 
latest source code available from 
http://gborg.postgresql.org/project/pgjdbc/projdisplay.php which as 
Dave mentioned has implemented some of these methods already.  As to 
whether anything needs to be added to the server, that depends on your 
implementation.  The Blob/Clob positioning seems like it could be done 
more efficiently on the server side.  Also the server doesn't have a Ref 
datatype, so you really can't implement get/setRef without it.

Kris Jurka