[JBoss jBPM] - Re: Tomcat 5.5 - Jbpm 3.2 - Starting failed <<couldn't get a
by dleerob
I followed the steps on the JbpmOnTomcat wiki, however there is one step that I think you left out. It had me going for a short while, till I figured it out.
By the way, I am using Tomcat 5.0.28, and MySQL 5.0.27.
When I finished doing everything on the Wiki, I started up tomcat, and got an error that the JbpmDS datasource was not found/bound to that context.
In the end, I had to change the hibernate.connection.datasource property in the hibernate.cfg.xml file to:
| <property name="hibernate.connection.datasource">java:comp/env/jdbc/JbpmDS</property>
|
Then in tomcat\conf\Catalina\localhost\jbpm-console.xml, I added the following:
| <Resource name="jdbc/JbpmDS" auth="Container" type="javax.sql.DataSource"/>
| <ResourceParams name="jdbc/JbpmDS">
| <parameter>
| <name>factory</name>
| <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
| </parameter>
| <parameter>
| <name>maxActive</name>
| <value>100</value>
| </parameter>
| <parameter>
| <name>maxIdle</name>
| <value>30</value>
| </parameter>
| <parameter>
| <name>maxWait</name>
| <value>10000</value>
| </parameter>
| <parameter>
| <name>username</name>
| <value>jbossjbpm</value>
| </parameter>
| <parameter>
| <name>password</name>
| <value>jbossjbpm</value>
| </parameter>
| <parameter>
| <name>driverClassName</name>
| <value>com.mysql.jdbc.Driver</value>
| </parameter>
| <parameter>
| <name>defaultAutoCommit</name>
| <value>true</value>
| </parameter>
| <parameter>
| <name>url</name>
| <value>jdbc:mysql://localhost/jbpm32?useUnicode=true&characterEncoding=utf-8</value>
| </parameter>
| <parameter>
| <name>removeAbandoned</name>
| <value>true</value>
| </parameter>
| <parameter>
| <name>removeAbandonedTimeout</name>
| <value>60</value>
| </parameter>
| <parameter>
| <name>logAbandoned</name>
| <value>true</value>
| </parameter>
| </ResourceParams>
|
After doing that, the jbpm-console worked.
There was no mention of creating this datasource in the Wiki. Did I miss something? Why was it different for me?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067811#4067811
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067811
18Â years, 9Â months
[JBoss jBPM] - Re: jBPM 3.2.1 on AS 4.2.1
by mputz
Angelo,
good to hear that it's working now.
Now on to the move to Oracle ;-)
First, please have a look at Chapter 8 of the docu for a general overview of the necessary steps for switching the database backend:
http://docs.jboss.com/jbpm/v3.2/userguide/html/thejbpmdatabase.html
(Please note that the user guide is sometimes still referring to the 3.1 version and contains therefore outdated path references!)
The steps in short are the following:
1.) create the db schema
2.) deploy the appropriate *-ds.xml datasource configuration file
3.) copy the db driver to the server/your_config/lib folder
4.) tell hibernate which db you are using by updating jbpm-enterprise.ear/lib/jbpm-configs.jar/hibernate.cfg.xml with the correct hibernate.dialect property value
Regarding step 1.), the scripts for different databases including Oracle can be found in the jbpm-jpdl-3.2.1/db folder - for Oracle it's the file 'jbpm.jpdl.oracle.sql'. (If you were using jBPM 3.2.GA then the ddl statements for the tables for the identity components are missing in this file, however. This has been changed recently so if you checked out the latest version from CVS or work with 3.2.1 you should be fine and get a script which contains the create statements for all tables.)
In order to execute this start sqlplus with a user with sufficient privileges and invoke '@<path-to-file>/jbpm.jpdl.oracle.sql'.
After that you might want to insert the test users to play around; here are the relevant sql statements for this:
INSERT INTO JBPM_ID_GROUP VALUES(1,'G','sales','organisation',NULL);
| INSERT INTO JBPM_ID_GROUP VALUES(2,'G','admin','security-role',NULL);
| INSERT INTO JBPM_ID_GROUP VALUES(3,'G','user','security-role',NULL);
| INSERT INTO JBPM_ID_GROUP VALUES(4,'G','hr','organisation',NULL);
| INSERT INTO JBPM_ID_GROUP VALUES(5,'G','manager','security-role',NULL);
| INSERT INTO JBPM_ID_USER VALUES(1,'U','user','user(a)sample.domain','user');
| INSERT INTO JBPM_ID_USER VALUES(2,'U','manager','manager(a)sample.domain','manager');
| INSERT INTO JBPM_ID_USER VALUES(3,'U','admin','admin(a)sample.domain','admin');
| INSERT INTO JBPM_ID_USER VALUES(4,'U','shipper','shipper(a)sample.domain','shipper');
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(1,'M',NULL,NULL,2,4);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(2,'M',NULL,NULL,3,4);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(3,'M',NULL,NULL,4,4);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(4,'M',NULL,NULL,4,3);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(5,'M',NULL,NULL,1,3);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(6,'M',NULL,NULL,2,3);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(7,'M',NULL,NULL,3,3);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(8,'M',NULL,NULL,3,2);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(9,'M',NULL,NULL,2,2);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(10,'M',NULL,NULL,2,5);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(11,'M',NULL,'boss',2,1);
| INSERT INTO JBPM_ID_MEMBERSHIP VALUES(12,'M',NULL,NULL,1,1);
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067806#4067806
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067806
18Â years, 9Â months
[JBoss jBPM] - BPEL: Creating arrays and unbounded entities.
by fresno
Hi all:
I'm using jbpm.bpel.Beta3 and I've come across a problem. Is it possible at all to create and use an array-like structure?
Here's my experience: The use of SOAP arrays is not allowed in this version (like v.gr. <attribute ref="soapenc:arrayType" wsdl:arrayType="soapenc:string[]"/> throws:
org.jbpm.bpel.BpelException: encoded use not supported
| at org.jbpm.bpel.integration.client.SoapClient.writeRpcBody(SoapClient.java:212)
| at org.jbpm.bpel.integration.client.SoapClient.writeMessage(SoapClient.java:199)
|
So I tried using an xsd structure, like this:
| <complexType name="ListaString">
| <sequence>
| <element maxOccurs="unbounded" minOccurs="1" name="elemento" type="xsd:string"/>
| </sequence>
| </complexType>
However, when creating the variable, it will only allow me to create a single item, as this:
<copy> <!-- nillables -->
| <from expression="'PRIMITIVA2'"/>
| <to variable="entradaPrueba" part="entrada" query="/entrada/primitivas/elemento[2]"/>
| </copy>
throws this exception:
| org.jbpm.bpel.graph.exe.BpelFaultException: org.jbpm.bpel.graph.exe.FaultInstance@1b8dc93[name={http://schemas
| .xmlsoap.org/ws/2004/03/business-process/}selectionFailure,id=0]
| at org.jbpm.bpel.sublang.xpath.XPathEvaluator.createNode(XPathEvaluator.java:91)
| at org.jbpm.bpel.sublang.xpath.XPathEvaluator.selectOrCreateNodes(XPathEvaluator.java:79)
|
Any ideas?
Thanks a lot in advance
Felipe
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067800#4067800
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067800
18Â years, 9Â months
[JBoss Seam] - Problem : Javascript-access to fields bound to component pro
by dkane
An overview :
h:graphicImage element has dynamic "url" parameter that is the property of Seam component.
When image is rerendered (this happens frequently in response to various actions on the same page), I need to execute some additional Javascript code. This code needs to "know" the number of properties of the same Seam component . Properties changes as often as image URL, i.e. should be re-read right before Javascript execution.
So I have included Javascript function as "onchange" event handler of h:graphicImage. Then I need to read Seam component properties from JavaScript. The first and obvious idea to do that was Remoting. But why send more HTTP requests when updated component is already in context ? So I added hidden fields and tied them to properties of interest. And, JavaScript code grabs these values via document.getElementById("fieldId").value ;
But now - the problem :
"onchange" event handler of h:graphicImage is being invoked, when hidden field values are not yet updated with new values of the component. So I have previous incorrect state of properties.
Further re-running the same script from button (when page is fully rendered) gives correct results.
I an thinking in two possible ways now :
1) Add some timeout before running the script (dirty and not reliable solution)
2) Use basically another approach - looking forward to your advices ..
Thank you
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067796#4067796
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067796
18Â years, 9Â months