Java Mailing List Archive

http://www.junlu.com/

Google
Google
Mailing List
Home
Forum Home
JBoss - Java Application Server
Tomcat - JSP/Servlet container
Struts - A MVC web framework
iText - An open source PDF Java Library
JDOM - JDOM XML Parser
J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition
JSP - A mailing list about Java Server Pages specification and reference
J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog
Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology
Struts & Hibernate
Subjects
• JSP editor plugin for eclipse ?
• org apache jasper JasperException: Unable to compile class for JSP
• Tomcat: Connection reset by peer: socket write error
• Cannot retrieve definition for form bean null
• Struts Tiles Tutorial (free Struts training)
• Where do I download Tomcat 4 0 6?
• Data Access Object (DAO) pattern, example DAO 's
• Where to download Tomcat v 4 1 24 from?
• Tomcat 5 0 16 Requested resource not available
• Servlet : Session invalidate
• Oracle Connection Pooling in 3 2 2
• Servlet action is currently unavailable
• Tomcat/Struts Unicode Encoding/Decoding problems
• Running a Simple JMS Example
• Tomcat and webapplication specific java library path
• Mapping in workers2 properties
• org apache jasper JasperException
• problem with html:text bean throwing exception
• Cannot find message resources under key org apache struts action
   MESSAGE
• Cannot find message resources under key org apache struts action MESSAGE
• invalid direct reference problem with solution
• Tool for jsp debug Try Sysdeo Eclipse Plugin
• Tomcat 5 Cannot load JDBC driver class 'null ' SQL state: null
• weblogic ejbc
• java properties file
• Jboss 3 2 3 Coyote Can 't re
• Tomcat 5, Apache2 and mod jk2 integration problem
• JBoss example problem new to J2EE
• Value attribute of <html:checkbox
• url string for connecting jboss to oracle
• javax servlet ServletException: BeanUtils populate
• 5 0 18: Windows XP Pro vs Windows 2000
• HTTP Status 404 The requested resource is not available
 
-none-

-none-

2007-08-14       - By jitendrasupe

 Back
I am new bee to JBPM.  Trying to deploy the sample application given in the
jbpm-jpdl-suite-3 (See http://ite-3.ora-code.com).2.1.

I am following documentation given for jbpm-jpdl-suite-3 (See http://ite-3.ora-code.com).2.1 Getting started
but getting following errors while starting the server from the folder "jbpm
-jpdl-suite-3 (See http://ite-3.ora-code.com).2.1\jbpm-jpdl-3 (See http://pdl-3.ora-code.com).2.1\server\bin" with command "run -c jbpm".


2007-08-14 11:13:06,616 DEBUG [org.hibernate.loader.hql.QueryLoader]
bindNamedParameters() Tue Aug 14 11:13:06 IST 2007 -> now [3]
2007-08-14 11:13:06,616 DEBUG [org.hibernate.loader.hql.QueryLoader]
bindNamedParameters() JbpmJobExector:172.17.225.114:1 -> lockOwner [2]
2007-08-14 11:13:06,647 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to
close PreparedStatement (open PreparedStatements: 1, globally: 1)
2007-08-14 11:13:06,663 DEBUG [org.hibernate.util.JDBCExceptionReporter] could
not execute query [select job0_.ID_ as ID1_26_, job0_.VERSION_ as VERSION3_26_,
job0_.DUEDATE_ as DUEDATE4_26_, job0_.PROCESSINSTANCE_ as PROCESSI5_26_, job0_
.TOKEN_ as TOKEN6_26_, job0_.TASKINSTANCE_ as TASKINST7_26_, job0_.ISSUSPENDED_
as ISSUSPEN8_26_, job0_.ISEXCLUSIVE_ as ISEXCLUS9_26_, job0_.LOCKOWNER_ as
LOCKOWNER10_26_, job0_.LOCKTIME_ as LOCKTIME11_26_, job0_.EXCEPTION_ as
EXCEPTION12_26_, job0_.RETRIES_ as RETRIES13_26_, job0_.NAME_ as NAME14_26_,
job0_.REPEAT_ as REPEAT15_26_, job0_.TRANSITIONNAME_ as TRANSIT16_26_, job0_
.ACTION_ as ACTION17_26_, job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_26_, job0_
.GRAPHELEMENT_ as GRAPHEL19_26_, job0_.NODE_ as NODE20_26_, job0_.CLASS_ as
CLASS2_26_ from JBPM_JOB job0_ where (job0_.LOCKOWNER_ is null or job0_
.LOCKOWNER_=?) and job0_.RETRIES_>0 and job0_.DUEDATE_<=? and job0_.ISSUSPENDED_
<>1 order by job0_.DUEDATE_ asc]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near '1 job0_.ID_ as ID1_26_, job0_.VERSION_ as
VERSION3_26_, job0_.DUEDATE_ as DUEDAT' at line 1
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
  at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java
:1268)
  at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
  at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery
(CachedPreparedStatement.java:90)
  at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery
(WrappedPreparedStatement.java:236)
  at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
  at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
  at org.hibernate.loader.Loader.doQuery(Loader.java:662)
  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader
.java:224)
  at org.hibernate.loader.Loader.doList(Loader.java:2145)
  at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
  at org.hibernate.loader.Loader.list(Loader.java:2024)
  at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
  at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
  at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
  at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
  at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
  at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java
:756)
  at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
  at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java
