hibernate-SQL Error: 17008, SQLState: null

2019-12-04 19:00栏目:编程
TAG:

public static void main(String[] args) {
 
  DeptEntity dept = getDept("402882e762ae888d0162ae888e420000");

延期加载在Hibernate中是暗许延迟加载;

SQL Error: 17008, SQLState: null
老是程序运维后生可畏段时间今后,就报此错
08-08-17 09:55:29 WARN JDBCExceptionReporter:71 - SQL Error: 17008, SQLState: null
08-08-17 09:55:29 E奥迪Q7RO凯雷德 JDBCExceptionReporter:72 - 关闭的连天
08-08-17 09:55:29 WARN JDBCExceptionReporter:71 - SQL Error: 17008, SQLState: null
08-08-17 09:55:29 ERubiconROTiguan JDBCExceptionReporter:72 - 关闭的接连
org.hibernate.exception.GenericJDBCException: could not execute query
Caused by: java.sql.SQLException: 关闭的连天

  //dept.getEmp(卡塔尔(英语:State of Qatar)获得子表的记录会集
  System.out.println(dept.getEmp());

测量试验代码生机勃勃:

我的的struts2 +hibernate3

}

HibernateTest.java

bob体育平台,dao是
public Userinfo checkUserinfo(String name, String pwd) {

private static DeptEntity getDept(String did){
  Session session = sessionFactory.openSession();
  DeptEntity dept = (DeptEntity)session.get(DeptEntity.class, did);
  session.close();
  return dept;
}

代码:

 Session session = HibernateSessionFactory.getSession(); Transaction ta = session.beginTransaction(); Userinfo userinfo =  session.createCriteria(Userinfo.class) .add(Expression.eq("userinfoName", name)).add( Expression.eq("userinfoPassword", pwd)).uniqueResult(); ta.commit(); HibernateSessionFactory.closeSession(); return userinfo;}

 

/**
 *
 */
bob体育app,package com.b510.examples;

[b]标题补充:[/b]
package com.shop.hibernate.util;

运维结果:

import java.util.Set;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;

Exception in thread "main" org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: com.javakc.hibernate.onetomany.entity.DeptEntity.emp, could not initialize proxy - no Session
at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:566)
at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:186)
at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:545)
at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:124)
at org.hibernate.collection.internal.PersistentSet.toString(PersistentSet.java:326)
at java.lang.String.valueOf(String.java:2827)
at java.io.PrintStream.println(PrintStream.java:771)
at com.javakc.hibernate.onetomany.action.TestAction.main(TestAction.java:74)

import org.hibernate.Session;

/**

 

/**
 *
 * @author XHW
 *
 * @date 2011-7-18
 *
 */
public class HibernateTest {
 public static void main(String[] args) {
  new HibernateTest().update();
 }
 public void update(){
  Session session=HibernateSessionFactoryUtil.getSessionFactory().getCurrentSession();
  session.beginTransaction();
  Category category=(Category)session.get(Category.class, 1);
  System.out.println("id:"+category.getId()+"  ,name:"+category.getName()+", description:"+category.getDescription());
  
  Set<Product> products=category.getProducts();
  
  session.getTransaction().commit();  
 }
 
 
}

  • Configures and provides access to Hibernate sessions, tied to the
  • current thread of execution. Follows the Thread Local Session
  • pattern, see {@link }.
    */
    public class HibernateSessionFactory {

    /**

    • Location of hibernate.cfg.xml file.
    • Location should be on the classpath as Hibernate uses
    • #resourceAsStream style lookup for its configuration file.
    • The default classpath location of the hibernate config file is
    • in the default package. Use #setConfigFile() to update
    • the location of the configuration file for the current session.
      */private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";private static final ThreadLocal threadLocal = new ThreadLocal();private static Configuration configuration = new Configuration();private static org.hibernate.SessionFactory sessionFactory;private static String configFile = CONFIG_FILE_LOCATION;

    static {
    try {
    configuration.configure(configFile);
    sessionFactory = configuration.buildSessionFactory();
    } catch (Exception e) {
    System.err
    .println("%%%% Error Creating SessionFactory %%%%");
    e.printStackTrace();
    }
    }
    private HibernateSessionFactory() {
    }

    /**

    • Returns the ThreadLocal Session instance. Lazy initialize
    • the SessionFactory if needed.*
    • @return Session
    • @throws HibernateException
      */
      public static Session getSession() throws HibernateException {
      Session session = threadLocal.get();

      if (session == null || !session.isOpen {
      if (sessionFactory == null) {
      rebuildSessionFactory();
      }
      session = (sessionFactory != null) ? sessionFactory.openSession()
      : null;
      threadLocal.set;
      }

      return session;
      }

    /**

    • Rebuild hibernate session factory**/public static void rebuildSessionFactory() {try { configuration.configure(configFile); sessionFactory = configuration.buildSessionFactory();} catch (Exception e) { System.err .println("%%%% Error Creating SessionFactory %%%%"); e.printStackTrace();}}

    /**

    • Close the single hibernate session instance.*
    • @throws HibernateException
      */
      public static void closeSession() throws HibernateException {
      Session session = threadLocal.get();
      threadLocal.set;

      if (session != null) {
      session.close();
      }
      }

    /**

    • return session factory**/public static org.hibernate.SessionFactory getSessionFactory() {return sessionFactory;}

    /**

    • return session factory*
    • session factory will be rebuilded in the next call*/public static void setConfigFile(String configFile) {HibernateSessionFactory.configFile = configFile;sessionFactory = null;}

    /**

    • return hibernate configuration**/public static Configuration getConfiguration() {return configuration;}

集合延迟加载开首化退步,不可能带头化贰个代理。就是聚众在非后生可畏对风流倜傥对象关系中,为了节省能源是暗中同意延迟加载,而get方法又是非延迟加载,所以在实行完二遍数据库查询后就实行session.close(卡塔尔;关闭了session,而集合是延迟加载,在选择集适那时候再加载,当时session已经关门,所以得不到代办。化解办法:能够在主表的hbm配置文件中,在<set>标签里设置lazy="false",集结就不推迟加载了,因而在实行get方法时,群集也拿到到了,就不会冒出延迟加载难点了。

运转结果:

}

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate:
    select
        category0_.id as id1_0_,
        category0_.name as name1_0_,
        category0_.description as descript3_1_0_
    from
        users.category category0_
    where
        category0_.id=?
id:1  ,name:java, description:java好啊

那是自动生成的

这里咱们看看我们关怀的是id,name和description属性,

[b]难题补充:[/b]

Caused by: java.sql.SQLException: 关闭的接连几日
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:895)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:334)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
... 122 more

即使有:  Set<Product> products=category.getProducts(卡塔尔; 代码,即:不管理群集对象。可是大家如若的是:

  System.out.println("id:"+category.getId()+"  ,name:"+category.getName()+", description:"+category.getDescription());
输出的是id,name和description属性值,别的的大家无论,所以Hibernate用了lazy loading(延迟加载卡塔尔(英语:State of Qatar),带来的好处就是我们不爱戴的

数量,不用现在加载,当大家要用的时候,才去加载

版权声明:本文由bob体育app发布于编程,转载请注明出处:hibernate-SQL Error: 17008, SQLState: null