Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Jul 12 21:48
    rsoika labeled #752
  • Jul 12 21:48
    rsoika labeled #751
  • Jul 12 21:48
    rsoika labeled #752
  • Jul 12 21:48
    rsoika labeled #752
  • Jul 12 21:47

    rsoika on imixs-workflow-5.2

    implementation Issue #752 (compare)

  • Jul 12 21:35

    rsoika on master

    implementation Issue #751 (compare)

  • Jul 12 20:50
    rsoika milestoned #752
  • Jul 12 20:50
    rsoika opened #752
  • Jul 12 20:50
    rsoika commented #751
  • Jul 12 20:49
    rsoika milestoned #751
  • Jul 12 20:49
    rsoika labeled #751
  • Jul 12 20:49
    rsoika opened #751
  • Jul 06 09:11
    rsoika commented #750
  • Jul 06 09:02
    rsoika labeled #750
  • Jul 06 09:02
    rsoika opened #750
  • Jul 06 09:02
    rsoika milestoned #750
  • Jul 05 21:57

    rsoika on master

    docu (compare)

  • Jul 05 21:17

    rsoika on master

    [maven-release-plugin] prepare … (compare)

  • Jul 05 21:17

    rsoika on imixs-workflow-6.0.0

    (compare)

  • Jul 05 21:17

    rsoika on master

    [maven-release-plugin] prepare … (compare)

Ralph Soika
@rsoika
@Aparna1995 : you can remove a model by using the Rest API. Take a look here
@95pratik : of course you can use a database realm. But than you must maintain your user database. This is an Wildfly topic and independent from the Imixs-Workflow. With Imixs-Workflow you can use any kind of authentication configured in your application serer. Just make sure your users are in one of the security roles (e.g. org.imixs.ACCESSLEVEL.AUTHORACCESS). Take a look here
Pratik Kumar
@95pratik
sir, i am getting following missing error.
"WFLYCTL0412: Required services that are not installed:" => [
"jboss.security.security-domain.imixsrealm",
"jboss.naming.context.java.mail.\"org.imixs.workflow.mail\""
],
"WFLYCTL0180: Services with missing/unavailable dependencies" => [
"jboss.deployment.unit.\"imixs-jsf-example-4.2.0.war\".component.JobHandlerMigration3X.CREATE is missing [jboss.
security.security-domain.imixsrealm]",
Pratik Kumar
@95pratik
sir please help me ..
Ahmed Taha
@engahmedtahaa
Hello pratik
please copy this stand alone file instead of your one
Pratik Kumar
@95pratik
@engahmedtahaa only standalone or persistent as well??
@engahmedtahaa more lines are there in standalone.xml
Ahmed Taha
@engahmedtahaa
not that
jndi-name="java:/jdbc/workflow" pool-name="workflow"
make sure the the pool-name
the same as jndi-name

<?xml version='1.0' encoding='UTF-8'?>

<server xmlns="urn:jboss:domain:4.0">

<extensions>
    <extension module="org.jboss.as.clustering.infinispan"/>
    <extension module="org.jboss.as.connector"/>
    <extension module="org.jboss.as.deployment-scanner"/>
    <extension module="org.jboss.as.ee"/>
    <extension module="org.jboss.as.ejb3"/>
    <extension module="org.jboss.as.jaxrs"/>
    <extension module="org.jboss.as.jdr"/>
    <extension module="org.jboss.as.jmx"/>
    <extension module="org.jboss.as.jpa"/>
    <extension module="org.jboss.as.jsf"/>
    <extension module="org.jboss.as.logging"/>
    <extension module="org.jboss.as.mail"/>
    <extension module="org.jboss.as.naming"/>
    <extension module="org.jboss.as.pojo"/>
    <extension module="org.jboss.as.remoting"/>
    <extension module="org.jboss.as.sar"/>
    <extension module="org.jboss.as.security"/>
    <extension module="org.jboss.as.transactions"/>
    <extension module="org.jboss.as.webservices"/>
    <extension module="org.jboss.as.weld"/>
    <extension module="org.wildfly.extension.batch.jberet"/>
    <extension module="org.wildfly.extension.bean-validation"/>
    <extension module="org.wildfly.extension.io"/>
    <extension module="org.wildfly.extension.request-controller"/>
    <extension module="org.wildfly.extension.security.manager"/>
    <extension module="org.wildfly.extension.undertow"/>
