[EJB 3.0] - How to configure an embedded Ejb to connect to MySql?
by mnrz
Hi all
I have a problem connection the embedded Ejb to a database other than Hsqldb that currently used in all Seam examples.
I am using registration example and change its config files to connect to MySql but it doesnt work. I want to use Ejb persistence.
every document I see has an example with Hsqldb.
any help greatly appreciated.
here is my config files:
persistence.xml
| <persistence>
| <persistence-unit name="testDatabase">
| <provider>org.hibernate.ejb.HibernatePersistence</provider>
| <!-- -->
|
| <jta-data-source>testDatasource</jta-data-source>
| <properties>
| <property name="hibernate.hbm2ddl.auto" value="update" />
| <property name="hibernate.show_sql" value="true" />
| <!-- These are the default for JBoss EJB3, but not for HEM: -->
| <property name="hibernate.cache.provider_class"
| value="org.hibernate.cache.HashtableCacheProvider" />
| <property name="hibernate.transaction.manager_lookup_class"
| value="org.hibernate.transaction.JBossTransactionManagerLookup" />
| <property name="hibernate.dialect"
| value="org.hibernate.dialect.MySQLDialect" />
| </properties>
| </persistence-unit>
| </persistence>
|
and 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:2.0">
|
| <bean name="testDatasourceBootstrap"
| class="org.jboss.resource.adapter.jdbc.local.LocalTxDataSource">
|
| <property name="driverClass">com.mysql.jdbc.Driver</property>
| <property name="connectionURL">
| jdbc:mysql://192.168.0.157:3306/seamtest?autoReconnect=true&useUnicode=true&characterEncoding=UTF8
| </property>
| <property name="userName">root</property>
| <property name="password">root</property>
| <property name="jndiName">testDatasource</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="testDatasource" class="java.lang.Object">
| <constructor factoryMethod="getDatasource">
| <factory bean="testDatasourceBootstrap" />
| </constructor>
| </bean>
|
| </deployment>
|
|
and this is exception message I receive:
|
| (core.Ejb 94 ) starting the embedded EJB container
| (xml.BeanSchemaBinding 227 ) You should use the 2.0 version of the Microcontainer xml.
| xmlns='ur
| n:jboss:bean-deployer:2.0'
| (local.LocalTxDataSource 117 ) Bound datasource to JNDI name 'java:/DefaultDS'
| (local.LocalTxDataSource 117 ) Bound datasource to JNDI name 'testDatasource'
| (ejb3.Ejb3DescriptorHandler 1699) adding class annotation org.jboss.annotation.internal.Def
| aultInterc
| eptorMarker to com.seam.web.action.RegisterAction org.jboss.annotation.internal.DefaultInterceptorMa
| rkerImpl@5
| f0e7d
| (ejb3.Ejb3Deployment 467 ) EJB3 deployment time took: 1656
| (ejb3.MCKernelAbstraction 84 ) installing bean: persistence.units:jar=registration-web.j
| ar,unitNam
| e=testDatabase with dependencies:
| (ejb3.MCKernelAbstraction 87 ) AbstractDependencyMetaData@9719f4{dependency=testDat
| asource}
| (ejb.Version 94 ) Hibernate EntityManager 3.2.0.CR1
| (annotations.Version 94 ) Hibernate Annotations 3.2.0.CR1
| (cfg.Environment 94 ) Hibernate 3.2 cr2
| (cfg.Environment 94 ) hibernate.properties not found
| (cfg.Environment 94 ) Bytecode provider name : cglib
| (cfg.Environment 94 ) using JDK 1.4 java.sql.Timestamp handling
| (ejb.Ejb3Configuration 94 ) Processing PersistenceUnitInfo [
| name: testDatabase
| ...]
| (ejb.Ejb3Configuration 94 ) found EJB3 Entity bean: com.seam.dto.User
| (ejb.Ejb3Configuration 104 ) Persistence provider caller does not implements the EJB3
| spec corre
| ctly. PersistenceUnitInfo.getNewTempClassLoader() is null.
| (cfg.Configuration 94 ) Reading mappings from resource: META-INF/orm.xml
| (ejb.Ejb3Configuration 94 ) [PersistenceUnit: testDatabase] no META-INF/orm.xml found
|
| (cfg.AnnotationBinder 94 ) Binding entity from annotated class: com.seam.dto.User
| (annotations.EntityBinder 94 ) Bind entity com.seam.dto.User on table user
| (connection.ConnectionProviderFactory 94 ) Initializing connection provider: org.hibernate.ejb.conn
| ection.Inj
| ectedDataSourceConnectionProvider
| (connection.InjectedDataSourceConnectionProvider 94 ) Using provided datasource
| (local.LocalTxDataSource 271 ) Throwable while attempting to get a new connection: null
| org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jbo
| ss.resourc
| e.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Dri
| ver, url:
|
| jdbc:mysql://192.168.0.157:3306/seamtest?autoReconnect=true&useUnicode=true&characterE
| ncoding=UTF8)
| at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnecti
| on(LocalMa
| nagedConnectionFactory.java:177)
| at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventL
| istener(In
| ternalManagedConnectionPool.java:579)
| at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(Internal
| ManagedCon
| nectionPool.java:247)
| at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JB
| ossManaged
| ConnectionPool.java:540)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConn
| ectionMana
| ger2.java:339)
| at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectio
| nManager.j
| ava:301)
| at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnec
| tionManage
| r2.java:392)
| at org.jboss.resource.adapter.jdbc.local.LocalTxDataSource$ConnectionManagerDelegate.allocat
| eConnectio
| n(LocalTxDataSource.java:78)
| at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88
| )
| at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionP
| rovider.ja
| va:69)
| at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)
| at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1928)
| at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1211)
| at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:631)
|
| at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:760
| )
| at org.hibernate.ejb.Ejb3Configuration.createContainerEntityManagerFactory(Ejb3Configuration
| .java:350)
|
| at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersi
| stence.jav
| a:119)
| 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.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:55)
| at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImp
| l.java:107
| )
| at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.dispatch(BasicMethodJoinPoint.java:66)
| at org.jboss.kernel.plugins.dependency.KernelControllerContextActions.dispatchJoinPoint(Kern
| elControll
| erContextActions.java:100)
| at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$LifecycleAction.instal
| lAction(Ke
| rnelControllerContextActions.java:582)
| at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$KernelControllerContex
| tAction.in
| stall(KernelControllerContextActions.java:175)
| at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerC
| ontextActi
| ons.java:51)
| at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.
| java:226)
| at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:593)
| at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:34
| 6)
| at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:4
| 38)
| at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:3
| 79)
| at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:225)
| at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:151)
| at org.jboss.kernel.plugins.dependency.AbstractKernelController.install(AbstractKernelContro
| ller.java:
| 79)
| at org.jboss.kernel.plugins.dependency.AbstractKernelController.install(AbstractKernelContro
| ller.java:
| 73)
| at org.jboss.ejb3.MCKernelAbstraction.install(MCKernelAbstraction.java:91)
| at org.jboss.ejb3.Ejb3Deployment.startPersistenceUnits(Ejb3Deployment.java:626)
| at org.jboss.ejb3.Ejb3Deployment.start(Ejb3Deployment.java:475)
| at org.jboss.ejb3.embedded.EJB3StandaloneDeployer.start(EJB3StandaloneDeployer.java:460)
| at org.jboss.seam.core.Ejb.startup(Ejb.java:50)
| 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.seam.util.Reflections.invoke(Reflections.java:13)
| at org.jboss.seam.util.Reflections.invokeAndWrap(Reflections.java:32)
| at org.jboss.seam.Component.callComponentMethod(Component.java:1334)
| at org.jboss.seam.Component.callCreateMethod(Component.java:1322)
| at org.jboss.seam.Component.newInstance(Component.java:1312)
| at org.jboss.seam.Component.getInstance(Component.java:1263)
| at org.jboss.seam.Component.getInstance(Component.java:1253)
| at org.jboss.seam.contexts.Lifecycle.startup(Lifecycle.java:125)
| at org.jboss.seam.contexts.Lifecycle.endInitialization(Lifecycle.java:104)
| at org.jboss.seam.init.Initialization.init(Initialization.java:196)
| at org.jboss.seam.servlet.SeamListener.contextInitialized(SeamListener.java:32)
| at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669)
| at org.apache.catalina.core.StandardContext.start(StandardContext.java:4104)
| at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
| at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
| at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
| at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:788)
| at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:677)
| at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:473)
| at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
| at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
| at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
| at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
| at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
| at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
| at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
| at org.apache.catalina.core.StandardService.start(StandardService.java:450)
| at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
| at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
| 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
| at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
| Caused by: org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for UR
| L: class:
| com.mysql.jdbc.Driver, url:
| jdbc:mysql://192.168.0.157:3306/seamtest?autoReconnect=true&useUnicode=true&characterE
| ncoding=UTF8
| at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManage
| dConnectio
| nFactory.java:288)
| at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnecti
| on(LocalMa
| nagedConnectionFactory.java:168)
| ... 81 more
| (cfg.SettingsFactory 109 ) Could not obtain connection metadata
| org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.jboss.resou
| rce.JBossR
| esourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url
| :
| jdbc:mysql://192.168.0.157:3306/seamtest?autoReconnect=true&useUnicode=true&characterE
| ncoding=UTF8); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create conn
| ection; -
| nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specifie
| d for URL:
| class: com.mysql.jdbc.Driver, url:
| jdbc:mysql://192.168.0.157:3306/seamtest?autoReconnect=true&useUnicode=true&characterE
| ncoding=UTF8))
| at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94
| )
| at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionP
| rovider.ja
| va:69)
| at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)
| at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1928)
| at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1211)
| at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:631)
|
| at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:760
| )
| at org.hibernate.ejb.Ejb3Configuration.createContainerEntityManagerFactory(Ejb3Configuration
| .java:350)
|
| at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersi
| stence.jav
| a:119)
| 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.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:55)
| at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImp
| l.java:107
| )
| at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.dispatch(BasicMethodJoinPoint.java:66)
| at org.jboss.kernel.plugins.dependency.KernelControllerContextActions.dispatchJoinPoint(Kern
| elControll
| erContextActions.java:100)
| at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$LifecycleAction.instal
| lAction(Ke
| rnelControllerContextActions.java:582)
| at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$KernelControllerContex
| tAction.in
| stall(KernelControllerContextActions.java:175)
| at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerC
| ontextActi
| ons.java:51)
|
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979876#3979876
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979876
19 years, 8 months