[jboss-user] [JBoss jBPM] - hibernate error when using jbpm on tomcat

[MDemont]

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) - com.mchange.v2.c3p0.impl.NewPooledConnection at 1c57a6a 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