Note | ||
---|---|---|
| ||
Work in progress |
Step 1: Obtain the MS JDBC driver
...
- Add the sqljdbc4.jar dependency to your pom.xml xml (Version 4 of the sqljdbc driver is required)
Code Block |
---|
<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
Code Block |
---|
## 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
Info | ||||
---|---|---|---|---|
| ||||
...