nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Activiti with persistent database (bug using mysql?)

pfeard

Hi,

I've tried everything now. My goal is to have one database for the activiti explorer and the activiti rest API, so that if I change something via rest I also could see it in the activiti explorer. I already tried two attempts:

1. I tried to run the h2 database in server mode. Therefore I gave the command

java -cp h2-1.3.171.jar org.h2.tools.Server -tcpPort 2962‍

and and replaced the jdbc url:

jdbc.url=jdbc:h2:tcp://localhost:2962/~/test‍

like described in this post: http://forums.activiti.org/content/how-configure-activiti-explorer-and-rest-use-same-database

But I always got the message that the class

org.h2.tools.Server‍

could not be found.

2. I created a persistent database in mysql using phpMyAdmin and the following code in both db.properties files:

db=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/activiti?autoReconnect=true
jdbc.username=root
jdbc.password=
‍‍‍‍‍‍‍

The database works fine and with this attempt I reached my goal that I can use both, the activiti explorer and the rest API.
but unfortunately now the resource URLs don't work anymore. For Example if I list the process definitions, I get several entries like this:

{
            "id": "createTimersProcess:1:37",
            "url": "http://localhost:8080/activiti-rest/service/repository/process-definitions/createTimersProcess%3A1%3A37",
            "key": "createTimersProcess",
            "version": 1,
            "name": "Create timers process",
            "description": "Test process to create a number of timers.",
            "deploymentId": "23",
            "deploymentUrl": "http://localhost:8080/activiti-rest/service/repository/deployments/23",
            "resource": "http://localhost:8080/activiti-rest/service/repository/deployments/23/resources/org%2Factiviti%2Fexplorer%2Fdemo%2Fprocess%2FcreateTimersProcess.bpmn20.xml",
            "diagramResource": null,
            "category": "Examples",
            "graphicalNotationDefined": false,
            "suspended": false,
            "startFormDefined": false
        }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

But the resource URL

http://localhost:8080/activiti-rest/service/repository/deployments/23/resources/org%2Factiviti%2Fexplorer%2Fdemo%2Fprocess%2FcreateTimersProcess.bpmn20.xml‍

only responds with an Status 400 Bad Request.
If I compare the same behavior with an h2 database (only used by rest API and not by activiti explorer as described above), I get a resource URL like

http://localhost:8080/activiti-rest/service/repository/deployments/20/resources/VacationRequest.bpmn20.xml‍

which works perfectly as far as I have a h2 database.

I would appreciate any help of this issue, or is this even a bug in combination with mysql?

Find more posts tagged with

Comments

jbarrez

How did you get both Explorer and Rest together?

The url seems to indicate

org%2Factiviti%2Fexplorer%2Fdemo%2Fprocess%2FcreateTimersProcess.bpmn20.xml

That somehow explorer is interfering with your REST install? Are these two separate wars?

MySQL doesnt have any influence on those urls whatsoever.

pfeard

You might be right, but how can I solve that?
I just copied and pasted the two wars <code>activiti-explorer.war</code> and <code>activiti-rest.war</code> in the webapps directory of my tomcat server.

I got a little further with my first attempt so that explorer and REST are using the same h2 database on a server. That means if I post e.g. a process instance via REST I see it on the explorer. But now the same issue occurs as if I use one MySQL Database. It's somehow interfering and I get those not working resource URLs.

Or does that mean, that I can't use REST and explorer with the same database without errors?

pfeard

Or is there a way to only have one *.war file which includes both, REST and explorer?

jbarrez

> Or does that mean, that I can't use REST and explorer with the same database without errors?

No, that works for sure.

> Or is there a way to only have one *.war file which includes both, REST and explorer?

Yes, but it shouldn't be. It should work out of the box.

What is in your database? More specifically the ACT_GE_BYTEARRAY and ACT_RE_DEPLOYMENT ?

pfeard

In ACT_GE_BYTEARRAY the NAME_ column looks good, like <code>org/activiti/explorer/demo/process/VacationRequest.bpmn20.xml</code> and in ACT_RE_DEPLOYMENT I have two entries: Demo processes and Demo reports. But still I get the not working resource URLs via REST with the %2F…

jbarrez

OK, im officially really puzzled now. really don't have a clue

Could you post the REST http request you do to get the data here? Maybe there is something off there (although i dont think so)

pfeard

