[JBoss jBPM] - Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
by ygiriyap
the hibernate entries are as below ...
anonymous wrote :
| | <!-- hibernate dialect -->
| | <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
| |
| | <!-- JDBC connection properties (begin) -->
| | <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
| | <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpm32test</property>
| | <property name="hibernate.connection.username">root</property>
| | <property name="hibernate.connection.password">admin</property>
| | <!-- JDBC connection properties (end) -->
| |
| | <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
| |
| | <!-- DataSource properties (begin) -->
| | <property name="hibernate.connection.datasource">java:/JbpmDS</property>
| | <!-- DataSource properties (end) -->
| |
Thanks,
--Yash
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4031916#4031916
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4031916
19Â years
[JBoss jBPM] - Re: JBPM 3.2 on tomcat which uses mysql - LOGINI UNSUCCESSFU
by ygiriyap
Yes ... I have done the following things ....
1. I have all the user,group and membership tables popluated properly in mysql db as in the default hsqldb. (this seems to be fine for me)
2. I have configured tomcat to use the mysql db.
In the file ... WEB-INF\classes\hibernate.cfg.xml ... following modifications were made.
<!-- hibernate dialect -->
org.hibernate.dialect.MySQLInnoDBDialect
<!-- JDBC connection properties (begin) -->
com.mysql.jdbc.Driver
jdbc:mysql://localhost:3306/jbpm32test
root
admin
<!-- JDBC connection properties (end) -->
org.hibernate.cache.HashtableCacheProvider
<!-- DataSource properties (begin) -->
java:/JbpmDS
<!-- DataSource properties (end) -->
Pls let me know if the hibernate properties are configured properly.
Do I need a Datasource as mentioned above?(wan not there for jbpm 3.1.4)
AND KINDLY LET ME KNOW THE RIGHT MINIMAL LIST OF THE JAR FILES NEEDED TO GET THIS WORKING.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4031915#4031915
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4031915
19Â years
[EJB 3.0] - multiple persistence unit in one persistence.xml
by nzhiv
Can I use two and more datasource in one persistence.xml?
When I use one persistence-unit tag in persistence.xml, it's work.
When I added second persistence-unit tag in persistence.xml I received next error message
anonymous wrote : 2007-03-26 16:18:24,646 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
| org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ?????????? ?????/??????: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))))
| at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
| at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:565)
| at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:250)
| at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:491)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
| at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:301)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
| at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
| at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
| at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)
| at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1933)
| at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1216)
| at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:688)
| at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
| at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:264)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.jboss.ejb3.ServiceDelegateWrapper.startService(ServiceDelegateWrapper.java:102)
| .......
|
My persistence.xml :
<?xml version="1.0" encoding="UTF-8"?>
| <persistence>
| <persistence-unit name="clrProd" transaction-type="JTA">
| <jta-data-source>java:/jdbc/ClrProdDS</jta-data-source>
| <properties>
| <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle9Dialect"/>
| </properties>
| </persistence-unit>
|
| <persistence-unit name="clrArch">
| <jta-data-source>java:/jdbc/ClrArchDS</jta-data-source>
| <provider>org.hibernate.ejb.HibernatePersistence</provider>
| <properties>
| <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle9Dialect"/>
| </properties>
| </persistence-unit>
| </persistence>
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4031908#4031908
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4031908
19Â years
[Persistence, JBoss/CMP, Hibernate, Database] - column: value (should be mapped with insert=
by ebross
08:22:39,984 WARN [ServiceController] Problem starting service persistence.units:ear=odmsapp.ear,unitName=odmsPersistenceUnit
| javax.persistence.PersistenceException: org.hibernate.MappingException: Repeated column in mapping for entity: com.xxxx.xx.pojo.service.ServiceEntity column: value (should be mapped with insert="false" update="false")
| at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:733)
| at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
| at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:242)
|
I understand this error except that I don't have a column called 'value'. Is 'value' a placeholder for some column? This same error is thrown in more than one entity.
I have undone the changes I made before I got this error but the error still appears. I would be very grateful if someone would explain to me what 'value' is.
Thanks
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4031905#4031905
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4031905
19Â years