jBPM7: org.postgresql.jdbc.PgPreparedStatement.setCharacterStream(int, Reader, long) is not yet impl

[Mário Cerqueira]

Hi,

I'm trying to using the jBPM7 installer with PostgreSQL 9.4.

In build.properties:

db.name=postgresql
db.driver.module.prefix=org/postgresql
db.driver.jar.name=postgresql-42.1.1.jar
db.driver.download.url=https://jdbc.postgresql.org/download/postgresql-42.1.1.jar

I also changed standalone-full-wildfly-10.1.0.Final.xml and created db/postgresql_module.xml.

When starting the demo with:

ant start.demo.noeclipse i'm getting a lot of Method org.postgresql.jdbc.PgPreparedStatement.setCharacterStream(int, Reader, long) is not yet implemented. Full log attached.

2017-07-05 11:08:17,280 INFO  [org.kie.server.controller.impl.KieServerControllerImpl] (default task-1) Server http://pcmac.local.saco.pt:8080/kie-server/services/rest/server connected to controller
2017-07-05 11:08:17,285 INFO  [org.jbpm.workbench.ks.integration.KieServerDataSetManager] (default task-1) Server instance 'default-...@pcmac.local.saco.pt:8080' connected, registering data sets
2017-07-05 11:08:17,287 INFO  [org.kie.server.controller.rest.RestKieServerControllerImpl] (default task-1) Server with id 'default-kieserver' connected
2017-07-05 11:08:17,319 INFO  [org.kie.server.api.marshalling.xstream.XStreamMarshaller] (default task-2) XStreamMarshallerExtension implementation found: org.kie.server.services.jbpm.xstream.HibernateXStreamMarshallerExtension
2017-07-05 11:08:17,322 INFO  [org.kie.server.services.impl.controller.ControllerConnectRunnable] (KieServer-ControllerConnect) Connected to controller, quiting connector thread
2017-07-05 11:08:17,322 INFO  [org.kie.server.services.impl.ContainerManager] (EJB default - 5) About to install containers '[]' on kie server 'KieServer{id='default-kieserver'name='default-kieserver'version='7.0.0.Final'location='http://pcmac.local.saco.pt:8080/kie-server/services/rest/server'}'
2017-07-05 11:08:17,391 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-2) SQL Error: 0, SQLState: 0A000
2017-07-05 11:08:17,392 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-2) Method org.postgresql.jdbc.PgPreparedStatement.setCharacterStream(int, Reader, long) is not yet implemented.
2017-07-05 11:08:17,393 WARN  [org.jbpm.shared.services.impl.TransactionalCommandService] (default task-2) Could not commit session: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.kie.services.impl.query.persistence.QueryDefinitionEntity]
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608)
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1152)
    at org.jbpm.shared.services.impl.JpaPersistenceContext.persist(JpaPersistenceContext.java:144)

[Maciej Swiderski]

you need to set the dialect via system property as currently it uses H2 and most likely that is the root cause of this errors:

-Dorg.kie.server.persistence.dialect=org.hibernate.dialect.PostgreSQLDialect

If I am not mistaken you need to add that to build.xml https://github.com/kiegroup/jbpm/blob/master/jbpm-installer/src/main/resources/build.xml#L458

Maciej

--
You received this message because you are subscribed to the Google Groups "jBPM Setup" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-setup+...@googlegroups.com.
To post to this group, send email to jbpm-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/5e142ea6-5270-4550-9c00-b4347cc09bd8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
<server.log>