Databases
StackOverflow2013
Postsdbo
POHow to deploy jBPM 3.2.2 console on Oracle 10g iAS
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to deploy jBPM 3.2.2 console on Oracle 10g iAS
    primarykey
    data
    text
    <p>Does anybody have experience regarding deployment of the jBPM Administration Console on Oracle 10g iAS?</p> <p>I successfully deployed it using an .ear, security mappings working, I can even login to the console, Hibernate finds the JNDI datasource but it cannot find the TransactionManager. I see no log, only the exception thrown in the jsf page: </p> <p><a href="http://i28.tinypic.com/b6obh5.jpg" rel="nofollow noreferrer">The error, TransactionManager not found http://i28.tinypic.com/b6obh5.jpg</a></p> <p>Can anybody help me? </p> <p>The hibernate.cfg.xml file now looks like this:</p> <pre><code> &lt;?xml version='1.0' encoding='utf-8'?&gt; &lt;!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"&gt; &lt;hibernate-configuration&gt; &lt;session-factory&gt; &lt;!-- hibernate dialect --&gt; &lt;property name="hibernate.dialect"&gt;org.hibernate.dialect.Oracle9Dialect&lt;/property&gt; &lt;!-- JDBC connection properties (begin) === &lt;property name="hibernate.connection.driver_class"&gt;org.hsqldb.jdbcDriver&lt;/property&gt; &lt;property name="hibernate.connection.url"&gt;jdbc:hsqldb:mem:jbpm&lt;/property&gt; &lt;property name="hibernate.connection.username"&gt;sa&lt;/property&gt; &lt;property name="hibernate.connection.password"&gt;&lt;/property&gt; ==== JDBC connection properties (end) --&gt; &lt;property name="hibernate.cache.provider_class"&gt;org.hibernate.cache.HashtableCacheProvider&lt;/property&gt; &lt;!-- DataSource properties (begin) --&gt; &lt;property name="hibernate.connection.datasource"&gt;java:/JbpmDS&lt;/property&gt; &lt;!-- DataSource properties (end) --&gt; &lt;!-- JTA transaction properties (begin) --&gt; &lt;property name="hibernate.transaction.factory_class"&gt;org.hibernate.transaction.JTATransactionFactory&lt;/property&gt; &lt;!-- &lt;property name="hibernate.transaction.manager_lookup_class"&gt;org.hibernate.transaction.JBossTransactionManagerLookup&lt;/property&gt;--&gt; &lt;!-- JTA transaction properties (end) --&gt; &lt;!-- CMT transaction properties (begin) === &lt;property name="hibernate.transaction.factory_class"&gt;org.hibernate.transaction.CMTTransactionFactory&lt;/property&gt; &lt;property name="hibernate.transaction.manager_lookup_class"&gt;org.hibernate.transaction.JBossTransactionManagerLookup&lt;/property&gt; ==== CMT transaction properties (end) --&gt; &lt;!-- logging properties (begin) --&gt; &lt;property name="hibernate.show_sql"&gt;true&lt;/property&gt; &lt;property name="hibernate.format_sql"&gt;true&lt;/property&gt; &lt;property name="hibernate.use_sql_comments"&gt;true&lt;/property&gt; &lt;--==== logging properties (end) --&gt; &lt;!-- ############################################ --&gt; &lt;!-- # mapping files with external dependencies # --&gt; &lt;!-- ############################################ --&gt; &lt;!-- following mapping file has a dependendy on --&gt; &lt;!-- 'bsh-{version}.jar'. --&gt; &lt;!-- uncomment this if you don't have bsh on your --&gt; &lt;!-- classpath. you won't be able to use the --&gt; &lt;!-- script element in process definition files --&gt; &lt;mapping resource="org/jbpm/graph/action/Script.hbm.xml"/&gt; &lt;!-- following mapping files have a dependendy on --&gt; &lt;!-- 'jbpm-identity.jar', mapping files --&gt; &lt;!-- of the pluggable jbpm identity component. --&gt; &lt;!-- Uncomment the following 3 lines if you --&gt; &lt;!-- want to use the jBPM identity mgmgt --&gt; &lt;!-- component. --&gt; &lt;!-- identity mappings (begin) --&gt; &lt;mapping resource="org/jbpm/identity/User.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/identity/Group.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/identity/Membership.hbm.xml"/&gt; &lt;!-- identity mappings (end) --&gt; &lt;!-- following mapping files have a dependendy on --&gt; &lt;!-- the JCR API --&gt; &lt;!-- jcr mappings (begin) === &lt;mapping resource="org/jbpm/context/exe/variableinstance/JcrNodeInstance.hbm.xml"/&gt; ==== jcr mappings (end) --&gt; &lt;!-- ###################### --&gt; &lt;!-- # jbpm mapping files # --&gt; &lt;!-- ###################### --&gt; &lt;!-- hql queries and type defs --&gt; &lt;mapping resource="org/jbpm/db/hibernate.queries.hbm.xml" /&gt; &lt;!-- graph.action mapping files --&gt; &lt;mapping resource="org/jbpm/graph/action/MailAction.hbm.xml"/&gt; &lt;!-- graph.def mapping files --&gt; &lt;mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/def/Node.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/def/Event.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/def/Action.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/&gt; &lt;!-- graph.node mapping files --&gt; &lt;mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/node/Join.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/node/MailNode.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/node/State.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/&gt; &lt;!-- context.def mapping files --&gt; &lt;mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/&gt; &lt;!-- taskmgmt.def mapping files --&gt; &lt;mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/&gt; &lt;!-- module.def mapping files --&gt; &lt;mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/&gt; &lt;!-- bytes mapping files --&gt; &lt;mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/&gt; &lt;!-- file.def mapping files --&gt; &lt;mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/&gt; &lt;!-- scheduler.def mapping files --&gt; &lt;mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/&gt; &lt;!-- graph.exe mapping files --&gt; &lt;mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/&gt; &lt;!-- module.exe mapping files --&gt; &lt;mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/&gt; &lt;!-- context.exe mapping files --&gt; &lt;mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/&gt; &lt;!-- job mapping files --&gt; &lt;mapping resource="org/jbpm/job/Job.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/job/Timer.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/job/ExecuteNodeJob.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/job/ExecuteActionJob.hbm.xml"/&gt; &lt;!-- taskmgmt.exe mapping files --&gt; &lt;mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/&gt; &lt;!-- logging mapping files --&gt; &lt;mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/&gt; &lt;mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/&gt; &lt;/session-factory&gt; &lt;/hibernate-configuration&gt; </code></pre> <p>---- edit ---</p> <p>I have already tried the hibernate.transaction.manager_lookup_class to set to the JBoss version (org.hibernate.transaction.JBossTransactionManagerLookup) it did not work...well it's not that suprising...I'll try now: org.hibernate.transaction.OC4JTransactionManagerLookup</p> <p>I tried with CMT instead of JTA, but it didn't work also.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBalint Pato
    1. USBalint Pato
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to deploy jBPM 3.2.2 console on Oracle 10g iAS
      1. USBalint Pato
      1. VTBountyStart
    2. VO
      singulars
      1. POHow to deploy jBPM 3.2.2 console on Oracle 10g iAS
      1. This table or related slice is empty.
      1. VTBountyClose
    1. COMaybe you diggin' too deep and something more obvious (like wrong classpath or missing jars) happens? I have working jbpm console deployed as .war in JBoss 4 connected to Oracle 10g and only differencies in my hibernate.cfg.xml are: another DS name and uncommented "hibernate.transaction.manager_lookup_class" property.
      singulars
      1. POHow to deploy jBPM 3.2.2 console on Oracle 10g iAS
      1. USVanger
    2. COI started with the simplest and most evident configurations but none of them worked... May be I'm missing something. Though 3 days spent with the problem should have been enough. I admit that there's too many possibilities here, it's hard to tell anything "remotely".
      singulars
      1. POHow to deploy jBPM 3.2.2 console on Oracle 10g iAS
      1. USBalint Pato
    3. COAAAAnd in the end, you were right. I restarted the whole thing, and succeeded...:) It's fairly easy, I'll describe it in an answer. Thanx.
      singulars
      1. POHow to deploy jBPM 3.2.2 console on Oracle 10g iAS
      1. USBalint Pato
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload