[RESOLVIDO]Erro ao tentar conectar com banco Mysql (Aplicação na Integrator)

Front-end
#1

Olá pessoal,

Venho aqui ver se alguém consegue me ajudar com um erro de conexão, é a minha primeira aplicação e hospedei na Integrator, local essa parte está tudo certo, acredito que não estou sabendo configurar corretamente para utilizar o banco da Integrator.

javax.servlet.ServletException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Could not open connection
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:606)
root cause

javax.faces.el.EvaluationException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Could not open connection
	javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
	com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:101)
	javax.faces.component.UICommand.broadcast(UICommand.java:315)
	javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
	javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
	com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
	com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
root cause

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Could not open connection
	org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
	org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
	org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1397)
	org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:62)
	ecapro.FormularioBean.enviar(FormularioBean.java:184)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.apache.el.parser.AstValue.invoke(AstValue.java:278)
	org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
	com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
	javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
	com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:101)
	javax.faces.component.UICommand.broadcast(UICommand.java:315)
	javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
	javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
	com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
	com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
root cause

org.hibernate.exception.SQLGrammarException: Could not open connection
	org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
	org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)
	org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
	org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160)
	org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1426)
	org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:59)
	ecapro.FormularioBean.enviar(FormularioBean.java:184)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.apache.el.parser.AstValue.invoke(AstValue.java:278)
	org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
	com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
	javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
	com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:101)
	javax.faces.component.UICommand.broadcast(UICommand.java:315)
	javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
	javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
	com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
	com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
root cause

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Access denied for user 'arturmar_admin'@'localhost' to database 'arturmar_ecapro'
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
	com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
	com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
	com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
	com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:204)
	org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)
	org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
	org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160)
	org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1426)
	org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:59)
	ecapro.FormularioBean.enviar(FormularioBean.java:184)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.apache.el.parser.AstValue.invoke(AstValue.java:278)
	org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
	com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
	javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
	com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:101)
	javax.faces.component.UICommand.broadcast(UICommand.java:315)
	javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
	javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
	com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
	com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
	javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

segue meu persistence.xml

<?xml version="1.0" encoding ="UTF-8"?>
<persistence version = " 2.0 "
	xmlns="http://java.sun.com/xml/ns/persistence"
	xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation = "http://java.sun.com/xml/ns/persistence
	http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" >
<persistence-unit name ="ecapro-pu" transaction-type ="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
	<class>ecapro.Formulario</class>
	<class>org.hibernate.ejb.Ejb3Configuration</class>
	<properties>
		<property name ="hibernate.dialect" value ="org.hibernate.dialect.MySQL5InnoDBDialect"/>
		<property name ="hibernate.hbm2ddl.auto" value ="update"/>
		<property name ="hibernate.show_sql" value ="true" />
		<property name ="javax.persistence.jdbc.driver" value ="com.mysql.jdbc.Driver"/>
		<property name ="javax.persistence.jdbc.user" value ="arturmar_admin"/>
		<property name ="javax.persistence.jdbc.password" value ="admin"/>
		<property name ="javax.persistence.jdbc.url" value ="jdbc:mysql://localhost:3306/arturmar_ecapro"/>
	</properties>
</persistence-unit>
</persistence>

Alguém que já utilizou banco na Integrator poderia me ajudar?

Desde já agradeço a atenção.

Att.

Artur Martini

#2

Resolvido.

Na Integrator você cria o banco e cria o usuário, mas depois você tem que atribuir o usuário ao banco manualmente, tem um botão adicionar usuário ao banco.

Faltava fazer isso, as configurações estão certinhas.

Vlw!

#3

Artur, boa tarde.

Cara, qual versão do Mysql conector vc está utilizando? esta fazendo com Jboss ou com Tomcat?

estou utilizando Jboss, mas estou com o seguinte erro:

No suitable driver found for jdbc:mysql://

Abs

#4