How to configure BPMS 6 to use an external Database?

Solution Verified - Updated -

Issue

  • How to configure BPMS 6 to use an external Database rather than the in-built H2 data store?
    By default, out-of-the-box it points to a datasource java:jboss/datasources/ExampleDS which is configured to use H2 data store in standalone*.xml files.
  • I get the Exception while startup
java.lang.ClassNotFoundException: oracle.sql.BLOB from [Module "deployment.dashbuilder.war:main" from Service Module Loader]
        at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:198)
        at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:363)
        at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:351)
        at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:93)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:264)
        at org.jboss.dashboard.database.hibernate.LOBHelper.oracleNullSafeSet(LOBHelper.java:92)
        at org.jboss.dashboard.database.hibernate.LOBHelper.nullSafeSet(LOBHelper.java:200)
        at org.jboss.dashboard.database.hibernate.LOBHelper$Proxy$_$$_WeldClientProxy.nullSafeSet(Unknown Source)
        at org.jboss.dashboard.database.hibernate.BinaryBlobType.nullSafeSet(BinaryBlobType.java:55)
        at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:158)
        at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2798)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3076)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521)
        at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
        at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303)
        at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349)
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195)
        at org.jboss.dashboard.database.hibernate.HibernateTransaction.flush(HibernateTransaction.java:182)
        at org.jboss.dashboard.database.hibernate.HibernateTransaction.complete(HibernateTransaction.java:153)
        at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeInitiator(HibernateTxFragment.java:182)
        at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:167)
        at org.jboss.dashboard.workspace.GraphicElementManagerImpl.deployBaseElements(GraphicElementManagerImpl.java:140)
        at org.jboss.dashboard.workspace.GraphicElementManagerImpl.start(GraphicElementManagerImpl.java:80)
        at org.jboss.dashboard.workspace.SkinsManagerImpl.start(SkinsManagerImpl.java:35)
        at org.jboss.dashboard.workspace.SkinsManagerImpl$Proxy$_$$_WeldClientProxy.start(Unknown Source)
        at org.jboss.dashboard.annotation.StartableProcessor.wakeUpStartableBeans(StartableProcessor.java:52)
        at org.jboss.dashboard.Application.start(Application.java:74)
        at org.jboss.dashboard.Application$Proxy$_$$_WeldClientProxy.start(Unknown Source)
        at org.jboss.dashboard.ui.controller.ControllerServlet.init(ControllerServlet.java:62)

Environment

  • Red Hat JBoss BPM Suite (BPMS)
    • 6.0.x
    • 6.1.x
    • 6.2.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In