The datasource-mapping for MySQL is called mySQL - I guess
case matters. You have MySql. To find the datasource-mappings
look in the standardjbosscmp-jdbc.xml in server/default/conf
JD
-----Original Message-----
From: wonder sonic [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 1:49 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] MySQL service installation
I've done all of you said: xml file in the deploy
directory with <attribute
name="JndiName">MySql</attribute>, xxx-13.jar file in
the jboss/lib directory and here is the
jbosscmp-jdbc.xml file of my ear:
...
<jbosscmp-jdbc>
<defaults>
<datasource>java:/MySqlDS</datasource>
<datasource-mapping>MySql</datasource-mapping>
</defaults>
And I've got the following exception for each of my
entity beans:
22:47:35,746 ERROR [URLDeploymentScanner] Failed to
deploy:
org.jboss.deployment.scanner.URLDeploymentScanner$DeployedURL@4e98
de0{
url=file:/E:/jboss-3.0.0_tomcat-4.0.3/server/myrpg/deploy/myrpg-atlas.ear,
deployedLastModified=0 }
org.jboss.deployment.DeploymentException: error in
create of EjbModule:
njar:file:/E:/jboss-3.0.0_tomcat-4.0.3/server/myrpg/tm
p/deploy/server/myrpg/deploy/myrpg-atlas.ear/78.myrpg-atlas.ear^/myrpg-atlas-ejb.jar;
- nested throwable: (org.jboss.deploymen
t.DeploymentException: Error in jbosscmp-jdbc.xml :
datasource-mapping MySql not found)
at
org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:384)
at
org.jboss.deployment.MainDeployer.create(MainDeployer.java:637)
at
org.jboss.deployment.MainDeployer.create(MainDeployer.java:631)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:512)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
at
sun.reflect.GeneratedMethodAccessor8.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy4.deploy(Unknown Source)
at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:237)
at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
at
sun.reflect.GeneratedMethodAccessor6.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:340)
at
sun.reflect.GeneratedMethodAccessor5.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy3.start(Unknown Source)
at
org.jboss.deployment.SARDeployer.start(SARDeployer.java:243)
at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:465)
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:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:314)
at
org.jboss.system.server.ServerImpl.start(ServerImpl.java:216)
at org.jboss.Main.boot(Main.java:142)
at org.jboss.Main$1.run(Main.java:375)
at java.lang.Thread.run(Thread.java:536)
Caused by: org.jboss.deployment.DeploymentException:
Error in jbosscmp-jdbc.xml : datasource-mapping MySql
not found
at
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.<init>(JDBCEntityMetaData.java:365)
at
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.<init>(JDBCApplicationMetaData.java:237)
at
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:67)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:601)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.create(JDBCStoreManager.java:321)
at
org.jboss.ejb.plugins.CMPPersistenceManager.create(CMPPersistenceManager.java:155)
at
org.jboss.ejb.EntityContainer.create(EntityContainer.java:337)
at
org.jboss.ejb.Container.invoke(Container.java:789)
at
org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
at $Proxy6.create(Unknown Source)
at
org.jboss.system.ServiceController.create(ServiceController.java:272)
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:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy19.create(Unknown Source)
at
org.jboss.ejb.EjbModule.createService(EjbModule.java:392)
at
org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:134)
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:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
at $Proxy6.create(Unknown Source)
at
org.jboss.system.ServiceController.create(ServiceController.java:272)
at
org.jboss.system.ServiceController.create(ServiceController.java:212)
at
sun.reflect.GeneratedMethodAccessor3.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy5.create(Unknown Source)
at
org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:380)
... 47 more
What did I missed?
Wonder sonic, brain storming ;)
--- Greg Turner <[EMAIL PROTECTED]> a
écrit : > Hmmm. I am running RC2 and there is no
> jboss/server/default/lib, so I meant jboss/lib. I
> don't clearly understand how <depends> works, but
> there is an
> example in the deploy/hsqldb-service.xml file for
> deploying the hypersonic db
>
> wonder sonic wrote:
>
> > The lib directory, you mean by this, the jboss/lib
> or
> > jboss/server/default/lib?
> >
> > And what would be the <depends> tag for a jar???
> >
> > tia,
> > wonder sonic
> >
> > --- Greg Turner <[EMAIL PROTECTED]> a
> > écrit : > Putting the driver jar file into /lib
> will
> > work, but
> > > I don't think that is the correct place. I
> think
> > > the correct place is in the /deploy directory.
> > > Putting it into the /deploy directory means you
> have
> > > to put a <depends></depends> tag into your xml
> file
> > > so that JBoss will not try and deploy your
> service
> > > before it deploys the jar file.
> > >
> > > wonder sonic wrote:
> > >
> > > > I use the 3.0 final, and indeed, the version
> is
> > > old (I
> > > > use the one downloadable in the CMP 2.0 /
> JBoss
> > > 3.0
> > > > tutorial ;) instead of the one in this
> directory
> > > :D
> > > > One thing I don't know is where to put the
> 2.0.11
> > > > driver archive :( If you know, could you
> please
> > > tell
> > > > me?
> > > >
> > > > TIA,
> > > > Wonder Sonic
> > > >
> > > > --- Ricardo_Argüello <[EMAIL PROTECTED]> a
> > > écrit :
> > > > > Are you using JBoss 3.0.0 final? It looks
> like
> > > your
> > > > > mysql-service.xml is an old one.
> > > > >
> > > > > There is an example file for MySQL
> > > > > (mysql-service.xml) in the
> > > > > jboss-3.0.0/docs/examples/jca/ directory.
> > > > >
> > > > > You should edit this file, and drop it into
> > > > > server/default/deploy
> > > > >
> > > > > Follow the instructions in the XML file.
> > > > >
> > > > > Ricardo Argüello
> > > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "wonder sonic" <[EMAIL PROTECTED]>
> > > > > To: <[EMAIL PROTECTED]>
> > > > > Sent: Thursday, June 06, 2002 11:23 AM
> > > > > Subject: [JBoss-user] MySQL service
> installation
> > > > >
> > > > >
> > > > > > Hi,
> > > > > > I've read the tutorial document about CMR
> 2.0
> > > with
> > > > > > JBoss 3.0 and tried to install mySQL as
> the
> > > > > default
> > > > > > datasource but I encouter some errors
> during
> > > the
> > > > > > deployment of my beans:
> > > > > >
> > > > > > Caused by:
> > > > > org.jboss.deployment.DeploymentException:
> > > > > > Error: can't find data source:
> java:/mySQLDS;
> > > -
> > > > > nested
> > > > > > throwable: (javax.
> > > > > > naming.NameNotFoundException: mySQLDS not
> > > bound)
> > > > > >
> > > > > > Though I've got:
> > > > > > <?xml version="1.0" encoding="UTF-8"?>
> > > > > > <!-- $Id: mysql-service.xml,v 1.3
> 2002/03/01
> > > > > 00:02:00
> > > > > > d_jencks Exp $ -->
> > > > > >
> > > > > >
> > > > > > <!--
> > > > > >
> > > > >
> > > >
> > >
> >
>
=====================================================================
> > > > > > -->
> > > > > > <!--
> > > > >
> > > > > > -->
> > > > > > <!-- Example configuration for the mysql
> > > database.
> > > > >
> > > > > > -->
> > > > > > <!-- Put the driver jar
> mm.mysql-2.0.4-bin.jar
> > > in
> > > > > > lib/ext -->
> > > > > > <!-- Contributed by Ignacio Coloma
> > > > > > [EMAIL PROTECTED]
> -->
> > > > > > <!--
> > > > > >
> > > > >
> > > >
> > >
> >
>
=====================================================================
> > > > > > -->
> > > > > >
> > > > > > <server>
> > > > > > <classpath codebase="."
> > > > > > archives="mm.mysql-2.0.11-bin.jar"/>
> > > > > >
> > > > > > <mbean
> > > > > >
> > >
> code="org.jboss.resource.ConnectionFactoryLoader"
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS">
> > > > > > <attribute
> > > > > >
> > > > >
> > > >
> > >
> >
>
name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg
> > > > > > DriverClass=org.gjt.mm.mysql.Driver
> > > > > > UserName=myrpg
> > > > > > Password=myrpg123</attribute>
> > > > > > <attribute
> name="JndiName">mySQLDS</attribute>
> > > > > > <attribute
> > > > > >
> > > > >
> > > >
> > >
> >
>
name="TransactionManagerName">java:/TransactionManager</attribute>
> > > > > > <depends
> > > > > >
> > > > >
> > > >
> > >
> >
>
optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva
> > > > > > JDBC LocalTransaction
> > > ResourceAdapter</depends>
> > > > > > <depends
> > > > > >
> > > > >
> > > >
> > >
> >
>
optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</depends>
> > > > > > <attribute
> > > name="ConnectionManagerProperties">#
> > > > > > #Wed Aug 15 16:17:29 EDT 2001
> > > > > > BlockingTimeoutMillis=500000
> > > > > > IdleTimeoutMinutes=30
> > > > > > MaxSize=10
> > > > > > CleanupIntervalMinutes=10
> > > > > > MinSize=0
> > > > > > MaxIdleTimeoutPercent=1.0
>
=== message truncated ===
___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
_______________________________________________________________
Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
