Re: old JDBC driver (8.1-JDBC3) can connect to postgresql 9.x?

On 1/16/2017 4:05 PM, itoshun001@efeel.to wrote:
>        Versions of jdbc driver that supported Java 5 can't connect to postgresql 9.4 or later
>        because
>         - the versions of jdbc driver don't support JDBC 4, 41 and 42
>         - the versions of postreqsql don't support JDBC3

java 5 is obsolete and no longer supported, so the postgres jdbc driver
no longer goes to the extra effort of testing to support it.

postgresql itself knows nothing about jdbc any version, thats purely
between Java and the JDBC driver.

the major issue I can see that you might hit using an old jdbc driver
with a much newer postgres database server is catalog changes...  the
old driver was written with an understanding of pg_catalog circa
postgres 8.1 or 8.3...    some things have changed, the new version
supports both new and old catalog changes.    the other potential issue
is somewhere around 8.4 or 9.0, postgresql got stricter on automatic
datatype casting, and there are certain implicit type casts that would
work in 8.x that no longer work.   I do forget exact version this happened.


--
john r pierce, recycling bits in santa cruz