Erro JBoss DataSource

7 respostas
Diguinho.Max
Boa noite Galera, estou com dificuldades para configurar o jboss 7 com datasource para hibernate. segue o erro.
00:54:08,182 INFO  [org.jboss.modules] JBoss Modules version 1.0.2.GA
00:54:08,393 INFO  [org.jboss.msc] JBoss MSC version 1.0.1.GA
00:54:08,442 INFO  [org.jboss.as] JBoss AS 7.0.2.Final "Arc" starting
00:54:16,305 ERROR [stderr] Exception in thread "Controller Boot Thread" java.lang.RuntimeException: org.jboss.as.controller.persistence.ConfigurationPersistenceException: Failed to parse configuration

00:54:16,305 ERROR [stderr] 	at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:89)

00:54:16,306 ERROR [stderr] 	at java.lang.Thread.run(Thread.java:662)

00:54:16,306 ERROR [stderr] Caused by: org.jboss.as.controller.persistence.ConfigurationPersistenceException: Failed to parse configuration

00:54:16,307 ERROR [stderr] 	at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:115)

00:54:16,308 ERROR [stderr] 	at org.jboss.as.controller.AbstractControllerService.boot(AbstractControllerService.java:104)

00:54:16,309 ERROR [stderr] 	at org.jboss.as.server.ServerService.boot(ServerService.java:195)

00:54:16,309 ERROR [stderr] 	at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:83)

00:54:16,309 ERROR [stderr] 	... 1 more

00:54:16,310 ERROR [stderr] Caused by: javax.xml.stream.XMLStreamException: org.jboss.jca.common.metadata.ParserException: IJ010061: Unexpected element: datasources

00:54:16,310 ERROR [stderr] 	at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$NewDataSourceSubsystemParser.readElement(DataSourcesExtension.java:708)

00:54:16,311 ERROR [stderr] 	at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$NewDataSourceSubsystemParser.readElement(DataSourcesExtension.java:277)

00:54:16,312 ERROR [stderr] 	at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:100)

00:54:16,312 ERROR [stderr] 	at org.jboss.staxmapper.XMLExtendedStreamReaderImpl.handleAny(XMLExtendedStreamReaderImpl.java:69)

00:54:16,330 ERROR [stderr] 	at org.jboss.as.controller.parsing.StandaloneXml.parseServerProfile(StandaloneXml.java:311)

00:54:16,330 ERROR [stderr] 	at org.jboss.as.controller.parsing.StandaloneXml.readServerElement(StandaloneXml.java:163)

00:54:16,331 ERROR [stderr] 	at org.jboss.as.controller.parsing.StandaloneXml.readElement(StandaloneXml.java:91)

00:54:16,331 ERROR [stderr] 	at org.jboss.as.controller.parsing.StandaloneXml.readElement(StandaloneXml.java:79)

00:54:16,331 ERROR [stderr] 	at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:100)

00:54:16,332 ERROR [stderr] 	at org.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:59)

00:54:16,332 ERROR [stderr] 	at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:107)

00:54:16,333 ERROR [stderr] 	... 4 more

00:54:16,333 ERROR [stderr] Caused by: org.jboss.jca.common.metadata.ParserException: IJ010061: Unexpected element: datasources

00:54:16,334 ERROR [stderr] 	at org.jboss.jca.common.metadata.ds.DsParser.parseDataSources(DsParser.java:182)

00:54:16,334 ERROR [stderr] 	at org.jboss.jca.common.metadata.ds.DsParser.parse(DsParser.java:118)

00:54:16,335 ERROR [stderr] 	at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$NewDataSourceSubsystemParser.readElement(DataSourcesExtension.java:700)

