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
- 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).
<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.x.x/filters/local.properties file and add your database information (Note: for ease of development we generally suggest leaving local.properties with hsql and adjusting dev.properties, test.properties, and prod.properties to your chosen DB. If you do this, pass "-Denv=dev" or whatever on your ant commands; e.g. "ant -Denv=dev dbtest").
## 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 # For SQL Server 2008+, you may want to have dialect set to org.hibernate.dialect.SQLServer2008Dialect
Step 4: Test the Configuration
Running the dbtest
ant target will tell you if you have configured the database connection properly.
ant dbtest
Step 5: Build and Deploy
Following a successful test, you can execute the command below to build the database tables and copy files to your servlet container.
ant clean initportal
Step 6: Restart Tomcat