java - 为什么hibernate查询表集报错?
问题描述
import java.util.List;import org.hibernate.Query;import org.hibernate.Session;import org.hibernate.SessionFactory;import org.hibernate.Transaction;import org.hibernate.cfg.Configuration;import qiye.Impl.ServiceDaoImpl;import qiye.entity.Contact;import qiye.entity.Service;public class TestJava { private static SessionFactory sessionFactory; static{Configuration configuraction = new Configuration().configure();sessionFactory = configuraction.buildSessionFactory(); } public static Session getSession(){return sessionFactory.openSession(); } public static List<Contact> getContactList(){Session s = null;List<Contact> list = null;try{ s = TestJava.getSession(); Query query = s.createQuery('from Service'); list = query.list(); for(Contact contact : list){System.out.println(contact.getAddress()); }}catch(Exception e){ e.printStackTrace();}finally{ if(s!=null){ s.close(); }}return list; }public static void main(String[] arg){TestJava.getContactList();System.out.println('hello'); }}
报错信息:
三月 29, 2017 4:49:54 下午 org.hibernate.Version logVersionINFO: HHH000412: Hibernate Core {5.2.7.Final}三月 29, 2017 4:49:54 下午 org.hibernate.cfg.Environment <clinit>INFO: HHH000206: hibernate.properties not found三月 29, 2017 4:49:54 下午 org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}三月 29, 2017 4:49:54 下午 org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntityWARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-mapping. Use namespace http://www.hibernate.org/dtd/hibernate-mapping instead. Support for obsolete DTD/XSD namespaces may be removed at any time.三月 29, 2017 4:49:55 下午 org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntityWARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-mapping. Use namespace http://www.hibernate.org/dtd/hibernate-mapping instead. Support for obsolete DTD/XSD namespaces may be removed at any time.三月 29, 2017 4:49:55 下午 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configureWARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)三月 29, 2017 4:49:55 下午 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreatorINFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/qiye?useUnicode=true&characterEncoding=UTF-8]三月 29, 2017 4:49:55 下午 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreatorINFO: HHH10001001: Connection properties: {user=root, password=****}三月 29, 2017 4:49:55 下午 org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreatorINFO: HHH10001003: Autocommit mode: false三月 29, 2017 4:49:55 下午 org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>INFO: HHH000115: Hibernate connection pool size: 20 (min=1)三月 29, 2017 4:49:55 下午 org.hibernate.dialect.Dialect <init>INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect三月 29, 2017 4:49:56 下午 org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnectionINFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@345c5f] for (non-JTA) DDL execution was not in auto-commit mode; the Connection ’local transaction’ will be committed and the Connection will be set into auto-commit mode.三月 29, 2017 4:49:56 下午 org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateServiceINFO: HHH000397: Using ASTQueryTranslatorFactoryHibernate: selectservice0_.ID as ID1_1_,service0_.TITLE as TITLE2_1_ fromSERVICE service0_java.lang.ClassCastException: qiye.entity.Service cannot be cast to qiye.entity.Contact at TestJava.getContactList(TestJava.java:33) at TestJava.main(TestJava.java:47)hello
这是怎么回事啊?
问题解答
回答1:List<Contact> list = null;
Query query = s.createQuery('from Service');list = query.list();
你的list里面是Contact,但是你查询的是Service,类型不匹配造成的,如果你确认查询的就是Service,改成List<Service>就行了
回答2:集合泛型List<Contact>,在擦除之后就没有类型了,因此,在这里定义的集合类型需要与结果类型一致,泛型之间不存在多态
相关文章:
1. 为什么我ping不通我的docker容器呢???2. mysql - JAVA怎么实现一个DAO同时实现查询两个实体类的结果集3. javascript - vue中父组件向子组件传递Object时,如何避免TypeError?4. golang - 用IDE看docker源码时的小问题5. mac连接阿里云docker集群,已经卡了2天了,求问?6. mysql - sql 语句更改表结构,添加多个列,怎么写?7. docker绑定了nginx端口 外部访问不到8. docker gitlab 如何git clone?9. javascript - 怎么设计项目的返回码,让不同的返回码代表不同的含义?10. html - IOS二维码识别问题