00:54:16,335 ERROR [stderr] 	... 14 more
meu xml da pasta standalone está assim:
<subsystem xmlns="urn:jboss:domain:datasources:1.0">
            <datasources>
                <datasource jndi-name="java:jboss/datasources/ExampleDS" enabled="true" use-java-context="true" pool-name="H2DS">
                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
                    <driver>h2</driver>
                    <pool></pool>
                    <security>
                        <user-name>sa</user-name>
                        <password>sa</password>
                    </security>
                </datasource>
                <drivers>
                    <driver name="h2" module="com.h2database.h2">
                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                    </driver>
                </drivers>
				<datasources>
				   <datasource jndi-name="java:jboss/datasources/MySqlDS" pool-name="MySqlDS">
					  <connection-url>jdbc:mysql://localhost:3306/SGPJ</connection-url>
						 <driver>com.mysql</driver>
					  <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
					  <pool>
						<min-pool-size>10</min-pool-size>
						<max-pool-size>100</max-pool-size>
						<prefill>true</prefill>
					  </pool>
					  <security>
						<user-name>rodrigo</user-name>
						<password>diguin</password>
					  </security>
					  <statement>
						<prepared-statement-cache-size>32</prepared-statement-cache-size>
						<share-prepared-statements/>
					  </statement>
					</datasource>
					<drivers>
					  <driver name="com.mysql" module="com.mysql">
						<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
					  </driver>
					</drivers>
				</datasources>
            </datasources>
        </subsystem>
meu module:
<module xmlns="urn:jboss:module:1.0" name="com.mysql">
  <resources>
    <resource-root path="mysql-connector-java-5.1.18-bin.jar"/>
  </resources>
  <dependencies>
    <module name="javax.api"/>
  </dependencies>
</module>

a estrutura é como citada no doc:
C:\jboss-as-web-7.0.2.Final\modules\com\mysql\main

meu web.xml:
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	id="WebApp_ID" version="2.5">
	<display-name>SGPJ</display-name>
	<welcome-file-list>
		<welcome-file>index.htm</welcome-file>
	</welcome-file-list>

	<servlet>
		<servlet-name>Faces Servlet</servlet-name>
		<servlet-class>javax.faces.webapp.FacesServlet</servlet-class>
		<load-on-startup>1</load-on-startup>
	</servlet>

	<servlet-mapping>
		<servlet-name>Faces Servlet</servlet-name>
		<url-pattern>*.jsf</url-pattern>
	</servlet-mapping>

	<context-param>
		<param-name>org.richfaces.skin</param-name>
		<param-value>blueSky</param-value>
	</context-param>

	<context-param>
		<param-name>org.richfaces.control_skinning</param-name>
		<param-value>disable</param-value>
	</context-param>

	<context-param>
		<param-name>javax.faces.DEFAULT_SUFFIX</param-name>
		<param-value>.xhtml</param-value>
	</context-param>
	<context-param>
		<param-name>javax.faces.FACELETS_SKIP_COMMENTS</param-name>
		<param-value>true</param-value>
	</context-param>
</web-app>

help plx fazem uns 3 dias já que estou nisso ¬¬

7 Respostas

balrog

3 dias e vc nao se deu o trabalho de ler o stack trace?

essa linha indica que vc tem um elemento chamado datasources que nao eh reconhecido, olhando seu xml vc tem um “datasources” dentro de outro, corrige isso e seu problema de 3 dias desaparece …

Hebert_Coelho

Nesse post, na página 6 tem um exemplo: Aplicação Web Completa JSF EJB JPA JAAS

Diguinho.Max
balrog:
3 dias e vc nao se deu o trabalho de ler o stack trace?
Unexpected element: datasources
essa linha indica que vc tem um elemento chamado datasources que nao eh reconhecido, olhando seu xml vc tem um "datasources" dentro de outro, corrige isso e seu problema de 3 dias desaparece ...

obrigado pela ajuda.

porem ocorreu mais um erro se puder me ajudar agradeço =)

