#156 Enable MS Sql Server for Jtrac backend

open
nobody
7
2010-08-25
2010-08-18
No

Currently i am using the MYSQL server as backend database, would like to use the Microsoft Sql Server as backend database, as i know that Jtrac properties file needs to be modified and i have done it for Mysql but wondering how to configure this to connect MS Sql server
database.driver=com.mysql.jdbc.Driver
database.url=jdbc:mysql://localhost/jtrac
database.username=root
database.password=xxxxxxx
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=false

Discussion

  • Manfred Wolff
    Manfred Wolff
    2010-08-18

    The Hibernate Dialect should be org.hibernate.dialect.SQLServerDialect. Perhaps I have no MSSQL Server you should use google ;-).

     
    • priority: 5 --> 7