Simple Hibernate Help (Im Noob)

[agustinus lumbantoruan]

Dear friend I think I might have a simple problem which ofcourse I do not have the solution yet.
I have set up my working file below neatly. I hope it does not confused you.
At the bottom you would see the outcome from my project.

This is my "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://127.0.0.1:3306/new_schema</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.connection.password">password</property> <mapping resource="demo/classes/Articles.hbm.xml"/> </session-factory> </hibernate-configuration>

This is my Articles.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="demo.classes.Articles" table="articles" catalog="new_schema"> <id name="articleId" type="short"> <column name="ArticleID" /> <generator class="assigned" /> </id> <property name="articleTitle" type="string"> <column name="ArticleTitle" length="60" not-null="true" /> </property> <property name="copyright" type="date"> <column name="Copyright" length="0" not-null="true" /> </property> </class> </hibernate-mapping>

Below is my Article class. It just have setter and getter only.

package demo.classes;
// Generated 31 Mar 11 16:23:18 by Hibernate Tools 3.2.1.GA


import java.util.Date;

/**
 * Articles generated by hbm2java
 */
public class Articles  implements java.io.Serializable {


     private short articleId;
     private String articleTitle;
     private Date copyright;

    public Articles() {
    }

    public Articles(short articleId, String articleTitle, Date copyright) {
       this.articleId = articleId;
       this.articleTitle = articleTitle;
       this.copyright = copyright;
    }
   
    public short getArticleId() {
        return this.articleId;
    }
    
    public void setArticleId(short articleId) {
        this.articleId = articleId;
    }
    public String getArticleTitle() {
        return this.articleTitle;
    }
    
    public void setArticleTitle(String articleTitle) {
        this.articleTitle = articleTitle;
    }
    public Date getCopyright() {
        return this.copyright;
    }
    
    public void setCopyright(Date copyright) {
        this.copyright = copyright;
    }
}

Finally my Test class

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package demo.classes;

import java.util.Date;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

/**
 *
 * @author Bio
 */
public class Test {
    public static void main(String[]args){
        Session session = null;

        SessionFactory sf = new Configuration().configure().buildSessionFactory();

        session = sf.openSession();

        Articles articles = new Articles();

        Transaction tx  = session.beginTransaction();

        articles.setArticleId((short)1230);
        articles.setArticleTitle("The long journey");
        articles.setCopyright(new Date(2009, 8, 28));
    }
}

This is the outcome by executing the Test.java
Could anyone help me out please. Im sorry to bother you.

init:
deps-module-jar:
deps-ear-jar:
deps-jar:
compile-single:
run-main:
31 Mar 11 16:29:40 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
31 Mar 11 16:29:40 org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
31 Mar 11 16:29:40 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
31 Mar 11 16:29:40 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
31 Mar 11 16:29:41 org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
31 Mar 11 16:29:41 org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
31 Mar 11 16:29:41 org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : demo/classes/Articles.hbm.xml
31 Mar 11 16:29:41 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: demo.classes.Articles -> articles
31 Mar 11 16:29:41 org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
31 Mar 11 16:29:41 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
31 Mar 11 16:29:41 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
31 Mar 11 16:29:41 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
31 Mar 11 16:29:41 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://127.0.0.1:3306/new_schema
31 Mar 11 16:29:41 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root, password=****}
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 5.1.51-community
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
31 Mar 11 16:29:41 org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
31 Mar 11 16:29:41 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
31 Mar 11 16:29:41 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
31 Mar 11 16:29:41 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
31 Mar 11 16:29:41 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
31 Mar 11 16:29:41 org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
31 Mar 11 16:29:41 org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
BUILD SUCCESSFUL (total time: 1 second)

My database sql

