Spring JDBC and the PostgreSQL JDBC driver

From: "Miller, Michael W" <michael(dot)w(dot)miller(at)lmco(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Spring JDBC and the PostgreSQL JDBC driver
Date: 2014-04-03 16:10:39
Message-ID: 8BF569EED6720F4FA6CF7D7112FB8B255ED83906@HVXDSP41.us.lmco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I apologize if this is not the correct place to post this question but who do I talk to about modifying the functionality of the JDBC driver?

The issue I'm running into is the interaction between the Spring Framework JDBC functionality and the PostgreSQL JDBC driver. The specific issue is that I'm using SimpleJdbcCall.execute() to call the database and getting back a Jdbc4Array. When I then try to do something like Jdbc4Array.getArray() I get a SQL error that can be tracked down to the Jdbc driver trying to use a connection object which has already been closed by the Spring Framework.

One of the benefits of the Spring Framework is that I don't have to bother with the drudge work like creating\closing connections. The drawback seems to be that the JDBC driver is making assumptions like the connection is still open.

What I 'm looking for is someone who is familiar with the JDBC driver who can say "Yes, it's worthwhile to add this functionality to the driver." Or "No, we should be looking at alternative ways to solve the problem."

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-04-03 16:13:59 Re: Spring JDBC and the PostgreSQL JDBC driver
Previous Message David Johnston 2014-04-03 16:09:29 Re: window function help