patternsqlMinor
Does it make sense to upgrade to a newer PostgreSQL JDBC driver?
Viewed 0 times
postgresqljdbcmakenewersensedoesdriverupgrade
Problem
I would like to know if it could be possible to gain any performance benefits from upgrading the default PostgreSQL JDBC drivers from applications like Confluence or JIRA.
Assume that you cannot modify the application that is using them, the question if there are any visible benefits from switching from the current driver
Does it make sense or not? If so, which version should I pick?
Assume that you cannot modify the application that is using them, the question if there are any visible benefits from switching from the current driver
postgresql-8.4-702.jdbc3.jar to something newer?- the backend is using PostgreSQL 9.1 and soon will be upgraded to 9.3
- JVM being used is the latest 1.7 from Oracle
Does it make sense or not? If so, which version should I pick?
Solution
You should always ensure that the JDBC driver is at least as new as the back-end server.
PostgreSQL's catalogs change between major versions, and other details like the bytea quoting method, string escaping features, etc have also changed over time. PgJDBC contains compatibility code to cope with this by querying the server version. If you don't use a current driver, you may have issues with some features, particularly JDBC metadata access and bytea fields.
PostgreSQL's catalogs change between major versions, and other details like the bytea quoting method, string escaping features, etc have also changed over time. PgJDBC contains compatibility code to cope with this by querying the server version. If you don't use a current driver, you may have issues with some features, particularly JDBC metadata access and bytea fields.
Context
StackExchange Database Administrators Q#64512, answer score: 3
Revisions (0)
No revisions yet.