username = "username" //datasource username
password = "password" //datasource password
passwordEncryptionCodec = "org.adroitlogic.isuite.JasyptEncryptionUtil" //encryption codec if the password is encrypted (Optional)Datasource Configuration
Integration Monitor datasource configurations are included in the file app-server-1.0.0/conf/Datasource.groovy. Open that file using a text editor and configure the following parameters.
-
Configure the username and password of the database user as follows. Optionally if an encrypted form of the password is configured, the encryption codec has to be configured as well.
-
Configure the URL, driver class name and the dialect of the datasource as follows. Depending on the type of the datasource, these values differ as mentioned below.
Oracle
url = "jdbc:oracle:thin:@<oracle_host>:<port>:<service_name>"
driverClassName = "oracle.jdbc.OracleDriver"
dialect = "org.hibernate.dialect.OracleDialect"MySQL
url = "jdbc:mysql://<mysql_host>:<port>/<database_name>"
driverClassName = "com.mysql.jdbc.Driver"
dialect = "org.hibernate.dialect.MySQL5InnoDBDialect"-
Optionally the following datasource properties also can be configured if desired, or their default values can be used.
properties {
maxActive = 50
maxIdle = 25
minIdle = 5
initialSize = 5
maxWait = 10000
validationQuery = "SELECT 1 FROM DUAL"
numTestsPerEvictionRun = 3
testOnBorrow = true
testWhileIdle = true
testOnReturn = true
minEvictableIdleTimeMillis = 1000 * 60 * 5
timeBetweenEvictionRunsMillis = 1000 * 60 * 5
}
Please note that this distribution does not contain any database connector jars. Therefore please download the correct JDBC connector jar file based on your database type (and version) from the database vendor and place it on the app-server-1.0.0/lib/ directory.
|
In this topic
In this topic