Manual Page Under Construction
Work in progress
Step 1: Obtain the MS JDBC driver
- The MS JDBC driver can be obtained here: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
Step 2: Add the dependency to your pom.xml
- Add the sqljdbc4.jar dependency to your pom.xml
<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 4: 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