[JBoss jBPM] - Re: jBPM : Couldn't be that complicated...
by viniciuscarvalho
"michea" wrote : To create the tables, I used the script given with 3.2 GA after :
| - removing the firsts ALTER TABLE instructions
| - adding ";" at the end of each line
|
| It seems to work, for the login/pass I just uses a properties file.
|
| We are still struggling with transactions and transitions, as we have different behaviours depending on the machine.
| I start to guess that 4.0.5GA + EJB3 might have some bug in redeployment, often I have to delete the content of server/tmp to deploy correctly.
|
| A jboss4.0.5+EJB3 bundled with JBPM... would be great in the suite.
Well, I really give up mysql here. Here's what I've done, step by step and it did not work in 4 different versions of mySQL (4.0.28,4.1.23,5.0.24a,5.1.7).
Ran the examples located at starterskit 3.1.3 (I run the ant tasks to create the scripts for mySQL)
Ran the scripts of 3.2 under db (removed the alter tables...)
Here's the result:
| mysql> source jbpm.jpdl.mysql.sql;
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| Query OK, 0 rows affected (0.00 sec)
|
| Query OK, 0 rows affected (0.06 sec)
|
| Query OK, 0 rows affected (0.00 sec)
|
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| Query OK, 0 rows affected, 1 warning (0.00 sec)
|
| Query OK, 0 rows affected (0.03 sec)
|
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| Query OK, 0 rows affected (0.01 sec)
|
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| Query OK, 0 rows affected (0.03 sec)
|
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
| Query OK, 0 rows affected (0.01 sec)
|
| Query OK, 0 rows affected (0.03 sec)
|
| ERROR 1050 (42S01): Table 'JBPM_ACTION' already exists
| ERROR 1050 (42S01): Table 'JBPM_BYTEARRAY' already exists
| Query OK, 0 rows affected, 1 warning (0.14 sec)
|
| Query OK, 0 rows affected, 1 warning (0.07 sec)
|
| Query OK, 0 rows affected, 1 warning (0.11 sec)
|
| ERROR 1050 (42S01): Table 'JBPM_DELEGATION' already exists
| ERROR 1050 (42S01): Table 'JBPM_EVENT' already exists
| ERROR 1050 (42S01): Table 'JBPM_EXCEPTIONHANDLER' already exists
| Query OK, 0 rows affected, 1 warning (0.09 sec)
|
| Query OK, 0 rows affected, 1 warning (0.10 sec)
|
| ERROR 1050 (42S01): Table 'JBPM_MODULEDEFINITION' already exists
| ERROR 1050 (42S01): Table 'JBPM_MODULEINSTANCE' already exists
| ERROR 1050 (42S01): Table 'JBPM_NODE' already exists
| ERROR 1050 (42S01): Table 'JBPM_POOLEDACTOR' already exists
| ERROR 1050 (42S01): Table 'JBPM_PROCESSDEFINITION' already exists
| ERROR 1050 (42S01): Table 'JBPM_PROCESSINSTANCE' already exists
| Query OK, 0 rows affected, 1 warning (0.08 sec)
|
| ERROR 1050 (42S01): Table 'JBPM_SWIMLANE' already exists
| ERROR 1050 (42S01): Table 'JBPM_SWIMLANEINSTANCE' already exists
| ERROR 1050 (42S01): Table 'JBPM_TASK' already exists
| Query OK, 0 rows affected, 1 warning (0.05 sec)
|
| ERROR 1050 (42S01): Table 'JBPM_TASKCONTROLLER' already exists
| ERROR 1050 (42S01): Table 'JBPM_TASKINSTANCE' already exists
| ERROR 1050 (42S01): Table 'JBPM_TOKEN' already exists
| ERROR 1050 (42S01): Table 'JBPM_TOKENVARIABLEMAP' already exists
| ERROR 1050 (42S01): Table 'JBPM_TRANSITION' already exists
| Query OK, 0 rows affected, 1 warning (0.10 sec)
|
| Query OK, 0 rows affected, 1 warning (0.09 sec)
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_ACTION_EVENT'
| ERROR 1061 (42000): Duplicate key name 'FK_ACTION_EXPTHDL'
| ERROR 1061 (42000): Duplicate key name 'FK_ACTION_PROCDEF'
| ERROR 1061 (42000): Duplicate key name 'FK_CRTETIMERACT_TA'
| ERROR 1061 (42000): Duplicate key name 'FK_ACTION_ACTNDEL'
| ERROR 1061 (42000): Duplicate key name 'FK_ACTION_REFACT'
| ERROR 1061 (42000): Duplicate key name 'FK_BYTEARR_FILDEF'
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.11 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.17 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.11 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_DELEGATION_PRCD'
| ERROR 1061 (42000): Duplicate key name 'FK_EVENT_PROCDEF'
| ERROR 1061 (42000): Duplicate key name 'FK_EVENT_NODE'
| ERROR 1061 (42000): Duplicate key name 'FK_EVENT_TRANS'
| ERROR 1061 (42000): Duplicate key name 'FK_EVENT_TASK'
| Query OK, 0 rows affected (0.11 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.17 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.65 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.18 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.18 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.18 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.18 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.17 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_TSKDEF_START'
| ERROR 1061 (42000): Duplicate key name 'FK_MODDEF_PROCDEF'
| Query OK, 0 rows affected (0.12 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_TASKMGTINST_TMD'
| ERROR 1061 (42000): Duplicate key name 'FK_MODINST_PRCINST'
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_PROCST_SBPRCDEF'
| ERROR 1061 (42000): Duplicate key name 'FK_NODE_PROCDEF'
| ERROR 1072 (42000): Key column 'SCRIPT_' doesn't exist in table
| ERROR 1061 (42000): Duplicate key name 'FK_NODE_ACTION'
| ERROR 1061 (42000): Duplicate key name 'FK_DECISION_DELEG'
| ERROR 1061 (42000): Duplicate key name 'FK_NODE_SUPERSTATE'
| ERROR 1061 (42000): Duplicate key name 'IDX_PLDACTR_ACTID'
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_POOLEDACTOR_SLI'
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_PROCDEF_STRTSTA'
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_PROCIN_PROCDEF'
| ERROR 1061 (42000): Duplicate key name 'FK_PROCIN_ROOTTKN'
| ERROR 1061 (42000): Duplicate key name 'FK_PROCIN_SPROCTKN'
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.17 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.42 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_SWL_ASSDEL'
| ERROR 1061 (42000): Duplicate key name 'FK_SWL_TSKMGMTDEF'
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_SWIMLANEINST_TM'
| ERROR 1061 (42000): Duplicate key name 'FK_SWIMLANEINST_SL'
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.18 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_TSK_TSKCTRL'
| ERROR 1061 (42000): Duplicate key name 'FK_TASK_ASSDEL'
| ERROR 1061 (42000): Duplicate key name 'FK_TASK_TASKNODE'
| ERROR 1061 (42000): Duplicate key name 'FK_TASK_PROCDEF'
| ERROR 1061 (42000): Duplicate key name 'FK_TASK_STARTST'
| ERROR 1061 (42000): Duplicate key name 'FK_TASK_TASKMGTDEF'
| ERROR 1061 (42000): Duplicate key name 'FK_TASK_SWIMLANE'
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_TSKCTRL_DELEG'
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1072 (42000): Key column 'PROCINST_' doesn't exist in table
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'IDX_TASK_ACTORID'
| ERROR 1072 (42000): Key column 'PROCINST_' doesn't exist in table
| ERROR 1061 (42000): Duplicate key name 'FK_TASKINST_TMINST'
| ERROR 1061 (42000): Duplicate key name 'FK_TASKINST_TOKEN'
| ERROR 1061 (42000): Duplicate key name 'FK_TASKINST_SLINST'
| ERROR 1061 (42000): Duplicate key name 'FK_TASKINST_TASK'
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.27 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.17 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_TOKEN_PARENT'
| ERROR 1061 (42000): Duplicate key name 'FK_TOKEN_NODE'
| ERROR 1061 (42000): Duplicate key name 'FK_TOKEN_PROCINST'
| ERROR 1061 (42000): Duplicate key name 'FK_TOKEN_SUBPI'
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_TKVARMAP_CTXT'
| ERROR 1061 (42000): Duplicate key name 'FK_TKVARMAP_TOKEN'
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR 1061 (42000): Duplicate key name 'FK_TRANSITION_TO'
| ERROR 1061 (42000): Duplicate key name 'FK_TRANS_PROCDEF'
| ERROR 1061 (42000): Duplicate key name 'FK_TRANSITION_FROM'
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.17 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.13 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.12 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.16 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.15 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| Query OK, 0 rows affected (0.14 sec)
| Records: 0 Duplicates: 0 Warnings: 0
|
| ERROR:
| No query specified
|
And after all this, the tables are not updated, for instance JBPM_TASKINSTANCE does not get an VERSION_ column
Well, what else am I doing wrong that I cant get it working on mysql? Oracle works pretty fine :) But ?I don't have an oracle on my machine :( hence I depend to be on my company network to run the examples I'm building...
Regards
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4032150#4032150
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4032150
19Â years
[JBossCache] - Re: PojoCache, Serializable object and cluster
by jacek187
About PojoCache.putObject()PojoCache.getObject() (look into testPojo() method)
Scenario is:
1. PojoCache is empty
2. Create instance of Serializable object
3. Call PojoCache.putObject() on first cache.
4. Get object fom second cache (object was replicated),
4. Change something in object
5. Because object is only serializable, put changed object back into second(PojoCache.putObject())
6. Get object from first cache (PojoCache.getObject())
I think, that should receive object from step 5, but i got object from step 2 (without any changes made in step 4!!!)
... or run presented in first post JUnit test.
I know' that if pojo will be instrumented, changes would be replicated and step 5 is not needed), but my pojo is only serializable.
And question: why afer first put object was replicated, but after second, third etc put object was not replicated? (And no warning/error or exception was logged?)
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4032148#4032148
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4032148
19Â years
[Installation, Configuration & Deployment] - Apache and Jboss integration problem
by pajarokillo
Hi!, I have developed an web application that i have deployed in my jboss application server. The Jboss version is 4.0.0. The context of my web application is /MyContextWeb
Moreover, i want put a Apache2 Web Server in front of my application server. I have configured the mod_jk module for connect Apache and Jboss, and all work correctly.
My problem is the next, i want that if a user write http://mydomain.com in the navigator, it maps to http://mydomain.com/MyContextWeb.
I think that it can be related with VirtualHost from Apache, but i don't know how i must configure it.
How can i get it?.
My configs file are the next:
httpd.conf
| Include conf/mod-jk.conf
|
| NameVirtualHost *.*.*.*:80
|
| <VirtualHost *.*.*.*:80>
| ServerName mydomain.com
| ServerAlias mydomain.com
| DocumentRoot /desarrollo/srvApp/jboss-4.0.0/server/itd_knowledge/deploy/ITDCargaDatosWeb.war
| ErrorLog logs/mydomain.com-error_log
| </VirtualHost>
mod-jk.conf
# Cargamos el módulo mod_jk
| LoadModule jk_module modules/mod_jk-apache-2.0.55.dll
|
| # workers.properties
| JkWorkersFile conf/workers.properties
|
| # logs
| JkLogFile logs/mod_jk.log
|
| # jk nivel log [debug/error/info]
| JkLogLevel info
|
| # formato de Log
| JkLogStampFormat "[%a %b %d %H:%M:%S %Y]"
|
| # JkOptions
| JkOptions +ForwardKeySize +ForwardURICompat -ForwardDirectories
|
| # JkRequestLogFormat
| JkRequestLogFormat "%w %V %T"
|
| #JkMount /jobsite.itdeusto.local.com/* workerITDK
|
| # Archivo de URI de aplicaciones
| JkMountFile conf/uriworkermap.properties
|
| # para shared memory, solo para plataformas Unix
| #JkShmFile logs/jk.shm
|
| # jkstatus
| <Location /jkstatus/>
| JkMount status
| Order deny,allow
| Deny from all
| Allow from 127.0.0.1
| </Location>
worker.properties
| worker.list=workerITDK
|
| worker.workerITDK.port=8009
| worker.workerITDK.host=localhost
| worker.workerITDK.type=ajp13
uriworkermap.properties
| /jmx-console=workerITDK
| /jmx-console/*=workerITDK
| /web-console=workerITDK
| /web-console/*=workerITDK
| /MyContextWeb/*=workerITDK
| /MyContextWeb*=workerITDK
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4032142#4032142
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4032142
19Â years