Question

hibernate为啥查询会出现错误啊，我的查询语句没问题，使用原生sql也不行，求大神解决

String sql = "select stc.`Invoice_category`,stc.Category_No,stc.Invoice_No,ts.Company_Name,ts.ID_Card ,stc.Invoice_Date,stc.`Month`,stc.Total_Money," +
"stc.Tax_Rate,stc.SumTaxMoney,stc.Flag from security_tax_controlled stc , tax_supplier ts where stc.S_PK_ID=ts.ID_Card and stc.secType='销项'" +
"and stc.invoice_Date>='"+firsttime+"' and stc.invoice_Date<='"+lasttime+"'";
SQLQuery query = this.getSession().createSQLQuery(sql);
List<Object []> objs = query.addEntity(TaxInformVO.class).list();
贴上代码
The server encountered an internal error () that prevented it from fulfilling this request.
exception

Answer 1

第一：直接使用HibernateTemplate 你的sql中from+对象名称（不是表名）。
第二：在hibernate中使用原生sql需要继承hibernate原来的类，public Object doInHibernate(final Session session) throws HibernateException, SQLException

Answer 2

异常贴出来喽

把异常信息贴多点出来..这一句看不出什么

Answer 3

贴错误信息