We apologize for untranslated text, you can use the Google Translation button to get an automatic translation of the web page in the language of your choice.

SQL Server Plugin

Description

This plugin adds the support for Microsoft SQL Server. Compatible versions should be consulted in installation manual. This version introduces the use of a nes JDBC library : SqlJdbc 4


Installation

Configuration

SQLServer

  • Add a new Database named jcmsdb.
  • The database must support UTF-8 encoding.
  • Create a new user jcms allowed to managed this Database.

JCMS

  • Go to Admin Area > Properties Editor > Database.
  • Select SQLServer in the RDBMS list box.
  • Enter the JDBC URL for SQLServer. Example: jdbc:jtds:sqlserver://localhost:1433/jcmsdb
  • Enter the name (jcms) and the password to access to the jcmsdb database.
  • Click on Check Connection...
  • Once the database connection has been established successfully , save and restart JCMS

Migration

If the database has been created by a previous version of the plugin, a migration step is needed.

The Hibernate dialect has been changed and all datetime fields of the database should be replaced by datetime2 fields.

Si la base a été créée avec la précédente version du module, il faudra effectuer un procédure de migration. En effet les champs de type datetime doivent maintenant être des champs de type datetime2.


Information

Version
  • 2.0
Stability
  • Stable
Compatibility
  • JCMS 9
    JPlatform 10
Certified by Jalios
  • Yes
Price
  • Module gratuit
Support
  • Jalios Support
Author
  • Jalios SA
License
  • Jalios
Size
  • 550.87 KB
Updated
  • 10/25/17
Download
  • 44
Domains