7 Replies Latest reply on Nov 28, 2002 12:48 PM by CL Gilbert

    "MySqlDB does not implement any service methods"?

    Mark Sederqvist Newbie

      I am using mySQL with JBoss 3.0.2. I have edited and deployed the mysql-service.xml and the login-conf.xml files, and I have the mm-mysql.jar on the JBoss classpath.

      My database is up and running, but I can't seem to get JBoss to use it. When I run JBoss I get the following output:

      07:24:50,388 WARN [ServiceController] jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper does not implement any Service methods
      (...)
      07:26:29,881 WARN [ServiceController] jboss.jca:service=LocalTxDS,name=MySqlDS does not implement any Service methods
      (...)
      07:26:29,922 INFO [MySqlDS] Bound connection factory for resource adapter 'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/MySqlDS'
      (...)

      When I try to look up the data source, I can't find it. I have tried under "MySqlDS", "java:/MySqlDS", "java:comp/env/MySqlDS" and several more. But what's worse is JBoss doesn't use the MySQL database for persistance, but the default Hypersonic SQL thing.

      I would really appreciate any help on this as I have struggled with it for a long time now. Here are the contents of my mysql-service.xml and login-conf.xml:


      mysql-service.xml:

      <?xml version="1.0" encoding="UTF-8"?>


      MySqlDbRealm

      <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->


      MySqlDS



      <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://80.196.134.77:3306/database</config-property>
      <config-property name="DriverClass" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
      <config-property name="UserName" type="java.lang.String">user</config-property>
      <config-property name="Password" type="java.lang.String">password</config-property>



      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper



      <depends optional-attribute-name="ManagedConnectionPool">
      <!--embedded mbean-->

      0
      50
      5000
      15
      <!--criteria indicates if Subject (from security domain) or app supplied
      parameters (such as from getConnection(user, pw)) are used to distinguish
      connections in the pool. Choices are
      ByContainerAndApplication (use both),
      ByContainer (use Subject),
      ByApplication (use app supplied params only),
      ByNothing (all connections are equivalent, usually if adapter supports
      reauthentication)-->
      ByContainer



      <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

      <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
      java:/TransactionManager
      jboss.jca:service=RARDeployer





      login-config.xml:

      <?xml version='1.0'?>
      <!DOCTYPE policy PUBLIC
      "-//JBoss//DTD JBOSS Security Config 3.0//EN"
      "http://www.jboss.org/j2ee/dtd/security_config.dtd">


      <application-policy name = "MySqlDbRealm">

      <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
      <module-option name = "principal">yourprincipal</module-option>
      <module-option name = "userName">yourusername</module-option>
      <module-option name = "password">yourpassword</module-option>
      <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>
      </login-module>

      </application-policy>




      I would really appreciate any input on this. Thanks in advance.

      Regards,
      Mark

        • 1. Re: "MySqlDB does not implement any service methods"?
          James Moring Newbie

          The warnins you mentioned are "normal".

          Your datasource config file appears correct. The datasource should be accessable at java:/MySqlDS. Why don't you post the code that is trying to fetch the datasource. it should be as simple as:

          InitialContext oCtx = new InitialContext();
          DataSource oDS = (DataSource)oCtx.lookup( "java:/MySqlDS" );

          As for JBoss persisting to HypersonicSQL ... persisting what? What are you using EJBs, JMS?

          Is your custom login module working?

          • 2. Re: "MySqlDB does not implement any service methods"?
            Mark Sederqvist Newbie

            First off, thank you for the assistance.

            Sorry if that was a bit unclear.

            I still cannot look up the datasource, the code you have is what I am doing. Here's the code and full error message:

            InitialContext oCtx = new InitialContext();
            DataSource oDS = (DataSource)oCtx.lookup( "java:/MySqlDS" );

            javax.naming.NameNotFoundException: MySqlDS not bound
            void sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(java.lang.Exception)
            void sun.rmi.transport.StreamRemoteCall.executeCall()
            java.lang.Object sun.rmi.server.UnicastRef.invoke(java.rmi.Remote, java.lang.reflect.Method, java.lang.Object[], long)
            java.lang.Object org.jnp.server.NamingServer_Stub.lookup(javax.naming.Name)
            java.lang.Object org.jnp.interfaces.NamingContext.lookup(javax.naming.Name)
            java.lang.Object org.jnp.interfaces.NamingContext.lookup(java.lang.String)
            java.lang.Object javax.naming.InitialContext.lookup(java.lang.String)
            void Samplemypackage2.MySessionEJBClient.main(java.lang.String[])

            Furthermore, I cannot lookup "java:/DefaultDS" either. I can look up my EJBs just fine.

            About the persistance, I am deploying an entity bean.

            In the hope that it may be some help, here is the entire JBoss server startup output:

            21:53:38,586 INFO [CacheStore] Started
            21:53:38,586 INFO [MessageCache] Starting
            21:53:38,586 INFO [MessageCache] Started
            21:53:38,616 INFO [PersistenceManager] Starting
            21:53:38,676 INFO [PersistenceManager] Started
            21:53:38,676 INFO [DynamicStateManager] Starting
            21:53:38,696 INFO [DynamicStateManager] Started
            21:53:38,696 INFO [DestinationManager] Starting
            21:53:38,696 INFO [DestinationManager] Started
            21:53:38,696 INFO [A] Starting
            21:53:38,726 INFO [A] Bound to JNDI name: queue/A
            21:53:38,726 INFO [A] Started
            21:53:38,726 INFO [B] Starting
            21:53:38,726 INFO [B] Bound to JNDI name: queue/B
            21:53:38,726 INFO [B] Started
            21:53:38,726 INFO [C] Starting
            21:53:38,726 INFO [C] Bound to JNDI name: queue/C
            21:53:38,726 INFO [C] Started
            21:53:38,726 INFO [D] Starting
            21:53:38,726 INFO [D] Bound to JNDI name: queue/D
            21:53:38,726 INFO [D] Started
            21:53:38,726 INFO [ex] Starting
            21:53:38,736 INFO [ex] Bound to JNDI name: queue/ex
            21:53:38,736 INFO [ex] Started
            21:53:38,736 INFO [SecurityManager] Starting
            21:53:38,756 INFO [JaasSecurityManagerService] Created securityMgr=org.jboss.security.plugins.JaasSecurityManager@172
            21:53:38,797 INFO [JaasSecurityManagerService] setCachePolicy, c=org.jboss.util.TimedCachePolicy@173
            21:53:38,797 INFO [JaasSecurityManagerService] Added jbossmq, org.jboss.security.plugins.SecurityDomainContext@174 to map
            21:53:38,797 INFO [SecurityManager] Started
            21:53:38,797 INFO [testTopic] Starting
            21:53:38,807 INFO [testTopic] Bound to JNDI name: topic/testTopic
            21:53:38,817 INFO [testTopic] Started
            21:53:38,817 INFO [securedTopic] Starting
            21:53:38,817 INFO [securedTopic] Bound to JNDI name: topic/securedTopic
            21:53:38,817 INFO [securedTopic] Started
            21:53:38,817 INFO [testDurableTopic] Starting
            21:53:38,817 INFO [testDurableTopic] Bound to JNDI name: topic/testDurableTopic

            21:53:38,817 INFO [testDurableTopic] Started
            21:53:38,817 INFO [testQueue] Starting
            21:53:38,817 INFO [testQueue] Bound to JNDI name: queue/testQueue
            21:53:38,817 INFO [testQueue] Started
            21:53:38,817 INFO [InterceptorLoader] Starting
            21:53:38,817 INFO [InterceptorLoader] Started
            21:53:38,817 INFO [Invoker] Starting
            21:53:38,817 INFO [Invoker] Started
            21:53:38,817 INFO [JVMServerILService] Starting
            21:53:38,847 INFO [JVMServerILService] Started
            21:53:38,907 INFO [RMIServerILService] Starting
            21:53:38,967 INFO [RMIServerILService] Started
            21:53:38,967 INFO [OILServerILService] Starting
            21:53:38,967 INFO [OILServerILService] JBossMQ OIL service available at : 0.0.0.0/0.0.0.0:8090
            21:53:38,977 INFO [OILServerILService] Started
            21:53:38,977 INFO [UILServerILService] Starting
            21:53:38,977 INFO [UILServerILService] JBossMQ UIL service available at : 0.0.0.0/0.0.0.0:8091
            21:53:38,997 INFO [UILServerILService] Started
            21:53:39,007 INFO [DLQ] Starting
            21:53:39,007 INFO [DLQ] Bound to JNDI name: queue/DLQ
            21:53:39,007 INFO [DLQ] Started
            21:53:39,007 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/jbossmq-service.xml
            21:53:39,007 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/jca-service.xml
            21:53:39,047 INFO [RARDeployer] Creating
            21:53:39,047 INFO [RARDeployer] Created
            21:53:39,047 INFO [RARDeployer] Starting
            21:53:39,047 INFO [MainDeployer] Adding deployer: org.jboss.resource.RARDeployer@1c1
            21:53:39,047 INFO [RARDeployer] Started
            21:53:39,047 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/jca-service.xml
            21:53:39,047 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/jms-service.xml
            21:53:39,147 INFO [JMSProviderLoader] Creating
            21:53:39,147 INFO [JMSProviderLoader] Created
            21:53:39,147 INFO [ServerSessionPoolLoader] Creating
            21:53:39,147 INFO [ServerSessionPoolLoader] Created
            21:53:39,147 INFO [EJBDeployer] Creating
            21:53:39,147 INFO [EJBDeployer] Created
            21:53:39,147 WARN [ServiceController] jboss.jca:service=XaTxDS,name=jmsra does not implement any Service methods
            21:53:39,147 INFO [JBossManagedConnectionPool] Creating
            21:53:39,147 INFO [JBossManagedConnectionPool] Created
            21:53:39,147 INFO [JMSProviderLoader] Starting
            21:53:39,157 INFO [JMSProviderLoader] Bound adapter to java:/DefaultJMSProvider

            21:53:39,157 INFO [JMSProviderLoader] Started
            21:53:39,157 INFO [ServerSessionPoolLoader] Starting
            21:53:39,167 INFO [ServerSessionPoolLoader] pool factory StdJMSPool bound to java:/StdJMSPool
            21:53:39,167 INFO [ServerSessionPoolLoader] Started
            21:53:39,167 INFO [EJBDeployer] Starting
            21:53:39,177 INFO [MainDeployer] Adding deployer: org.jboss.ejb.EJBDeployer@1cf

            21:53:39,177 INFO [EJBDeployer] Started
            21:53:39,177 INFO [JBossManagedConnectionPool] Starting
            21:53:39,177 INFO [JBossManagedConnectionPool] Started
            21:53:39,177 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/jms-service.xml
            21:53:39,177 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/mail-service.xml
            21:53:39,187 INFO [MainDeployer] Package: file:/C:/jboss-3.0.2/server/default/lib/mail.jar is already deployed
            21:53:39,197 INFO [MainDeployer] Package: file:/C:/jboss-3.0.2/server/default/lib/activation.jar is already deployed
            21:53:39,197 INFO [MainDeployer] Package: file:/C:/jboss-3.0.2/server/default/lib/mail-plugin.jar is already deployed
            21:53:39,217 INFO [MailService] Creating
            21:53:39,237 INFO [MailService] Created
            21:53:39,237 INFO [MailService] Starting
            21:53:39,327 INFO [MailService] Mail Service bound to java:/Mail
            21:53:39,327 INFO [MailService] Started
            21:53:39,337 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/mail-service.xml
            21:53:39,337 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/mysql-service.xml
            21:53:39,417 WARN [ServiceController] jboss.jca:service=LocalTxDS,name=MySqlDS does not implement any Service methods
            21:53:39,417 INFO [JBossManagedConnectionPool] Creating
            21:53:39,417 INFO [JBossManagedConnectionPool] Created
            21:53:39,417 INFO [JBossManagedConnectionPool] Starting
            21:53:39,417 INFO [JBossManagedConnectionPool] Started
            21:53:39,417 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/mysql-service.xml
            21:53:39,417 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/properties-service.xml
            21:53:39,588 INFO [MainDeployer] Package: file:/C:/jboss-3.0.2/server/default/lib/properties-plugin.jar is already deployed
            21:53:39,598 INFO [PropertyEditorManagerService] Creating
            21:53:39,598 INFO [PropertyEditorManagerService] Created
            21:53:39,598 INFO [PropertyEditorManagerService] Starting
            21:53:39,598 INFO [PropertyEditorManagerService] Started
            21:53:39,598 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/properties-service.xml
            21:53:39,598 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/scheduler-service.xml
            21:53:39,658 INFO [MainDeployer] Package: file:/C:/jboss-3.0.2/server/default/lib/scheduler-plugin-example.jar is already deployed
            21:53:39,658 INFO [MainDeployer] Package: file:/C:/jboss-3.0.2/server/default/lib/scheduler-plugin.jar is already deployed
            21:53:39,658 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/scheduler-service.xml
            21:53:39,658 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/user-service.xml
            21:53:39,698 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/user-service.xml
            21:53:39,698 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/jboss-local-jdbc.rar
            21:53:39,798 WARN [ServiceController] jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper does not implement any Service methods
            21:53:39,798 WARN [ServiceController] jboss.jca:service=LocalTxDS,name=hsqldbDS does not implement any Service methods
            21:53:39,798 INFO [LocalTxConnectionManager] Creating
            21:53:39,858 INFO [LocalTxConnectionManager] Created
            21:53:39,858 WARN [ServiceController] jboss.jca:service=LocalTxDS,name=MySqlDS does not implement any Service methods
            21:53:39,858 INFO [LocalTxConnectionManager] Creating
            21:53:39,868 INFO [LocalTxConnectionManager] Created
            21:53:39,908 INFO [LocalTxConnectionManager] Starting
            21:53:39,938 INFO [DefaultDS] Bound connection factory for resource adapter 'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/DefaultDS'
            21:53:39,938 INFO [LocalTxConnectionManager] Started
            21:53:39,938 INFO [LocalTxConnectionManager] Starting
            21:53:39,948 INFO [JaasSecurityManagerService] Created securityMgr=org.jboss.security.plugins.JaasSecurityManager@1e6
            21:53:39,948 INFO [JaasSecurityManagerService] setCachePolicy, c=org.jboss.util.TimedCachePolicy@1e7
            21:53:39,948 INFO [JaasSecurityManagerService] Added MySqlDbRealm, org.jboss.security.plugins.SecurityDomainContext@1e8 to map
            21:53:39,978 INFO [MySqlDS] Bound connection factory for resource adapter 'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/MySqlDS'
            21:53:39,978 INFO [LocalTxConnectionManager] Started
            21:53:39,978 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/jboss-local-jdbc.rar
            21:53:39,978 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/jboss-xa.rar
            21:53:40,028 INFO [RARMetaData] Loading Minerva Resource Adapter for JDBC 2 XA drivers
            21:53:40,028 INFO [RARMetaData] Required license terms present. See deployment descriptor.
            21:53:40,058 WARN [ServiceController] jboss.jca:service=RARDeployment,name=Minerva JDBC XATransaction ResourceAdapter does not implement any Service methods
            21:53:40,058 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/jboss-xa.rar
            21:53:40,068 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/jms-ra.rar
            21:53:40,158 WARN [ServiceController] jboss.jca:service=RARDeployment,name=JMS Adapter does not implement any Service methods
            21:53:40,158 WARN [ServiceController] jboss.jca:service=XaTxDS,name=jmsra does not implement any Service methods
            21:53:40,158 INFO [XATxConnectionManager] Creating
            21:53:40,168 INFO [XATxConnectionManager] Created
            21:53:40,199 INFO [XATxConnectionManager] Starting
            21:53:40,209 INFO [JaasSecurityManagerService] Created securityMgr=org.jboss.security.plugins.JaasSecurityManager@1f5
            21:53:40,209 INFO [JaasSecurityManagerService] setCachePolicy, c=org.jboss.util.TimedCachePolicy@1f6
            21:53:40,209 INFO [JaasSecurityManagerService] Added JmsXARealm, org.jboss.security.plugins.SecurityDomainContext@1f7 to map
            21:53:40,309 INFO [JmsXA] Bound connection factory for resource adapter 'JMS Adapter' to JNDI name 'java:/JmsXA'
            21:53:40,309 INFO [XATxConnectionManager] Started
            21:53:40,309 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/jms-ra.rar
            21:53:40,309 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/ejb-management.jar
            21:53:40,689 INFO [EjbModule] Creating
            21:53:40,699 INFO [EjbModule] Deploying MEJB
            21:53:40,809 INFO [EjbModule] Created
            21:53:40,809 INFO [EjbModule] Starting
            21:53:40,859 INFO [EjbModule] Started
            21:53:40,859 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/ejb-management.jar
            21:53:40,859 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/ejb1.jar
            21:53:41,080 INFO [EjbModule] Creating
            21:53:41,090 INFO [EjbModule] Deploying Pakke
            21:53:41,170 INFO [EjbModule] Deploying MySessionEJB
            21:53:41,871 INFO [STDOUT] Server 1.6 is running
            21:53:41,871 INFO [STDOUT] Press [Ctrl]+[C] to abort
            21:53:42,131 INFO [JDBCInitCommand] Table 'Pakke' already exists
            21:53:42,141 INFO [EjbModule] Created
            21:53:42,141 INFO [EjbModule] Starting
            21:53:42,161 INFO [EjbModule] Started
            21:53:42,161 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/ejb1.jar
            21:53:42,161 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/jmx-ejb-adaptor.jar
            21:53:42,292 INFO [EjbModule] Creating
            21:53:43,063 INFO [EjbModule] Deploying jmx/ejb/Adaptor
            21:53:43,093 INFO [EjbModule] Created
            21:53:43,093 INFO [EjbModule] Starting
            21:53:43,143 INFO [EjbModule] Started
            21:53:43,143 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/jmx-ejb-adaptor.jar
            21:53:43,143 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/axis.war/
            21:53:44,365 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=1,context=/axis
            21:53:44,895 INFO [jbossweb] Started WebApplicationContext[/axis,Apache-Axis]
            21:53:45,676 INFO [jbossweb] successfully deployed file:/C:/jboss-3.0.2/server/default/deploy/axis.war/ to /axis
            21:53:45,676 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/axis.war/
            21:53:45,676 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/jmx-console.war/
            21:53:45,807 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=2,context=/jmx-console
            21:53:46,588 INFO [jbossweb] Started WebApplicationContext[/jmx-console,file:/C:/jboss-3.0.2/server/default/deploy/jmx-console.war/]
            21:53:46,638 INFO [jbossweb] successfully deployed file:/C:/jboss-3.0.2/server/default/deploy/jmx-console.war/ to /jmx-console
            21:53:46,638 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/jmx-console.war/
            21:53:46,638 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.0.2/server/default/deploy/mywebapp.war/
            21:53:46,708 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=3,context=/mywebapp
            21:53:46,918 INFO [jbossweb] Started WebApplicationContext[/mywebapp,file:/C:/jboss-3.0.2/server/default/deploy/mywebapp.war/]
            21:53:46,918 INFO [jbossweb] Internal Error: File /WEB-INF/web.xml not found
            21:53:46,928 INFO [jbossweb] successfully deployed file:/C:/jboss-3.0.2/server/default/deploy/mywebapp.war/ to /mywebapp
            21:53:46,928 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/deploy/mywebapp.war/
            21:53:46,928 INFO [URLDeploymentScanner] Started
            21:53:46,928 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.2/server/default/conf/jboss-service.xml
            21:53:46,928 INFO [Server] JBoss (MX MicroKernel) [3.0.2 Date:200208271339] Started in 0m:21s:991ms

            • 3. Re: "MySqlDB does not implement any service methods"?
              Mark Sederqvist Newbie

              Also, I am not sure how to test if the custom login module is working.

              • 4. Re: "MySqlDB does not implement any service methods"?
                Mark Sederqvist Newbie

                Addition: The JNDIView page shows the MySqlDS (as well as the DefaultDS) as bound under the "java:" namespace. Why I can't look them up remains shrouded in mystery to me. Other "java:/" JNDI resources can be looked up succesfully, like XAConnectionFactory.

                • 5. Re: "MySqlDB does not implement any service methods"?
                  Mark Sederqvist Newbie

                  Problem solved. I edited standardjbosscmp-jdbc.xml and standardjaws.xml to point to MySqlDS as the default database instead of to DefaultDS. Now it connects and persists everything to mySQL. I don't know how many of the changes I have made that were actually necessary, but these last ones did the trick.

                  About the lookups, it seems to be a problem of my client starting up in a separate JVM, hence not seeing the JBoss JVM java:/ namespace. I still don't know how to register a datasource in global namespace, but then, I don't really need it either at the moment.

                  Thanks for the help.

                  • 6. Re: "MySqlDB does not implement any service methods"?
                    CL Gilbert Newbie

                    Thanks, that did fix it. What I noticed is that jaws.xml datasource is being ignored.