:111)
  at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)
2007-08-14 11:13:06,663 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL
Error: 1064, SQLState: 42000
2007-08-14 11:13:06,663 ERROR [org.hibernate.util.JDBCExceptionReporter] You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '1 job0_.ID_ as ID1_26_,
job0_.VERSION_ as VERSION3_26_, job0_.DUEDATE_ as DUEDAT' at line 1
2007-08-14 11:13:06,663 ERROR [org.jbpm.db.JobSession] org.hibernate.exception
.SQLGrammarException: could not execute query
2007-08-14 11:13:06,663 DEBUG [org.jbpm.JbpmContext] closing JbpmContext
2007-08-14 11:13:06,663 DEBUG [org.jbpm.svc.Services] closing service
'persistence': org.jbpm.persistence.db.DbPersistenceService@(protected)
2007-08-14 11:13:06,663 DEBUG [org.jbpm.persistence.db.DbPersistenceService]
committing hibernate transaction org.hibernate.transaction.JDBCTransaction
@(protected)

Here are  configuration files I have changed for configuring Mysql DB

--- hibernate.cfg --



<?xml version='1.0' encoding='utf-8 (See http://utf-8.ora-code.com)'?>

<!DOCTYPE hibernate-configuration PUBLIC
         "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
         "http://hibernate.sourceforge.net/hibernate-configuration-3 (See http://ion-3.ora-code.com).0.dtd">

<hibernate-configuration>
 <session-factory>

   <!-- mysql dialect -->
   org.hibernate.dialect.MySQLDialect
   <!-- JDBC connection properties (begin) -->
   com.mysql.jdbc.Driver
   jdbc:mysql://172.17.225.171:3306/jbpm_sample
   root
   password
   org.hibernate.transaction.JDBCTransactionFactory

   <!-- JDBC connection properties (end) -->
   
   org.hibernate.cache.HashtableCacheProvider
   
   
   <!-- ############################################ -->
   <!-- # mapping files with external dependencies # -->
   <!-- ############################################ -->

   <!-- following mapping file has a dependendy on   -->
   <!-- 'bsh-{version}.jar'.                         -->
   <!-- uncomment this if you don't have bsh on your -->
   <!-- classpath.  you won't be able to use the     -->
   <!-- script element in process definition files   -->
   

   <!-- following mapping files have a dependendy on  -->
   <!-- 'jbpm-identity.jar', mapping files            -->
   <!-- of the pluggable jbpm identity component.     -->
   <!-- Uncomment the following 3 lines if you        -->
   <!-- want to use the jBPM identity mgmgt           -->
   <!-- component.                                    -->
   <!-- identity mappings (begin) -->
   
   
   
   <!-- identity mappings (end) -->
   
   <!-- following mapping files have a dependendy on  -->
   <!-- the JCR API                                   -->

   <!-- ###################### -->
   <!-- # jbpm mapping files # -->
   <!-- ###################### -->

   <!-- hql queries and type defs -->
   

   <!-- graph.action mapping files -->
   
   
   <!-- graph.def mapping files -->
   
   
   
   
   
   
   
   

   <!-- graph.node mapping files -->
   
   
   
   
   
   
   
   
   

   <!-- context.def mapping files -->
   
   

   <!-- taskmgmt.def mapping files -->
   
   
   
   

   <!-- module.def mapping files -->
   

   <!-- bytes mapping files -->
   

   <!-- file.def mapping files -->
   

   <!-- scheduler.def mapping files -->
   
   

   <!-- graph.exe mapping files -->
   
   
   
   

   <!-- module.exe mapping files -->
   
       
   <!-- context.exe mapping files -->
   
   
   
   
   
   
   
   
   
   
   

   <!-- job mapping files -->
   
   
   
   

   <!-- taskmgmt.exe mapping files -->
   
   
   
   

   <!-- logging mapping files -->
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
 </session-factory>
</hibernate-configuration>


--- jbpm-ds.xml ----


<?xml version="1.0" encoding="UTF-8 (See http://UTF-8.ora-code.com)"?>


  <local-tx-datasource>
     <jndi-name>JbpmDS</jndi-name>
     <connection-url>jdbc:mysql://172.17.225.171:3306/jbpm_sample</connection
-url>
     <driver-class>com.mysql.jdbc.Driver</driver-class>
     <user-name>root</user-name>
     password
     <min-pool-size>1</min-pool-size>
     <max-pool-size>5</max-pool-size>
     <idle-timeout-minutes>0</idle-timeout-minutes>
     <track-statements/>
     <prepared-statement-cache-size>32</prepared-statement-cache-size>
     <type-mapping>MySQL</type-mapping>
  </local-tx-datasource>



Please help in solving this issue in case you are aware of .

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic
&p=4073840#4073840

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode
=reply&p=4073840
__ ____ ____ ____ ____ ____ ____ ____ ____ ____
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user
©2008 junlu.com - Jax Systems, LLC, U.S.A.