Using SQL Server 2005 with Address Book Server

Before you begin making changes you need to create a new database. The following instructions assume the database name to be addressbook however you can change this to whatever you like. If you do change the database name, you will also need to change the configuration files below.

The configuration files containing the database connection parameters can be found in :

/usr/share/addressBookServerEnterpriseEdition/apache-tomcat-6.0.18/

Disable H2 from starting automatically by setting the flag to false in the configuration file

bin/setenv.sh

JAVA_OPTS="$JAVA_OPTS -Dcom.addressbookserver.ENABLE_H2=false"

conf/server.xml

In the server.xml you need to configure your database connection setting. Typically this means specifying the host and access credential you use to access your database. This has to be done twice as Address Book Server used multiple connection pool, one during standard operation and another to authenticate web users. Both connection pools should point to the same database.

...
<Resource name="jdbc/AddressBookDB" auth="Container" type="javax.sql.DataSource"
   maxActive="25" maxIdle="5" maxWait="-1"
   username="sa" password="" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
   url="jdbc:sqlserver://localhost:1433;DatabaseName=AddressBookDB"/>
<Realm className="org.apache.catalina.realm.JDBCRealm"
  driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
  connectionURL="jdbc:sqlserver://localhost:1433;DatabaseName=AddressBookDB"
  connectionName="sa" connectionPassword=""
  userTable="WebUsers" userNameCol="userid" userCredCol="password"
  userRoleTable="UserRoles" roleNameCol="accessRole"/>
...

lib/META-INF/persistence.xml

...
<property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>
...

The SQL Server JDCB driver is available from  Microsoft JDBC Driver. The JAR file should be placed in lib directory.

After changing the server.xml file restart tomcat using the instruction : Restarting Address Book Server