Обсуждение: postgres and Jdbc 2.0
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."
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
> 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