12:56:08,088 INFO  [org.jboss.modules] JBoss Modules version 1.0.2.GA
12:56:08,383 INFO  [org.jboss.msc] JBoss MSC version 1.0.1.GA
12:56:08,457 INFO  [org.jboss.as] JBoss AS 7.0.2.Final "Arc" starting
12:56:14,161 WARN  [org.jboss.as] No security realm defined for native management service, all access will be unrestricted.
12:56:14,626 INFO  [org.jboss.as] creating http management service using network interface (management) port (9990)
12:56:14,719 WARN  [org.jboss.as] No security realm defined for http management service, all access will be unrestricted.
12:56:14,733 INFO  [org.jboss.as.logging] Removing bootstrap log handlers
12:56:15,007 INFO  [org.jboss.as.connector.subsystems.datasources] (Controller Boot Thread) Deploying JDBC-compliant driver class org.h2.Driver (version 1.2)
12:56:15,201 INFO  [org.jboss.as.connector.subsystems.datasources] (Controller Boot Thread) Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
12:56:15,394 INFO  [org.jboss.as.clustering.infinispan.subsystem] (Controller Boot Thread) Activating Infinispan subsystem.
12:56:16,831 INFO  [org.jboss.as.naming] (Controller Boot Thread) JBAS011800: Activating Naming Subsystem
12:56:17,249 INFO  [org.jboss.as.naming] (MSC service thread 1-3) JBAS011802: Starting Naming Service
12:56:17,396 INFO  [org.jboss.as.osgi] (Controller Boot Thread) JBAS011910: Activating OSGi Subsystem
12:56:17,870 INFO  [org.jboss.as.security] (Controller Boot Thread) Activating Security Subsystem
12:56:18,194 INFO  [org.jboss.remoting] (MSC service thread 1-7) JBoss Remoting version 3.2.0.Beta2
12:56:18,560 INFO  [org.xnio] (MSC service thread 1-7) XNIO Version 3.0.0.Beta3
12:56:19,611 INFO  [org.xnio.nio] (MSC service thread 1-7) XNIO NIO Implementation Version 3.0.0.Beta3
12:56:23,938 INFO  [org.apache.catalina.core.AprLifecycleListener] (MSC service thread 1-5) The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.6.0_31\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\Java\jdk1.6.0_31\jre\bin;native;.
12:56:24,343 INFO  [org.jboss.as.ee] (Controller Boot Thread) Activating EE subsystem
12:56:24,376 INFO  [org.jboss.as.jmx.JMXConnectorService] (MSC service thread 1-1) Starting remote JMX connector
12:56:24,998 INFO  [org.jboss.as.remoting] (MSC service thread 1-2) Listening on /127.0.0.1:9999
12:56:26,785 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-8) Starting Coyote HTTP/1.1 on http--127.0.0.1-8080
12:56:28,979 INFO  [org.jboss.as.connector] (MSC service thread 1-2) Starting JCA Subsystem (JBoss IronJacamar 1.0.3.Final)
12:56:31,393 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) Bound data source [java:jboss/datasources/ExampleDS]
12:56:31,434 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-6) Bound data source [java:jboss/datasources/MySqlDS]
12:56:33,888 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (JCA PoolFiller) IJ000610: Unable to fill pool: javax.resource.ResourceException: Could not create connection
	at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
	at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
	at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:706) [ironjacamar-core-impl-1.0.3.Final.jar:1.0.3.Final]
	at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.fillToMin(SemaphoreArrayListManagedConnectionPool.java:653) [ironjacamar-core-impl-1.0.3.Final.jar:1.0.3.Final]
	at org.jboss.jca.core.connectionmanager.pool.mcp.PoolFiller.run(PoolFiller.java:97) [ironjacamar-core-impl-1.0.3.Final.jar:1.0.3.Final]
	at java.lang.Thread.run(Thread.java:662) [:1.6.0_31]
