Versions Compared

Old Version 10

changes.mady.by.user Jan Pechanec

Saved on

compared with

New Version Current

changes.mady.by.user DamienD

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

Database configuration notes

  • It's necessary to enable TCP access to your SQL Server database, as JDBC is a TCP-based protocol. You could do it by SQL Server Configuration Manager - item SQL Server Network Configuration.
  • SQL Server Express - check your TCP port in SQL Server Network Configuration - dcm4chee connects by default to 1433.
  • Your database user pacs should have it's Default language set to English. Otherwise you would get error messages like "java.sql.SQLException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.".

Download the JDBC driver and install it

...

To use the default configuration, download this driver from the jTDS website, and copy the driver JAR file to server/default/lib.

You may also instead use the Microsoft JDBC driver, but you'll have to modify the datasource files directly to reflect the correct driver name (com.microsoft.sqlserver.jdbc.SQLServerDriver) and JDBC URL (jdbc:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=pacsdb). Using the Microsoft distributed driver may have some benefit, based on your usage, because it provides support for mirrored database deployments. Do your research and make your own decision, but the jTDS driver will get you up and running quickly with the least hassle.

...