users@glassfish.java.net

Re: Providing failover? Using glassfish and ms sql server database mirrorin

From: <glassfish_at_javadesktop.org>
Date: Tue, 12 Aug 2008 06:02:34 PDT

under glassfish admin console:
resource->jdbc->connection pool
new
Name : persistent unit name
Resource Type: javax.sql.XADataSource
Resource Type: microsofst sql server
next
New JDBC Connection Pool (Step 2 of 2):
Datasource classname: com.microsoft.sqlserver.jdbc.SQLServerXADataSource
Additional Property:
URL:jdbc:sqlserver://ip_A;port=1433;failoverPartner=ip_B;databaseName=testDB;integratedSecurity=true;loginTimeout=5

You need to download microsoft jdbc driver and sqljdbc_auth.dll from:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en
and put them under:
<glassfish>\domains\domain1\lib\ext

restart glassfish

That's what I have done
[Message sent by forum member 'imyst918' (imyst918)]

http://forums.java.net/jive/thread.jspa?messageID=292844