...
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):
...
<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>
You will have to change the db-version entry to match your version of MS SQL Server.
Testing the Configuration
...