[resolvido]

[jbjaresPJ]

Amigos estou com enorme dificuldade em configurar o hibernate…
Não sei informar qual o problema, por isso colocarei a baixo todo meu projeto para que os amigos possam dar uma força se possivel… valeu!

Disposição do projeto:

hib/build/classes/hib [ Main.class, Message.class, Message.hbm.xml, hibernate.cfg.xml. log4j.properties, messageDAO.class ]

OBS: hibernate.cfg.xml tá aki porque em outros lugares ele passa a não ser encontrado dando um outro tipo de erro.

hib/src/hib [ Main.java, Message.java e messageDAO.java ]

log4j.properties:

log4j.rootLogger=INFO, dest1

log4j.appender.dest1=org.apache.log4j.ConsoleAppender
log4j.appender.dest1.layout=org.apache.log4j.PatternLayout
log4j.appender.dest1.layout.ConversionPattern=%d %-5p %-5c{3} %x -> %m%n

hibernate.cfg.xml

<?xml version=‘1.0’ encoding=‘utf-8’?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
“http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd”>
<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://localhost:3306/hibernate
</property>
<property name=“hibernate.connection.username”>root</property>
<property name=“hibernate.connection.password”>root</property>
<!-- Condiguração do c3p0 -->
<property name=“hibernate.c3p0.max_size”>10</property>
<property name=“hibernate.c3p0.min_size”>2</property>
<property name=“hibernate.c3p0.timeout”>5000</property>
<property name=“hibernate.c3p0.max_statements”>10</property>
<property name=“hibernate.c3p0.idle_test_period”>3000</property>
<property name=“hibernate.c3p0.acquire_increment”>2</property>
<!-- Configurações de debug -->
<property name=“show_sql”>true</property>
<property name=“hibernate.generate_statistics”>true</property>
<property name=“hibernate.use_sql_comments”>true</property>

	<mapping resource="hib/Message.hbm.xml"/>
	
</session-factory>

</hibernate-configuration>

Message.hbm.xml

<?xml version=“1.0” encoding=“UTF-8”?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
“http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd”>

<hibernate-mapping>
<class name=“Message” table=“MESSAGE”>
<id name=“message” column=“message” type=“string”>
<generator class=“assigned”/>
</id>
</class>
</hibernate-mapping>

Message.java

package hib;

/**
*

• @author jbjares
  */
  public class Message {

  /** Creates a new instance of Message */
  public Message()
  {
  }

  private String message;

  public void setMessage(String message)
  {
  this.message=message;
  }

  public String getMessage()
  {
  return message;
  }

}

messageDAO.java

package hib;

/**
*

• @author jbjares
  */

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class messageDAO
{

private SessionFactory factory;

public messageDAO() throws Exception
{
//factory = new Configuration().addClass(Message.class).buildSessionFactory();
Configuration cfg = new Configuration().configure(“hib/hibernate.cfg.xml”);
cfg.setProperties(System.getProperties());
factory = cfg.buildSessionFactory();

}

public void insert(Message message) throws Exception
{
Session session = factory.openSession();
session.save(message);
session.flush();
session.close();
}

public void delete(Message message) throws Exception
{
Session session = factory.openSession();
session.delete(message);
session.flush();
session.close();
}
}

Main.java

public class Main {

/** Creates a new instance of Main */
public Main() {
}

/**
 * @param args the command line arguments
 */
public static void main(String[] args)
{
    messageDAO dao;
    try 
    {
        dao = new messageDAO();
        Message message = new Message();
        message.setMessage("Olá");
        dao.insert(message);
    } 
    catch (Exception ex) 
    {
        ex.printStackTrace();
    }
   
}

}

A tabela:

CREATE TABLE message (
message varchar(20) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

O erro:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:409)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:119)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289)
at hib.messageDAO.<init>(messageDAO.java:34)
at hib.Main.main(Main.java:30)

Se alguem já tiver passado por isso e tiver como ajudar… SOCORROOO!!

[jbjaresPJ]

Resolvido…

[eltonk]

Sua dúvida pode ser a dúvida dos outros, assim como a sua resposta será a resposta dos outros…

Poste a sua solução!