</extensions>

<system-properties>
    <property name="eclipselink.archive.factory" value="org.jipijapa.eclipselink.JBossArchiveFactoryImpl"/>
</system-properties>


<management>
    <security-realms>
        <security-realm name="ManagementRealm">
            <authentication>
                <local default-user="$local" skip-group-loading="true"/>
                <properties path="mgmt-users.properties" relative-to="jboss.server.config.dir"/>
            </authentication>
            <authorization map-groups-to-roles="false">
                <properties path="mgmt-groups.properties" relative-to="jboss.server.config.dir"/>
            </authorization>
        </security-realm>
        <security-realm name="ApplicationRealm">
            <authentication>
                <local default-user="$local" allowed-users="*" skip-group-loading="true"/>
                <properties path="application-users.properties" relative-to="jboss.server.config.dir"/>
            </authentication>
            <authorization>
                <properties path="application-roles.properties" relative-to="jboss.server.config.dir"/>
            </authorization>
        </security-realm>
    </security-realms>
    <audit-log>
        <formatters>
            <json-formatter name="json-formatter"/>
        </formatters>
        <handlers>
            <file-handler name="file" formatter="json-formatter" path="audit-log.log" relative-to="jboss.server.data.dir"/>
        </handlers>
        <logger log-boot="true" log-read-only="false" enabled="false">
            <handlers>
                <handler name="file"/>
            </handlers>
        </logger>
    </audit-log>
    <management-interfaces>
        <http-interface security-realm="ManagementRealm" http-upgrade-enabled="true">
            <socket-binding http="management-http"/>
        </http-interface>
    </management-interfaces>
    <access-control provider="simple">
        <role-mapping>
            <role name="SuperUser">
                <include>
                    <user name="$local"/>
                </include>
            </role>
        </role-mapping>
    </access-control>
</management>

<profile>
    <subsystem xmlns="urn:jboss:domain:logging:3.0">
        <console-handler name="CONSOLE">
            <level name="FINE"/>
            <formatter>
                <named-formatter na
Pratik Kumar
@95pratik
@engahmedtahaa java:/jdbc/workflow_db I have configured in database on web console of jboss
Ahmed Taha
@engahmedtahaa
can you send me your standalone
your issue related to DB connection
Pratik Kumar
@95pratik
okay I am sending but entire file will not send once here
Ahmed Taha
@engahmedtahaa
send me on my email
Pratik Kumar
@95pratik
yeah that would be better
jst sending
Pratik Kumar
@95pratik
I have sent the required documents please have a look on it @engahmedtahaa
did you get it my mail??
Ralph Soika
@rsoika
@engahmedtahaa Thank you for your support!
lodhipr
@lodhipr
I need a help, I am unable to use my controller class file stored in the .../org/.../ui/ folder location, does it need any entry in the any record file, As I have simple created new class file as DataListController.java by simple coping code of TeamListController.java and changing class name as DataListController, Instead of calling TeamListController I called DataListController in TeamList.xhtml but it does not display and information from the Table Team Which it shows using TeamListController, please provide me a way how to add my own controller file and display data in TeamList.XHTML file.
Hi can you provide me a location where does the table workitem and team stores data in back end and fetch it. I do not find any location or data entry in the project.
Ralph Soika
@rsoika
@lodhipr can you post your code example on github? It is easier for me if we can discuss a concrete example.
Pratik Kumar
@95pratik

