JBossDeveloper

iam sorry for my stupid.. post... now i got that fixed ... it is hust because the problem with struts 1.1.jar file when i re downloaded it and placed in lib file it running fine...

and really Thanks for every thing .. espesially Diwa you helped me a lot... really my heartful thanks to you


Thanks & Regards
sam

hello sam,

its good to hear that its finally working!
enjoy...........

regards and thanks
diwa

I tried following these steps to install jbpm3.1.2 to tomcat 5.5.17. It fails for me when I try to create database.

Here is the error -

[loadidentities] 16:30:32,474 [main] DEBUG DbPersistenceService : beginning hibe
rnate transaction
[loadidentities] 16:30:33,376 [main] WARN JDBCExceptionReporter : SQL Error: -8
0, SQLState: 08000
[loadidentities] 16:30:33,376 [main] ERROR JDBCExceptionReporter : socket creati
on error
[loadidentities] 16:30:33,376 [main] DEBUG JbpmContext : closing JbpmContext
[loadidentities] 16:30:33,376 [main] DEBUG Services : closing service 'persisten
ce': org.jbpm.persistence.db.DbPersistenceService@ae1cf
[loadidentities] 16:30:33,376 [main] DEBUG DbPersistenceService : flushing hiber
nate session
[loadidentities] 16:30:33,376 [main] DEBUG DbPersistenceService : closing hibern
ate session

BUILD FAILED
D:\Java\jbpm-starters-kit-3.1.2\jbpm\build.deploy.xml:50: org.hibernate.exceptio
n.JDBCConnectionException: Cannot open connection

I appreciate if anyone can help me here. Thank you.

- Meghana

---------------------------------------------------------------------

"diwa_pv" wrote:
hi,

Even i faced the same problem while deploying the 3.1 version of jbpm on tomcat! but finally made it on tomcat.

My tomcat version was 5.x and used Oracle 9i as backend!


<b>
Here are the steps i followed to deploy 3.1 version of jbpm on tomcat. </b>

<ul>
<li>
Download jbpm-starters-kit-3.1.1 from Jboss site
</li>
<li>
Deploy jbpm-starters-kit-3.1.1\jbpm-server\server\jbpm\deploy\jbpm.war into tomcat webapps.
</li>
<li>
Copy hibernate.cfg.xml from jbpm-starters-kit-3.1.1\jbpm\src\config.files to ur <jbpm-home>/WEB-INF/classes/
</li>
<li>
Run ant task for creating database tables and data from jbpm-starters-kit-3.1.1\jbpm\build.deploy.xml
( ant create.db ?buildfile build.deploy.xml)
</li>
<li>
Add few jars to lib folder of your application.
</li>
<li>
Start tomcat.
</li>
<li>
Start jbpm application.
</li>
</ul>


thanks and regards
diwa

hi,

please go through the entire thread. iam sure you will find the solution at the end.

thanks and regards
diwa

I am sorry but following this thread did not lead me to anything useful. In my console log I can see that it cannot connect to the database. Actually there is nothing created in jbpm\build\db. I am faily new to jBoss and hibernate so it is relatively hard to debug the problem. The first stack trace I get on my console is -

[jbpmschema] 16:30:26,014 [main] INFO DriverManagerConnectionProvider : using d
river: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost:1701
[jbpmschema] 16:30:26,014 [main] INFO DriverManagerConnectionProvider : connect
ion properties: {user=sa, password=****}
[jbpmschema] 16:30:27,086 [main] ERROR SchemaExport : schema export unsuccessful

[jbpmschema] java.sql.SQLException: socket creation error
[jbpmschema] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[jbpmschema] at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
[jbpmschema] at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
[jbpmschema] at org.hsqldb.jdbcDriver.connect(Unknown Source)
[jbpmschema] at java.sql.DriverManager.getConnection(DriverManager.java:525)
[jbpmschema] at java.sql.DriverManager.getConnection(DriverManager.java:140)
[jbpmschema] at org.hibernate.connection.DriverManagerConnectionProvider.getC
onnection(DriverManagerConnectionProvider.java:110)
[jbpmschema] at org.hibernate.tool.hbm2ddl.SchemaExport$ProviderConnectionHel
per.getConnection(SchemaExport.java:467)
[jbpmschema] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.
java:183)
[jbpmschema] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.j

