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