postgres and Jdbc 2.0

From: chinni <naveen(dot)bysani(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: postgres and Jdbc 2.0
Date: 2004-08-04 14:20:09
Message-ID: e6f02b1404080407204beb3f45@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

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


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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2004-08-04 14:43:30 Re: postgres and Jdbc 2.0
Previous Message Rod Taylor 2004-08-04 14:14:21 Re: Bug in ALTER COLUMN/TYPE

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2004-08-04 14:43:30 Re: postgres and Jdbc 2.0
Previous Message Oliver Jowett 2004-08-04 06:37:05 Re: [JDBC] Very strange Error in Updates