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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.