I don't know if this is relevant or helpful but ...
We use Glassfish with SQL Server and heres a clip from domain.xml for our
connection pool:
<jdbc-connection-pool
datasource-classname="net.sourceforge.jtds.jdbcx.JtdsDataSource"
res-type="javax.sql.ConnectionPoolDataSource" description="ELECT DB LIVE"
name="ELECT_BERLIN" ping="true">
<property name="databaseName" value="ELECT9" />
<property name="password" value="xxxxxx" />
<property name="portNumber" value="1433" />
<property name="roleName" value="dbo" />
<property name="serverName" value="BERLIN" />
<property name="user" value="xxxx" />
<property name="instance" value="SQLexpress" />
</jdbc-connection-pool>
Some of the "extras" such as /roleName/ are added on the /Additional
Properties/ tab. The /instance/ is really to discriminate between multiple
instances of SQL Server running on the same physical server, but using
SQLexpress (I seem to remember) always requires this property.
--
[Message sent by forum member 'joerobbins']
View Post: http://forums.java.net/node/709407