JDBC Realm with JBPM 6

[anishjr]

Hai ,

    I want to integrate my application with JBPM 6 . All i want is to use users from my application to connect with  JBPM. As i see we can satisfy with JDBC realm or with LDAP connection servers. Can anyone suggest how to configure JDBC realm with JBPM

[zcc39r]

If you use WildFly you should at least configure a security domain for jBPM using DatabaseServerLoginModule. See Security subsystem configuration.

[anishjr]

Thank you Rustam for your active participation.

As from your reply, its right if we use container authentication autherization we have to configure security sub system for container.. My concern is that is there any way to use JBPM authentication authorization which uses external applications users and roles.

[zcc39r]

As regards human tasks you could try to use org.kie.internal.task.api.UserInfo and org.kie.internal.task.api.UserGroupCallback interfaces. Look at jbpm/UserDataServiceProvider.java. You can select db-aware implementation via corresponding system property.

[anishjr]

Ya seems so. But i have configured exactly wat said in the document ...

Standalone.xml

	<datasources>
	<datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
	<connection-url>jdbc:mysql://192.168.181.129:3306/jbpmdb</connection-url>
	<driver>mysql</driver>
	<security>
	<user-name>root</user-name>
	<password>emrdb2</password>
	</security>
	</datasource>
	<datasource jta="true" jndi-name="java:jboss/datasources/jbpmDS" pool-name="MySQLDS" enabled="true" use-java-context="true" use-ccm="true">
	<connection-url>jdbc:mysql://192.168.181.129:3306/jbpmdb</connection-url>
	<driver>mysql</driver>
	<security>
					<user-name>root</user-name>
	<password>emrdb2</password>
	</security>
	</datasource>
	<drivers>
	<driver name="mysql" module="com.mysql">
	<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
	</driver>
	</drivers>
	</datasources>

[anishjr]

jbpm-persistence-JPA2.xml

<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />

build.properties

db.name=mysql

db.driver.module.prefix=com/mysql

db.driver.jar.name=mysql-connector-java-5.1.18.jar

db.driver.download.url=https://repository.jboss.org/nexus/service/local/repositories/central/content/mysql/mysql-connector-java/5.1.18/mysql-connector-java-5.1.18.jar