Skip site navigation (1) Skip section navigation (2)

Re: JDBC issues for JDK1.4

From: Barry Lind <barry(at)xythos(dot)com>
To: "Mark Lillywhite (pg-jdbc)" <mark-jdbc(at)inomial(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC issues for JDK1.4
Date: 2001-10-23 21:17:10
Message-ID: 3BD5DE56.3050704@xythos.com (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-patches
Mark,

Any help on moving the jdbc code base forward is more than welcome.  In 
briefly looking over your suggestions below they all seem fine to me. 
(Of course the devil is in the details).  I would also suggest looking 
at http://lab.applinet.nl/postgresql-jdbc for a list of where we are 
lacking in jdbc2 support.

thanks,
--Barry

Mark Lillywhite (pg-jdbc) wrote:

> Hi folks
> 
> I'd like to make the JDBC driver comple with JDK1.4. I've got the
> following list of errors and potential remedies. Does anyone have any
> objections if I start work on this?
> 
> The following are the methods defined in JDK1.4 which are not currently
> implemented in the JDBC driver:
> 
> javax.transaction.RollbackException is not defined in 1.4.
> -- this appears to be renamed to TransationRolledbackException
> 
> Statement.getMoreResults(int)
> -- defines the behaviour of the current ResultSet when the next one is
> retrieved. Appears that we need to simply perform appropriate operations
> on the result instance field of jdbc2.Statement.
> 
> PreparedStatement.setURL(java.net.URL)
> -- Presumably convert the URL to a string and set it like everything
> else?
> 
> CallableStatement.registerOutParameter(String, int)
> -- There are a bunch of these actually, javac is only listing one. They
> all take parameter names rather than indexes. Should be straightforward
> to fix?
> 
> Connection.setHoldability(int)
> -- Not too sure about this. It defines the "holdability" of result sets
> between commits. Need to investigate further (tips?)
> 
> DataBaseMetaData.supportsSavepoints()
> -- Presumably: "return false;"
> 
> ResultSet.getURL(int)
> -- Presumably, "return new URL(getParameter...));"
> 
> PGblob.setBytes(long, byte[])
> PGclob.setString(long, String)
> -- This stuff looks harder, there are setBinaryStream() etc methods. Not
> sure how to go about this at this stage. Maybe an Unsupported exception?
> 
> ClientConnection.setHoldability(int)
> -- presumably, pass the call to Connection.setHoldability()?
> 
> Feedback/comments welcome.
> 
> Cheers
> Mark
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
> 
> 



In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-10-23 21:29:39
Subject: Re: [PATCHES] DatabaseMetadata patch
Previous:From: Bill StudenmundDate: 2001-10-23 19:21:37
Subject: New version of packages patch

pgsql-jdbc by date

Next:From: Bruce MomjianDate: 2001-10-23 21:29:39
Subject: Re: [PATCHES] DatabaseMetadata patch
Previous:From: Peter EisentrautDate: 2001-10-23 20:41:36
Subject: Re: FW: Re: [PATCHES] Ant configuration

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group