RE: [JBoss-user] MySQL service installation
Title: RE: [JBoss-user] MySQL service installation
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
name="JndiName">MySql, xxx-13.jar file in
the jboss/lib directory and here is the
jbosscmp-jdbc.xml file of my ear:
...
java:/MySqlDS
MySql
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.Thr
Re: [JBoss-user] MySQL service installation
y this, the jboss/lib > > or > > > jboss/server/default/lib? > > > > > > And what would be the 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 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: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >> > > > > > archives="mm.mysql-2.0.11-bin.jar"/> > > > > > > > > > > > > > >> > > > > > > > > > > > code="org.jboss.resource.ConnectionFactoryLoader" > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg > > > > > > > DriverClass=org.gjt.mm.mysql.Driver > > > > > > > UserName=myrpg > > > > > > > Password=myrpg123 > > > > > > > > name="JndiName">mySQLDS > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > name="TransactionManagerName">java:/TransactionManager > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva > > > > > > > JDBC LocalTransaction > > > > ResourceAdapter > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory > > > > > > > > > > name="ConnectionManagerProperties"># > > > > > > > #Wed Aug 15 16:17:29 EDT 2001 > > > > > > > BlockingTimeoutMillis=50 > > > > > > > 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 -- Greg Turner Tiburon Enterprise Systems http://www.tiburon-e-systems.com Box 1171 Tiburon, CA 94920 415-332-3363 ___ 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
Re: [JBoss-user] MySQL service installation
MySql
should be:
mySQL
Other datasource mappings are listed in:
jboss-3.0.0\server\default\conf\standardjbosscmp-jdbc.xml
In this form:
...
...
Ricardo Argüello
- Original Message -
From: "wonder sonic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 3:49 PM
Subject: Re: [JBoss-user] MySQL service installation
> I've done all of you said: xml file in the deploy
> directory with name="JndiName">MySql, xxx-13.jar file in
> the jboss/lib directory and here is the
> jbosscmp-jdbc.xml file of my ear:
> ...
>
>
> java:/MySqlDS
> MySql
>
>
> 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.invok
Re: [JBoss-user] MySQL service installation
e. > > > > > > > > > > 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: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >> > > > > archives="mm.mysql-2.0.11-bin.jar"/> > > > > > > > > > > > >> > > > > > > > > code="org.jboss.resource.ConnectionFactoryLoader" > > > > > > > > > > > > > > > > > > > > > > > > > > > name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS"> > > > > > > > > > > > > > > > > > > > > > > > > > > name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg > > > > > > DriverClass=org.gjt.mm.mysql.Driver > > > > > > UserName=myrpg > > > > > > Password=myrpg123 > > > > > > name="JndiName">mySQLDS > > > > > > > > > > > > > > > > > > > > > > > > > > name="TransactionManagerName">java:/TransactionManager > > > > > > > > > > > > > > > > > > > > > > > > > > optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva > > > > > > JDBC LocalTransaction > > > ResourceAdapter > > > > > > > > > > > > > > > > > > > > > > > > > > optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory > > > > > > > > name="ConnectionManagerProperties"># > > > > > > #Wed Aug 15 16:17:29 EDT 2001 > > > > > > BlockingTimeoutMillis=50 > > > > > > 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
Re: [JBoss-user] MySQL service installation
Hmmm. I am running RC2 and there is no jboss/server/default/lib, so I meant jboss/lib. I don't clearly understand how 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 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 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: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >> > > > archives="mm.mysql-2.0.11-bin.jar"/> > > > > > > > > > >> > > > > > code="org.jboss.resource.ConnectionFactoryLoader" > > > > > > > > > > > > > > > > > > > > name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS"> > > > > > > > > > > > > > > > > > > > name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg > > > > > DriverClass=org.gjt.mm.mysql.Driver > > > > > UserName=myrpg > > > > > Password=myrpg123 > > > > > mySQLDS > > > > > > > > > > > > > > > > > > > name="TransactionManagerName">java:/TransactionManager > > > > > > > > > > > > > > > > > > > >optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva > > > > > JDBC LocalTransaction > > ResourceAdapter > > > > > > > > > > > > > > > > > > > >optional-attribute-name="ConnectionManagerFactoryLoaderName
Re: [JBoss-user] MySQL service installation
The lib directory, you mean by this, the jboss/lib or jboss/server/default/lib? And what would be the 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 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: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >> > > archives="mm.mysql-2.0.11-bin.jar"/> > > > > > > > >> > > > code="org.jboss.resource.ConnectionFactoryLoader" > > > > > > > > > > > > > > name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS"> > > > > > > > > > > > > > name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg > > > > DriverClass=org.gjt.mm.mysql.Driver > > > > UserName=myrpg > > > > Password=myrpg123 > > > > mySQLDS > > > > > > > > > > > > > name="TransactionManagerName">java:/TransactionManager > > > > > > > > > > > > > optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva > > > > JDBC LocalTransaction > ResourceAdapter > > > > > > > > > > > > > optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory > > > > name="ConnectionManagerProperties"># > > > > #Wed Aug 15 16:17:29 EDT 2001 > > > > BlockingTimeoutMillis=50 > > > > IdleTimeoutMinutes=30 > > > > MaxSize=10 > > > > CleanupIntervalMinutes=10 > > > > MinSize=0 > > > > MaxIdleTimeoutPercent=1.0 > > > > > > > > > > > > > > > > > > > > > > org.jboss.resource.security.ManyToOnePrincipalMapping > > > > > > > > > > > > > > > > > name="PrincipalMappingProperties">UserName= > > > > > > > > > > > > > > > > in my server/myrpg/deploy directory including > > > > mm.mysql-2.0.11-bin.jar > > > > > > > > and in my .ant.properties (I use the jboss > > > template > > > > project): > > > > ... > > > > # JBoss 3.0 settings > > > > jboss.home=E:/jboss-3.0.0_tomcat-4.0.3 > > > > jboss.version=3.0 > > > > #datasource.name=java:/DefaultDS > > > > #type.mapping=Hypersonic SQL > > > > datasource.name=java:/mySQLDS > > > > type.mapping=mySQL > > > > ... > > > > > > > > And in > > > server/myrpg/conf/standardjbosscmp-jdbc.xml: > > > > ... > > > > > > > > > > > > > > > > > > > > java:/mySQLDS > > > > > mySQL > > > > > > > > true > > > > ... > > > > > > > > Did someone else encounter this error? If so, > can > > > you > > > > help me? (my mySQL version is 3.23.42-nt and > my > === 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
Re: [JBoss-user] MySQL service installation
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 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: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >> > archives="mm.mysql-2.0.11-bin.jar"/> > > > > > >> > code="org.jboss.resource.ConnectionFactoryLoader" > > > > > > > > > name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS"> > > > > > > > > name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg > > > DriverClass=org.gjt.mm.mysql.Driver > > > UserName=myrpg > > > Password=myrpg123 > > > mySQLDS > > > > > > > > name="TransactionManagerName">java:/TransactionManager > > > > > > > > >optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva > > > JDBC LocalTransaction ResourceAdapter > > > > > > > > >optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory > > > # > > > #Wed Aug 15 16:17:29 EDT 2001 > > > BlockingTimeoutMillis=50 > > > IdleTimeoutMinutes=30 > > > MaxSize=10 > > > CleanupIntervalMinutes=10 > > > MinSize=0 > > > MaxIdleTimeoutPercent=1.0 > > > > > > > > > > > > > > > org.jboss.resource.security.ManyToOnePrincipalMapping > > > > > > > > > > > name="PrincipalMappingProperties">UserName= > > > > > > > > > > > > in my server/myrpg/deploy directory including > > > mm.mysql-2.0.11-bin.jar > > > > > > and in my .ant.properties (I use the jboss > > template > > > project): > > > ... > > > # JBoss 3.0 settings > > > jboss.home=E:/jboss-3.0.0_tomcat-4.0.3 > > > jboss.version=3.0 > > > #datasource.name=java:/DefaultDS > > > #type.mapping=Hypersonic SQL > > > datasource.name=java:/mySQLDS > > > type.mapping=mySQL > > > ... > > > > > > And in > > server/myrpg/conf/standardjbosscmp-jdbc.xml: > > > ... > > > > > > > > > > > > > > > java:/mySQLDS > > > mySQL > > > > > > true > > > ... > > > > > > Did someone else encounter this error? If so, can > > you > > > help me? (my mySQL version i
Re: [JBoss-user] MySQL service installation
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: > > > > > > > > > > > > > > > > > > > > > > > > > >> archives="mm.mysql-2.0.11-bin.jar"/> > > > >> code="org.jboss.resource.ConnectionFactoryLoader" > > > > > name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS"> > > > > name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg > > DriverClass=org.gjt.mm.mysql.Driver > > UserName=myrpg > > Password=myrpg123 > > mySQLDS > > > > name="TransactionManagerName">java:/TransactionManager > > > > optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva > > JDBC LocalTransaction ResourceAdapter > > > > optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory > > # > > #Wed Aug 15 16:17:29 EDT 2001 > > BlockingTimeoutMillis=50 > > IdleTimeoutMinutes=30 > > MaxSize=10 > > CleanupIntervalMinutes=10 > > MinSize=0 > > MaxIdleTimeoutPercent=1.0 > > > > > > > > > org.jboss.resource.security.ManyToOnePrincipalMapping > > > > > > name="PrincipalMappingProperties">UserName= > > > > > > > > in my server/myrpg/deploy directory including > > mm.mysql-2.0.11-bin.jar > > > > and in my .ant.properties (I use the jboss > template > > project): > > ... > > # JBoss 3.0 settings > > jboss.home=E:/jboss-3.0.0_tomcat-4.0.3 > > jboss.version=3.0 > > #datasource.name=java:/DefaultDS > > #type.mapping=Hypersonic SQL > > datasource.name=java:/mySQLDS > > type.mapping=mySQL > > ... > > > > And in > server/myrpg/conf/standardjbosscmp-jdbc.xml: > > ... > > > > > > > > > > java:/mySQLDS > > mySQL > > > > true > > ... > > > > Did someone else encounter this error? If so, can > you > > help me? (my mySQL version is 3.23.42-nt and my > > database's name is myrpg (already created). > Perhaps it > > is the version of the mysql driver archive? > > > > Thank you in advance, > > Wonder Sonic > > > > > ___ > > 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 > > > > > ___ > > 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 ___ 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
Re: [JBoss-user] MySQL service installation
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: > > > > > > > > > > > > >archives="mm.mysql-2.0.11-bin.jar"/> > >code="org.jboss.resource.ConnectionFactoryLoader" > > name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS"> > name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg > DriverClass=org.gjt.mm.mysql.Driver > UserName=myrpg > Password=myrpg123 > mySQLDS > name="TransactionManagerName">java:/TransactionManager > >optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva > JDBC LocalTransaction ResourceAdapter > >optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory > # > #Wed Aug 15 16:17:29 EDT 2001 > BlockingTimeoutMillis=50 > IdleTimeoutMinutes=30 > MaxSize=10 > CleanupIntervalMinutes=10 > MinSize=0 > MaxIdleTimeoutPercent=1.0 > > > > org.jboss.resource.security.ManyToOnePrincipalMapping > > name="PrincipalMappingProperties">UserName= > > > > in my server/myrpg/deploy directory including > mm.mysql-2.0.11-bin.jar > > and in my .ant.properties (I use the jboss template > project): > ... > # JBoss 3.0 settings > jboss.home=E:/jboss-3.0.0_tomcat-4.0.3 > jboss.version=3.0 > #datasource.name=java:/DefaultDS > #type.mapping=Hypersonic SQL > datasource.name=java:/mySQLDS > type.mapping=mySQL > ... > > And in server/myrpg/conf/standardjbosscmp-jdbc.xml: > ... > > > > > java:/mySQLDS > mySQL > > true > ... > > Did someone else encounter this error? If so, can you > help me? (my mySQL version is 3.23.42-nt and my > database's name is myrpg (already created). Perhaps it > is the version of the mysql driver archive? > > Thank you in advance, > Wonder Sonic > > ___ > 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 > ___ 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
[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: ConnectionURL=jdbc:mysql://localhost/myrpg DriverClass=org.gjt.mm.mysql.Driver UserName=myrpg Password=myrpg123 mySQLDS java:/TransactionManager jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory # #Wed Aug 15 16:17:29 EDT 2001 BlockingTimeoutMillis=50 IdleTimeoutMinutes=30 MaxSize=10 CleanupIntervalMinutes=10 MinSize=0 MaxIdleTimeoutPercent=1.0 org.jboss.resource.security.ManyToOnePrincipalMapping UserName= in my server/myrpg/deploy directory including mm.mysql-2.0.11-bin.jar and in my .ant.properties (I use the jboss template project): ... # JBoss 3.0 settings jboss.home=E:/jboss-3.0.0_tomcat-4.0.3 jboss.version=3.0 #datasource.name=java:/DefaultDS #type.mapping=Hypersonic SQL datasource.name=java:/mySQLDS type.mapping=mySQL ... And in server/myrpg/conf/standardjbosscmp-jdbc.xml: ... java:/mySQLDS mySQL true ... Did someone else encounter this error? If so, can you help me? (my mySQL version is 3.23.42-nt and my database's name is myrpg (already created). Perhaps it is the version of the mysql driver archive? Thank you in advance, Wonder Sonic ___ 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
