Database (Preferences)

From COSSAN Wiki
Jump to: navigation, search

The Database is used to store and retrieve information from previous analyses.

Settings

To get started, COSSAN-X can be automatically configured to create and use a local SQLite database. Alternatively, a dedicated MySQL database can be used.

  • Database Driver: Select the database (driver) type that you would like to use.
  • JDBC Driver: The JDBC driver name (populated automatically depending on choice of Database Driver).
  • JDBC Address: The location/URL of the database server (populated automatically, providing example syntax).
  • Name of the Database: The name of the database to be used.
  • Username: The username for connecting to the database.
  • Password: The password for connecting to the database (not visible).
  • Simulation Database Query: This will become populated automatically when the first custom query has been run. Custom queries can also be edited in this field.
  • Solver Database Query: This will become populated automatically when the first custom query has been run. Custom queries can also be edited in this field.
  • Result Database Query: This will become populated automatically when the first custom query has been run. Custom queries can also be edited in this field.
Database.png

SQLite Driver

If selecting the SQLite option, all necessary configuration settings will be automatically populated.

To use the SQLite driver

  1. Select Database Driver: SQLite
  2. It is recommended to leave the default settings (though if required the location and/or database name can be changed).
  3. Apply the settings, and choose OK to exit the preferences window.
  4. Close COSSAN-X and then re-open it.

If default settings were chosen, the database will be created automatically in the ‘cossanx_worskpace’ folder, which can be noted by the appearance of the cossanx.db file.


MySQL Driver

To use a MySQL server,

  1. Select Database Driver: MySQL
  2. Enter details of the database:
    1. location
    2. name
    3. username (with appropriate permissions to write to and modify the database)
    4. password
  3. Apply the settings, and choose OK to exit the preferences window.

The MySQL driver is now ready for use.