xad Posted March 6, 2009 Share Posted March 6, 2009 Hi all, I'm using a JDNI connnection to postgres so that I can access a stored procedure. The problem is that I'm using postgres 7.4 which has issues with temp tables and persistent connections. What I need to do is basically disconnect after exach query. How do I go about that? Link to comment Share on other sites More sharing options...
xad Posted March 9, 2009 Author Share Posted March 9, 2009 no one? There must be a setting past the ones in the context.xml. Link to comment Share on other sites More sharing options...
swood Posted March 16, 2009 Share Posted March 16, 2009 The connections are pooled in JasperServer either by JasperServer if it is a JDBC data source, or by the app server if you are using JNDI.Do you need to not pool? If so, you are going to need to create a custom data source. You can base it on the existing JDBC data source code, but create and destory a new connection each time. ShermanJaspersoft Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now