Re: postgres and Jdbc 2.0

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