Configuration base de données mysql
Bonjour,
J'ai configuré la base de données par defaut de bonita pour mysql;
ca donne une erreur comme ca:
[INFO] configuration for Database vendor: mysql
[ERROR] HikariPool-1 - Exception during pool initialization.
java.sql.SQLSyntaxErrorException: Base 'bonita.db' inconnue
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at org.bonitasoft.platform.setup.PlatformSetup.initDataSource(PlatformSetup.java:449)
at org.bonitasoft.platform.setup.PlatformSetup.initPlatformSetup(PlatformSetup.java:479)
at org.bonitasoft.platform.setup.PlatformSetup.init(PlatformSetup.java:98)
at org.bonitasoft.platform.setup.command.InitCommand.execute(InitCommand.java:45)
at org.bonitasoft.platform.setup.PlatformSetupApplication.execute(PlatformSetupApplication.java:105)
at org.bonitasoft.platform.setup.PlatformSetupApplication.run(PlatformSetupApplication.java:79)
at org.bonitasoft.platform.setup.PlatformSetupApplication.main(PlatformSetupApplication.java:64)
[ERROR] java.sql.SQLSyntaxErrorException: Base 'bonita.db' inconnue
[ERROR] You might get more detailed information about the error by adding '--debug' to the command line, and run again
Appuyez sur une touche pour continuer...
NB: la connexion avec l'utilisateur marche tres bien
- J'utilise mysql 8.0.18
- J'ai crée une base appelée bonita et business_data
voici les modification que j'ai fait dans le fichier database.proprieties:
#
Bonita database properties
#
valid values are (h2, postgres, sqlserver, oracle, mysql)
db.vendor=mysql
when using h2, no server or port setting is needed since connexion is made using file protocol mode using relative directory:
db.server.name=localhost
db.server.port=3308
if your database name contains a backslash () character, you must double it (\):
db.database.name=bonita.db
db.user=root
if your database password contains a backslash () character, you must double it (\):
db.password=
#
Business Data database properties
#
valid values are (h2, postgres, sqlserver, oracle, mysql)
bdm.db.vendor=mysql
bdm.db.server.name=localhost
bdm.db.server.port=3308
bdm.db.database.name=business_data.db
bdm.db.user=root
bdm.db.password=
Merci pour l'aide