[JBoss jBPM] - error executing GetProcessDefinitionsCommand
by AJanz
i use jbpm 3.2.3 on oracle
when i try to execute a GetProcessDefinitionsCommand
i got
14:46:35,473 ERROR [STDERR] org.hibernate.MappingException: Could not determine type for: org.jbpm.identity.hibernate.PermissionUserType, for columns: [org.hibe
rnate.mapping.Column(CLASS_), org.hibernate.mapping.Column(NAME_), org.hibernate
.mapping.Column(ACTION_)]
hibernate.cfg.xml is
| <?xml version="1.0" encoding="utf-8" ?>
| <!DOCTYPE hibernate-configuration (View Source for full doctype...)>
| - <hibernate-configuration>
| - <session-factory>
| - <!-- hibernate dialect
| -->
| <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
| - <!-- JDBC connection properties (begin)
| -->
| <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
| <property name="hibernate.connection.url">jdbc:oracle:thin:@server:1521:oracle</property>
| <property name="hibernate.connection.username">admin</property>
| <property name="hibernate.connection.password">admin</property>
| - <!-- JDBC connection properties (end)
| -->
| <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
| - <!-- DataSource properties (begin) ===
| <property name="hibernate.connection.datasource">java:/JbpmDS</property>
| ==== DataSource properties (end)
| -->
| - <!-- JTA transaction properties (begin) ===
| <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
| <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
| ==== JTA transaction properties (end)
| -->
| - <!-- CMT transaction properties (begin) ===
| <property name="hibernate.transaction.factory_class">org.hibernate.transaction.CMTTransactionFactory</property>
| <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
| ==== CMT transaction properties (end)
| -->
| - <!-- logging properties (begin) ===
| <property name="hibernate.show_sql">true</property>
| <property name="hibernate.format_sql">true</property>
| <property name="hibernate.use_sql_comments">true</property>
| ==== logging properties (end)
| -->
| - <!-- ############################################
| -->
| - <!-- # mapping files with external dependencies #
| -->
| - <!-- ############################################
| -->
| - <!-- following mapping file has a dependendy on
| -->
| - <!-- 'bsh-{version}.jar'.
| -->
| - <!-- uncomment this if you don't have bsh on your
| -->
| - <!-- classpath. you won't be able to use the
| -->
| - <!-- script element in process definition files
| -->
| <mapping resource="org/jbpm/graph/action/Script.hbm.xml" />
| - <!-- following mapping files have a dependendy on
| -->
| - <!-- 'jbpm-identity.jar', mapping files
| -->
| - <!-- of the pluggable jbpm identity component.
| -->
| - <!-- Uncomment the following 3 lines if you
| -->
| - <!-- want to use the jBPM identity mgmgt
| -->
| - <!-- component.
| -->
| - <!-- identity mappings (begin)
| -->
| - <!-- mapping resource="org/jbpm/identity/User.hbm.xml"/>
| <mapping resource="org/jbpm/identity/Group.hbm.xml"/>
| <mapping resource="org/jbpm/identity/Membership.hbm.xml"/
| -->
| - <!-- identity mappings (end)
| -->
| - <!-- following mapping files have a dependendy on
| -->
| - <!-- the JCR API
| -->
| - <!-- jcr mappings (begin) ===
| <mapping resource="org/jbpm/context/exe/variableinstance/JcrNodeInstance.hbm.xml"/>
| ==== jcr mappings (end)
| -->
| - <!-- ######################
| -->
| - <!-- # jbpm mapping files #
| -->
| - <!-- ######################
| -->
| - <!-- hql queries and type defs
| -->
| <mapping resource="org/jbpm/db/hibernate.queries.hbm.xml" />
| - <!-- graph.action mapping files
| -->
| <mapping resource="org/jbpm/graph/action/MailAction.hbm.xml" />
| - <!-- graph.def mapping files
| -->
| <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml" />
| <mapping resource="org/jbpm/graph/def/Node.hbm.xml" />
| <mapping resource="org/jbpm/graph/def/Transition.hbm.xml" />
| <mapping resource="org/jbpm/graph/def/Event.hbm.xml" />
| <mapping resource="org/jbpm/graph/def/Action.hbm.xml" />
| <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml" />
| <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml" />
| <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml" />
| - <!-- graph.node mapping files
| -->
| <mapping resource="org/jbpm/graph/node/StartState.hbm.xml" />
| <mapping resource="org/jbpm/graph/node/EndState.hbm.xml" />
| <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml" />
| <mapping resource="org/jbpm/graph/node/Decision.hbm.xml" />
| <mapping resource="org/jbpm/graph/node/Fork.hbm.xml" />
| <mapping resource="org/jbpm/graph/node/Join.hbm.xml" />
| <mapping resource="org/jbpm/graph/node/MailNode.hbm.xml" />
| <mapping resource="org/jbpm/graph/node/State.hbm.xml" />
| <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml" />
| - <!-- context.def mapping files
| -->
| <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml" />
| <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml" />
| - <!-- taskmgmt.def mapping files
| -->
| <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml" />
| - <!-- module.def mapping files
| -->
| <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml" />
| - <!-- bytes mapping files
| -->
| <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml" />
| - <!-- file.def mapping files
| -->
| <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml" />
| - <!-- scheduler.def mapping files
| -->
| <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml" />
| <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml" />
| - <!-- graph.exe mapping files
| -->
| <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml" />
| <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml" />
| <mapping resource="org/jbpm/graph/exe/Token.hbm.xml" />
| <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml" />
| - <!-- module.exe mapping files
| -->
| <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml" />
| - <!-- context.exe mapping files
| -->
| <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml" />
| <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml" />
| <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml" />
| <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml" />
| <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml" />
| <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml" />
| <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml" />
| <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml" />
| <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml" />
| <mapping resource="org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml" />
| <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml" />
| - <!-- job mapping files
| -->
| <mapping resource="org/jbpm/job/Job.hbm.xml" />
| <mapping resource="org/jbpm/job/Timer.hbm.xml" />
| <mapping resource="org/jbpm/job/ExecuteNodeJob.hbm.xml" />
| <mapping resource="org/jbpm/job/ExecuteActionJob.hbm.xml" />
| - <!-- taskmgmt.exe mapping files
| -->
| <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml" />
| - <!-- logging mapping files
| -->
| <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml" />
| <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml" />
| <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml" />
| <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml" />
| <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml" />
| <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml" />
| <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml" />
| <mapping resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml" />
| <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml" />
| <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml" />
| <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml" />
| <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml" />
| <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml" />
| <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml" />
| </session-factory>
| </hibernate-configuration>
|
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4167012#4167012
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4167012
16 years, 4 months
[JBoss jBPM] - Re: Oracle Error Keyword from missing
by AJanz
ok found the default data....
insert into JBPM_ID_USER (ID_,CLASS_,NAME_,EMAIL_,PASSWORD_) values (1,'U','user','user(a)sample.domain','user');
insert into JBPM_ID_USER (ID_,CLASS_,NAME_,EMAIL_,PASSWORD_) values (2,'U','manager','manager(a)sample.domain','manager');
insert into JBPM_ID_USER (ID_,CLASS_,NAME_,EMAIL_,PASSWORD_) values (3,'U','admin','admin(a)sample.domain','admin');
insert into JBPM_ID_USER (ID_,CLASS_,NAME_,EMAIL_,PASSWORD_) values( 4,'U','shipper','shipper(a)sample.domain','shipper');
insert into JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_) values (1,'G','sales','organisation');
insert into JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_) values (2,'G','admin','security-role');
insert into JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_) values (3,'G','user','security-role');
insert into JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_) values (4,'G','hr','organisation');
insert into JBPM_ID_GROUP (ID_,CLASS_,NAME_,TYPE_) values (5,'G','manager','security-role');
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (1,'M',2,4);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (2,'M',3,4);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (3,'M',4,4);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (4,'M',4,3);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (5,'M',1,3);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (6,'M',2,3);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (7,'M',3,3);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (8,'M',3,2);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (9,'M',2,2);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (10,'M',2,5);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (11,'M',2,1);
insert into JBPM_ID_MEMBERSHIP (ID_,CLASS_,USER_,GROUP_) values (12,'M',1,1);
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4167009#4167009
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4167009
16 years, 4 months
[JBoss jBPM] - Re: org.hibernate.HibernateException: null index column for
by kukeltje
anonymous wrote : to be honest, I do not know why i am posting question on this forum, since I am the one who only answers on them, and I really do not think I will have an answer on this one :)
Sorry, but that might have to do with how questions are posed, what info is provided etc...
- do you use spring jBPM template? if so, ditch it (not spring, just this template, it's officially only for 3.1.x afaik)
- Do both the junit and tomcat use spring?
- Same jbpm config? (not e.g. one without and one with transactions configured)
- same transactionmanager?
- same transactionmanager config?
- if you cut spring out of it (for this specific situation) does it work then?
anonymous wrote : NOTE: since I am using JBPM with spring and within a big enterprise application, I am not able to send short Unit test, that someone can try locally.
Hmm...... strange.... Does this mean you have very few big classes that do a lot of work?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4166795#4166795
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4166795
16 years, 4 months