I am working on program in Java that can connect to PostgreSQL multiple databases. Problem occurs when I want to reconnect to other database on the same server. I am using JDBC postgresql driver and whenever I try to close old connection and create new I get an exception:
org.postgresql.util.PSQLException: Something unusual has occured to cause the driver to fail. Please report this exception.
Is there any way to reconnect to other database?
duffymo :
I'd recommend creating the connection when you need it and closing it when you're done in the narrowest scope possible.\n\nI'd also advise you to set up connection pools, one for each database you might connect to.",
2013-03-04T21:03:09