facebook

[Closed] cannot read the data from database ,but can save?

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #259752 Reply

    wanggang_ln
    Member

    Hi,
    new trouble, when i follow the example like this
    http://myeclipseide.com/enterpriseworkbench/help/index.jsp?topic=/com.genuitec.myeclipse.doc/html/quickstarts/hibernate/index.html”

    I found some problem occured,it can save data,but not read,why?
    version 5.0.1 GA database sqlserver 2000

    test file:

    import java.util.List;

    import org.hibernate.HibernateException;
    import org.hibernate.Session;
    import org.hibernate.Transaction;

    import com.genuitec.hibernate.EchoMessage;
    import com.genuitec.hibernate.HibernateSessionFactory;

    public class Test {

    /**
    * @param args
    */
    public static void main(String[] args) {
    // TODO Auto-generated method stub

    EchoMessage message=new EchoMessage();
    message.setMsg(“hello wanggang”);
    try{
    Session session=HibernateSessionFactory.getSession();
    Transaction tx=session.beginTransaction();
    session.save(message);
    tx.commit();
    System.out.println(“save successful.”);
    EchoMessage em=(EchoMessage)session.get(EchoMessage.class,new Long(1));
    //em.getMsg();
    //em.getMsg();
    //session.r
    //session.saveOrUpdate(em);

    Session session1 = HibernateSessionFactory.getSessionFactory().getCurrentSession();
    session1.beginTransaction();
    List result = session1.createQuery(“from EchoMessage”).list();
    session1.getTransaction().commit();
    for (int i = 0; i < result.size(); i++) {
    EchoMessage theEvent = (EchoMessage) result.get(i);
    System.out.println(“Event: ” + theEvent.getMsg());
    }
    System.out.println(“save fail.”);
    }catch(HibernateException e){
    System.out.println(“save fail.”);
    }catch(Exception e){
    System.out.println(e.getMessage());
    System.out.println(“error occur”);
    e.printStackTrace();
    }
    finally{
    HibernateSessionFactory.closeSession();
    }

    }

    }

    What’s the problem? thanks!!!!!

    If convenience,I email this project to you.my email address :wanggang_ln@163.com

    #259754 Reply

    wanggang_ln
    Member

    And prompt messages:

    java.lang.ClassCastException
    at org.hibernate.type.IntegerType.set(IntegerType.java:41)
    at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:83)
    at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:65)
    at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1514)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1576)
    at org.hibernate.loader.Loader.doQuery(Loader.java:661)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
    at org.hibernate.loader.Loader.loadEntity(Loader.java:1785)
    at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:47)
    at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:41)
    at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2730)
    at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:365)
    at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:346)
    at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:123)
    at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:177)
    at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87)
    at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:862)
    at org.hibernate.impl.SessionImpl.get(SessionImpl.java:799)
    at org.hibernate.impl.SessionImpl.get(SessionImpl.java:792)
    at Test.main(Test.java:27)

    #259768 Reply

    Haris Peco
    Member

    wanggang_ln ,

    You have type mismatch.Try change :

    EchoMessage em=(EchoMessage)session.get(EchoMessage.class,new Long(1));

    to

    EchoMessage em=(EchoMessage)session.get(EchoMessage.class,new Integer(1));

    or change id type in EchoMessage from Inetger to Long

    Best
    Peco

    #259775 Reply

    wanggang_ln
    Member

    My problem has been resolved,Thank you a lot.
    Thanks.

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: [Closed] cannot read the data from database ,but can save?

You must be logged in to post in the forum log in