JBPM 7.3.0.Final Examples - H2 Problem when running

[ksgf...@gmail.com]

Hello, I recently began working with JBPM and in order to get my feet wet, wanted to exercise through some of the examples provided on jbpm.org.

When Running for example the "Evaluation Example" I get the following Errors:

"

15:43:28.479 [main] INFO  org.jbpm.test.util.PoolingDataSource.init:65 - jdbc:h2:tcp://localhost/~/jbpm-db

15:43:28.488 [main] INFO  org.jbpm.test.util.PoolingDataSource.init:70 - Unable to find "setUrl" method in db driver JAR. Trying "setURL" 

org.h2.jdbc.JdbcSQLException: Wrong Username or Password

Wrong user name or password [28000-173]

And ofcourse a bunch of followup errors.

I was not able to find the configuration Files in the example Project regarding login and pw, so I ran it with my own H2 Database and also tried running it with the JBPM Demo. Neither did anything.

So my question is, where are the Configuration Files stored, if there are any. 

Or am I overlooking something else?

Thanks a bunch in advance 

[Maciej Swiderski]

would be best if you pastebin (or attach) entire server log as this info is not enough to figure out what might be wrong.

Maciej

--
You received this message because you are subscribed to the Google Groups "jBPM Setup" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-setup+...@googlegroups.com.
To post to this group, send email to jbpm-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/7f4feced-bd4f-44e3-8515-13c463e9546b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[ksgf...@gmail.com]

Good point, here's the link to the Pastebin with the complete log.

https://pastebin.com/UrcjD2xi

Thanks

[Maciej Swiderski]

just tried the example and it does work as expected, could it be that you have another H2 server running that has different user name or password? Maybe you have jbpm running on wildfly (from jbpm installer) that could somehow interfere…

Maciej

--
You received this message because you are subscribed to the Google Groups "jBPM Setup" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-setup+...@googlegroups.com.
To post to this group, send email to jbpm-...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/76a565c5-b483-40c0-a89b-6a3f36368393%40googlegroups.com.

[ksgf...@gmail.com]

Actively running, no. And that h2 database used the standard usernames and passwords.

But i'll see if I can look into it on that front.

Another thing just came to my mind, regardless of this issue:  Where do I find the Authoring tab in JBPM 7.3.0 ? Or was this removed?  

The Documentation mentions it quite often, but I dont have it in the Workbench Menu. (Logged in as Admin).

[ksgf...@gmail.com]

Sorry for Doubleposting..

Just cleaned the JBPM Installer and rerun the Evaluation example. 

It gets a bit further so there was a problem there, but now I get another Error:  https://pastebin.com/xTxmpYAp

Thanks

[Maciej Swiderski]

looks like a missing jaxb … might be something with the jvm you run on. 

you could add these to pom.xml to avoid it …

<dependency>
	<groupId>com.sun.xml.bind</groupId>
	<artifactId>jaxb-core</artifactId>
	</dependency>
	<dependency>
	<groupId>com.sun.xml.bind</groupId>
	<artifactId>jaxb-impl</artifactId>
	</dependency>

Maciej

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/627fc10d-e4a6-4e7d-9d8d-c5dcc76ff630%40googlegroups.com.

[ksgf...@gmail.com]

I tried that, the Error changed a bit, but sadly it didnt resolve. 

Its now https://pastebin.com/i8qM3FHv .

Im running Java 9 JDK on MAC if thats any help.  

[Maciej Swiderski]

try with java 8… 9 is “relatively” young so I do expect number of frameworks to have issues with it.

Maciej

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/a18afff4-90a7-4439-8a5c-413f835e06bb%40googlegroups.com.

[ksgf...@gmail.com]

I'll do that.  Thanks for the help so far.

I'll write again when that resolves it or not.

[ksgf...@gmail.com]

Yep, Issue resolved.  

Using Java 8 helped.  

Thanks alot.

Another thing:  I cant seem to find the "Authoring" Menu in the 7.3.0 Workbench. Was that removed or is that only available to certain users ? (I used Admin so far).

The Authoring Tab is often mentioned in the Documentation and Userguide, but I cant seem to find it in 7.3.0.

Thanks =)

[Maciej Swiderski]

On 10 Oct 2017, at 12:36, ksgf...@gmail.com wrote:

Yep, Issue resolved.  

Using Java 8 helped.  

Thanks alot.

Another thing:  I cant seem to find the "Authoring" Menu in the 7.3.0 Workbench. Was that removed or is that only available to certain users ? (I used Admin so far).

The Authoring Tab is often mentioned in the Documentation and Userguide, but I cant seem to find it in 7.3.0.

it was not removed but redesigned so it follows new approach - Library - you can still do pretty much all that you had in previous versions but in simpler way :)

