failed to update mysql jdbc connector

Q&A
1

Hi,it is my first time to bonita(2021.1) community edition.

I have a simple task that needs to connect to an external database (mysql 8.0.26) using a connector (default: mysql 5.5 jdbc database query 4), but there is an error, I searched a lot and found that the reason is probably the lack of compatibility between versions. So I tried to add file (mysql-connector-java 8.0.26.jar) to tomcat path and to my project in bonita in java dependencies and make this file active when should select or add database driver but it didn't work, and I still had the same error:

 

Error creating SQL Model Connection connection to database. (Error: Could not create connection to database server. Attempted reconnect 5 times. Giving up.)
org.bonitasoft.studio.common.jface.BonitaErrorDialog.<init>(BonitaErrorDialog.java:65)
org.bonitasoft.studio.sqlbuilder.ex.wizard.AbstractConnectDBWizardWizardPage$5.run(AbstractConnectDBWizardWizardPage.java:406)
org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)
org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:185)
org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4005)
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3633)
org.eclipse.jface.operation.ModalContext$ModalContextThread.block(ModalContext.java:166)
org.eclipse.jface.operation.ModalContext.run(ModalContext.java:368)
org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:1033)
org.bonitasoft.studio.sqlbuilder.ex.wizard.AbstractConnectDBWizardWizardPage$2.widgetSelected(AbstractConnectDBWizardWizardPage.java:241)
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
org.eclipse.swt.widgets.Display.sendEvent(Display.java:4213)
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1037)
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4030)
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3630)
org.eclipse.jface.window.Window.runEventLoop(Window.java:823)
org.eclipse.jface.window.Window.open(Window.java:799)
org.bonitasoft.studio.connectors.ui.property.section.ConnectorSection$3.widgetSelected(ConnectorSection.java:264)
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
org.eclipse.swt.widgets.Display.sendEvent(Display.java:4213)
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1037)
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4030)
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3630)
org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1158)
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1047)
org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)
org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:658)
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:557)
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:154)
org.bonitasoft.studio.application.BonitaStudioApplication.createAndRunWorkbench(BonitaStudioApplication.java:137)
org.bonitasoft.studio.application.BonitaStudioApplication.start(BonitaStudioApplication.java:100)
org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:137)
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:107)
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:401)
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.base/java.lang.reflect.Method.invoke(Unknown Source)
org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:657)
org.eclipse.equinox.launcher.Main.basicRun(Main.java:594)
org.eclipse.equinox.launcher.Main.run(Main.java:1447)
 

What should I do, I have tried many solutions but no use 

EDIT

I found another solution :in database access information window I just select ((use a text editor)) instead of ((use graphical query builder))

 

2

Hello,

When using the MySQL connector in a process Bonita automatically embeds the mysql-connector-java 8.0.23.jar (at the time of writing). You do not have to manage drivers on your own (no need to add dependencies nor trying to load them, etc...)

From what I gather from your message, the versions should be compatible. Have you verified that the database server you are trying to reach is accessible (server up, URL valid, username and password valid, etc...)? 

Captain Bonita

3

Hello,

when I delete (mysql-connector-java 8.0.26.jar) and depend on the default file(mysql-connector-java 5.1.23-bin.jar) I still have the same error.

I tried to use DbSchema and made it connecting  to mysql database with the same (URL,Username,Password  )used in Bonita, it could  connecting with no problem .just in bonita I can not connect with the same url ,password , username to mysql database.

jdbc url:jdbc:mysql://localhost:3306/db_full_company?autoReconnect=true&useSSL=false&maxReconnects=5&enabledTLSProtocols=TLSv1.2&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

I also tried to add bind_address=

"127.0.0.1"

in my.ini ,but no use.