hibernate入门的例子,查询出错.
public void Query()
{
String hql ="from examples.Cat c where cat_id like '3%'"; //正常(cat_id是主键)
//String hql ="from examples.Cat c where name like '%name%'"; //使用这句则报下面的错.
Query query = psession.createQuery(hql);
for (Iterator lst = query.iterate(); lst.hasNext();)
{
Cat c1 = (Cat) lst.next();
System.out.println(c1.getName());
}
}
org.hibernate.JDBCException: could not load an entity: [examples.Cat#1] [select cat0_.CAT_ID as CAT_ID0_, cat0_.NAME as NAME1_0_, cat0_.sex as sex1_0_, cat0_.weight as weight1_0_ from CAT cat0_ where cat0_.CAT_ID=?]
at org.hibernate.util.JDBCExceptionReporter.newJDBCException(JDBCExceptionReporter.java:57)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1105)
at org.hibernate.loader.EntityLoader.load(EntityLoader.java:111)
at org.hibernate.loader.EntityLoader.load(EntityLoader.java:97)
at org.hibernate.persister.BasicEntityPersister.load(BasicEntityPersister.java:2262)
at org.hibernate.event.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:353)
at org.hibernate.event.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:334)
at org.hibernate.event.DefaultLoadEventListener.load(DefaultLoadEventListener.java:159)
at org.hibernate.event.DefaultLoadEventListener.load(DefaultLoadEventListener.java:132)
at org.hibernate.event.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:111)
at org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:1223)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:59)
at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:80)
at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:115)
at examples.Cat$$EnhancerByCGLIB$$e511c641.getName(<generated>)
at cauchy.TestRegion.Query(TestRegion.java:103)
at cauchy.TestRegion.main(TestRegion.java:28)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.<init>(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:340)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:291)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:80)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:967)
at org.hibernate.loader.Loader.doQuery(Loader.java:338)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:190)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1096)
... 15 more
问题点数:20、回复次数:3Top
1 楼AiQun(爱麇)回复于 2005-06-07 20:18:36 得分 0
同时有两个相同的标题的帖也能发?Top
2 楼xiangqianchong(向前冲)回复于 2005-06-07 22:19:25 得分 0
public void Query()
{
String hql ="from examples.Cat c where cat_id like '3%'"; //正常(cat_id是主键)
//String hql ="from examples.Cat c where name like '%name%'"; //使用这句则报下面的错.
Query query = psession.createQuery(hql);
List l = query .list();
Iterator lst = l.iterator();
while (lst.hasNext())
{
Cat c1 = (Cat) lst.next();
System.out.println(c1.getName());
}
}
Top
3 楼AiQun(爱麇)回复于 2005-08-11 22:45:28 得分 20
public void Query()
{
String hql ="from examples.Cat c where cat_id like '3%'"; //正常(cat_id是主键)
//String hql ="from examples.Cat c where name like '%name%'"; //使用这句则报下面的错.
List query = psession.createQuery(hql).list();
for (Iterator lst = query.iterate(); lst.hasNext();)
{
Cat c1 = (Cat) lst.next();
System.out.println(c1.getName());
}
}
Top