Sorry havn't worked on it for a while.
The REST http request is simply <code>http://localhost:8080/activiti-rest/service/repository/process-definitions</code>
If I use different databases (like it is on default) everything is fine both on activit-explorer and activiti REST. I can post a process instance via <code>http://localhost:8080/activiti-rest/service/runtime/process-instances</code> and see it with the same request <code>http://localhost:8080/activiti-rest/service/runtime/process-instances</code> but I can't see it on activiti explorer (since I use different databases in this case)
As soon as I use one database for both, the resource URL on this GET request <code>http://localhost:8080/activiti-rest/service/repository/process-definitions</code> are not working anymore.

alfheim

I've got the same problem.
Activiti version: 5.15.1
Tomcat version: 7.0.54

First I try with H2
http://192.168.56.150:8080/activiti-rest/service/repository/process-definitions

{
           "id": "fixSystemFailure:1:35",
           "url": "http://192.168.56.150:8080/activiti-rest/service/repository/process-definitions/fixSystemFailure%3A1%3A35",
           "key": "fixSystemFailure",
           "version": 1,
           "name": "Fix system failure",
           "description": null,
           "deploymentId": "20",
           "deploymentUrl": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20",
           "resource": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resources/FixSystemFailureProcess.bpmn20.xml",
           "diagramResource": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resources/FixSystemFailureProcess.png",
           "category": "Examples",
           "graphicalNotationDefined": false,
           "suspended": false,
           "startFormDefined": false
       },

GET http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resources/FixSystemFailureProcess.png

    {
       "id": "FixSystemFailureProcess.png",
       "url": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resources/FixSystemFailureProcess.png",
       "contentUrl": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resourcedata/FixSystemFailureProcess.png",
       "mediaType": "image/png",
       "type": "resource"
    }

GET http://192.168.56.150:8080/activiti-rest/service/repository/deployments/20/resourcedata/FixSystemFailureProcess.png
Image OK

Then I configure mysql db
lib: mysql-connector-java-5.1.31-bin.jar

file db.properties
db=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/activiti
jdbc.username=activiti
jdbc.password=Password1

cp /root/db.properties /usr/local/tomcat/webapps/activiti-explorer/WEB-INF/classes/
cp /root/db.properties /usr/local/tomcat/webapps/activiti-rest/WEB-INF/classes/

http://192.168.56.150:8080/activiti-rest/service/repository/process-definitions

{
           "id": "fixSystemFailure:1:35",
           "url": "http://192.168.56.150:8080/activiti-rest/service/repository/process-definitions/fixSystemFailure%3A1%3A35",
           "key": "fixSystemFailure",
           "version": 1,
           "name": "Fix system failure",
           "description": null,
           "deploymentId": "23",
           "deploymentUrl": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/23",
           "resource": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/23/resources/org%2Factiviti%2Fexplorer%2Fdemo%2Fprocess%2FFixSystemFailureProcess.bpmn20.xml",
           "diagramResource": "http://192.168.56.150:8080/activiti-rest/service/repository/deployments/23/resources/org%2Factiviti%2Fexplorer%2Fdemo%2Fprocess%2FFixSystemFailureProcess.png",
           "category": "Examples",
           "graphicalNotationDefined": false,
           "suspended": false,
           "startFormDefined": false
       },

GET http://192.168.56.150:8080/activiti-rest/service/repository/deployments/23/resources/org%2Factiviti%2Fexplorer%2Fdemo%2Fprocess%2FFixSystemFailureProcess.png

    Status Code: 400 Bad Request
    Connection: close
    Content-Length: 0
    Date: Thu, 03 Jul 2014 04:52:42 GMT
    Server: Apache-Coyote/1.1

Then I try to use the same url format as H2
GET http://192.168.56.150:8080/activiti-rest/service/repository/deployments/23/resources/FixSystemFailureProcess.png

    Status Code: 404 Not Found
    Accept-Ranges: bytes
    Content-Length: 78
    Content-Type: application/json;charset=UTF-8
    Date: Thu, 03 Jul 2014 04:54:14 GMT
    Server: Restlet-Framework/2.1.4
    Vary: Accept-Charset, Accept-Encoding, Accept-Language, Accept

Hope this helps

Cheers

martin_grofcik

Hi,

I do not have answer, but I ask more questions 🙂 :
1. Is there any stack trace?
2. Did you try to debug rest service?

Regards
Martin

alfheim

No stack trace, logs are clean

Can you tell me how to debug rest service?

martin_grofcik

Hi,

As soon as I use one database for both, the resource URL on this GET request http://localhost:8080/activiti-rest/service/repository/process-definitions are not working anymore.

Any stacktrace? jUnit test?

Regards
Martin

alfheim

Reading documentation I find this rest endpoint to fetch diagram:

/activiti-rest/service/process-definition/fixSystemFailure:1:35/diagram

and it works like a charm, with mysql too

Thank you