Differences
This shows you the differences between two versions of the page.
|
databaseconfiguration [2011/06/30 12:37] predrag.radenkovic [Database Configuration] |
databaseconfiguration [2011/06/30 15:35] (current) milorad.poptosic |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| The database to be used in a SOLoist application is configured by way of a db.properties file. | The database to be used in a SOLoist application is configured by way of a db.properties file. | ||
| - | Currently, SOLoist supports Oracle, Sybase SQL Anywhere, MySQL databases, but any other RDBMS that supports the usual relational paradigm, SQL (Structured Query Language), and ODBC can be easily supported, too. In the Empty Project, which can be downloaded from [[http://www.soloist4uml.com/downloads|SOLoist Website Download Section]] there are three db.properties files for each supported database. You will have to rename appropriate db.properties file depending on which RDBMS you will use. | + | Currently, SOLoist supports Oracle, Sybase SQL Anywhere, MySQL databases, but any other RDBMS that supports the usual relational paradigm, SQL (Structured Query Language), and ODBC can be easily supported, too. In the Empty Project, which can be downloaded from [[http://www.soloist4uml.com/downloads|SOLoist Website Download Section]] there are three db.properties files for each supported database. You will have to rename appropriate properties file to db.properties depending on which RDBMS you will use. |
| Before you start configuring database for a SOLoist application, you need to create a database schema, and add a user with appropriate privileges for that schema. Be sure to memorize or write down the schema name, user name and password, beacuse you will need to enter them into the db.properties file. | Before you start configuring database for a SOLoist application, you need to create a database schema, and add a user with appropriate privileges for that schema. Be sure to memorize or write down the schema name, user name and password, beacuse you will need to enter them into the db.properties file. | ||
| ===== Properties ===== | ===== Properties ===== | ||
| + | The most important settings are described below. For a full description of all options, see [[http://commons.apache.org/dbcp/configuration.html|DBCP Configuration]]. | ||
| ==== database ==== | ==== database ==== | ||
| This property specifies the RDBMS to be used. It can be one of the following: mysql, oracle, sybase_asa. | This property specifies the RDBMS to be used. It can be one of the following: mysql, oracle, sybase_asa. | ||
| Line 20: | Line 20: | ||
| It is highly recommended to set this property to false, as otherwise SOLoist transactions will not work. | It is highly recommended to set this property to false, as otherwise SOLoist transactions will not work. | ||
| Find out [[http://download.oracle.com/javase/tutorial/jdbc/basics/transactions.html#disable_auto_commit|more about the auto-commit mode]]. | Find out [[http://download.oracle.com/javase/tutorial/jdbc/basics/transactions.html#disable_auto_commit|more about the auto-commit mode]]. | ||
| + | |||
| In sections which follow, it is shown how to configure the most important settings for the three supported databases. | In sections which follow, it is shown how to configure the most important settings for the three supported databases. | ||
| Line 48: | Line 49: | ||
| password=sol_user | password=sol_user | ||
| </file> | </file> | ||
| - | |||
| - | ===== Additional Options ===== | ||
| ===== Security Issues ===== | ===== Security Issues ===== | ||
