Child pages
  • Using External Database

Versions Compared

Key

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

It's possible to use You can use an external database with license serverLicense Server. The following databases are supported:

  • MySQL 5
  • Sybase Adaptive Server Enterprise (ASE) 15

To change migrate to an external database, edit make the following modifications to licenseServer.war/WEB-INF/classes/META-INF/modelContext.xml. Comment 2 places (jdbc connection & toplink's database dialect) with embedded database specification , and uncomment samples relevant to your database. Specify database connection parameters:

  1. In org.apache.commons.dbcp.BasicDataSource bean properties, comment out driverClassName property referencing the embedded database, and uncomment driverClassName property corresponding to the external database of your choice.
  2. In org.springframework.orm.jpa.vendor.TopLinkJpaVendorAdapter bean properties, comment out databasePlatform property that references oracle.toplink.essentials.platform.database.DerbyPlatform SQL dialect, and uncomment the databasePlatform property corresponding to the external database of your choice.
  3. Replace default values for url, username, and password properties of dataSource bean with production values. Make sure to set necessary database connection settings using the url property.