Erro JBoss DataSource

Boa noite Galera, estou com dificuldades para configurar o jboss 7 com datasource para hibernate.
segue o erro.

[code]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
[/code]

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:

[code]<?xml version="1.0" encoding="UTF-8"?>

SGPJ

index.htm

<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>

[/code]

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

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 …

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

[quote=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 … [/quote]

obrigado pela ajuda.

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

[code]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.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(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
[/code]

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)

[quote=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)[/quote]

  • 2

Obrigado

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