[jboss-user] [Beginner's Corner] - Re: datasource MySql

Vladica Maric [https://community.jboss.org/people/vmaric] created the discussion "Re: datasource MySql" To view the discussion, visit: https://community.jboss.org/message/778501#778501 -------------------------------------------------------------- Thanks a lot, on your ansver, Wolf-Dieter! I have the same problem with derby database. My userbean do not work. I can connet on deta base from database development tab. I can ping base from jboss console. Bat from JSF DataSource do not work. My question is is that correct if i write in my bean: @Resource(name="java:/MyDerby" If I put in jboss dat JDNI is  java:.MyDerby This is my log of Jboss7.1: 10:20:11,451 INFO  [org.jboss.modules] JBoss Modules version 1.1.1.GA 10:20:11,669 INFO  [org.jboss.msc] JBoss MSC version 1.0.2.GA 10:20:11,732 INFO  [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" starting 10:20:12,966 INFO  [org.xnio] XNIO Version 3.0.3.GA 10:20:12,966 INFO  [org.jboss.as.server] JBAS015888: Creating http management service using socket-binding (management-http) 10:20:12,982 INFO  [org.xnio.nio] XNIO NIO Implementation Version 3.0.3.GA 10:20:12,982 INFO  [org.jboss.remoting] JBoss Remoting version 3.2.3.GA 10:20:13,044 INFO  [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers 10:20:13,107 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800: Activating Naming Subsystem 10:20:13,107 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 44) JBAS013101: Activating Security Subsystem 10:20:13,122 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 31) JBAS010280: Activating Infinispan subsystem. 10:20:13,122 INFO  [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011940: Activating OSGi Subsystem 10:20:13,138 INFO  [org.jboss.as.configadmin] (ServerService Thread Pool -- 26) JBAS016200: Activating ConfigAdmin Subsystem 10:20:13,201 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension 10:20:13,404 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3) 10:20:13,435 INFO  [org.jboss.as.security] (MSC service thread 1-1) JBAS013100: Current PicketBox version=4.0.7.Final 10:20:13,466 INFO  [org.jboss.as.connector] (MSC service thread 1-1) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.9.Final) 10:20:13,466 INFO  [org.jboss.as.naming] (MSC service thread 1-1) JBAS011802: Starting Naming Service 10:20:13,529 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-1) JBAS015400: Bound mail session [java:jboss/mail/Default] 10:20:13,794 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-2) Starting Coyote HTTP/1.1 on http--0.0.0.0-8080 10:20:14,169 INFO  [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-4) JBoss Web Services - Stack CXF Server 4.0.2.GA 10:20:14,326 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) JBAS015012: Started FileSystemDeploymentService for directory C:\jboss-as-7.1.1.Final\standalone\deployments 10:20:14,341 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found BaseProba1.war in deployment directory. To trigger deployment create a file called BaseProba1.war.dodeploy 10:20:14,341 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "derbyclient.jar" 10:20:14,341 INFO  [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100: Listening on /0.0.0.0:4447 10:20:14,357 INFO  [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100: Listening on localhost/127.0.0.1:9999 10:20:14,560 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_cs.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,560 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_de_DE.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,560 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_es.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,576 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_fr.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,576 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_hu.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,576 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_it.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,576 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_ja_JP.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,576 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_ko_KR.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,576 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_pl.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,576 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_pt_BR.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,576 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_ru.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,576 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_zh_CN.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,591 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) Class Path entry derbyLocale_zh_TW.jar in "/C:/jboss-as-7.1.1.Final/bin/content/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:20:14,591 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS] 10:20:14,904 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) JBAS010403: Deploying JDBC-compliant driver class org.apache.derby.jdbc.ClientDriver (version 10.9) 10:20:14,919 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) JBAS010400: Bound data source [java:/MyDerby] 10:20:15,013 INFO  [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed "derbyclient.jar" 10:20:15,169 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990 http://127.0.0.1:9990 10:20:15,169 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss AS 7.1.1.Final "Brontes" started in 4109ms - Started 157 of 235 services (76 services are passive or on-demand) 10:21:34,515 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "BaseProba1.war" 10:21:35,702 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_cs.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,702 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_de_DE.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,702 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_es.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,702 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_fr.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,702 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_hu.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,702 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_it.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,718 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_ja_JP.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,718 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_ko_KR.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,718 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_pl.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,718 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_pt_BR.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,718 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_ru.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,733 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_zh_CN.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:35,733 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry derbyLocale_zh_TW.jar in "/C:/jboss-as-7.1.1.Final/standalone/deployments/BaseProba1.war/WEB-INF/lib/derbyclient.jar"  does not point to a valid jar for a Class-Path reference. 10:21:36,046 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015893: Encountered invalid class name 'com.sun.faces.vendor.Tomcat6InjectionProvider:org.apache.catalina.util.DefaultAnnotationProcessor' for service type 'com.sun.faces.spi.injectionprovider' 10:21:36,046 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015893: Encountered invalid class name 'com.sun.faces.vendor.Jetty6InjectionProvider:org.mortbay.jetty.plus.annotation.InjectionCollection' for service type 'com.sun.faces.spi.injectionprovider' 10:21:37,593 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-2) MSC00001: Failed to start service jboss.deployment.unit."BaseProba1.war".PARSE: org.jboss.msc.service.StartException in service jboss.deployment.unit."BaseProba1.war".PARSE: Failed to process phase PARSE of deployment "BaseProba1.war"     at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:119) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]     at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]     at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [rt.jar:1.6.0_37]     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.6.0_37]     at java.lang.Thread.run(Unknown Source) [rt.jar:1.6.0_37] Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: IJ010061: Unexpected element: local-tx-datasource     at org.jboss.as.connector.deployers.processors.DsXmlDeploymentParsingProcessor.deploy(DsXmlDeploymentParsingProcessor.java:85)     at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]     ... 5 more Caused by: org.jboss.jca.common.metadata.ParserException: IJ010061: Unexpected element: local-tx-datasource     at org.jboss.jca.common.metadata.ds.DsParser.parseDataSources(DsParser.java:183)     at org.jboss.jca.common.metadata.ds.DsParser.parse(DsParser.java:119)     at org.jboss.jca.common.metadata.ds.DsParser.parse(DsParser.java:82)     at org.jboss.as.connector.deployers.processors.DsXmlDeploymentParsingProcessor.deploy(DsXmlDeploymentParsingProcessor.java:80)     ... 6 more 10:21:37,640 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015870: Deploy of deployment "BaseProba1.war" was rolled back with failure message {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"BaseProba1.war\".PARSE" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"BaseProba1.war\".PARSE: Failed to process phase PARSE of deployment \"BaseProba1.war\""}} 10:21:38,077 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015877: Stopped deployment BaseProba1.war in 455ms 10:21:38,093 INFO  [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report JBAS014777:   Services which failed to start:      service jboss.deployment.unit."BaseProba1.war".PARSE: org.jboss.msc.service.StartException in service jboss.deployment.unit."BaseProba1.war".PARSE: Failed to process phase PARSE of deployment "BaseProba1.war" 10:21:38,093 ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"BaseProba1.war\".PARSE" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"BaseProba1.war\".PARSE: Failed to process phase PARSE of deployment \"BaseProba1.war\""}}}} -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/778501#778501] Start a new discussion in Beginner's Corner at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]