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