any pointers to getting this to work with oracle?<br><br><div class="gmail_quote">On Thu, Oct 11, 2007 at 4:48 AM, Shi Yusen <<a href="mailto:shiys@langhua.cn">shiys@langhua.cn</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi list,<br>
<br>
We are happy to announce the release of OpenCms7.0.1-jBPM3.1.2 module.<br>
<br>
<br>
What's new?<br>
1. A new Xmlcontent editor controlled by workflow.<br>
2. A new publish process you can use it as a sample to build your own.<br>
As here is such a publish workflow sample, we'll cease the development<br>
of OpenCms-OSWorkflow module.<br>
<br>
<br>
<br>
The bugs we know<br>
During the developing of this module, we found 2 main bugs:<br>
Bug 1. You have to import the module twice in OpenCms 7.0.1 to make it<br>
work.<br>
Solution: We'll upgrade to OpenCms 7.0.x (x > 1) to see whether the bug<br>
can be resolved.<br>
<br>
Bug 2. When synchronizing users from OpenCms to jBPM, there's a<br>
hibernate flush problem which may stop the sync.<br>
Solution: We'll try to upgrade to jBPM 3.2.x to see whether this bug can<br>
be gone.<br>
<br>
If you have any solutions to solve these bugs, or you find any bugs in<br>
this module, please do let us know. You can feedback to this list, or to<br>
our bugzilla: <a href="http://www.langhua.cn/bugzilla/" target="_blank">http://www.langhua.cn/bugzilla/</a><br>
<br>
<br>
<br>
Special thanks<br>
Thank Dalian Commodity Exchange and MFG.com who kindly sponsored this<br>
release.<br>
<br>
<br>
<br>
Source Code<br>
<a href="http://jbpm-opencms.cvs.sourceforge.net/jbpm-opencms/OpenCms-7.0.1-jBPM-3.1.2/" target="_blank">http://jbpm-opencms.cvs.sourceforge.net/jbpm-opencms/OpenCms-7.0.1-jBPM-3.1.2/</a><br>
<br>
<br>
<br>
Test Environments<br>
Tested on Fedora 6 + MySQL 5.0.27 + Tomcat 5.5.17 + OpenCms 7.0.1 + jBPM<br>
3.1.2<br>
      Windows XP + MySQL 4.1 +Tomcat 5.5.20 + OpenCms 7.0.1 + jBPM 3.1.2<br>
<br>
<br>
<br>
Setup Steps<br>
1. Import the jBPM-OpenCms module in your Administration view. Make sure<br>
the following jars are deployed with the module:<br>
        jbpm-3.1.2.jar<br>
        jbpm-identity-3.1.2.jar<br>
        jbpm-webapp-3.1.2.jar<br>
        hibernate3.jar<br>
        bsh-1.3.0.jar<br>
        cglib-2.1_2jboss.jar<br>
        antlr-2.7.5H3.jar<br>
        jta.jar<br>
        asm.jar<br>
        ehcache-1.1.jar<br>
        jdbc2_0-stdext.jar<br>
        asm-attrs.jar<br>
   jbpm-opencms-2.0.1.jar<br>
<br>
2. Config datasource:<br>
In OpenCms workplace,<br>
edit /system/modules/cn.langhua.opencms.jbpm/classes/hibernate.cfg.xml,<br>
modify the datasource if necessary.<br>
Edit ${CATALINA_HOME}/conf/context.xml, add the datasource you assigned.<br>
For example,<br>
        <Resource name="JbpmDS" auth="Container" type="javax.sql.DataSource"<br>
               maxActive="10" maxIdle="3" maxWait="2000"<br>
               username="username" password="password"<br>
driverClassName="com.mysql.jdbc.Driver"<br>
<br>
url="jdbc:mysql://localhost:3306/jbpm?autoReconnect=true"/><br>
<br>
3. Add jBPM servlets to web.xml<br>
(see /system/modules/cn.langhua.opencms.jbpm/docs/web.xml).<br>
<?xml version="1.0" encoding="UTF-8"?><br>
<br>
<web-app xmlns="<a href="http://java.sun.com/xml/ns/j2ee" target="_blank">http://java.sun.com/xml/ns/j2ee</a>"<br>
        xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>"<br>
        xsi:schemaLocation="<a href="http://java.sun.com/xml/ns/j2ee" target="_blank">http://java.sun.com/xml/ns/j2ee</a><br>
<a href="http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" target="_blank">http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd</a>"<br>
        version="2.4"><br>
<br>
    <display-name>OpenCms</display-name><br>
<br>
    <description><br>
        OpenCms, the Open Source Content Management System.<br>
        (c) 2005 Alkacon Software GmbH with contributions from the<br>
OpenCms community.<br>
        For more details about OpenCms, please see<br>
<a href="http://www.opencms.org/" target="_blank">http://www.opencms.org/</a>.<br>
        For more details about Alkacon Software GmbH, please see<br>
<a href="http://www.alkacon.com/" target="_blank">http://www.alkacon.com/</a>.<br>
    </description><br>
