Hibernate Community • View topic - Hibernate Created Oracle10g Table But Not Inserting Records

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Hibernate Created Oracle10g Table But Not Inserting Records

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

ezanih

Post subject: Hibernate Created Oracle10g Table But Not Inserting Records

Posted: Tue Apr 01, 2008 2:53 am

Newbie

Joined: Mon Mar 31, 2008 12:50 am
Posts: 4

Hi there

I am using Hibernate 3.2 and OracleXE (10g) with Eclipse Europa and JBoss 4.2.2GA to do a simple database CRUD app with Swing and a Bean. My app is basically a CD with a HILO ID and Title. I have set show-sql to true and Hibernate to auto create-drop.

My problem is : Hibernate created my CD table but it did not insert any record when I click the Add button in my Swing app. My app compiles without error and reviewing the log appeared to show the Hibernate code seems OK.

Please can you help me? Thanks in advance! - Ezani

CD.java -
-----------

Code:

import java.io.*;
import java.util.*;

public class CD {

   int id;
   String title;

   public CD() {}
   
   public CD(String title) {
   this.title = title;
   }

   public void setId(int id) {
   this.id = id;
   }
   
   public int getId(){
   return id;
   }
   
   public void setTitle(String title) {
   this.title = title;
   }
   
   public String getTitle() {
   return title;
   }
   
   public String toString() {
   return this.id + " " + this.title;
   }   
}

CDTest.java (shortened to show just the Add function) -
--------------

Code:

import org.apache.log4j.Logger;
import org.apache.log4j.BasicConfigurator;
import java.io.*;
import java.awt.*;
import javax.swing.*;
import java.util.*;
import javax.swing.table.*;
import javax.swing.event.*;
import java.awt.event.*;
import org.hibernate.*;
import org.hibernate.cfg.*;
import org.hibernate.Session;

public class CDTest extends JFrame implements ListDataListener {
   
   private static final long serialVersionUID = 1L;   
   static Logger logger = Logger.getLogger(CDTest.class);

   JList list;
   CDList listModel;
   JTextField titleField;
   JTextField IDField;
   JLabel IDLabel;
   int selectedListIndex;

   SessionFactory sessionFactory;

   
   public CDTest(){

      try {
      
         Configuration cfg = new Configuration().addClass(CD.class);   
         //Configuration cfg = new Configuration();
         //cfg.addClass(CD.class);
         cfg.configure("hibernate.cfg.xml");
         sessionFactory = cfg.buildSessionFactory();
         buildGUI();
      }
      
      catch (Exception e)
      
      {
         e.printStackTrace();
      }

}



