Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...