<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Conexión MySQL y JBoss 7.1.1
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/josemo">Jose Moreno</a> in <i>Datasource Configuration</i> - <a href="https://community.jboss.org/message/811099#811099">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Buenos días, </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Desde hace ya un tiempo arrastro el siguiente problema que no me deja continuar con mi desarrollo... Intento conectar una base de datos MySQL (llamada 'login') y un servidor JBoss 7.1.1 en el entorno Eclipse IDE en Windows XP.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Les adjunto los pasos que he realizado para su valoración.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>El archivo <strong>standalone.xml</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><datasources></p><p>                <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true"></p><p>                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url></p><p>                    <driver>h2</driver></p><p>                    <security></p><p>                        <user-name>sa</user-name></p><p>                        <password>sa</password></p><p>                    </security></p><p>                </datasource></p><p>                <strong><datasource jta="true" jndi-name="java:jboss/datasources/login" pool-name="login" enabled="true" use-java-context="true" use-ccm="true"></strong></p><p><strong>                    <connection-url>jdbc:mysql://localhost:3306/login</connection-url></strong></p><p><strong>                    <driver>mysql</driver></strong></p><p><strong>                    <security></strong></p><p><strong>                        <user-name>root</user-name></strong></p><p><strong>                    </security></strong></p><p><strong>                </datasource></strong></p><p>                <drivers></p><p>                    <driver name="h2" module="com.h2database.h2"></p><p>                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class></p><p>                    <strong></driver></strong></p><p><strong>                    <driver name="mysql" module="com.mysql"></strong></p><p><strong>                        <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class></strong></p><p><strong>                    </driver></strong></p><p>                </drivers></p><p>            </datasources></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Duda 1. ¿La password de la base de datos es una cadena vacía... está bien que se omita? Lo pongo pero JBoss al cargar elimina el tag de <password></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>A continuación, en el directorio <strong>modules/com/mysql/main </strong>pegué el .jar de MySQL (mysql-connector-java-5.0.8-bin.jar), se me creó automáticamente el .index de ese .jar y, además, creé el archivo <strong>module.xml</strong> que pego abajo:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong><?xml version="1.0" encoding="UTF-8"?></strong></p><p><strong><module xmlns="urn:jboss:module:1.0" name="mysql"></strong></p><p><strong>  <resources></strong></p><p><strong>    <resource-root path="mysql-connector-java-5.0.8-bin.jar"/></strong></p><p><strong>  </resources></strong></p><p><strong>  <dependencies></strong></p><p><strong>          <module name="javax.api"/></strong></p><p><strong>          <module name="javax.transaction.api"/></strong></p><p><strong>          <module name="javax.servlet.api" optional="true"/></strong></p><p><strong>  </dependencies></strong></p><p><strong></module></strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>El método que tengo de conexión en Java es el siguiente...</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>private Connection cnn = null;</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong>public Connection getConexion (String strDs) throws Exception {</strong></p><p><strong>              try {</strong></p><p><strong>                        InitialContext initialContext = new InitialContext();</strong></p><p><strong>                        DataSource ds = (DataSource) initialContext.lookup(strDs.toString());</strong></p><p><strong>                        try {</strong></p><p><strong>                                  cnn = ds.getConnection();                        // Línea en la que falla...</strong></p><p><strong>                        } catch (SQLException sqle) {</strong></p><p><strong>                                  System.out.println(</strong></p><p><strong>                                                      "Error en el método getConexion() de la clase Proceso: " + strDs +</strong></p><p><strong>                                                                          sqle.getMessage());</strong></p><p><strong>                                  throw sqle;</strong></p><p><strong>                        }</strong></p><p><strong>              } catch (NamingException ne) {</strong></p><p><strong>                        System.out.println(</strong></p><p><strong>                                            "Error en el método getConexion() de la clase Proceso: " +</strong></p><p><strong>                                                                ne.getMessage());</strong></p><p><strong>                        throw ne;</strong></p><p><strong>              }</strong></p><p><strong>              return cnn;</strong></p><p><strong>          }</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Pego también la consola:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>15:12:18,218 INFO  [org.jboss.modules] JBoss Modules version 1.1.1.GA</p><p>15:12:19,015 INFO  [org.jboss.msc] JBoss MSC version 1.0.2.GA</p><p>15:12:19,171 INFO  [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" starting</p><p>15:12:23,296 INFO  [org.jboss.as.server] JBAS015888: Creating http management service using socket-binding (management-http)</p><p>15:12:23,328 INFO  [org.xnio] XNIO Version 3.0.3.GA</p><p>15:12:23,328 INFO  [org.xnio.nio] XNIO NIO Implementation Version 3.0.3.GA</p><p>15:12:23,343 INFO  [org.jboss.remoting] JBoss Remoting version 3.2.3.GA</p><p>15:12:23,609 INFO  [org.jboss.as.configadmin] JBAS016200: Activating ConfigAdmin Subsystem</p><p>15:12:23,671 INFO  [org.jboss.as.clustering.infinispan] JBAS010280: Activating Infinispan subsystem.</p><p>15:12:23,703 INFO  [org.jboss.as.naming] JBAS011800: Activating Naming Subsystem</p><p>15:12:23,734 INFO  [org.jboss.as.osgi] JBAS011940: Activating OSGi Subsystem</p><p>15:12:23,906 INFO  [org.jboss.as.security] JBAS013101: Activating Security Subsystem</p><p>15:12:23,937 INFO  [org.jboss.as.webservices] JBAS015537: Activating WebServices Extension</p><p>15:12:24,203 INFO  [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers</p><p>15:12:25,468 INFO  [org.jboss.as.connector] (MSC service thread 1-2) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.9.Final)</p><p>15:12:25,484 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-2) JBAS015400: Bound mail session [java:jboss/mail/Default]</p><p>15:12:25,953 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-2) Arrancando Coyote HTTP/1.1 en puerto http-localhost-127.0.0.1-8080</p><p>15:12:27,296 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]</p><p>15:12:27,343 INFO  [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-1) JBoss Web Services - Stack CXF Server 4.0.2.GA</p><p>15:12:27,609 INFO  [org.jboss.as.remoting] (MSC service thread 1-1) JBAS017100: Listening on /127.0.0.1:9999</p><p>15:12:27,687 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) JBAS015012: Started FileSystemDeploymentService for directory C:\Documents and Settings\Administrador\Mis documentos\jboss-as-7.1.1.Final\standalone\deployments</p><p>15:12:27,750 INFO  [org.jboss.as.remoting] (MSC service thread 1-1) JBAS017100: Listening on localhost/127.0.0.1:4447</p><p>15:12:27,859 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found Login_7.1.war in deployment directory. To trigger deployment create a file called Login_7.1.war.dodeploy</p><p>15:12:28,125 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report</p><p>JBAS014775:    New missing/unsatisfied dependencies:</p><p>      service jboss.jdbc-driver.com_mysql_jdbc_Driver (missing) dependents: [service jboss.data-source.java:jboss/datasources/login] <span style="text-decoration: underline;"><strong> ¿De dónde sale esto?</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>15:12:28,171 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "Login_7.1.war"</p><p>15:12:29,390 INFO  [org.jboss.web] (MSC service thread 1-1) JBAS018210: Registering web context: /Login_7.1</p><p><span>15:12:29,406 INFO  [org.jboss.as] (MSC service thread 1-2) JBAS015951: Admin console listening on </span><a class="jive-link-external-small" href="http://127.0.0.1:9990" rel="nofollow" target="_blank">http://127.0.0.1:9990</a></p><p>15:12:29,406 ERROR [org.jboss.as] (MSC service thread 1-2) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 12110ms - Started 175 of 255 services (2 services failed or missing dependencies, 76 services are passive or on-demand)</p><p>15:12:29,609 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "Login_7.1.war"</p><p>15:12:44,250 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/Login_7.1].[jsp]] (http-localhost-127.0.0.1-8080-1) Servlet.service() para servlet jsp lanzó excepción: java.lang.NoSuchMethodError: Metodos.bbdd.getConexion(Ljava/lang/String;)V</p><p>          at org.apache.jsp.Validacion_jsp._jspService(Validacion_jsp.java:68)</p><p>          at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) [jbossweb-7.0.13.Final.jar:]</p><p>          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]</p><p>          at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:253) [jbossweb-7.0.13.Final.jar:]</p><p>          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]</p><p>          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]</p><p>          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]</p><p>          at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_15]</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>15:15:43,515 INFO  [org.jboss.as.osgi] (MSC service thread 1-1) JBAS011942: Stopping OSGi Framework</p><p>15:15:43,671 INFO  [org.jboss.as.logging] JBAS011503: Restored bootstrap log handlers</p><p>15:15:43,984 INFO  [com.arjuna.ats.jbossatx] ARJUNA032018: Destroying TransactionManagerService</p><p>15:15:43,984 INFO  [com.arjuna.ats.jbossatx] ARJUNA032014: Stopping transaction recovery manager</p><p>15:15:44,000 INFO  [org.jboss.as.server.deployment] JBAS015877: Stopped deployment Login_7.1.war in 510ms</p><p>15:15:44,000 INFO  [org.jboss.as.controller] JBAS014774: Service status report</p><p>JBAS014776:    Newly corrected services:</p><p>      service jboss.jdbc-driver.com_mysql_jdbc_Driver (new available) <span style="text-decoration: underline;"><strong>¿Por qué cuando apago el servidor aparece este mensaje?</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>15:15:44,000 INFO  [org.jboss.as] JBAS015950: JBoss AS 7.1.1.Final "Brontes" stopped in 513ms</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Espero que me puedan ayudar con las 'pistas' que les estoy dando.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Muchas gracias, un saludo.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/811099#811099">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>