   private void buildGUI() {

      Container container = getContentPane();
      listModel = new CDList();
//      listModel.addCD("Grace Under Pressure");
      list = new JList();
      list.setModel(listModel);
      list.setCellRenderer(new CDRenderer());
      container.add(list, BorderLayout.NORTH);
      list.addListSelectionListener(new ListSelectionListener() {      
      
   public void valueChanged(ListSelectionEvent ae) {

      JList list = (JList)ae.getSource () ;
      CDList model = (CDList)list.getModel();
      selectedListIndex = ((JList)ae.getSource()).getSelectedIndex();
      CD cd = (CD)model.getElementAt(selectedListIndex);
      IDLabel.setText(""+cd.getId());
      titleField.setText(cd.getTitle());
      }

   });

   
      JPanel panel = new JPanel(new GridLayout(7,2));
      titleField = new JTextField(25);
      IDLabel = new JLabel();
      panel.add(new JLabel("ID"));
      panel.add(IDLabel);
      panel.add(new JLabel("Title"));
      panel.add (titleField);


      panel.add (button);
      button = new JButton("Add");
      button.addActionListener(new ActionListener() {

         
   public void actionPerformed(ActionEvent ae) {

         CD cd = new CD(   titleField.getText()  );
         listModel.addCD(cd);
         System.out.println(cd.toString());

         try {
            Session session = sessionFactory.openSession();            
            session.save(cd);
            session.flush();
            session.close();

         }
         catch (Exception e) {
            e.printStackTrace();
         }

         IDLabel.setText("");
         titleField.setText("");
         }
      });

..................
   public static void main(String [] args) {
      org.apache.log4j.BasicConfigurator.configure();   
      CDTest t = new CDTest() ;
   }
   
   private class CDList extends AbstractListModel {
   Vector v = new Vector();
   public void addCD(String title) {
   CD cd = new CD(title);
   v.add(cd);
   fireContentsChanged(this, 0, 0);
   }
   
   
   public void addCD(CD cd) {
   v.add(cd) ;
   fireContentsChanged(this, 0, 0);
   }
   
   
   public void addCDs(java.util.List cds) {
   v.addAll(cds);
   fireContentsChanged(this, 0, 0);
   }

Oracle table schema -
------------------------

Code:

ID NUMBER(10,0) 
TITLE VARCHAR2(255) 

hibernate.cfg.xml -
----------------------

Code:

<?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.connection.driver_class">oracle.jdbc.driver.OracleDriver</property> 
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property> 
<property name="hibernate.connection.username">SYSTEM</property> 
<property name="hibernate.connection.password">Swordfish1</property> 
<property name="connection.pool_size">10</property>
<property name="show_sql">true</property>
<!-- Mapping files -->
      <mapping resource="CD.hbm.xml"/>
</session-factory> 
</hibernate-configuration>  

CD.hbm.xml -
------------------
[/code]
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

<class name="CD" table="CD">

<id name="Id" type="int" column="ID"> <generator class="hilo"/></id>

<property name="title" type="string"><column name="title"/></property>

</class>

</hibernate-mapping>
[/code]

Console output -
-------------------
When I start the app :

Code:

n] INFO org.hibernate.cfg.Environment  - Hibernate 3.2.5
[main] INFO org.hibernate.cfg.Environment  - hibernate.properties not found
[main] INFO org.hibernate.cfg.Environment  - Bytecode provider name : cglib
[main] INFO org.hibernate.cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
[main] INFO org.hibernate.cfg.Configuration  - Reading mappings from resource: CD.hbm.xml
[main] INFO org.hibernate.cfg.Configuration  - Reading mappings from resource: CD.hbm.xml
[main] DEBUG org.hibernate.util.DTDEntityResolver  - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
[main] DEBUG org.hibernate.util.DTDEntityResolver  - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
[main] DEBUG org.hibernate.util.DTDEntityResolver  - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
[main] INFO org.hibernate.cfg.HbmBinder  - Mapping class: CD -> CD
[main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: Id -> ID
[main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: title -> title
[main] INFO org.hibernate.cfg.Configuration  - configuring from resource: hibernate.cfg.xml
[main] INFO org.hibernate.cfg.Configuration  - Configuration resource: hibernate.cfg.xml
[main] DEBUG org.hibernate.util.DTDEntityResolver  - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
[main] DEBUG org.hibernate.util.DTDEntityResolver  - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
[main] DEBUG org.hibernate.util.DTDEntityResolver  - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
[main] DEBUG org.hibernate.cfg.Configuration  - hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
[main] DEBUG org.hibernate.cfg.Configuration  - hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:XE
[main] DEBUG org.hibernate.cfg.Configuration  - hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
[main] DEBUG org.hibernate.cfg.Configuration  - hibernate.connection.username=SYSTEM
[main] DEBUG org.hibernate.cfg.Configuration  - hibernate.connection.password=Swordfish1
[main] DEBUG org.hibernate.cfg.Configuration  - connection.pool_size=10
[main] DEBUG org.hibernate.cfg.Configuration  - show_sql=true
[main] INFO org.hibernate.cfg.Configuration  - Configured SessionFactory: null
[main] DEBUG org.hibernate.cfg.Configuration  - Preparing to build session factory with filters : {}
[main] DEBUG org.hibernate.cfg.Configuration  - processing extends queue
[main] DEBUG org.hibernate.cfg.Configuration  - processing collection mappings
[main] DEBUG org.hibernate.cfg.Configuration  - processing native query and ResultSetMapping mappings
[main] DEBUG org.hibernate.cfg.Configuration  - processing association property references
[main] DEBUG org.hibernate.cfg.Configuration  - processing foreign key constraints
[main] INFO org.hibernate.connection.DriverManagerConnectionProvider  - Using Hibernate built-in connection pool (not for production use!)
[main] INFO org.hibernate.connection.DriverManagerConnectionProvider  - Hibernate connection pool size: 10
[main] INFO org.hibernate.connection.DriverManagerConnectionProvider  - autocommit mode: false
[main] INFO org.hibernate.connection.DriverManagerConnectionProvider  - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@localhost:1521:XE
[main] INFO org.hibernate.connection.DriverManagerConnectionProvider  - connection properties: {user=SYSTEM, password=Swordfish1}
[main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
[main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - opening new JDBC connection
[main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - created connection to: jdbc:oracle:thin:@localhost:1521:XE, Isolation Level: 2
[main] INFO org.hibernate.cfg.SettingsFactory  - RDBMS: Oracle, version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
[main] INFO org.hibernate.cfg.SettingsFactory  - JDBC driver: Oracle JDBC driver, version: 11.1.0.6.0-Production+
[main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
[main] INFO org.hibernate.dialect.Dialect  - Using dialect: org.hibernate.dialect.Oracle10gDialect
[main] INFO org.hibernate.transaction.TransactionFactoryFactory  - Using default transaction strategy (direct JDBC transactions)
[main] INFO org.hibernate.transaction.TransactionManagerLookupFactory  - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[main] INFO org.hibernate.cfg.SettingsFactory  - Automatic flush during beforeCompletion(): disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Automatic session close at end of transaction: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - JDBC batch size: 15
[main] INFO org.hibernate.cfg.SettingsFactory  - JDBC batch updates for versioned data: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Scrollable result sets: enabled
[main] DEBUG org.hibernate.cfg.SettingsFactory  - Wrap result sets: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - JDBC3 getGeneratedKeys(): disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Connection release mode: auto
[main] INFO org.hibernate.cfg.SettingsFactory  - Default batch fetch size: 1
[main] INFO org.hibernate.cfg.SettingsFactory  - Generate SQL with comments: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Order SQL updates by primary key: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Order SQL inserts for batching: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory  - Using ASTQueryTranslatorFactory
[main] INFO org.hibernate.cfg.SettingsFactory  - Query language substitutions: {}
[main] INFO org.hibernate.cfg.SettingsFactory  - JPA-QL strict compliance: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Second-level cache: enabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Query cache: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Cache provider: org.hibernate.cache.NoCacheProvider
[main] INFO org.hibernate.cfg.SettingsFactory  - Optimize cache for minimal puts: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Structured second-level cache entries: disabled
[main] DEBUG org.hibernate.exception.SQLExceptionConverterFactory  - Using dialect defined converter
[main] INFO org.hibernate.cfg.SettingsFactory  - Echoing all SQL to stdout
[main] INFO org.hibernate.cfg.SettingsFactory  - Statistics: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Deleted entity synthetic identifier rollback: disabled
[main] INFO org.hibernate.cfg.SettingsFactory  - Default entity-mode: pojo
[main] INFO org.hibernate.cfg.SettingsFactory  - Named query checking : enabled
[main] INFO org.hibernate.impl.SessionFactoryImpl  - building session factory
[main] DEBUG org.hibernate.impl.SessionFactoryImpl  - Session factory constructed with filter configurations : {}
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  - Static SQL for entity: CD
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Version select: select ID from CD where ID =?
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Snapshot select: select cd_.ID, cd_.title as title0_ from CD cd_ where cd_.ID=?
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Insert 0: insert into CD (title, ID) values (?, ?)
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Update 0: update CD set title=? where ID=?
[main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Delete 0: delete from CD where ID=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity CD: select cd0_.ID as ID0_0_, cd0_.title as title0_0_ from CD cd0_ where cd0_.ID=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity CD: select cd0_.ID as ID0_0_, cd0_.title as title0_0_ from CD cd0_ where cd0_.ID=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity CD: select cd0_.ID as ID0_0_, cd0_.title as title0_0_ from CD cd0_ where cd0_.ID=? for update
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity CD: select cd0_.ID as ID0_0_, cd0_.title as title0_0_ from CD cd0_ where cd0_.ID=? for update nowait
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity CD: select cd0_.ID as ID0_0_, cd0_.title as title0_0_ from CD cd0_ where cd0_.ID=? for update nowait
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for action ACTION_MERGE on entity CD: select cd0_.ID as ID0_0_, cd0_.title as title0_0_ from CD cd0_ where cd0_.ID=?
[main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for action ACTION_REFRESH on entity CD: select cd0_.ID as ID0_0_, cd0_.title as title0_0_ from CD cd0_ where cd0_.ID=?
[main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory  - initializing class SessionFactoryObjectFactory
[main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory  - registered: 2c90b2d61908c136011908c137ff0000 (unnamed)
[main] INFO org.hibernate.impl.SessionFactoryObjectFactory  - Not binding factory to JNDI, no JNDI name configured
[main] DEBUG org.hibernate.impl.SessionFactoryImpl  - instantiated session factory
[main] DEBUG org.hibernate.impl.SessionFactoryImpl  - Checking 0 named HQL queries
[main] DEBUG org.hibernate.impl.SessionFactoryImpl  - Checking 0 named SQL queries

And when I click the Add button :

Code:

testCD
[AWT-EventQueue-0] DEBUG org.hibernate.impl.SessionImpl  - opened session at timestamp: 12070314130
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.DefaultSaveOrUpdateEventListener  - saving transient instance
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.AbstractBatcher  - opening JDBC connection
[AWT-EventQueue-0] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
[AWT-EventQueue-0] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - using pooled JDBC connection, pool size: 0
[AWT-EventQueue-0] DEBUG org.hibernate.SQL  - select next_hi from hibernate_unique_key for update
[AWT-EventQueue-0] DEBUG org.hibernate.SQL  - update hibernate_unique_key set next_hi = ? where next_hi = ?
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing JDBC connection (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)
[AWT-EventQueue-0] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
[AWT-EventQueue-0] DEBUG org.hibernate.id.TableHiLoGenerator  - new hi value: 4
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractSaveEventListener  - generated identifier: 131072, using strategy: org.hibernate.id.TableHiLoGenerator
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractSaveEventListener  - saving [CD#131072]
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - flushing session
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - processing flush-time cascades
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - dirty checking collections
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushing entities and processing referenced collections
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Processing unreferenced collections
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Scheduling collection removes/(re)creates/updates
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushed: 1 insertions, 0 updates, 0 deletions to 1 objects
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
[AWT-EventQueue-0] DEBUG org.hibernate.pretty.Printer  - listing entities:
[AWT-EventQueue-0] DEBUG org.hibernate.pretty.Printer  - CD{title=testCD, Id=131072}
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - executing flush
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.ConnectionManager  - registering flush begin
[AWT-EventQueue-0] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  - Inserting entity: [CD#131072]
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.ConnectionManager  - opening JDBC connection
[AWT-EventQueue-0] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
[AWT-EventQueue-0] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - using pooled JDBC connection, pool size: 0
[AWT-EventQueue-0] DEBUG org.hibernate.SQL  - insert into CD (title, ID) values (?, ?)
Hibernate: insert into CD (title, ID) values (?, ?)
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.AbstractBatcher  - preparing statement
[AWT-EventQueue-0] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  - Dehydrating entity: [CD#131072]
[AWT-EventQueue-0] DEBUG org.hibernate.type.StringType  - binding 'testCD' to parameter: 1
[AWT-EventQueue-0] DEBUG org.hibernate.type.IntegerType  - binding '131072' to parameter: 2
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.AbstractBatcher  - Executing batch size: 1
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.Expectations  - success of batch update unknown: 0
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing statement
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.ConnectionManager  - registering flush end
[AWT-EventQueue-0] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - post flush
[AWT-EventQueue-0] DEBUG org.hibernate.impl.SessionImpl  - closing session
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.ConnectionManager  - performing cleanup
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.ConnectionManager  - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
[AWT-EventQueue-0] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
[AWT-EventQueue-0] DEBUG org.hibernate.jdbc.ConnectionManager  - aggressively releasing JDBC connection
[AWT-EventQueue-0] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion

Top

ezanih

Post subject: Problem Solved!

Posted: Tue Apr 01, 2008 3:06 am

Newbie

Joined: Mon Mar 31, 2008 12:50 am
Posts: 4

Its ok, my problem is solved! Thank God! I added a begin transaction and a commit transaction after session.save.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum