hi guys,
problem solved. i had to add the security realm to the mysql-service.xml file.
sorry for bothering.
regards
marco
> -----Original Message-----
> From: ext [mailto:[EMAIL PROTECTED]
> Sent: 05 August, 2003 09:28
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: [JBoss-user] problem in connecting to mySql database
> with jboss
> 3.2.1
>
>
> HI all,
> i am trying to connect to mySql database running on my
> machine (localhost:3306).
> i have copied from the doc\samples directory the
> mysql-service.xml file and put it into
> <jbossdir>\server\default\deploy.
>
> content of the file is as following:
>
> <datasources>
> <local-tx-datasource>
> <jndi-name>MySqlDS</jndi-name>
>
> <connection-url>jdbc:mysql://jdbc:mysql://localhost:3306/menag
> erie</connection-url>
> <driver-class>org.gjt.mm.mysql.Driver</driver-class>
> <user-name>root</user-name>
> <password></password>
> </local-tx-datasource>
> </datasources>
>
> i have then added to the <jbossdir>\server\default\conf
> following lines
>
> <application-policy name = "MySqlDbRealm">
> <authentication>
> <login-module code =
> "org.jboss.resource.security.ConfiguredIdentityLoginModule"
> flag = "required">
> <module-option name = "principal">root</module-option>
> <module-option name = "userName">root</module-option>
> <module-option name = "password"></module-option>
> <module-option name =
> "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,nam
> e=MySqlDS</module-option>
> </login-module>
> </authentication>
> </application-policy>
>
>
>
> i am then using following code to retrieve DataSource
>
> Context jndiCntx = new InitialContext();
> DataSource ds =
> (javax.sql.DataSource)jndiCntx.lookup("java:/MySqlDS");
> con = ds.getConnection();
>
>
>
> Here at least Jboss shows that the xml file related to mysql
> has been deployed
>
> bu09:23:41,319 INFO [MainDeployer] Starting deployment of
> package: file:/C:/jboss
> -3.2.1_tomcat-4.1.24/server/default/deploy/mysql-service.xml
> 09:23:41,409 INFO [MainDeployer] Deployed package:
> file:/C:/jboss-3.2.1_tomcat-
> 4.1.24/server/default/deploy/mysql-service.xml
>
>
> but when i try to access the database i got following exception:
>
> 09:24:22,130 ERROR [STDERR] getConnection failed. See error
> log for stack trace
> .
> 09:24:22,140 ERROR [STDERR]
> javax.naming.NameNotFoundException: MySqlDS not boun
> d
> 09:24:22,150 ERROR [STDERR] at
> org.jnp.server.NamingServer.getBinding(Naming
> Server.java:495)
> 09:24:22,160 ERROR [STDERR] at
> org.jnp.server.NamingServer.getBinding(Naming
> Server.java:503)
> 09:24:22,160 ERROR [STDERR] at
> org.jnp.server.NamingServer.getObject(NamingS
> erver.java:509)
> 09:24:22,190 ERROR [STDERR] at
> org.jnp.server.NamingServer.lookup(NamingServ
> er.java:282)
> 09:24:22,200 ERROR [STDERR] at
> org.jnp.interfaces.NamingContext.lookup(Namin
> gContext.java:492)
> 09:24:22,210 ERROR [STDERR] at
> org.jnp.interfaces.NamingContext.lookup(Namin
> gContext.java:471)
> 09:24:22,220 ERROR [STDERR] at
> javax.naming.InitialContext.lookup(InitialCon
> text.java:345)
> 09:24:22,230 ERROR [STDERR] at
> com.marco.ActionServlet.init(Unknown Source)
> 09:24:22,230 ERROR [STDERR] at
> org.apache.catalina.core.StandardWrapper.load
> Servlet(StandardWrapper.java:935)
> 09:24:22,240 ERROR [STDERR] at
> org.apache.catalina.core.StandardWrapper.load
> (StandardWrapper.java:823)
> 09:24:22,250 ERROR [STDERR] at
> org.apache.catalina.core.StandardContext.load
> OnStartup(StandardContext.java:3420)
> 09:24:22,260 ERROR [STDERR] at
> org.apache.catalina.core.StandardContext.star
> t(StandardContext.java:3608)
> 09:24:22,270 ERROR [STDERR] at
> org.apache.catalina.core.ContainerBase.addChi
> ldInternal(ContainerBase.java:821)
> 09:24:22,280 ERROR [STDERR] at
> org.apache.catalina.core.ContainerBase.addChi
> ld(ContainerBase.java:807)
> 09:24:22,290 ERROR [STDERR] at
> org.apache.catalina.core.StandardHost.addChil
> d(StandardHost.java:579)
> 09:24:22,300 ERROR [STDERR] at
> org.jboss.web.catalina.EmbeddedCatalinaServic
> e41.createWebContext(EmbeddedCatalinaService41.java:417)
> 09:24:22,310 ERROR [STDERR] at
> org.jboss.web.catalina.EmbeddedCatalinaServic
> e41.performDeploy(EmbeddedCatalinaService41.java:266)
> 09:24:22,320 ERROR [STDERR] at
> org.jboss.web.AbstractWebContainer.start(Abst
> ractWebContainer.java:357)
> 09:24:22,330 ERROR [STDERR] at
> org.jboss.deployment.MainDeployer.start(MainD
> eployer.java:832)
> 09:24:22,340 ERROR [STDERR] at
> org.jboss.deployment.MainDeployer.deploy(Main
> Deployer.java:640)
> 09:24:22,350 ERROR [STDERR] at
> org.jboss.deployment.MainDeployer.deploy(Main
> Deployer.java:613)
> 09:24:22,360 ERROR [STDERR] at
> java.lang.reflect.Method.invoke(Native Method
> )
> 09:24:22,370 ERROR [STDERR] at
> org.jboss.mx.capability.ReflectedMBeanDispatc
> her.invoke(ReflectedMBeanDispatcher.java:284)
> 09:24:22,380 ERROR [STDERR] at
> org.jboss.mx.server.MBeanServerImpl.invoke(MB
> eanServerImpl.java:549)
> 09:24:22,390 ERROR [STDERR] at
> org.jboss.mx.util.MBeanProxyExt.invoke(MBeanP
> roxyExt.java:177)
> 09:24:22,400 ERROR [STDERR] at $Proxy7.deploy(Unknown Source)
> 09:24:22,400 ERROR [STDERR] at
> org.jboss.deployment.scanner.URLDeploymentSca
> nner.deploy(URLDeploymentScanner.java:302)
> 09:24:22,410 ERROR [STDERR] at
> org.jboss.deployment.scanner.URLDeploymentSca
> nner.scan(URLDeploymentScanner.java:476)
> 09:24:22,420 ERROR [STDERR] at
> org.jboss.deployment.scanner.AbstractDeployme
> ntScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:200)
> 09:24:22,430 ERROR [STDERR] at
> org.jboss.deployment.scanner.AbstractDeployme
> ntScanner.startService(AbstractDeploymentScanner.java:273)
> 09:24:22,440 ERROR [STDERR] at
> org.jboss.system.ServiceMBeanSupport.start(Se
> rviceMBeanSupport.java:192)
> 09:24:22,450 ERROR [STDERR] at
> java.lang.reflect.Method.invoke(Native Method
> )
> 09:24:22,460 ERROR [STDERR] at
> org.jboss.mx.capability.ReflectedMBeanDispatc
> her.invoke(ReflectedMBeanDispatcher.java:284)
> 09:24:22,470 ERROR [STDERR] at
> org.jboss.mx.server.MBeanServerImpl.invoke(MB
> eanServerImpl.java:549)
> 09:24:22,480 ERROR [STDERR] at
> org.jboss.system.ServiceController$ServicePro
> xy.invoke(ServiceController.java:966)
> 09:24:22,480 ERROR [STDERR] at $Proxy0.start(Unknown Source)
> 09:24:22,490 ERROR [STDERR] at
> org.jboss.system.ServiceController.start(Serv
> iceController.java:392)
> 09:24:22,500 ERROR [STDERR] at
> java.lang.reflect.Method.invoke(Native Method
> )
> 09:24:22,510 ERROR [STDERR] at
> org.jboss.mx.capability.ReflectedMBeanDispatc
> her.invoke(ReflectedMBeanDispatcher.java:284)
> 09:24:22,520 ERROR [STDERR] at
> org.jboss.mx.server.MBeanServerImpl.invoke(MB
> eanServerImpl.java:549)
> 09:24:22,530 ERROR [STDERR] at
> org.jboss.mx.util.MBeanProxyExt.invoke(MBeanP
> roxyExt.java:177)
> 09:24:22,530 ERROR [STDERR] at $Proxy5.start(Unknown Source)
> 09:24:22,540 ERROR [STDERR] at
> org.jboss.deployment.SARDeployer.start(SARDep
> loyer.java:226)
> 09:24:22,550 ERROR [STDERR] at
> org.jboss.deployment.MainDeployer.start(MainD
> eployer.java:832)
> 09:24:22,560 ERROR [STDERR] at
> org.jboss.deployment.MainDeployer.deploy(Main
>
>
> should the JNDI name to look up be instead java:comp/env/MySqlDS ?
>
> anyone can help me in figuring out the problem?
>
> regards
> marco
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet
> _072303_01/01
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
