Thread: jdbc capabilities
What capabilities does the postgresql jdbc have? Specifically I was testing creating a scrollable, updatable resultset so that I could update a field. However, upon trying to execute java.sql.ResultSet.updateString() I was informed that the method was not yet implemented. Is there documentation that specifically covers what is implemented and/or available with postgresql jdbc?
Thanks,
Steve
You can check the capabilities even at runtime querying the DatabaseMetaData object returned by java.sql.Connection.getMetaData(). At design time you can look at the source code :-). The result set is scrollable, but for this purpose a client side cache is used instead of a backend side cursor, what would be more useful for large result set. Consequently the result set is not updatable :-(. Again, the source code is your best friend. -----Original Message----- From: Steven Dahlin [mailto:Steven_dahlin@hotmail.com] Sent: Friday, October 12, 2001 7:52 AM To: pgsql-jdbc@postgresql.org Subject: [JDBC] jdbc capabilities What capabilities does the postgresql jdbc have? Specifically I was testing creating a scrollable, updatable resultset so that I could update a field. However, upon trying to execute java.sql.ResultSet.updateString() I was informed that the method was not yet implemented. Is there documentation that specifically covers what is implemented and/or available with postgresql jdbc? Thanks, Steve
On Thu, 11 Oct 2001 23:52:22 -0600, you wrote: >Is there documentation that specifically covers what >is implemented and/or available with postgresql jdbc? We're working on it. Work in progress can be found on http://lab.applinet.nl/postgresql-jdbc/ Regards, René Pijlman <rene@lab.applinet.nl>