[jBPM] - jBPM 5.2 setup on Jboss7.1b error
by Tony D
Tony D [http://community.jboss.org/people/pushpak1981] created the discussion
"jBPM 5.2 setup on Jboss7.1b error"
To view the discussion, visit: http://community.jboss.org/message/643936#643936
--------------------------------------------------------------
Hi
I have installed jBPM 5.2 on Jboss 7.1b. I modified the following files to point to my oracle 11g database.
1. standalone.xml
2. jbpm-gwt-console-server.war
a. persistence.xml
b. hibernate.cfg.xml
c. JBPMorm.xml
After starting the server JPA is loaded and the following error occurs:
18:50:18,828 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-2) MSC00001: Failed to start service jboss.persistenceunit."jbpm-gwt-console-server.war#org.jbpm.persistence.jpa": org.jboss.msc.service.StartException in service jboss.persistenceunit."j
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1780) [jboss-msc-1.0.1.GA.jar:]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [:1.6.0_03]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [:1.6.0_03]
at java.lang.Thread.run(Thread.java:619) [:1.6.0_03]
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:890)
at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:73)
at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:149)
at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.start(PersistenceUnitServiceImpl.java:79)
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824) [jboss-msc-1.0.1.GA.jar:]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759) [jboss-msc-1.0.1.GA.jar:]
... 3 more
Caused by: org.hibernate.MappingException: Could not determine type for: java.util.Set, at table: ProcessInstanceInfo, for columns: [org.hibernate.mapping.Column(eventTypes)]
at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:304)
at org.hibernate.mapping.SimpleValue.isValid(SimpleValue.java:288)
at org.hibernate.mapping.Property.isValid(Property.java:216)
at org.hibernate.mapping.PersistentClass.validate(PersistentClass.java:467)
at org.hibernate.mapping.RootClass.validate(RootClass.java:268)
at org.hibernate.cfg.Configuration.validate(Configuration.java:1287)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1718)
at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:76)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:905)
... 9 more
Is there anything wrong in the configuration.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/643936#643936]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
11 years, 2 months
[Datasource Configuration] - AS7: Wrong Driver Class for Postgresql
by zaq xsw
zaq xsw [http://community.jboss.org/people/akpramod] created the discussion
"AS7: Wrong Driver Class for Postgresql"
To view the discussion, visit: http://community.jboss.org/message/643777#643777
--------------------------------------------------------------
Dear JBoss users,
I am facing an issue with creating the postgresql connection pool with postgres 9.1 + AS7.
I deployed the postgres jdbc driver in the deployments folder and then when the standalone server is started, I see the following exceptions.
The postgres database is up and running.
=====
08:29:03,281 INFO [org.jboss.as.jpa] (MSC service thread 1-1) added javax.persistence.api dependency to postgresql-9.1-901.jdbc4.jar
08:29:03,312 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) Deploying non-JDBC-compliant driver class org.postgresql.Driver (version 9.1)
08:29:03,328 INFO [org.jboss.as.server.controller] (Controller Boot Thread) Deployed "postgresql-9.1-901.jdbc4.jar"
08:29:03,515 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) Bound data source [java:jboss/datasources/myDS]
08:29:03,546 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (JCA PoolFiller) IJ000610: Unable to fill pool: javax.resource.ResourceException: Could not create connection
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:706) [ironjacamar-core-impl-1.0.3.Final.jar:1.0.3.Final]
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.fillToMin(SemaphoreArrayListManagedConnectionPool.java:653) [ironjacamar-core-impl-1.0.3.Final.jar:1.0.3.Final]
at org.jboss.jca.core.connectionmanager.pool.mcp.PoolFiller.run(PoolFiller.java:97) [ironjacamar-core-impl-1.0.3.Final.jar:1.0.3.Final]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_30]
Caused by: javax.resource.ResourceException: *Wrong driver class [class org.postgresql.Driver] for this connection URL [jdbc:postgres://localhost:5432/mydb]*
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:251)
... 5 more
08:29:03,578 INFO [org.jboss.as] (Controller Boot Thread) JBoss AS 7.0.2.Final "Arc" started in 8782ms - Started 108 of 165 services (57 services are passive or on-demand)
=====
My datasource configuration in standalone.xml is as below.
=====
+<datasources>+
+ <datasource jndi-name="java:jboss/datasources/myDS" pool-name="myDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">+
+ <connection-url> jdbc:postgres://localhost:5432/mydb </connection-url>+
+ <driver-class> org.postgresql.Driver </driver-class>+
+ <driver> postgresql-9.1-901.jdbc4.jar </driver>+
+ <pool>+
+ <min-pool-size> 10 </min-pool-size>+
+ <max-pool-size> 100 </max-pool-size>+
+ <prefill> true </prefill>+
+ <use-strict-min> false </use-strict-min>+
+ <flush-strategy> FailingConnectionOnly </flush-strategy>+
+ </pool>+
+ <security>+
+ <user-name> admin </user-name>+
+ <password> abc123 </password>+
+ </security>+
+ <statement>+
+ <prepared-statement-cache-size> 32 </prepared-statement-cache-size>+
+ <share-prepared-statements/>+
+ </statement>+
+ </datasource>+
+ <drivers>+
+ <driver name="postgresql-9.1-901.jdbc4.jar" module="org.postgresql">+
+ <driver-class> org.postgresql.Driver </driver-class>+
+ <xa-datasource-class> org.postgresql.xa.PGXADataSource </xa-datasource-class>+
+ </driver>+
+ </drivers>+
+</datasources>+
=====
Thanks.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/643777#643777]
Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
11 years, 2 months