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 > </attribute> > <attribute name="PrincipalMappingClass"> > > org.jboss.resource.security.ManyToOnePrincipalMapping > </attribute> > <attribute > name="PrincipalMappingProperties">UserName=</attribute> > </mbean> > </server> > > 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: > ... > <jbosscmp-jdbc> > > <defaults> > <!-- > <datasource>java:/DefaultDS</datasource> > <datasource-mapping>Hypersonic > SQL</datasource-mapping> > --> > <datasource>java:/mySQLDS</datasource> > <datasource-mapping>mySQL</datasource-mapping> > > <create-table>true</create-table> > ... > > 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
