...
- 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
- From the uPortal source directory, open the uPortal-4.x.x/pom.xml file and add the sqljdbc4.jar dependency to your pom.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:
...
Configure the Database Filter
- From the uPortal source directory, open the uPortal-4.0x.x/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:
...
Test the Configuration
Running the dbtest ant target will tell you if you have configured the database connection properly.
| Code Block |
|---|
ant cleandbtest deploy-war |
Step 5: Deploy
Following a successful test, you can execute the command below to build the database tables and copy files to your servlet container.
| Code Block |
|---|
ant initportal |
Step 6: Restart Tomcat
| Info | ||||
|---|---|---|---|---|
| ||||
...