Could not resolve root entity 'Usuarios'
Cezar Apulchro
{
Usuarios_DAO_W1 usuario = null;
EntityManagerFactory emf = null;
EntityManager em = null;
Query query = null;
try {
emf = Persistence.createEntityManagerFactory("itcmedbr_PU");
em = emf.createEntityManager();
EntityTransaction transct = em.getTransaction();
query = em.createQuery(
"select i from Usuarios i where i.Apelido = ?1 and Senha = ?2 and cnpj = ?3"
);
query.setParameter(1, Apelido);
query.setParameter(2, Senha);
query.setParameter(3, CNPJ);
em.close();
} catch (Exception e) {
e.printStackTrace();
System.out.println("Caiu no catch senha invalida....");
log.info("Retorno: " + usuario);
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE html>");
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet NewServlet</title>");
out.println("</head>");
out.println("<body>");
out.println("<br>");
out.println("<h1>PacientesDAO - Usuário ou senha invalido!</h1>");
out.println("</body>");
out.println("</html>");
out.close();
} finally {
if ( em != null ) {
em.close();
}
if ( emf != null ) {
emf.close();
}
}
return usuario;
}
"
I appreciate any help.
Thanks and best regards.
Jens Kutschke
Cezar Apulchro
@Table(name = "tabela_profissional_medico")
@Access(value = AccessType.FIELD)
@Entity(name = "Usuarios")
public class Usuarios_DAO_W1 implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "IND")
private Integer ind;
@Column(name = "CNPJ")
private String cnpj;
@Column(name = "Nome")
private String nome;
@Column(name = "Apelido")
private String apelido;
@Column(name = "Email")
private String email;
@Column(name = "Cremerj")
private String cremerj;
@Column(name = "Coren")
private String coren;
@Column(name = "Senha")
private String senha;
@Column(name = "Tipo")
private String tipo;
@Column(name = "Celular")
private String celular;
.......
GETTERS, SETTERS And TOSTRING
public Usuarios_DAO_W1 getLoginW0(String Apelido, String Senha, String CNPJ) throws Exception
{
Usuarios_DAO_W1 usuario = new Usuarios_DAO_W1();
EntityManagerFactory emf = null;
EntityManager em = null;
Query query = null;
try {
emf = Persistence.createEntityManagerFactory("itcmedbr_PU");
em = emf.createEntityManager();
EntityTransaction transct = em.getTransaction();
return (Usuarios_DAO_W1) em.createQuery(
"FROM Usuarios i where i.Apelido = :apelido AND i.Senha = :senha AND i.CNPJ = :cnpj")
.setParameter("apelido", Apelido)
.setParameter("senha", Senha)
.setParameter("cnpj", CNPJ);
} catch (Exception e) {
e.printStackTrace();
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE html>");
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet NewServlet</title>");
out.println("</head>");
out.println("<body>");
out.println("<br>");
out.println("<h1>PacientesDAO - Usuário ou senha invalido!</h1>");
out.println("</body>");
out.println("</html>");
out.close();
} finally {
if ( em != null ) {
em.close();
}
if ( emf != null ) {
emf.close();
}
}
return usuario;
}
"
Thanks by assistance.
Cezar Apulchro
@Table(name = "tabela_profissional_medico")
@Access(value = AccessType.FIELD)
hibernate.cfg.xml:
<session-factory>
<property name="connection.driver_class">com.mysql.cj.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/DB_Medical</property>-->
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/DB_Medical</property>
<property name="connection.username">root</property>
<property name="connection.password">root</property>
<property name="connection.pool_size">10</property>
<property name="dialect">org.hibernate.dialect.MySQL8Dialect</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<property name="current_session_context_class">thread</property>
<property name="hbm2ddl.auto">update</property>
<!--Mapeando classes-->
<mapping class="itc.systems.beans.Bean_Pre_Natal"/>
<mapping class="itc.systems.beans.Bean_Visita_Internados"/>
<mapping class="itc.systems.beans.BeanConsumoInternados"/>
<mapping class="itc.systems.beans.BeanDadosPessoais"/>
<mapping class="itc.systems.beans.Usuarios_DAO_W1"/>
</session-factory>
</hibernate-configuration>
<session-factory name="">
<!-- Database connection properties - Driver, URL, user, password -->
<property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/DB_Medical</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">root</property>
<!-- org.hibernate.HibernateException: No CurrentSessionContext configured! -->
<property name="hibernate.current_session_context_class">thread</property>
<property name="hbm2ddl.auto">update</property>
<!-- Mapping with model class containing annotations -->
<mapping class="itc.systems.beans.Bean_Pre_Natal"/>
<mapping class="itc.systems.beans.Bean_Visita_Internados"/>
<mapping class="itc.systems.beans.BeanConsumoInternados"/>
<mapping class="itc.systems.beans.BeanDadosPessoais"/>
<mapping class="itc.systems.beans.Usuarios_DAO_W1"/>
</session-factory>
</hibernate-configuration>
Scott Marlow
<subsystem xmlns="urn:jboss:domain:logging:1.0">
<console-handler name="CONSOLE">
<level name="TRACE" />
...
</console-handler>
...
<logger category="org.hibernate.SQL">
<level name="TRACE" />
</logger>--
You received this message because you are subscribed to the Google Groups "WildFly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wildfly+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/wildfly/2af9bd69-d931-489f-a8da-25718766a5ecn%40googlegroups.com.