"MySqlDB does not implement any service methods"?

[johnyzee]

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

[jmoring]

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?

[johnyzee]

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

[johnyzee]

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

[johnyzee]

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.

[johnyzee]

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.

[dnoyeb]

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

[dnoyeb]

That real solution I found and posted here

http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/