You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 8
Next »
Step 1: Obtain the MS JDBC driver
Step 2: Add the dependency to your pom.xml
- Add the sqljdbc4.jar dependency to your pom.xml (Version 4 of the sqljdbc driver is required)
<jdbc.groupId>com.microsoft.sqlserver</jdbc.groupId>
<jdbc.artifactId>sqljdbc4</jdbc.artifactId>
<jdbc.version>4.0</jdbc.version>
<dependencies>
...
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
</dependency>
...
</dependencies>
Step 3: Edit the filters/local.properties file
- Open the uPortal/filters/local.properties file and add your database information
## HSQL Configuration
environment.build.hsql.port=8887
## Database Connection Settings (Uncomment the Maven Filters section in rdbm.properties)
environment.build.hibernate.connection.driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver
environment.build.hibernate.connection.url=jdbc:sqlserver://<servername>:<port>;databaseName=<databasename>
environment.build.hibernate.connection.username=username
environment.build.hibernate.connection.password=password
environment.build.hibernate.dialect=org.hibernate.dialect.SQLServerDialect
Step 4: Redeploy and Restart uPortal