i'm trying connect failover cluster using glassfish connection pooling. resource type xadatasource
, classname jtdsdatasource
. additional properties are:
- user
- databasename
- password
- portnumber
- servername
all of these work connecting have been unable find correct property name connecting mirror database. on basis of page https://msdn.microsoft.com/en-us/library/ms175484.aspx i've tried failoverpartner
, failover_partner
during testing primary database brought down while server running glassfish still trying connect primary.
with nothing else go on regarding particular scenario, ask specific property name used specify mirror database in glassfish.
thanks in advance.
setting of database mirroring has little glassfish in particular, must supported jdbc driver.
it seems using jtds driver connect ms sql. unfortunately, does not support database mirroring - guys in question discuss possibilities create wrapper around driver, if cannot afford switch driver.
you may better off official driver microsoft. should support failoverpartner parameter in connection string.
Comments
Post a Comment