...
Opening /uPortal/pom.xml, there is a section about 92 110 lines down that reads:
| Code Block | ||||
|---|---|---|---|---|
| ||||
<!-- The JDBC Driver used by uPortal -->
<jdbc.groupId>hsqldb</jdbc.groupId>
<jdbc.artifactId>hsqldb</jdbc.artifactId>
<jdbc.version>${hsqldb.version}</jdbc.version>
|
...
| Code Block |
|---|
##### Microsoft SQL Server
hibernate.connection.driver_class=net.sourceforge.jtds.jdbc.Driver
hibernate.connection.url=jdbc:jtds:sqlserver://my.school.edu:1433/uPortal3db
hibernate.connection.username=test
hibernate.connection.password=mypass
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
|
Edit /uPortal/uportal-impl/src/main/resources/properties/db/dbloader.xml by adding the following entry (if it does not already exist):
| Code Block | ||
|---|---|---|
| xml | xml |
<db-type-mapping>
<db-name>Microsoft SQL Server</db-name>
<db-version>09.00.2047</db-version>
<driver-name>jTDS Type 4 JDBC Driver for MS SQL Server and Sybase</driver-name>
<driver-version>1.3</driver-version>
<type><generic>INTEGER</generic><local>INTEGER</local></type>
<type><generic>VARCHAR</generic><local>VARCHAR</local></type>
<type><generic>TEXT</generic><local>TEXT</local></type>
<type><generic>TIMESTAMP</generic><local>DATETIME</local></type>
<type><generic>LONGVARCHAR</generic><local>NTEXT</local></type>
</db-type-mapping>
|
...
Testing the Configuration
...
Much of the information on this page was provided by ~bneupane Bikrant Neupane on the uportal-user list. Thanks.
| Warning | ||||
|---|---|---|---|---|
| ||||
Please send us feedback at uportal-user@lists.ja-sig.org |