日期:2014-05-16 浏览次数:20606 次
报出异常:net.sf.hibernate.JDBCException: Could not execute query
连上数据库没有问题的 
? 请看代码: 
? private void test() throws HibernateException,QueryException{ 
? System.out.println("testing the hibernate....."); 
? Session session = HibernateSessionFactory.currentSession(); 
? Transaction transaction = session.beginTransaction(); 
? Query query = session.createQuery("from jiveid"); 
? System.out.println("flag in action"); 
? for(Iterator iterator = query.iterate();iterator.hasNext();){ 
? System.out.println("flag in for statemant"); 
? Jiveid jiveid =(Jiveid)iterator.next(); 
? System.out.println("idtype is :" + jiveid.getIdtype()); 
? } 
? // System.out.println("ifConnected: " + session.isConnected()); 
? // System.out.println("ifOpen :" + session.isOpen()); 
? // System.out.println("ifDirty :" + session.isDirty()); 
? // List l = session.find("FROM jiveid"); 
? // //List l = q.list(); 
? // for (int i=0; i< l.size(); i++) { 
? // Long id = (Long) l.get(i); 
? // System.out.println(id.longValue()); 
? // } 
? transaction.commit(); 
? HibernateSessionFactory.closeSession(); 
? }
------解决方法--------------------
Query query = session.createQuery("from jiveid"); 
? 
? 改成 
? 
? Query query = session.createQuery("select jiveid from Jiveid as jiveid");试试!!