Connecting to other database postgresql JDBC

Question

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?

Without seeing the code you're using and the full, exact text of the error message and associated stack trace, it's nearly impossible to say. — Craig Ringer
– Craig Ringer, Commented Mar 4, 2013 at 23:58

duffymo · Accepted Answer · 2013-03-04 21:03:09Z

1

I'd recommend creating the connection when you need it and closing it when you're done in the narrowest scope possible.

I'd also advise you to set up connection pools, one for each database you might connect to.

answered Mar 4, 2013 at 21:03

duffymo

310k46 gold badges376 silver badges570 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pfulop · Accepted Answer · 2013-03-05 21:47:45Z

0

I didn't notice that there is another exception under the first one. The second exception was the real problem. I was running reconnecting on main thread. Putting it in the own thread solved the problem.

answered Mar 5, 2013 at 21:47

pfulop

1,00913 silver badges24 bronze badges

Collectives™ on Stack Overflow

Connecting to other database postgresql JDBC

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related