<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
   "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
   
<hibernate-mapping>
   <class
      name="hello.Message"
      table="MESSAGES">
   
      <id
         name="id"
         column="MESSAGE_ID">
         <generator class="increment" />
      </id>
     
        <property
         name="text"
         column="MESSAGE_TEXT" />
     
     <many-to-one
         name="nextMessage"
         cascade="all"
         column="NEXT_MESSAGE_ID" />
   
   </class>
</hibernate-mapping>

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
   "-//Hibernate/Hibernate Configuration DTD 2.0//EN"
   "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<hibernate-configuration>
    <session-factory>
        <property name="connection.url">jdbc:oracle:thin:@10.122.83.99:1521:ROSTEST</property>
        <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="connection.username">HIBERNATE</property>
        <property name="connection.password">HIBERNATE</property>
       
        <property name="c3p0.min_size">5</property>
        <property name="c3p0.max_size">20</property>
        <property name="c3p0.timeout">300</property>
        <property name="c3p0.max_statements">50</property>
        <property name="c3p0.idle_test_period">3000</property>

        <property name="show_sql">false</property>
        <property name="dialect">net.sf.hibernate.dialect.OracleDialect</property>

        <!-- Mapping files -->
       <mapping resource="hello/Message.hbm.xml" />
    </session-factory>
</hibernate-configuration>

         Configuration cfg = new Configuration().configure();
         //cfg.addResource("hello/Message.hbm.xml");
         cfg.setProperties(System.getProperties());
         SessionFactory sessions = cfg.buildSessionFactory();
         
         Session session = sessions.openSession();
         Transaction tx = session.beginTransaction();
         
         Message message = new Message("Hello World");
         session.save(message);
         
         tx.commit();
         session.close();

log4j:WARN No appenders could be found for logger (net.sf.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
java.lang.UnsupportedOperationException: The user must supply a JDBC connection
   at net.sf.hibernate.connection.UserSuppliedConnectionProvider.getConnection(UserSuppliedConnectionProvider.java:32)
   at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:289)
   at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3361)
   at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3321)
   at net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)
   at net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
   at net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2251)
   at hello.TestHibernate.main(TestHibernate.java:33)

         Configuration cfg = new Configuration().configure();
         //cfg.addResource("hello/Message.hbm.xml");
         System.setProperty("hibernate.connection.password","password");
         System.setProperty("hibernate.connection.username","username");
         System.setProperty("hibernate.connection.driver_class", "oracle.jdbc.driver.OracleDriver");
         System.setProperty("hibernate.connection.url", "jdbc:oracle:thin:@localhost:1521:SNAME");
         System.setProperty("hibernate.dialect", "net.sf.hibernate.dialect.OracleDialect");
         cfg.setProperties(System.getProperties());
         SessionFactory sessions = cfg.buildSessionFactory();

SessionFactory sessions = cfg.configure().buildSessionFactory();

SessionFactory sessions = cfg.configure( "some_hiber_config.xml" ).buildSessionFactory();

   Configuration cfg = new Configuration().configure();
   cfg.setProperties(System.getProperties());
   SessionFactory sessions = cfg.buildSessionFactory();

        Configuration cfg = new Configuration();
   cfg.setProperties(System.getProperties());
   SessionFactory sessions = cfg.configure().buildSessionFactory();

        Configuration cfg = new Configuration();
   SessionFactory sessions = cfg.configure().buildSessionFactory();