[JBoss jBPM] - Cannot get JBPM + MSSQL to run together!
by pjodev
Hello everyone,
I am fairly new to JBPM, but I have read as much documentation and forums as I can without posting a question, but I am still stuck. Here is my config:
Tomcat 6.0
JBPM 3.2
MS SQL 2000
Using the jtds-1.2.jar for MSSQL access.
Here is my hibernate.cfg.xml file
<?xml version='1.0' encoding='utf-8'?>
|
| <!DOCTYPE hibernate-configuration PUBLIC
| "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
| "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
|
| <hibernate-configuration>
| <session-factory>
|
| <!-- hibernate dialect -->
| <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
|
| <!-- JDBC connection properties (begin) ===
| <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
| <property name="hibernate.connection.url">jdbc:jtds:sqlserver://192.168.0.2</property>
| <property name="hibernate.connection.username">jbpmsa</property>
| <property name="hibernate.connection.password">testjbpm</property>
| <property name="c3p0.min_size">5</property>
| <property name="c3p0.max_size">20</property>
| <property name="c3p0.timeout">300</property>
| <property name="c3p0.max_statements">50</property>
| <property name="c3p0.idle_test_period">3000</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) -->
| <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
|
|
| <!-- CMT transaction properties (begin) ===
| <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</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.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/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>
|
Everytime I try to load the jbpm-console, I get this error:
INFO: Statistics: disabled
| Apr 12, 2007 10:36:04 PM org.hibernate.cfg.SettingsFactory buildSettings
| INFO: Deleted entity synthetic identifier rollback: disabled
| Apr 12, 2007 10:36:04 PM org.hibernate.cfg.SettingsFactory buildSettings
| INFO: Default entity-mode: pojo
| Apr 12, 2007 10:36:04 PM org.hibernate.impl.SessionFactoryImpl <init>
| INFO: building session factory
| Apr 12, 2007 10:36:08 PM org.hibernate.impl.SessionFactoryObjectFactory addInstance
| INFO: Not binding factory to JNDI, no JNDI name configured
| Apr 12, 2007 10:36:09 PM org.jbpm.job.executor.JobExecutorThread run
| SEVERE: exception in job executor thread. waiting 5000 milliseconds
| java.lang.UnsupportedOperationException: The user must supply a JDBC connection
| at org.hibernate.connection.UserSuppliedConnectionProvider.getConnection(UserSuppliedConnectionProvider.java:30)
| at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
| at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
| at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
| at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
| at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
| at org.jbpm.persistence.db.DbPersistenceService.beginTransaction(DbPersistenceService.java:130)
| at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:122)
| at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:352)
| at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:563)
| at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:109)
| at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)
I know I must be missing something here, but I really do not know ;/ Any help?
Thanks!
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4036938#4036938
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4036938
19 years
[Installation, Configuration & Deployment] - Re: Jboss install
by jgayathri
Thanks, today it build successfully . The path iin etc/profile i made change, i set it yesterday like this
#java
JAVA_HOME= /usr/java/jdk1.5.0_11
PATH=/usr/java/jdk1.5.0_11/bin:$PATH
CLASSPATH=/usr/java/jdk1.5.0_11/lib:$CLASSPATH
#ANT1.6
ANT_HOME=/home/servers/java/apache-ant-1.6.0
PATH=/home/servers/java/apache-ant-1.6.0/bin:$PATH
earlier th e order was different. it build successful today.
I downloaded example3.ear from roseindia.net, this i copied to jboss deploy , iimmediately it gave error like this classcast exception . This is happening for both the downloaded bin jboss and in the built jboss also .
my profile setting now is:
#java
JAVA_HOME= /usr/java/jdk1.5.0_11
PATH=/usr/java/jdk1.5.0_11/bin:$PATH
CLASSPATH=/usr/java/jdk1.5.0_11/lib:$CLASSPATH
#JBoss
#JBOSS_HOME=/home/servers/java/jboss-4.0.5.GA
JBOSS_HOME=/home/servers/java/jboss-4.0.5.GA-src/build/output/jboss-4.0.5.GA
#ANT1.6
ANT_HOME=/home/servers/java/apache-ant-1.6.0
PATH=/home/servers/java/apache-ant-1.6.0/bin:$PATH
#ANT
#ANT_HOME=/home/servers/java/apache-ant-1.7.0
#PATH=/home/servers/java/apache-ant-1.7.0/bin:$PATH
#J2EE
#CLASSPATH=/home/servers/java/j2ee.jar:$CLASSPATH
export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE INPUTRC PGPORT LD_LIBRARY_PATH PATH MANPATH CLASSPATH JAVA_HOME JBOSS_HOME ANT_HOME
i need help to resolve this error: is:
09:08:23,438 INFO [ProxyFactory] Bound EJB Home 'test/MyTestSession' to jndi 'ejb/test/MyTestSessionBean'
09:08:23,482 INFO [EJBDeployer] Deployed: file:/home/servers/java/jboss-4.0.5.GA-src/build/output/jboss-4.0.5.GA/server/default/tmp/deploy/tmp2627example3.ear-contents/example3.jar
09:08:23,900 INFO [TomcatDeployer] deploy, ctxPath=/example3, warUrl=.../tmp/deploy/tmp2627example3.ear-contents/example3-exp.war/
09:08:24,708 ERROR [STDERR] java.lang.ClassCastException
09:08:24,746 ERROR [STDERR] at com.sun.corba.se.impl.javax.rmi.PortableRemoteObject.narrow(PortableRemoteObject.java:229)
09:08:24,747 ERROR [STDERR] at javax.rmi.PortableRemoteObject.narrow(PortableRemoteObject.java:137)
09:08:24,748 ERROR [STDERR] at test.session.SessionTestServlet.init(SessionTestServlet.java:29)
09:08:24,789 ERROR [STDERR] at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
09:08:24,790 ERROR [STDERR] at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
09:08:24,827 ERROR [STDERR] at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3951)
09:08:24,828 ERROR [STDERR] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4225)
09:08:24,865 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4036934#4036934
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4036934
19 years
[JBoss Seam] - Re: security pattern
by markfoerstein
You mean extend Identity from your User class like this?:
...class User extends Identity {
| ...
|
I don't think it is the right approach (although Im not the expert here :-P)
You use Identity whenever you want to restrict access to a class or method and to query if the user is logged in or not. By "user" I don't mean your class "User".
When you authenticate, Seam will flag the Identity with loggedIn = true, and you can restrict access to classes or methods:
| @Restrict("#{identity.loggedIn}")
| public class ...
|
| (OR)
|
| @Restrict("#{identity.loggedIn}")
| public String create() {
| ...
|
Also, when you authenticate (through querying the database) you can @Out your authenticated "User" class so you can @In it wherever you want and get the members (username, nickname, etc). Just see the examples Shane told you...
Hope this could be helpful...
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4036928#4036928
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4036928
19 years