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 > > </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 ___________________________________________________________ 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
