Is it possible to switch BDM database from H2 to MySql in community edition?
Hi,
I followed the documentation for
Database configuration
Database configuration for business data
and made all changes to switch DB from H2 to MySql.
I was able to start the TOMCAT and studio successfully.
Once i create a business data and tried to save it i am getting below error.
Where else i need to modify to have BDM switch from H2 to MySql?
An error occurred while deploying the Business Data Model in engine
org.bonitasoft.studio.engine.server.PortConfigurator.findListenerWithClassName(PortConfigurator.java:171)
org.bonitasoft.studio.engine.server.PortConfigurator.h2TCPPort(PortConfigurator.java:157)
org.bonitasoft.studio.engine.server.PortConfigurator.h2PortInUse(PortConfigurator.java:110)
org.bonitasoft.studio.engine.server.PortConfigurator.canStartH2Server(PortConfigurator.java:100)
org.bonitasoft.studio.engine.BOSWebServerManager.createServer(BOSWebServerManager.java:381)
org.bonitasoft.studio.engine.BOSWebServerManager.startServer(BOSWebServerManager.java:212)
org.bonitasoft.studio.engine.BOSEngineManager.start(BOSEngineManager.java:132)
org.bonitasoft.studio.engine.BOSEngineManager.loginTenant(BOSEngineManager.java:257)
org.bonitasoft.studio.engine.BOSEngineManager.loginDefaultTenant(BOSEngineManager.java:242)
org.bonitasoft.studio.businessobject.core.operation.DeployBDMOperation.login(DeployBDMOperation.java:88)
org.bonitasoft.studio.businessobject.core.operation.DeployBDMOperation.run(DeployBDMOperation.java:77)
org.bonitasoft.studio.businessobject.ui.wizard.ManageBusinessDataModelWizard$2.run(ManageBusinessDataModelWizard.java:152)
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
Thanks,
Phani
has anyone found a solution to that problem:
An error occured during synchronization
org.bonitasoft.studio.actors.operation.PublishOrganizationOperation.run(PublishOrganizationOperation.java:106)
org.bonitasoft.studio.actors.ui.handler.InstallOrganizationHandler.execute(InstallOrganizationHandler.java:70)
org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:294)
org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:55)
org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:247)
org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:229)
org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)
org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:149)
org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)
org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)
org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:210)
org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:343)
org.bonitasoft.studio.actors.ui.wizard.SynchronizeOrganizationWizard$1.run(SynchronizeOrganizationWizard.java:115)
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
if so your solution will be greatly appreciated.
Thanx in advance.
It is not recommended (or possible that I know of) to change Studio from H2 to another database, it is only possible to change the production style Portal.
There is another piece of documentation that says how to change the BDM database here:
http://documentation.bonitasoft.com/database-configuration-business-data-1
It is separate from the normal, change the database information and I think should be put together with it. Made easier in other words.
regards