well, i tried to setup jbpm (from jbpm.war) to tomcat server, and it seem to 
work:
- I configured hibernate.cfg.xml to connect to mysql, create db & table & few 
datas (the insert lines from 
http://docs.jboss.com/jbpm/v3/userguide/thejbpmdatabase.html#d0e2251 )

- and I can now connect to http://127.0.0.1:8080/jbpm/
(I then got the same page as when I used jbpm server & hypersonic)

- but if I try to use eclipse plugin to upload a process, it have that strange 
error :?
<log...>
Hibernate: 
    /* named HQL query GraphSession.findLatestProcessDefinitionQuery */ select
        processdef0_.ID_ as ID1_4_,
        processdef0_.NAME_ as NAME2_4_,
        processdef0_.VERSION_ as VERSION3_4_,
        processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_4_,
        processdef0_.STARTSTATE_ as STARTSTATE5_4_ 
    from
        JBPM_PROCESSDEFINITION processdef0_ 
    where
        processdef0_.NAME_=? 
    order by
        processdef0_.VERSION_ desc limit ?
2006-12-14 17:11:18,828 DEBUG [http-8080-Processor23] 
org.hibernate.jdbc.AbstractBatcher (AbstractBatcher.java:421) - preparing 
statement
2006-12-14 17:11:18,875 DEBUG [http-8080-Processor23] 
com.mchange.v2.c3p0.impl.NewPooledConnection (NewPooledConnection.java:367) - 
[EMAIL PROTECTED] handling a throwable.
java.sql.SQLException: 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 
'?' at line 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
        at 
com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
        at 
com.mysql.jdbc.ServerPreparedStatement.(ServerPreparedStatement.java:151)
        at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
        at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
        at 
com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190)
        at 
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:439)
        at 
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:366)
        at 
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
        at org.hibernate.loader.Loader.doQuery(Loader.java:661)
        at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
        at org.hibernate.loader.Loader.doList(Loader.java:2147)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
        at org.hibernate.loader.Loader.list(Loader.java:2021)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
        at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1020)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
        at 
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:650)
        at 
org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)
        at 
org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:67)
        at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)
        at 
org.jbpm.webapp.servlet.UploadServlet.doDeployment(UploadServlet.java:94)
        at 
org.jbpm.webapp.servlet.UploadServlet.handleRequest(UploadServlet.java:81)
        at org.jbpm.webapp.servlet.UploadServlet.service(UploadServlet.java:50)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

do you have any suggestion ?

Mathieu

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

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3993924
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to