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