If you have started you workflow project using the build-in Derby Database from Glassfish you maybe can run into a performance problem if you manage a lot and complex of Data. This is because Derby is not so scalable in managing complex SQL statements like other Database Management Systems. In such a case you can easily migrate your workflow system form Derby to MySQL which is much more scalable.
Follow these steps to migrate data in a running system
- Start your Derby DB and Glassfish Server
- Make sure that your Workflow System is up and running
- Switch to the Imixs JEE Admin Client.
- Connect to the EntityPersistenceManager from your Workflow Instance
- Start a export using the default EQL Statement. This will export all existing Data of your workflow system into a file
>SELECT wii FROM Entity wiI
If the export did not succeed a reason can be the HeapSize of your Glassfish Server instance. You can increase the default HeapSize from 512m to 1024m using the Glassfish Admin Console.
Go to : Applicationserver->JVM Settings -> JVM Optionsand change -Xmx512m into -Xmx1024m
- Undeploy your Workflow Instance
- Shutdown your Derby Database
- Setup a new MySQL Database and create a new JDBC Connection Pool using the Glassfish Console
- Now you can switch the JDBC/Ressource of your Workflow System from your Derby Database to your new MySQL Database
- Deploy your Workflow Instance again – this will generate the necessary Tables in your new MySQL Database
- Optionall : after deplyoment you can setup Entity Index Fields manually if necessary
- Import your Data form the Export File you generated in Step 5.
If the import process fails on MySQL check the following:
If you got the Excepiton:
com.mysql.jdbc.PacketTooBigException: Packet for query is too large
you should change the max_allowed_packet setting in your MySQL server for the import process
- Open your MySQL console
>mysql -u root -p
- Change the max_allowed_packet setting
>SET GLOBAL max_allowed_packet=3000000000;
- Restart your Glassfish Server (not the MySQL Database!)
- Reimport your data
- Restart you MySQL Server and Glassfish Server to reset the max_allowed_packet settings.
If you got the Exeption:
javax.persistence.PersistenceException: Exception [TOPLINK-4002] (Oracle TopLink Essentials – 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘DATA’ at row 1
MySQL tells you that the BLOB field is to small to store the data. This is because MySQL generates per default a SmallBlob (64K) for your Data Fields in the Entity Table. You can change the Blob type after the deplyoment of your Workflow Instance :
- Open your MySQL console
>mysql -u root -p
- Connect to to your Database
- Change the BLOB Type to LONGBLOB (4GB) or MEDIUMBLOB (16MB)
>ALTER TABLE Entity CHANGE DATA DATA MEDIUMBLOB NOT NULL;
The new version of the IX Modeler for Eclipse is now available!
The new relase 2.2.9 of the Basic module and 2.2.6 of the Integration module includes a lot of enhancements of the user interface. The management of Process and Activity properties is now extended by a new property editor concept. All properties are now managed using the “Tabbed Properties View Extension Points”. This allows you to extend the IX Workflow Modeler in your Software projectes much faster as you can now use the eclipse standard extention point for tabbed properties.
The new version was tested with Eclipse 3.4.2 for Windows and Linux.
As we were often ask about the licensing of of the Imixs Open Source Workflow which is subject to the General Public License (GPL). I want to give you today a short idea how your own individual Software project is affected form this license when you are using the Imixs Workflow components.
Assuming that you plan to develop an individual software system using the Imixs Workflow System you have to take care about the subject of GPL. But since your software project is no workflow management system or a pure workflow engine, like the Imixs Workflow itself, there is no reason to worry about the GPL. You are free to use the Imixs Workflow components implementing any kind of business process application.
In contrast if you enhance or modify components of the Imixs Workflow Implementation or you implement a derived unit you are constrained to leave this code also under GPL.
Our goal is to avoid that someone restrict the purpose of the Imixs Workflow Software. Everyone is free to use the Imixs Workflow as free software in the manner of the Free Software Foundain (http://www.fsf.org/).
So we appreciate everybody who plan to use the Imixs Workflow in an individual Software Project. You be bound to inform your users and customer that Imixs Workflow is fee software under GPL. This means that he will receive also the source code (of the Imixs Workflow) or can get it if he want it. He can change the software or use pieces of it in new free programs.
If you enhance the Imixs Workflow you are bound to leave this code again under GPL and share your experience with the community.
So we did not restrict you in your freedom to develop software and business applications using the Imixs Workflow. We also did not restrict your freedom to distribute your software or charge for service if you wish.
Free Software is about to exchange experience and knowledge, not to restrict other people in there freedom to use it.
Today we opened a new Project HomePage on Kenai
Kenai is a social network for connected developers. You can find and collaborate with developers of like mind and passion from around the globe.
Currently its beta but I think this is a cool thing!
Currently we are working on the new 1.6 release of Imixs IX Workflow API and IX JEE Workflow Server. The new release will include a ReportService. This feature support a power full report function which allows you to generate dynamic reports based on running Business Processes. The Report Feature will be included into the IX REST Services so reports can be used very easy.
Also we extend the IX Workflow Modeler with a new Report Editor that allows a Workflow Modeler to create and manage reports as *.ixr files directly in a Eclipse project.
The new functionality will expand the Imixs IX Workflow Tool with a really strong feature set! Source code of new Version 1.6 will be available on subversion repository in a pre-beta version:
The new version 2.2.4 of the Imixs IX Workflow Modeler is now released. This version includes a lot of improvements concerning the graphical modeling. Therefor the popular style has changed. The attributes of activity entities,like Mail or Access Configurations, now are displayed graphicaly. The handling of users and time objects has been improved.
WEBSERVICE PLUGIN 1.3.0
Also the WebSerivce Plugin was updated to version 1.3.0. Et.al. it includes a better error handling, so connection failures will be displayed much better as in the releases before.
Also all these features are sucessfully tested in newest eclipse version Ganemede 3.4.
We are now also supporting Bea WebLogic Server 10.0. Currently Bea WebLogic 10.0 did not support all the functionality as specified in the JEE spec. Particularly the Web Service implementation is not completed so if you try to deploy the Imixs IX JEE Workflow components you need some modifications.
As there are some restrictions in Bea WebLogic 10.0 concerning the Web Service Functionality you could run into problems during deployment of the IX JEE Workflow components on Bea. But it is possible to run Imixs IX Workflow on Bea 10.0.
If you like to deploy the Imixs IX JEE Workflow components on a Bea WebLogic Server 10.0 there are some things you must pay attention to.
First we recommend to remove the WebService implementations
from the deployment.
Then it is useful to integrate the worklfow model in a programmatic way inside you Application. We are also supporting helpful component for this.
In general you can build your ear module like described in the chapters Deployment . But as Bea WebLogic 10.0 did not support all the functionality as specified in the JEE spec you need do some modifications. We published a description about the procedure here.
Additional we are supporting a new branch of the IX JEE Workflow for Bea WebLogic. You can checkout this branch on the Subversion Repository on java.net. The branch also supports the maven configuration management.
If you have questions about IX Workflow and Bea WebLogic please give us your feedback.
Since two months we are member of the java.net community. We moved our project to dev.java.netbecause the Imixs IX Workflow is mainly focused on Java Technologies. So the dev.java.net is a suitable place for our project.
As our newest subproject Imixs JEE Workflow is mainly developed on Glassfish Server we are also supporting a lot of deployment tips for Glassfish. So you will find now all the informations on one place.
We moved also the sources to dev.java.net which were hosted before on Sourceforge.