For the last 10 years or so, I have been accessing the tables of a PostgreSQL database successfully. Suddenly, having upgraded to Version 13.0, I get error messages in the simplest of queries, such as listing the columns of a table. (The connection itself is established without error.)

enter image description here

Mind you, this is not new code I wrote, this is code that's been functioning since forever. Nothing has happened to the database as I can query it successfully with the Python code I have also had since forever.

I am thinking this is as "updated" JDBC driver issue. Does anyone know how to undo this "improvement" without reverting to an older version of Mathematica?

  • 2
    $\begingroup$ What version information do you get from JDBCDrivers[] ? You can install and resister the version you know works and use it explicitly in your connection. $\endgroup$
    – Edmund
    Commented Apr 28, 2022 at 12:14
  • $\begingroup$ JDBCDrivers[] gives me, among others, JDBCDriver["Name" -> "PostgreSQL", "Driver" -> "org.postgresql.Driver", "Protocol" -> "jdbc:postgresql://", "Version" -> 3.1, "Description" -> "PostgreSQL using PostgreSQL JDBC Driver - Version 42.1.4.", "Location" -> "/Applications/Mathematica.app/Contents/SystemFiles/Links/\ DatabaseLink/DatabaseResources/postgresql.m"] $\endgroup$
    – Matthias
    Commented Apr 28, 2022 at 12:16
  • 3
    $\begingroup$ If that version is not working then download and install the version you need (does not need to be in a Mma install subdirectory). Register it in Mma (see the guide) and they used that registered name in your connections. $\endgroup$
    – Edmund
    Commented Apr 28, 2022 at 12:19
  • $\begingroup$ Similar problem here mathematica.stackexchange.com/questions/253551/… with solution. But that issue was supposedly fixed in 13. :( $\endgroup$ Commented May 4, 2022 at 19:50


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.