PostgreSQL is giving me a couple of issues, and I'...

# exposed

[Hamza]

PostgreSQL is giving me a couple of issues, and I'm not sure what the issue is. I have a simple main fuction at the moment with just connects to my database, and a transaction. i simple application is giving me the error Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
which is quite curious

Database.connect(
        url = "jdbc:<postgresql://localhost:5432/library>",
        user = "hm",
        password = "wouldn't u like to know",
        driver = "org.postgresql.Driver"
    )

    transaction {
        Books.select { Op.TRUE }.forEach(::println)
    }

[tapac]

What is Books? Do you have custom toString on it?

[Hamza]

The issue was that I was using a too recent version of PostgreSQL. Using the version in the wiki solved the issue

[tapac]

What was an issue? And on which Postgresql version?

[Hamza]

the issue was that any insert operation caused a This ResultSet is closed. error

[Hamza]

let me get the version i was using

[Hamza]

@tapac I was using version 9.1-901-1.jdbc instead of the recomended 42.2.2

--
https://mvnrepository.com/artifact/postgresql/postgresql/9.1-901-1.jdbc4