Do I need to run some other script before the creation of schema starts? to get database created in that folder?

- Meghana

ok so finally I got the db created and deployed my jbpm web application on tomcat successfully. Now I get server error 500. Here is the stack trace -

javax.faces.FacesException: Cannot get value for expression '#{userBean.userSelectItems}'
org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch(ServletExternalContextImpl.java:421)
org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:234)
org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:300)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:95)
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:703)

It is coming from login.jsp when it tries to resolve userSelectItems. How do I debug this now? Do I have specify these users somewhere so that they are created in db?

Thank you in advance,

Meghana

ok I finally got it working with Tomcat 5.5.17 and derby. In addition to the jars listed in this thread, I had copy derby jars to to web-inf\lib and j2ee.jar to <tomcat-home>\shared\lib.

Thought of posting it back for those who are struggling to get Jbpm running on tomcat even after following this thread and the blog post

http://blogs.sun.com/chengfang/entry/how_to_run_jbpm_on

- Meghana

hello,

I've a pb when using ant in step 4.
I finally managed to configure DB and hibernate, but then fall on a xml parging error?

[deployprocess] deploying process archive C:\JBPM\jbpm-starters-kit-3.1.2\jbpm\build\websale.process ...
[deployprocess] 17:26:23,265 [main] DEBUG JbpmContextInfo : creating jbpm context with service factories '[persistence]'
[deployprocess] 17:26:23,265 [main] DEBUG JbpmContext : creating JbpmContext
[deployprocess] 17:26:23,312 [main] WARN JpdlParser : couldn't set xml parser property 'http://java.sun.com/xml/jaxp/properties/schemaLanguage' to 'http://www.w3.org/2001/XMLSchema'
[deployprocess] org.xml.sax.SAXNotRecognizedException: Property: http://java.sun.com/xml/jaxp/properties/schemaLanguage
[deployprocess] at org.apache.crimson.parser.XMLReaderImpl.setProperty(Unknown Source)
[deployprocess] at org.apache.crimson.jaxp.SAXParserImpl.setProperty(Unknown Source)
[deployprocess] at org.jbpm.jpdl.xml.JpdlParser.createXmlReader(JpdlParser.java:77)
............( error stack).......

do you have some advice for what to look for ?

Mathieu

hi diwa_pv,
follow your steps and finally I encounted such some problems like blow. I use mysql. Can you do me a favor to tell me what is wrong?

org.apache.jasper.JasperException: Cannot get value for expression '#{userBean.userSelectItems}'
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.jbpm.webapp.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:55)
org.jbpm.web.JbpmContextFilter.doFilter(JbpmContextFilter.java:83)
org.jbpm.webapp.filter.LogFilter.doFilter(LogFilter.java:59)


Regards and thanks.
Vt00098

o, I forget someting. I have created the database in mysql. and I have change the hibernate.cfg.xml file to met the request. but it didn't work.

I resolve the pb. I didn't init the userbean.

hi,

i was just about to send u the reply to your problem. but you found the way out of it! Its really good to see most of them are successfully deploying jbpm on tomcat after seeing this post!

regards and thanks
diwa

hi

diwa, u r every kind.i really appreciate your help.

regards and thanks

Hi vt00098.
Can you tell me how do you init the userbean?
Thanks.

Hi, I try to run Jbpm with tomcat, after following all the steps given in this theard when I try to run the Jbpm application I got the following error message:

HTTP Status 404 - /jbpm/

type Status report
message /jbpm/
description The requested resource (/jbpm) is not available

Could someone help me please.