Problem with mySQL datasource

[ianbeer]

Hi i have deployed a datasource for mySQL

<datasources>
 <local-tx-datasource>
 <jndi-name>mySQLDs</jndi-name>
 <connection-url>jdbc:mysql://localhost:3306/myDB</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>user</user-name>
 <password>pass</password>
 </local-tx-datasource>
</datasources>

every thing ok there. then i have checked that the name is bound by logging into console and checking in java:namespace

java: Namespace
 +- XAConnectionFactory (class: org.jboss.mq.SpyXAConnectionFactory)
 +- DefaultDS (class: org.jboss.resource.adapter.jdbc.WrapperDataSource)
 +- SecurityProxyFactory (class: org.jboss.security.SubjectSecurityProxyFactory)
 +- DefaultJMSProvider (class: org.jboss.jms.jndi.JNDIProviderAdapter)
 +- comp (class: javax.naming.Context)
 +- JmsXA (class: org.jboss.resource.adapter.jms.JmsConnectionFactoryImpl)
 +- ConnectionFactory (class: org.jboss.mq.SpyConnectionFactory)
 +- jaas (class: javax.naming.Context)
 | +- HsqlDbRealm (class: org.jboss.security.plugins.SecurityDomainContext)
 | +- jbossmq (class: org.jboss.security.plugins.SecurityDomainContext)
 | +- JmsXARealm (class: org.jboss.security.plugins.SecurityDomainContext)
 +- timedCacheFactory (class: javax.naming.Context)
Failed to lookup: timedCacheFactory, errmsg=org.jboss.util.TimedCachePolicy
 +- mySQLDs (class: org.jboss.resource.adapter.jdbc.WrapperDataSource)
 +- TransactionPropagationContextExporter (class: org.jboss.tm.TransactionPropagationContextFactory)
 +- StdJMSPool (class: org.jboss.jms.asf.StdServerSessionPoolFactory)
 +- Mail (class: javax.mail.Session)
 +- comp.ejb3 (class: javax.naming.Context)
 | NonContext: null
 +- TransactionPropagationContextImporter (class: org.jboss.tm.TransactionPropagationContextImporter)
 +- TransactionManager (class: org.jboss.tm.TxManager)

then am using code

String jndiName="java:mySQLDs";

ds=(DataSource)new InitialContext().lookup(jndiName);

to look up said datasource and am receiving

2006-08-28 13:07:28,765 INFO [com.zoodate.controllers.LoginController] jndi name java:mySQLDs
2006-08-28 13:07:28,765 ERROR [STDERR] javax.naming.NameNotFoundException: mySQLDs not bound
2006-08-28 13:07:28,765 ERROR [STDERR] at org.jnp.server.NamingServer.getBinding(NamingServer.java:529)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.jnp.server.NamingServer.getBinding(NamingServer.java:537)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.jnp.server.NamingServer.getObject(NamingServer.java:543)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.jnp.server.NamingServer.lookup(NamingServer.java:296)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:625)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587)
2006-08-28 13:07:28,765 ERROR [STDERR] at javax.naming.InitialContext.lookup(InitialContext.java:351)
2006-08-28 13:07:28,765 ERROR [STDERR] at com.zoodate.controllers.LoginController.login(LoginController.java:30)
2006-08-28 13:07:28,765 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2006-08-28 13:07:28,765 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2006-08-28 13:07:28,765 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2006-08-28 13:07:28,765 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
2006-08-28 13:07:28,765 ERROR [STDERR] at javax.faces.component.UICommand.broadcast(UICommand.java:106)
2006-08-28 13:07:28,765 ERROR [STDERR] at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
2006-08-28 13:07:28,765 ERROR [STDERR] at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
2006-08-28 13:07:28,765 ERROR [STDERR] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:106)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
2006-08-28 13:07:28,765 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
2006-08-28 13:07:28,781 ERROR [STDERR] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
2006-08-28 13:07:28,781 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)

Does anyone have any idea what is causing this rather bizarre problem as i am stumped on this one and it is important

[peterj]

I can't see anything wrong, based on the information you gave it looks correct to me.

Try this in place of, or in front of, your current lookup code:

Context initCtx = new InitialContext();
NamingEnumeration ne = initCtx.listBindings("java:");
while (ne.hasMore()) {
 Binding binding = (Binding)ne.next();
 System.out.println("binding name=" + binding.getName());
}

That will let you know what the code thinks is in the "java:" namepsace. Perhaps that might clue you in as to what the problem is.

[georgesberscheid]

Try java:/mySQLDs instead.

[ianbeer]

Peter many thanks i will try this one, it just seems odd that it is listed on the console page though, but i do see your point.

George many thanks for your suggestion - however i had already tried that name with a slash. The really crazy thing is i have set this up exactly the same on another machine and all works fine. Coulkd this be a VM issue??????

[peterj]

I don't think it is a VM issue. I think that it is a configuration issue and your are connected to something, but not what you think you are connected to. Hence my suggestion to print the namepsace contents.