{"WFLYCTL0080: Failed services" => {"jboss.deployment.unit.\"imixs-jsf-example-4.2.0.war\".undertow-deployment" => "javax.ejb.EJBTransactionRolledbackException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.4.v20190115-ad5b7c6b2a): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'imixs.document' doesn't exist

Error Code: 1146

Call: SELECT ID AS a1, CREATED AS a2, DATA AS a3, MODIFIED AS a4, TYPE AS a5, VERSION AS a6 FROM DOCUMENT WHERE (TYPE IN (?, ?)) ORDER BY CREATED ASC LIMIT ?, ?

bind => [4 parameters bound]

Query: ReadAllQuery(referenceClass=Document sql=\"SELECT ID AS a1, CREATED AS a2, DATA AS a3, MODIFIED AS a4, TYPE AS a5, VERSION AS a6 FROM DOCUMENT WHERE (TYPE IN (?, ?)) ORDER BY CREATED ASC LIMIT ?, ?\")
Caused by: javax.ejb.EJBTransactionRolledbackException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.4.v20190115-ad5b7c6b2a): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'imixs.document' doesn't exist

Error Code: 1146

Call: SELECT ID AS a1, CREATED AS a2, DATA AS a3, MODIFIED AS a4, TYPE AS a5, VERSION AS a6 FROM DOCUMENT WHERE (TYPE IN (?, ?)) ORDER BY CREATED ASC LIMIT ?, ?

bind => [4 parameters bound]

Query: ReadAllQuery(referenceClass=Document sql=\"SELECT ID AS a1, CREATED AS a2, DATA AS a3, MODIFIED AS a4, TYPE AS a5, VERSION AS a6 FROM DOCUMENT WHERE (TYPE IN (?, ?)) ORDER BY CREATED ASC LIMIT ?, ?\")
Caused by: javax.ejb.EJBException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.4.v20190115-ad5b7c6b2a): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'imixs.document' doesn't exist

Error Code: 1146

Call: SELECT ID AS a1, CREATED AS a2, DATA AS a3, MODIFIED AS a4, TYPE AS a5, VERSION AS a6 FROM DOCUMENT WHERE (TYPE IN (?, ?)) ORDER BY CREATED ASC LIMIT ?, ?

bind => [4 parameters bound]

Query: ReadAllQuery(referenceClass=Document sql=\"SELECT ID AS a1, CREATED AS a2, DATA AS a3, MODIFIED AS a4, TYPE AS a5, VERSION AS a6 FROM DOCUMENT WHERE (TYPE IN (?, ?)) ORDER BY CREATED ASC LIMIT ?, ?\")
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.4.v20190115-ad5b7c6b2a): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'imixs.document' doesn't exist

Error Code: 1146

Call: SELECT ID AS a1, CREATED AS a2, DATA AS a3, MODIFIED AS a4, TYPE AS a5, VERSION AS a6 FROM DOCUMENT WHERE (TYPE IN (?, ?)) ORDER BY CREATED ASC LIMIT ?, ?

bind => [4 parameters bound]

Query: ReadAllQuery(referenceClass=Document sql=\"SELECT ID AS a1, CREATED AS a2, DATA AS a3, MODIFIED AS a4, TYPE AS a5, VERSION AS a6 FROM DOCUMENT WHERE (TYPE IN (?, ?)) ORDER BY CREATED ASC LIMIT ?, ?\")
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.4.v20190115-ad5b7c6b2a): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'imixs.document' doesn't exist

Error Code: 1146

Call: SELECT ID AS a1, CREATED AS a2, DATA AS a3, MODIFIED AS a4, TYPE AS a5, VERSION AS a6 FROM DOCUMENT WHERE (TYPE IN (?, ?)) ORDER BY CREATED ASC LIMIT ?, ?

bind => [4 parameters bound]

Query: ReadAllQuery(referenceClass=Document sql=\"SELECT ID AS a1, CREATED AS a2, DATA AS a3, MODIFIED AS a4, TYPE AS a5, VERSION AS a6 FROM DOCUMENT WHERE (TYPE IN (?, ?)) ORDER BY CREATED ASC LIMIT ?, ?\")
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'imixs.document' doesn't exist"}}

@rsoika sir security issue is reloved but now i am getting this error
Ralph Soika
@rsoika
This looks like something with your persistence.xml or datapool is not correct. can you post your persistance.xml on gihub?
Pratik Kumar
@95pratik
do i need to add any dependency in pom.xml

<?xml version="1.0" encoding="UTF-8"?>

<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence">

<!-- Imixs JPA definition Make sure that the imixs-workflow-jee library version maches the version provided by the EAR/EJB -->

<!-- eclipselink -->
<persistence-unit name="org.imixs.workflow.jpa" transaction-type="JTA">
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
<jta-data-source>jdbc/workflow</jta-data-source>
<jar-file>lib/imixs-workflow-engine-${org.imixs.workflow.version}.jar</jar-file>
<properties>
<!-- target-database Auto MySQL PostgreSQL -->
<property name="eclipselink.target-database" value="Auto" />
<property name="eclipselink.ddl-generation" value="create-tables" />
<property name="eclipselink.deploy-on-startup" value="true" />
<property name="eclipselink.logging.level" value="INFO" />

<!-- disable 2nd level cache <property name="eclipselink.cache.shared.default" value="false" /> <property name="eclipselink.query-results-cache" value="false"/> -->
</properties>
</persistence-unit>



</persistence>

Ralph Soika
@rsoika
@95pratik no dependencies are not needed, just make sure you can ping the database
Pratik Kumar
@95pratik
@rsoika this is my persistence.xml
Ralph Soika
@rsoika
@95pratik persistence.xml looks fine. Do you have the property 'org.imixs.workflow.version' defined in your pom.xml? If not you need to place the version number here.
Pratik Kumar
@95pratik
yes sir
@rsoika <dependency>
<groupId>org.imixs.workflow</groupId>
<artifactId>imixs-workflow-engine</artifactId>
<version>${org.imixs.workflow.version}</version>
</dependency>
    <dependency>
        <groupId>org.imixs.workflow</groupId>
        <artifactId>imixs-workflow-jax-rs</artifactId>
        <version>${org.imixs.workflow.version}</version>
    </dependency>

    <dependency>
        <groupId>org.imixs.workflow</groupId>
        <artifactId>imixs-workflow-faces</artifactId>
        <version>${org.imixs.workflow.version}</version>
    </dependency>
Ralph Soika
@rsoika
I'm in a meeting for a moment. Am back in an hour.
Pratik Kumar
@95pratik

okay sir

thanks for suppoort

waiting for your response

Ralph Soika
@rsoika
@95pratik ok your persistence.xml and pom is fine. So I guess there is something with the database. Can you ping the database from your jboss web console?
Pratik Kumar
@95pratik
sir i have tested with database connection and its saying successfull
@rsoika sir , can i send my standalone.xml
Ralph Soika
@rsoika
@95pratik what is more important is the log file. You only posted the message "Table 'imixs.document' doesn't exist". But during deployment of your application there must be much more information about what exactly happens.
Pratik Kumar
@95pratik
sir since log file is quite large How can i upload here??
Ralph Soika
@rsoika
please open an issue in github here. And yes -we do not need the complete log file. Just the part when you start deploying your application.
Pratik Kumar
@95pratik
@rsoika sir jst uploaded the server log please have a look on it
Pratik Kumar
@95pratik

@rsoika
okay sir

thanks for suppoort

waiting for your response

Pratik Kumar
@95pratik
sir uploaded the stabdalone.xml on same url @rsoika
Pratik Kumar
@95pratik
@rsoika sir application is deployed successfully but only imixs-jsf-example.war is visible please tell me sir where its rest of the pages??