[JBoss Seam] - Connecting Booking demo to MySQL
by diablo341
I've done this with jboss-4.0.4RC1, but I can't get it to work with 4.0.5GA. I get the following exception:
14:37:01,354 INFO [EARDeployer] Started J2EE application: file:/C:/jboss-4.0.5.GA/server/default/deploy/workforce-planning.ear
| 14:37:01,364 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
|
| --- MBeans waiting for other MBeans ---
| ObjectName: persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
| State: NOTYETINSTALLED
| I Depend On:
| jboss.jca:name=workforceDatasource,service=DataSourceBinding
|
| ObjectName: persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
| State: NOTYETINSTALLED
| I Depend On:
| jboss.jca:name=workforceDatasource,service=DataSourceBinding
|
| ObjectName: persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
| State: NOTYETINSTALLED
| I Depend On:
| jboss.jca:name=workforceDatasource,service=DataSourceBinding
| Depends On Me:
| jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=BookingListAction,service=EJB3
| jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=ChangePasswordAction,service=EJB3
| jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=HotelBookingAction,service=EJB3
| jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=HotelSearchingAction,service=EJB3
| jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=LoginAction,service=EJB3
| jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=RegisterAction,service=EJB3
|
| ObjectName: jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=BookingListAction,service=EJB3
| State: NOTYETINSTALLED
| I Depend On:
| persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
|
| ObjectName: jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=ChangePasswordAction,service=EJB3
| State: NOTYETINSTALLED
| I Depend On:
| persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
|
| ObjectName: jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=HotelBookingAction,service=EJB3
| State: NOTYETINSTALLED
| I Depend On:
| persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
|
| ObjectName: jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=HotelSearchingAction,service=EJB3
| State: NOTYETINSTALLED
| I Depend On:
| persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
|
| ObjectName: jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=LoginAction,service=EJB3
| State: NOTYETINSTALLED
| I Depend On:
| persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
|
| ObjectName: jboss.j2ee:ear=workforce-planning.ear,jar=workforce-planning.jar,name=RegisterAction,service=EJB3
| State: NOTYETINSTALLED
| I Depend On:
| persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
|
| --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
| ObjectName: jboss.jca:name=workforceDatasource,service=DataSourceBinding
| State: NOTYETINSTALLED
| Depends On Me:
| persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
| persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
| persistence.units:ear=workforce-planning.ear,jar=workforce-planning.jar,unitName=workforceDatabase
persistence.xml:
<persistence>
| <persistence-unit name="workforceDatabase">
| <provider>org.hibernate.ejb.HibernatePersistence</provider>
| <jta-data-source>java:/workforceDatasource</jta-data-source>
| <properties>
| <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
| <property name="hibernate.case.user_query_cache" value="true"/>
| <property name="hibernate.show_sql" value="true"/>
| <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
| <property name="hibernate.connection.datasource" value="java:/workforceDatasource"/>
| </properties>
| </persistence-unit>
| </persistence>
jboss-beans.xml:
<?xml version="1.0" encoding="UTF-8"?>
|
| <deployment xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
| xsi:schemaLocation="urn:jboss:bean-deployer bean-deployer_1_0.xsd"
| xmlns="urn:jboss:bean-deployer">
|
| <bean name="workforceDatasourceBootstrap" class="org.jboss.resource.adapter.jdbc.local.LocalTxDataSource">
| <property name="driverClass">org.mysql.jdbc.Driver</property>
| <property name="connectionURL">jdbc:mysql://localhost:3306/workforce</property>
| <property name="userName">root</property>
| <property name="jndiName">java:/workforceDatasource</property>
| <property name="minSize">0</property>
| <property name="maxSize">10</property>
| <property name="blockingTimeout">1000</property>
| <property name="idleTimeout">100000</property>
| <property name="transactionManager"><inject bean="TransactionManager"/></property>
| <property name="cachedConnectionManager"><inject bean="CachedConnectionManager"/></property>
| <property name="initialContextProperties"><inject bean="InitialContextProperties"/></property>
| </bean>
|
| <bean name="workforceDatasource" class="java.lang.Object">
| <constructor factoryMethod="getDatasource">
| <factory bean="workforceDatasourceBootstrap"/>
| </constructor>
| </bean>
|
| </deployment>
workforce-ds.xml:
<datasources>
| <local-tx-datasource>
| <jndi-name>workforceDatasource</jndi-name>
| <connection-url>jdbc:mysql://localhost:3306/workforce</connection-url>
| <driver-class>com.mysql.jdbc.Driver</driver-class>
| <user-name>root</user-name>
| <password>mypass</password>
| </local-tx-datasource>
| </datasources>
I copied mysql-connector-java-3.1.11-bin.jar to server/default/lib. Any ideas?
John
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3985608#3985608
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3985608
19Â years, 7Â months