On the home screen, you have a Design (Create and modify projects and dashboards) - this is where you want to go - so you can author your busienss assets. There you can create new project or import one. If you need to cloe repository from outside your the import option there and select advanced import and then custom. There you will be able to put git url and off you go :)

Maciej

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/1067324d-34f9-44b9-8b25-c0cdbf4f29a2%40googlegroups.com.

[ksgf...@gmail.com]

Ah thanks alot, so I actually worked the whole time with that xD

One other Thing just turned up though:  The examples work with the JBPMHelper which is unfortunately a blackbox class when Im not mistaken.  

I guess thats where the configuration takes place.  Anywhere I could go to have a look at that file?  

Or is it available as a library of sorts?

Thanks in advance. =)

[Maciej Swiderski]

On 10 Oct 2017, at 16:07, ksgf...@gmail.com wrote:

Ah thanks alot, so I actually worked the whole time with that xD

yes, indeed, haven’t you noticed ;)

One other Thing just turned up though:  The examples work with the JBPMHelper which is unfortunately a blackbox class when Im not mistaken.  

I guess thats where the configuration takes place.  Anywhere I could go to have a look at that file?  

it’s part of the jbpm-test module that can be found here: 

https://github.com/kiegroup/jbpm/tree/master/jbpm-test/src/main/java/org/jbpm/test

Maciej

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/20724041-4a7e-440f-af69-74cc506a9c7b%40googlegroups.com.

[ksgf...@gmail.com]

Thanks again =)

Made my life a whole lot easier ;)

[ksgf...@gmail.com]

Would it be recommended to Setup JBPM like in the JPBM Helper or regarding to it being "deprecated" use RuntimeManager etc. direclty?

And are there any up to date examples of how such a setup would look like ?

Thanks again

[Maciej Swiderski]

it depends what you want to do… so if you could slightly elaborate what you’re trying to achieve that would be easier to suggest the way to go

Maciej

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/ff209e9e-67c3-4786-a912-3b04a722e26b%40googlegroups.com.

[ksgf...@gmail.com]

In the End I'd like to set up JBPM with an embedded Workbench on a JavaServer (for the time being locally on my Mac), to automate questionnaire processes.

I'm currently struggling with getting the setup in itself right, the Userguide often times sadly does not go into great detail or its unclear if parts of the guide are still viable for 7.3.0.

My main problem are: Where do I make my Configurations in a 7.3.0 JBPM Environment (Database connection etc.) and how to properly embed / include the Workbench in my Application.

Thanks 

[Maciej Swiderski]

Not sure what that means - embedded workbench - workbench is standalone jee app so how do you plan to embed it?

in version 7 workbench does not have capabilities to execute processes, it does allow to start process and so on but it actually interacts with remote kie server for that. With that in mind workbench does not have to have any data base connections.

On the other hand when you want to execute processes this is where kie server comes into the picture. And it does rely on data base. So you need to configure data base connection on the application server level that kie server simply looks up and uses.

By default it uses embedded H2 data base that comes with WildFly but it’s for demo purpose only. So when you need to use it for real then you need to reconfigure it and set additional system properties:

-Dorg.kie.server.persistence.dialect=org.hibernate.dialect.PostgreSQLDialect 

-Dorg.kie.server.persistence.ds=java:jboss/datasources/psjbpmDS

first is the hibernate dialect that matches your data base

second is name of the JNDI data source you created for the data base

and that’s all when it comes to configuration to change the db

Maciej

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/e057b621-d084-408a-ad44-be759eedbdd9%40googlegroups.com.

[ksgf...@gmail.com]

Oh okay, thanks.

I got the embedded part from the Userguide, so I wanted to use the Workbench as a GUI for the Process creation and stuff.

Is the Kie Server only remotely available or can I implement that on my Server? 

And is the Kie Server free / Open Source aswell? 

Thanks

[Maciej Swiderski]

On 12 Oct 2017, at 09:27, ksgf...@gmail.com wrote:

Oh okay, thanks.

I got the embedded part from the Userguide, so I wanted to use the Workbench as a GUI for the Process creation and stuff.

Is the Kie Server only remotely available or can I implement that on my Server? 

it can run anywhere, can be on same server as workbench, it can run in another server instance, it can run on another host etc. no restrictions whatsoever.

And is the Kie Server free / Open Source aswell? 

yes it is, it’s the same Apache license as workbench and entire KIE platform

Maciej

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/8254b173-48cb-4cd7-9a43-7de6b0844696%40googlegroups.com.

[ksgf...@gmail.com]

Okay thanks alot. 

I seem to have trouble finding it though. Where can I get the Kie Server?

Thanks in advance

[Maciej Swiderski]

it is included in jbpm installer or you can download it from maven

http://repository.jboss.org/nexus/content/groups/public/org/kie/server/kie-server/

Maciej

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/f3131bff-cb44-47c1-a06e-8391ddf672be%40googlegroups.com.

[ksgf...@gmail.com]

Thanks.