Pessoal não sei muito de banco de dados remotos; estava fazendo um projeto com localhost poren quando botei para rotar com banco remoto parece o seguinte erro na pagina web.
# HTTP Status 500 - Internal Server Error
type Exception report
message Internal Server Error
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
root cause
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user ‘gabrielms’@‘10.129.62.38’ for table ‘menu’
note The full stack traces of the exception and its root causes are available in the GlassFish Server Open Source Edition 4.1.1 logs.
### GlassFish Server Open Source Edition 4.1.1
Minha classe hibernete
<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://protecline1.mysql.uhserver.com/protecline1?zeroDateTimeBehavior=convertToNull</property>
<property name="hibernate.connection.username">gabrielms</property>
<property name="hibernate.connection.password">senha</property>
<property name="hibernate.connection.pool_size">24</property>
<mapping resource="entity/Material.hbm.xml"/>
<mapping resource="entity/Cliente.hbm.xml"/>
<mapping resource="entity/Pedido.hbm.xml"/>
<mapping resource="entity/Funcionario.hbm.xml"/>
<mapping resource="entity/Local.hbm.xml"/>
<mapping resource="entity/TipoAtendimento.hbm.xml"/>
<mapping resource="entity/Menu.hbm.xml"/>
<mapping resource="entity/ItemPedido.hbm.xml"/>
<mapping resource="entity/Perfil.hbm.xml"/>
</session-factory>
</hibernate-configuration>
Minha classe DAO
public class MenuDAO {
public boolean save(Menu p) {
try {
SessionFactory factory = HibernateUtil.getSessionFactory();
Session session = factory.openSession();
session.beginTransaction();
session.save(p);
session.getTransaction().commit();
session.close();
return true;
} catch (Exception e) {
return false;
}
}
public boolean alterar (Menu m) {
try {
SessionFactory factory = HibernateUtil.getSessionFactory();
Session session = factory.openSession();
session.beginTransaction();
session.update(m);
session.getTransaction().commit();
session.close();
return true;
} catch (Exception e) {
return false;
}
}
public boolean deletar(Menu p) {
try {
SessionFactory factory = HibernateUtil.getSessionFactory();
Session session = factory.openSession();
session.beginTransaction();
session.delete(p);
session.getTransaction().commit();
session.close();
return true;
} catch (Exception e) {
return false;
}
}
public static ArrayList getAllMenu() {
SessionFactory factory = HibernateUtil.getSessionFactory();
Session session = factory.openSession();
ArrayList<Menu> mList = (ArrayList<Menu>) session.createQuery("SELECT al FROM Menu al").list();
mList.toString();
session.close();
return mList;
}
public static Menu carregarID(int id) {
SessionFactory factory = HibernateUtil.getSessionFactory();
Session session = factory.openSession();
Menu m = (Menu) session.get(Menu.class, id);
return m;
}
}
Alguém pode me ajudar?