5 Replies Latest reply on Apr 28, 2016 9:16 AM by Anish Jr

    JDBC Realm with JBPM 6

    Anish Jr Newbie

      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

        • 1. Re: JDBC Realm with JBPM 6
          Rustam Usmanov Apprentice

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

          • 2. Re: JDBC Realm with JBPM 6
            Anish Jr Newbie

            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.

            • 3. Re: JDBC Realm with JBPM 6
              Rustam Usmanov Apprentice

              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.

              • 4. Re: JDBC Realm with JBPM 6
                Anish Jr Newbie

                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>
                • 5. Re: JDBC Realm with JBPM 6
                  Anish Jr Newbie

                  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