Re: JDBC issues for JDK1.4

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
>
>