Skip to main content

Glassfish v3 JDBC setup for active/passive databases

1 reply [Last post]
Glassfish v3 JDBC setup for active/passive databases
February 10, 2012 - 05:36
jsavel
Offline
Joined: 2012-01-19
Points: 0

Hello,

I have configured JDBC Connection Pool for Postgres DB and deployed my application. As I want to complete my HA on DB side, I am using Slony-I replication mechanism. To complete this, I need to somehow tell to my Glassfish JDBC Connection Pool in case of active DB is down, to use my backup DB.

1. Is there any internal function in Glassfishv3 to do that?

2. Does anyone have any such example in Persistence.xml to serve both primary and backup DB? In my Persistence.xml I am using jdbc/<app name> to direct to my JDBC resource

Thanks,

Jan

‹ GF3.1.2_b20: Exception while trying to weave class Database (User) Connection per Http Session (User), how? ›

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Re: Glassfish v3 JDBC setup for active/passive databases
February 22, 2012 - 02:14
#1
jsavel
Offline
Joined: 2012-01-19
Points: 0

Hello,

I have found some solution, it is called Sequoia. It may have a limitation as last blogs I found are at least two years old.

Has anybody experiences with Sequoia s far?

Jan