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/menagerie</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,name=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