<br>
    <!--<br>
        Changing the servlet name from "opencms" to something else<br>
requires 3 changes in this file.<br>
        For example, to change the servlet name to "mycms" you must:<br>
<br>
        1. Change the <context-param> called "OpenCmsServlet" from<br>
"/opencms/*" to "/mycms/*"<br>
        2. Change the <servlet-mapping> for "OpenCmsServlet" from<br>
"/opencms/*" to "/mycms/*"<br>
        3. Change the <error-page> setting for the 404 error from<br>
"/opencms/handle404" to "/mycms/handle404"<br>
    --><br>
<br>
    <context-param><br>
        <param-name>OpenCmsServlet</param-name><br>
        <param-value>/opencms/*</param-value><br>
    </context-param><br>
<br>
    <context-param><br>
        <param-name>DefaultWebApplication</param-name><br>
        <param-value>ROOT</param-value><br>
    </context-param><br>
<br>
  <filter><br>
    <filter-name>LogFilter</filter-name><br>
    <filter-class>org.jbpm.webapp.filter.LogFilter</filter-class><br>
  </filter><br>
<br>
  <filter><br>
    <filter-name>JbpmContextFilter</filter-name><br>
    <filter-class>org.jbpm.web.JbpmContextFilter</filter-class><br>
  </filter><br>
<br>
  <filter-mapping><br>
    <filter-name>JbpmContextFilter</filter-name><br>
    <url-pattern>/*</url-pattern><br>
  </filter-mapping><br>
<br>
        <!--<br>
            Uncomment this parameter in case you change the web application<br>
context using an application server<br>
            specific deployment descriptor. E.g. in Jboss, you could use the<br>
jboss-web.xml file to deploy opencms under the<br>
            context 'myopencms' but still keep the files in the folder<br>
'opencms.war'<br>
<br>
    <context-param><br>
        <param-name>WebApplicationContext</param-name><br>
        <param-value>myopencms</param-value><br>
    </context-param><br>
    --><br>
<br>
    <listener><br>
<br>
<listener-class>org.opencms.main.OpenCmsListener</listener-class><br>
    </listener><br>
<br>
    <servlet><br>
        <description><br>
            The main servlet that handles all requests to the OpenCms<br>
VFS.<br>
        </description><br>
        <servlet-name>OpenCmsServlet</servlet-name><br>
        <servlet-class>org.opencms.main.OpenCmsServlet</servlet-class><br>
        <!-- Uncomment this if using BEA WLS 9.x --><br>
        <!--<br>
        <init-param><br>
                <param-name>OnErrorExitWithoutException</param-name><br>
                <param-value>true</param-value><br>
                <description><br>
                        This is important while the setup/update wizard is enabled.<br>
                        The default value of 'false' should work for almost all<br>
servlet containers.<br>
                        But if using BEA WLS 9.x, you should set it to 'true'.<br>
                </description><br>
        </init-param><br>
         --><br>
        <!-- Uncomment this if using BEA WLS 9.x --><br>
        <load-on-startup>1</load-on-startup><br>
    </servlet><br>
<br>
    <servlet><br>
        <description><br>
            The error handling servlet, also servers as trigger for<br>
static export requests.<br>
        </description><br>
        <servlet-name>OpenCmsServletErrorHandler</servlet-name><br>
<br>
<servlet-class>org.opencms.main.OpenCmsServletErrorHandler</servlet-class><br>
        <!-- Uncomment this if using BEA WLS 9.x --><br>
        <!--<br>
        <init-param><br>
                <param-name>OnErrorExitWithoutException</param-name><br>
                <param-value>true</param-value><br>
                <description><br>
                        This is important while the setup/update wizard is enabled.<br>
                        The default value of 'false' should work for almost all<br>
servlet containers.<br>
                        But if using BEA WLS 9.x, you should set it to 'true'.<br>
                </description><br>
        </init-param><br>
        <init-param><br>
                <param-name>RequestErrorPageAttribute</param-name><br>
                <param-value>weblogic.servlet.errorPage</param-value><br>
                <description><br>
                        This is only needed when the HttpServletRequest#getPathInfo() is<br>
not<br>
                        really working as expected like in BEA WLS 9.x, where you have<br>
to use<br>
                        the 'weblogic.servlet.errorPage' attribute.<br>
                </description><br>
        </init-param><br>
         --><br>
        <!-- Uncomment this if using BEA WLS 9.x --><br>
        <load-on-startup>0</load-on-startup><br>
    </servlet><br>
<br>
    <servlet><br>
        <description><br>
            Creates an access to OpenCms through WebDAV.<br>
        </description><br>
        <servlet-name>OpenCmsWebDavServlet</servlet-name><br>
<br>
<servlet-class>org.opencms.webdav.CmsWebdavServlet</servlet-class><br>
        <init-param><br>
          <param-name>listings</param-name><br>
          <param-value>true</param-value><br>
        </init-param><br>
        <init-param><br>
          <param-name>readonly</param-name><br>
          <param-value>false</param-value><br>
        </init-param><br>
        <init-param><br>
          <param-name>repository</param-name><br>
          <param-value>standard</param-value><br>
        </init-param><br>
    </servlet><br>
 <servlet><br>
    <servlet-name>JbpmThreadsServlet</servlet-name><br>
    <servlet-class>org.jbpm.web.JbpmThreadsServlet</servlet-class><br>
    <load-on-startup>1</load-on-startup><br>
  </servlet><br>
  <servlet-mapping><br>
    <servlet-name>JbpmThreadsServlet</servlet-name><br>
    <url-pattern>/threads</url-pattern><br>
  </servlet-mapping><br>
<servlet><br>
    <servlet-name>ProcessImageServlet</servlet-name><br>
<br>
<servlet-class>org.jbpm.webapp.servlet.ProcessImageServlet</servlet-class><br>
  </servlet><br>
  <servlet-mapping><br>
    <servlet-name>ProcessImageServlet</servlet-name><br>
    <url-pattern>/processimage</url-pattern><br>
  </servlet-mapping><br>
    <servlet-mapping><br>
        <servlet-name>OpenCmsServlet</servlet-name><br>
        <url-pattern>/opencms/*</url-pattern><br>
    </servlet-mapping><br>
<br>
    <servlet-mapping><br>
        <servlet-name>OpenCmsServletErrorHandler</servlet-name><br>
        <url-pattern>/opencms-errorhandler/*</url-pattern><br>
    </servlet-mapping><br>
<br>
    <servlet-mapping><br>
      <servlet-name>OpenCmsWebDavServlet</servlet-name><br>
      <url-pattern>/webdav/*</url-pattern><br>
    </servlet-mapping><br>
<br>
    <session-config><br>
        <session-timeout>30</session-timeout><br>
    </session-config><br>
<br>
    <welcome-file-list><br>
        <welcome-file>index.jsp</welcome-file><br>
        <welcome-file>index.html</welcome-file><br>
        <welcome-file>index_export.html</welcome-file><br>
    </welcome-file-list><br>
<br>
    <error-page><br>
        <error-code>404</error-code><br>
        <location>/opencms-errorhandler/handle404</location><br>
    </error-page><br>
<br>
        <error-page><br>
        <error-code>500</error-code><br>
<br>
<location>/opencms-errorhandler/system/handler/handle500.html</location><br>
    </error-page><br>
<br>
        <jsp-config><br>
            <taglib><br>
                <taglib-uri><a href="http://www.opencms.org/taglib/cms" target="_blank">http://www.opencms.org/taglib/cms</a></taglib-uri><br>
                <taglib-location>/WEB-INF/opencms.tld</taglib-location><br>
            </taglib><br>
        </jsp-config><br>
<br>
</web-app><br>
<br>
4. Add jbpm_cms.tld in WEB-INF folder.<br>
<?xml version="1.0"?><br>
<br>
<!DOCTYPE taglib PUBLIC<br>
    "-//Sun Microsystems, Inc.//DTD JSP Tag Library 1.1//EN"<br>
    "<a href="http://java.sun.com/j2ee/dtds/web-jsptaglibrary_1_1.dtd" target="_blank">http://java.sun.com/j2ee/dtds/web-jsptaglibrary_1_1.dtd</a>"><br>
<br>
<taglib><br>
  <tlibversion>1.0</tlibversion><br>
  <jspversion>1.1</jspversion><br>
  <shortname>jBPM_OpenCMS tags</shortname><br>
  <info>jBPM_OpenCMS tags</info><br>
<br>
  <!-- PROCESS IMAGE --><br>
  <tag><br>
    <name>processimage</name><br>
    <tagclass>cn.langhua.opencms.tools.jbpm.CmsProcessImage</tagclass><br>
    <bodycontent>empty</bodycontent><br>
    <attribute><br>
        <name>task</name><br>
        <required>true</required><br>
        <rtexprvalue>true</rtexprvalue><br>
    </attribute><br>
  </tag><br>
<br>
  <tag><br>
    <name>processimageToken</name><br>
    <tagclass>cn.langhua.opencms.tools.jbpm.CmsProcessImage</tagclass><br>
    <bodycontent>empty</bodycontent><br>
    <attribute><br>
        <name>token</name><br>
        <required>true</required><br>
        <rtexprvalue>true</rtexprvalue><br>
    </attribute><br>
  </tag><br>
<br>
</taglib><br>
<br>
5. Add <mimetype extension=".process" type="application/zip" /> in the<br>
<mimetypes> of <opencms-vfs.xml><br>
<br>
6. Restart Tomcat.<br>
<br>
7. Create jBPM database tables. You can set the database parameter of<br>
this module and put the scripts accordingly.<br>
<br>
8. You can upload the websale.process or publish.process in this folder<br>
and run it as a sample.<br>
<br>
<br>
<br>
Regards,<br>
<br>
Shi Jinghai/Beijing Langhua Ltd.<br>
<br>
<br>
<br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
<a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Andrew R. Thompson<br>Currently in N.Y *not* Consulting