-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Mar 31, 2011 at 05:05 -- Server version: 5.1.51 -- PHP Version: 5.3.1 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `new_schema` -- -- -------------------------------------------------------- -- -- Table structure for table `articles` -- CREATE TABLE IF NOT EXISTS `articles` ( `ArticleID` smallint(6) NOT NULL, `ArticleTitle` varchar(60) NOT NULL, `Copyright` year(4) NOT NULL, PRIMARY KEY (`ArticleID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `articles` -- INSERT INTO `articles` (`ArticleID`, `ArticleTitle`, `Copyright`) VALUES (12786, 'How write a paper', 1934), (13331, 'Publish a paper', 1919), (14356, 'Sell a paper', 1966), (15729, 'Buy a paper', 1932), (16284, 'Conferences', 1996), (17695, 'Journal', 1980), (19264, 'Information', 1992), (19354, 'AI', 1993); -- -------------------------------------------------------- -- -- Table structure for table `authorarticle` -- CREATE TABLE IF NOT EXISTS `authorarticle` ( `AuthID` smallint(6) NOT NULL, `ArticleID` smallint(6) NOT NULL, PRIMARY KEY (`AuthID`,`ArticleID`), KEY `ArticleID` (`ArticleID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `authorarticle` -- INSERT INTO `authorarticle` (`AuthID`, `ArticleID`) VALUES (1009, 12786), (1006, 14356), (1008, 15729), (1011, 15729), (1014, 16284), (1010, 17695), (1012, 19264), (1012, 19354); -- -------------------------------------------------------- -- -- Table structure for table `authors` -- CREATE TABLE IF NOT EXISTS `authors` ( `AuthID` smallint(6) NOT NULL, `AuthorFirstName` varchar(20) DEFAULT NULL, `AuthorMiddleName` varchar(20) DEFAULT NULL, `AuthorLastName` varchar(20) DEFAULT NULL, PRIMARY KEY (`AuthID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `authors` -- INSERT INTO `authors` (`AuthID`, `AuthorFirstName`, `AuthorMiddleName`, `AuthorLastName`) VALUES (1006, 'Henry', 'S.', 'Thompson'), (1007, 'Jason', 'Carol', 'Oak'), (1008, 'James', NULL, 'Elk'), (1009, 'Tom', 'M', 'Ride'), (1010, 'Jack', 'K', 'Ken'), (1011, 'Mary', 'G.', 'Lee'), (1012, 'Annie', NULL, 'Peng'), (1013, 'Alan', NULL, 'Wang'), (1014, 'Nelson', NULL, 'Yin'); -- -- Constraints for dumped tables -- -- -- Constraints for table `authorarticle` -- ALTER TABLE `authorarticle` ADD CONSTRAINT `authorarticle_ibfk_1` FOREIGN KEY (`AuthID`) REFERENCES `authors` (`AuthID`), ADD CONSTRAINT `authorarticle_ibfk_2` FOREIGN KEY (`ArticleID`) REFERENCES `articles` (`ArticleID`); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[David O'Meara]

and what is the problem?

[agustinus lumbantoruan]

I believe this sir
INFO: Not binding factory to JNDI, no JNDI name configured

[agustinus lumbantoruan]

David O'Meara wrote:and what is the problem?

I think the problem is "INFO: Not binding factory to JNDI, no JNDI name configured".

I have also tried to create a resource in the TOMCAT context

<Resource name="jdbc/new_schema" auth="Container" type="javax.sql.DataSource" removeAbandoned="true" removeAbandonedTimeout="30" maxActive="100" maxIdle="30" maxWait="10000" username="root" password="b105x777" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/new_schema"/>

I have also update the hibernate.cfg.xml file to this
<?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://127.0.0.1:3306/new_schema</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.connection.password">b105x777</property> <property name="hibernate.connection.datasource">java:comp/env/jdbc/new_schema</property> <mapping resource="demo/classes/Articles.hbm.xml"/> </session-factory> </hibernate-configuration>

It produce this error

SEVERE: Could not find datasource: java:comp/env/jdbc/new_schema
javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:645)
at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:288)
at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:325)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:414)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at demo.classes.Test.main(Test.java:22)
Exception in thread "main" org.hibernate.HibernateException: Could not find datasource
at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:56)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:414)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at demo.classes.Test.main(Test.java:22)
Caused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:645)
at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:288)
at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:325)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
... 7 more
Java Result: 1
BUILD SUCCESSFUL (total time: 1 second)

[David O'Meara]

Are you using Tomcat? It is the first time you mentioned it.
Going back to your first example, you need some way to connect your code to the Hibernate configuration.
It logs your connection details so no problem there.
Your SessionFactory is not bound to JNDI so that's not a problem.
Looking at your test code, you open a transaction and then do nothing.
Committing it could be useful.
You can also look for the property which logs SQL statements as this is handy to test what it going to the database.

[agustinus lumbantoruan]

Sir Sherif, thank you for the response
unfortunately it gave me this error

Test.class update

package demo.classes;

import java.util.Date;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

/**
 *
 * @author Bio
 */
public class Test {
    public static void main(String[]args){
        Session session = null;
        try{
        SessionFactory sf = new Configuration().configure().buildSessionFactory();

        session = sf.openSession();

        Articles articles = new Articles();

        Transaction tx  = session.beginTransaction();

        articles.setArticleId((short)1230);
        articles.setArticleTitle("The long journey");
        articles.setCopyright(new Date(2009));
        session.save(articles);
        tx.commit();
        }
        catch(Exception e){
            System.out.println(e.getMessage());
        }
        finally{
          session.close();
        }
    }
}

I also try added the HibernateUtil.java

package demo.classes;

import java.sql.*;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import java.io.*;

public class HibernateUtil {
  public static final SessionFactory sessionFact;
  static {
    try {
      // Create the SessionFactory from hibernate.cfg.xml
      sessionFact = new Configuration().configure().buildSessionFactory();
    }
    catch(Throwable e) {
      System.out.println("SessionFactory creation failed." + e);
      throw new ExceptionInInitializerError(e);
    }
  }
  public static final ThreadLocal session = new ThreadLocal();

  public static Session currentSession() throws HibernateException {
    Session sess = (Session) session.get();
    // Open a new Session, if this thread has none yet
    if(sess == null){
      sess = sessionFact.openSession();
      // Store it in the ThreadLocal variable
      session.set(sess);
    }
    return sess;
  }
  public static void SessionClose() throws Exception {
    Session s = (Session) session.get();
    if (s != null)
      s.close();
    session.set(null);
  }
}

Error code:

SEVERE: Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
Could not execute JDBC batch update
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at demo.classes.Test.main(Test.java:29)
Caused by: java.sql.BatchUpdateException: Data truncated for column 'Copyright' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 8 more

I have not eaten yet, becauase i have not resolve this problem since 10PM

[agustinus lumbantoruan]

agustinus lumbantoruan wrote:Sir Sherif, thank you for the response
Yes Sherif, I do use Tomcat because it's cool )
unfortunately it gave me this error

Test.class update

package demo.classes;

import java.util.Date;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

/**
 *
 * @author Bio
 */
public class Test {
    public static void main(String[]args){
        Session session = null;
        try{
        SessionFactory sf = new Configuration().configure().buildSessionFactory();

        session = sf.openSession();

        Articles articles = new Articles();

        Transaction tx  = session.beginTransaction();

        articles.setArticleId((short)12345);
        articles.setArticleTitle("The long journey");
        articles.setCopyright(new Date(2009));
        session.save(articles);
        tx.commit();
        }
        catch(Exception e){
            System.out.println(e.getMessage());
        }
        finally{
          session.close();
        }
    }
}

I also try added the HibernateUtil.java

package demo.classes;

import java.sql.*;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import java.io.*;

public class HibernateUtil {
  public static final SessionFactory sessionFact;
  static {
    try {
      // Create the SessionFactory from hibernate.cfg.xml
      sessionFact = new Configuration().configure().buildSessionFactory();
    }
    catch(Throwable e) {
      System.out.println("SessionFactory creation failed." + e);
      throw new ExceptionInInitializerError(e);
    }
  }
  public static final ThreadLocal session = new ThreadLocal();

  public static Session currentSession() throws HibernateException {
    Session sess = (Session) session.get();
    // Open a new Session, if this thread has none yet
    if(sess == null){
      sess = sessionFact.openSession();
      // Store it in the ThreadLocal variable
      session.set(sess);
    }
    return sess;
  }
  public static void SessionClose() throws Exception {
    Session s = (Session) session.get();
    if (s != null)
      s.close();
    session.set(null);
  }
}

Error code:

SEVERE: Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
Could not execute JDBC batch update
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at demo.classes.Test.main(Test.java:29)
Caused by: java.sql.BatchUpdateException: Data truncated for column 'Copyright' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 8 more

I have not eaten yet, becauase i have not resolve this problem since 10PM

[David O'Meara]

Excellent, now we're getting somewhere!
Does that item already exist in the database?

[agustinus lumbantoruan]

I dont think so hmmmmm

[Arun Kumarr]

It says data is truncated. Can you check, if you are trying to insert value which is more the allowed length by the table's column?

[David O'Meara]

My bad, I was looking at the wrong error:

Caused by: java.sql.BatchUpdateException: Data truncated for column 'Copyright' at row 1 

I'm not sure I like that field, maybe you should remove it for now, or make it a simple Date field while you're learning?

[Prasad Krishnegowda]

In your create script of articles table, you declare it has year(4), and here you are trying to insert new Date(2009), that will result in Thu Jan 01 05:30:02 IST 1970.. try inserting only year.. it should work..

EDIT: Didn't notice David's reply.. Yes, you can do what david has suggested, for learning make the type as date..

[agustinus lumbantoruan]

Sorry dear programmers, i did not reply quick because I had a nap
Im surprised there are so many response.
You guys are great, let me try your solutions.
I will be back with you soon

[David O'Meara]

I wondered where you went

[agustinus lumbantoruan]

My dear programmers

At last, I would like to end this month with a great news for all of you that "The Hibernate is working!!!" yayyyyyy
Now i see a light at the end of the tunnel

anyway so, I "Alter table Articles drop copyright" as most of you suggested me to.

I managed to delete the unnecesary copyright variable in the Articles.hbm.xml and Articles.java

Many thanks to David, Arun and Prasad for your help.
You guys saved me from having a nightmare.


The latest Articles.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"> <!-- Generated 31 Mar 11 16:23:19 by Hibernate Tools 3.2.1.GA --> <hibernate-mapping> <class catalog="new_schema" name="demo.classes.Articles" table="articles"> <id name="articleId" type="short"> <column name="ArticleID"/> <generator class="assigned"/> </id> <property name="articleTitle" type="string"> <column length="60" name="ArticleTitle" not-null="true"/> </property> </class> </hibernate-mapping>

the latest Articles.java

package demo.classes;
// Generated 31 Mar 11 16:23:18 by Hibernate Tools 3.2.1.GA


import java.util.Date;

/**
 * Articles generated by hbm2java
 */
public class Articles  implements java.io.Serializable {


     private short articleId;
     private String articleTitle;

    public Articles() {
    }

    public Articles(short articleId, String articleTitle) {
       this.articleId = articleId;
       this.articleTitle = articleTitle;
    }
   
    public short getArticleId() {
        return this.articleId;
    }
    
    public void setArticleId(short articleId) {
        this.articleId = articleId;
    }
    public String getArticleTitle() {
        return this.articleTitle;
    }
    
    public void setArticleTitle(String articleTitle) {
        this.articleTitle = articleTitle;
    }
}

[agustinus lumbantoruan]

So, how could you insert a variable with a data type "Date" into a database using Hibernate?

That is interesting.

Or should i make a new thread?

[David O'Meara]

Probably a new thread.
If you only wanted to store a (single) year value and weren't concerned about filtering, sorting or selecting the value then a varchar(4) might suffice. It's larger than a Date but easy to read and harder to get wrong than a Date-which-only-has-a-year

[Arun Kumarr]

Nice to hear you had it working. Pleasure was ours.
You might want to turn on "hibernate.show_sql=true" in your config file and actually inspect the query and what values are getting inserted.
I also faintly think that hibernate might show something (?, ?, ?, ?) while inserting instead of actual values, which I'm not very sure.
If it does, then excuse me.