Caused by: java.sql.SQLException: Access denied for user 'rodrigo'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
	at com.mysql.jdbc.ConnectionImpl.&lt;init&gt;(ConnectionImpl.java:792)
	at com.mysql.jdbc.JDBC4Connection.&lt;init&gt;(JDBC4Connection.java:47)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [:1.6.0_31]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [:1.6.0_31]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [:1.6.0_31]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [:1.6.0_31]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
	at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
	... 5 more

12:56:44,943 INFO  [org.jboss.as.deployment] (MSC service thread 1-8) Started FileSystemDeploymentService for directory C:\jboss-as-web-7.0.2.Final\standalone\deployments
12:56:45,691 INFO  [org.jboss.as] (Controller Boot Thread) JBoss AS 7.0.2.Final "Arc" started in 37838ms - Started 98 of 153 services (55 services are passive or on-demand)
12:56:46,047 INFO  [org.jboss.as.deployment] (DeploymentScanner-threads - 1) Found SGPJ.war in deployment directory. To trigger deployment create a file called SGPJ.war.dodeploy
12:56:48,046 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-5) Starting deployment of "mysql-connector-java-5.1.18-bin.jar"
12:56:48,048 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-6) Starting deployment of "SGPJ.war"
12:56:53,495 INFO  [org.jboss.as.jpa] (MSC service thread 1-2) added javax.persistence.api dependency to mysql-connector-java-5.1.18-bin.jar
Hebert_Coelho

Sério mesmo, vou fazer a mesma colocação do balrog… Vc precisa ler o seu LOG de erro cara.

Olha a mensagem: Access denied for user ‘rodrigo’@‘localhost’ (using password: YES)

jmag

jakefrog:
Sério mesmo, vou fazer a mesma colocação do balrog… Vc precisa ler o seu LOG de erro cara.

Olha a mensagem: Access denied for user ‘rodrigo’@‘localhost’ (using password: YES)

  • 2
Diguinho.Max

Obrigado

P

Pessoal, estou tendo um problema parecido… e não consigo resolver =/
Sou iniciante ainda, e estou aprendendo… estou fazendo este projeto com base em um outro que fiz num treinamento. A unica diferença é que agora estou tentando usar o Postgre ao invés do MySql… se alguém puder me ajudar, agradeceria muito!

Estou usando Eclipse, Jboss 7.0.2

o erro quando inicio o servidor:

00:52:26,922 INFO  [org.jboss.modules] JBoss Modules version 1.0.2.GA
00:52:27,295 INFO  [org.jboss.msc] JBoss MSC version 1.0.1.GA
00:52:27,362 INFO  [org.jboss.as] JBoss AS 7.0.2.Final "Arc" starting
00:52:28,212 ERROR [stderr] Exception in thread "Controller Boot Thread" java.lang.RuntimeException: org.jboss.as.controller.persistence.ConfigurationPersistenceException: Failed to parse configuration

00:52:28,212 ERROR [stderr] 	at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:89)

00:52:28,213 ERROR [stderr] 	at java.lang.Thread.run(Thread.java:619)

00:52:28,213 ERROR [stderr] Caused by: org.jboss.as.controller.persistence.ConfigurationPersistenceException: Failed to parse configuration

00:52:28,213 ERROR [stderr] 	at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:115)

00:52:28,213 ERROR [stderr] 	at org.jboss.as.controller.AbstractControllerService.boot(AbstractControllerService.java:104)

00:52:28,214 ERROR [stderr] 	at org.jboss.as.server.ServerService.boot(ServerService.java:195)

00:52:28,214 ERROR [stderr] 	at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:83)

00:52:28,214 ERROR [stderr] 	... 1 more

00:52:28,215 ERROR [stderr] Caused by: javax.xml.stream.XMLStreamException: com.ctc.wstx.exc.WstxParsingException: Received non-all-whitespace CHARACTERS or CDATA event in nextTag().

00:52:28,215 ERROR [stderr]  at [row,col {unknown-source}]: [135,5]

00:52:28,215 ERROR [stderr] 	at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$NewDataSourceSubsystemParser.readElement(DataSourcesExtension.java:708)

00:52:28,215 ERROR [stderr] 	at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$NewDataSourceSubsystemParser.readElement(DataSourcesExtension.java:277)

00:52:28,216 ERROR [stderr] 	at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:100)

00:52:28,217 ERROR [stderr] 	at org.jboss.staxmapper.XMLExtendedStreamReaderImpl.handleAny(XMLExtendedStreamReaderImpl.java:69)

00:52:28,217 ERROR [stderr] 	at org.jboss.as.controller.parsing.StandaloneXml.parseServerProfile(StandaloneXml.java:311)

00:52:28,217 ERROR [stderr] 	at org.jboss.as.controller.parsing.StandaloneXml.readServerElement(StandaloneXml.java:163)

00:52:28,218 ERROR [stderr] 	at org.jboss.as.controller.parsing.StandaloneXml.readElement(StandaloneXml.java:91)

00:52:28,218 ERROR [stderr] 	at org.jboss.as.controller.parsing.StandaloneXml.readElement(StandaloneXml.java:79)

00:52:28,218 ERROR [stderr] 	at org.jboss.staxmapper.XMLMapperImpl.processNested(XMLMapperImpl.java:100)

00:52:28,218 ERROR [stderr] 	at org.jboss.staxmapper.XMLMapperImpl.parseDocument(XMLMapperImpl.java:59)

00:52:28,219 ERROR [stderr] 	at org.jboss.as.controller.persistence.XmlConfigurationPersister.load(XmlConfigurationPersister.java:107)

00:52:28,219 ERROR [stderr] 	... 4 more

00:52:28,219 ERROR [stderr] Caused by: com.ctc.wstx.exc.WstxParsingException: Received non-all-whitespace CHARACTERS or CDATA event in nextTag().

00:52:28,220 ERROR [stderr]  at [row,col {unknown-source}]: [135,5]

00:52:28,220 ERROR [stderr] 	at com.ctc.wstx.sr.StreamScanner.constructWfcException(StreamScanner.java:606)

00:52:28,220 ERROR [stderr] 	at com.ctc.wstx.sr.StreamScanner.throwParseError(StreamScanner.java:479)

00:52:28,220 ERROR [stderr] 	at com.ctc.wstx.sr.StreamScanner.throwParseError(StreamScanner.java:464)

00:52:28,221 ERROR [stderr] 	at com.ctc.wstx.sr.BasicStreamReader.nextTag(BasicStreamReader.java:1137)

00:52:28,221 ERROR [stderr] 	at org.jboss.staxmapper.XMLExtendedStreamReaderImpl.nextTag(XMLExtendedStreamReaderImpl.java:152)

00:52:28,221 ERROR [stderr] 	at org.jboss.jca.common.metadata.ds.DsParser.parseDataSource(DsParser.java:551)

00:52:28,221 ERROR [stderr] 	at org.jboss.jca.common.metadata.ds.DsParser.parseDataSources(DsParser.java:165)

00:52:28,222 ERROR [stderr] 	at org.jboss.jca.common.metadata.ds.DsParser.parse(DsParser.java:118)

00:52:28,222 ERROR [stderr] 	at org.jboss.as.connector.subsystems.datasources.DataSourcesExtension$NewDataSourceSubsystemParser.readElement(DataSourcesExtension.java:700)

00:52:28,222 ERROR [stderr] 	... 14 more

se com base nisso alguém puder me dar uma luz… se precisar posto o codigo dos outros arquivos… nao pus por enquanto para nao fica muito extenso.
Obrigado!
Abraços.

*PS: Sou tao iniciante que quis criar um tópico mas nao consigui! Não sei como faz… HAUHUAUHA, se alguem quiser me ajuda nisso tbm ;D hehe

Criado 27 de fevereiro de 2012
Ultima resposta 30 de abr. de 2012
Respostas 7
Participantes 5