users@glassfish.java.net

Re: Configuration of jdbc connection pool with mssql

From: <forums_at_java.net>
Date: Mon, 27 Jun 2011 00:00:44 -0500 (CDT)

Have you set all the properties of the jdbc connection pool to the
appropriate values? A sample jdbc connection pool configuration from the
domain.xml for a mssql server 2005 looks like :

<jdbc-connection-pool
        name="microsoft_sqlserver2005_pool"
       
datasource-classname="com.microsoft.sqlserver.jdbc.SQLServerDataSource"
        res-type="javax.sql.DataSource">
        <property name="user" value="DB_USER"/>
        <property name="password" value="DB_PASSWORD"/>
        <property name="serverName" value="DB_HOSTNAME"/>
        <property name="portNumber" value="1433"/>
        <property name="databaseName" value="DATABASE_NAME"/>
    </jdbc-connection-pool>
 

Also make sure that the database is running in the host/port mentioned.


--
[Message sent by forum member 'sm157516']
View Post: http://forums.java.net/node/816236