使用hibernate hql update 关联表的问题 [问题点数:50分,结帖人michealp]

一键查看最优答案

确认一键查看最优答案?
本功能为VIP专享,开通VIP获取答案速率将提升10倍哦!
Bbs1
本版专家分:0
结帖率 100%
Bbs6
本版专家分:6171
Bbs1
本版专家分:0
Bbs1
本版专家分:3
Bbs1
本版专家分:0
Bbs6
本版专家分:6171
Bbs1
本版专家分:0
Bbs6
本版专家分:5806
Bbs1
本版专家分:0
Bbs1
本版专家分:0
Bbs1
本版专家分:0
hql语句的问题update同时set多个值,语句错误。
java.lang.IllegalArgumentException: node to traverse cannot be null! tomcat报上面的错误 下面是我的<em>hql</em>语句, String <em>hql</em> = "<em>update</em> Teacher t set t.tsex=? and t.ttelephone=? and t.teach_year=? and t.subject_One=? and t.teach_class_One=? where t.tusername=?"; Query sqlquery = ses.createQuery(<em>hql</em>); sqlquery.setParameter(0, teacher.getTsex()); sqlquery.setParameter(1, teacher.getTtelephone()); sqlquery.setParameter(2, teacher.getTeach_year()); sqlquery.setParameter(3, sOne); sqlquery.setParameter(4, cOne); sqlquery.setParameter(5, nowLogin);
Hibernate——HQL语句
HQL(Hibernate Query Language) – 官方推荐 前面的入门示例中,我们通过session.load(Employee.class, 1),也就是通过load()方法或者get()方法,可以通过主键属性来查询一条记录。当然这种方法很有局限性,为了更多的查询需求,我们需要<em>使用</em>HQL语句。 HQL即Hibernate查询语言,它是面向对象的查询语言,与SQL不同,HQL中的...
HQL 中 可以使用 SELECT* 吗?
如题
hql
HQL 是Hibernate Query Language的缩写 <em>hql</em> 与 sql 的区别/异同 <em>hql</em> sql 类名/属性 <em>表</em>名/列名 区分大小写,关键字不区分大小写 不区分大小写 别名 : ?,从下标0开始计算位置(<em>hibernate</em>5之后不支持) 别名:?,从顺序1开始计算位置 :命名参数 不支持:命名参数 面向对象的查询语言 面向结构查询语言 <em>hql</em>...
hibernate hql 使用关联对象查询的问题
public static void main(String args) { Session session = HibernateSessionFactory.getSession(); Stri
HQL多查询,多条件查询语句
一、题目内容 Student(id,name,age,StudentCard) StudentCard(id,cardNumber) 1.用HQL查询出:(学生ID,学生名,学生年龄,学生卡号,号ID) 条件:①学生年龄在18-25间②学生卡号包含有’01’字符③以学生年龄降序排序及学生名升序排序 2.用HQL统计符号以上条件的学生的平均年龄。 二、提问原因:本来初学<em>hql</em>,不太会。烦请大佬指正。 ``` @Test public static List findUserById(Integer id) { String <em>hql</em> ="SELECT s.id,s.name,s.age,c.cardNumber,c.id from Student s,StudentCard c where s.cid=c.id"; if(s.age! = null && .equals(s.age)){ <em>hql</em> += "and s.age between 18 and 25"; } if(c.cardNumber! = null && .equals(c.cardNumber)){ <em>hql</em> += "and c.cardNumber like '%01%'"; } if(s.age! = null && s.name! = null){ <em>hql</em> += "and order by s.age desc, s.name asc"; } List list = session.createQuery(<em>hql</em>).list(); for(Student student: list) { System.out.println(student); } } ``` ``` List results = session.find("select count(*), avg(s.age) from User as user"); ```
hibernate关联查询 HQL 查询语句?
查询出 A<em>表</em>的 ID 和 NAME 查询出 B<em>表</em>的所有字段 查询出 C<em>表</em>的 salary 该三个<em>表</em>都通过 ID <em>关联</em> A<em>表</em>的主键是 ID B<em>表</em>的主键是 ID 和修改时间 C<em>表</em>的主键是 ID 和 修改时
hql里面添加数据怎么写。。。。。。
<em>hql</em>怎么写添加语句? insert肯定不行 忘了SSH怎么用的了都
HQL的update语句
<em>update</em> A set a = "12" where car = "car1" 这条sql语句用我想用<em>hibernate</em>执行,该如何操作?我用的是<em>hibernate</em>3. 我试图这样写: try {
HQL条件查询
【例】雇员信息比较运算:查询姓名为“李树生”的雇员信息session=HibernateSessionFactory.getSession(); String <em>hql</em>=&quot;from Employee e where e.emp_name=?&quot;; Query query=session.createQuery(<em>hql</em>); query.setParameter(0, &quot;李树生&quot;); ...
三、HQL语句--where(限制)
where子句:逻辑<em>表</em>达式。用来设置查询的条件来限制返回的查询结果。 比较运算:将持久化类的属性与给定的查询条件来进行比较。  比较运算符: =、&amp;lt;&amp;gt;、&amp;lt;、&amp;gt;、&amp;gt;=、&amp;lt;= null值判断— is [not] null 或者<em>使用</em>相等(=)、不等(&amp;lt;&amp;gt;)进行判断。x=null -&amp;gt; x is null; x&amp;lt;&amp;gt;null -&amp;gt;...
spring-data-jpa 如何用@Query多查询,返回map
@Query("select s.userid,s.playeddury,s.courseid,s.videoid,l.name as videoname,l.clicknum,l.uploadtim
【求助】EF有方法批量删除数据吗?
就是 delete from orderdetails where orderid=1,order=1的details中有好几条,一条sql就全删除了。 foreach (InvoiceDetails
hibernate hqlupdate语句写法
我现在有一个班级<em>表</em>和一个学生<em>表</em>,班级<em>表</em>的主键)是学生<em>表</em>的外键,在班级<em>表</em>中,有一个“学生人数”的字段; 想要<em>使用</em><em>hql</em>语句,查询统计不同班级的学生人数,然后更新到班级<em>表</em>的“学生人数”字段里去; 用sql
Hibernate 中update hql语句
今天在MySQL中用<em>hibernate</em>测试<em>update</em>语句发现以下<em>问题</em>: <em>update</em>语句竟然不去作用; <em>表</em>机构如下: create table student(sid int prima
Hql 更新部分字段
Hql 更新部分字段 有多种方式我选择的是Query query = dao.getCurrentSession().createQuery(&quot;<em>update</em> realestate.Supervice.sto.PayableBill p set p.paybill_BankName=?,p.paybill_BankStaff =?,p.paybill_Money =?,p.paybill_Date ...
SQL如何直接批量删除
将数据导入到了默认系统数据库master,现想删除,不能批量操作,请教。
hibernate之Hql ->update语句的用法
虽然<em>hibernate</em>提供了许多方法对数据库进行更新,但是这的确不能满足开发需要。现在讲解一下用<em>hql</em>语句对数据进行更新。 不<em>使用</em>参数绑定格式String <em>hql</em>="<em>update</em> User u set u.userName=123 where u.userId=2"; 介绍5种参数绑定,和为什么要<em>使用</em>参数绑定,好处在哪里。 一.query.setParameter(属性名,真实值,类型)
hibernate中执行hql语句,只查询部分字段得到的结果集也只有那一部分字段的属性
如何在<em>hibernate</em>中执行<em>hql</em>语句,只查询部分字段得到的结果集也只有那一部分字段的属性,我试过select new Game(autoid,name,pinyin,initial,appkey,type) from Game 并且在对应的实体当中也创建了构造方法,DEBUG进去也确实是执行了 ``` public Game(Integer autoid, String name, String pinyin, String initial, String appkey, String type) { this.autoid = autoid; this.name = name; this.pinyin = pinyin; this.initial = initial; this.appkey = appkey; this.type = type; } ``` 但是我最后的结果集,还是把其他那一堆的字段全带上了,只不过没赋值而已,怎样才能让他得到的结果集里没有别的乱七八糟的属性,只有我想要的字段的?
hql语句的增删改查如何书写
![图片说明](https://img-ask.csdn.net/upload/201804/01/1522584950_382218.png)
HQL语句三张关联查询
<em>hql</em>语句的三<em>表</em><em>关联</em>查询怎么写,我要查部门<em>表</em>(TPart)的信息,部门<em>表</em>里有分公司 (TFgs)的外键name和总公司(TZgs)的外键zid,根据这两个外键条件查询
Struts Hibernate Spring 后台数据查询
Struts Hibernate Spring 后台数据查询 本文源自:http://blog.csdn.net/tannongchun/article/details/11034047 ,感谢作者的分享 自定义查询PropertyFilter与QBC 1、页面参数传递规则 参数规则:前缀+&quot;_&quot;+操作符+属性类型+&quot;_&quot;+属性名称     前缀:以&quot;filter&quot;开头    ...
hibernate hql语句
1.什么是<em>hql</em> HQL是Hibernate Query Language的缩写,提供更加丰富灵活、更为强大的查询能力;HQL更接近SQL语句查询语法。 <em>hql</em>和sql区别/异同 HQL SQL 操作的是类名/属性 操作的是<em>表</em>名/列名 语句区分大小写,关键字不区分大小写 语句不区分大小写 ?,从下标0开始计算位置(<em>hibernate</em>5之后不支持) ?,从顺序1开始计算位置 :命名参数 ...
【HIbernate学习】HIbernate保存更新操作(四)
HIbernate中有save()、persist()、saveOrUpdate()3种方法可以进行保存操作,外加SQL插入语句的执行,总共四种实现插入操作的方式。现在我们就来讲解下它们的<em>使用</em>和区别。 保存操作 save() @Test public void saveForNew() { Session session = null; try { session =...
HQL语句详解(转载)
4.3 <em>使用</em>HQL查询 Hibernate提供了异常强大的查询体系,<em>使用</em>Hibernate有多种查询方式。可以选择<em>使用</em>Hibernate的HQL查询,或者<em>使用</em>条件查询,甚至可以<em>使用</em>原生的SQL查询语句,此外还提供了一种数据过滤功能,这些都可用于筛选目标数据。下面分别介绍Hibernate的4种数据筛选方法:4.3.1 HQL查询 HQL是Hibernate Query Lang...
hql语句怎么写
有个A类,其中有属性no。然后B类把这个A类作为主键id。B类利用<em>hibernate</em>映射到xml文件。 我这样写HQL查询语句,[code="java"]String sql = "from B where B.id.no=1"[/code] 这样会报映射不到B的错误。请问这种情况下,<em>hql</em>语句怎么写?
HQL语句报错
这句话是我写的HQL查询语句: String queryString = "select a.id,a.authority.id,a.name,a.description,b.id,b.name fr
hql的基本用法
HQL(Hibernate Query Language)提供更加丰富灵活、更为强大的查询能力;HQL更接近SQL语句查询语法;[select/delete/<em>update</em>…][from…][where…][group by…][having…][order by…] 定义 Criteria查询对查询条件进行了面向对象封装,符合编程人员的思维方式,不过HQL(Hibernate Query Lan
hql是什么
<em>hql</em> 是<em>hibernate</em>查询语言  <em>hibernate</em> query language 是一种接近sql的查询语言。 完整的HQL语句如下: Select/<em>update</em>/delete…… from …… where …… group by …… having …… order by …… asc/desc 其中的<em>update</em>/delete为Hibernate3中所新添加的功能。
hql查询(查询所有)
http://blog.csdn.net/yaerfeng/article/details/6969649这一篇文章写的挺好  大家可以参考第一步导包from  实体类名称    这是查询所有调用list获得结果  存在实体类中输出结果一共是三步第一步是    创建对象  第二步      调用方法  获得结果第三步是   输出结果其实查询很简单这是别人博客上的一个人例子   现在能看懂了这些步骤...
怎么在hibernate 中执行一个update的sql语句?
我作乐一个 public void sjbmb<em>update</em>(DbXtwhSjbmb sjbm){ //DbXtwhSjbmb sjbm=new DbXtwhSjbmb(); try{ String h
常用的Hql语句
// HQL: Hibernate Query Language. // 特点: // &amp;gt;&amp;gt; 1,与SQL相似,SQL中的语法基本上都可以直接<em>使用</em>。 // &amp;gt;&amp;gt; 2,SQL查询的是<em>表</em>和<em>表</em>中的列;HQL查询的是对象与对象中的属性。 // &amp;gt;&amp;gt; 3,HQL的关键字不区分大小写,类名与属性名是区分大小写的。 // &amp;gt;&amp;gt; 4,SELECT可以省略. ...
mysql update语句更新值
UPDATE USER SET username = username+'xxx' WHERE username NOT LIKE 'admin%' ![图片说明](https://img-ask.csdn.net/upload/201906/05/1559714675_870111.png) 请问为什么这句sql不能够正常执行呢,如何做到让username不是admin的用户,后面加一个x呢?
Hql语句和Sql语句的区别
1、sql 面向数据库<em>表</em>查询。2、<em>hql</em> 面向对象查询。3、<em>hql</em> : from 后面跟的 类名+类对象 where 后 用 对象的属性做条件。4、sql: from 后面跟的是<em>表</em>名             where 后 用<em>表</em>中字段做条件查询。5、在Hibernate中<em>使用</em>查询时,一般<em>使用</em>Hql查询语句。6、HQL(Hibernate Query Language),即Hibernate的查询语...
Hibernate HQL查询 插入 更新(update)实例
1、实体查询: 有关实体查询技术,其实我们在先前已经有多次涉及,比如下面的例子: String <em>hql</em>=”from User user ”; List list=session.CreateQuery(<em>hql</em>).list(); 上面的代码执行结果是,查询出User实体对象所对应的所有数据,而且将数据封装成User实体对象,并且放入List中返回。这里需要注意的是,Hibernate的实体查
Hibernate之hql使用
1、什么是<em>hql</em>? <em>hql</em> 是<em>hibernate</em>查询语言,全称Hibernate Query Language。 2. <em>hql</em>和sql区别/异同 HQL SQL 类名/属性 <em>表</em>名/列名 区分大小写,关键字不区分大小写 不区分大小写 别名 别名 ?,从下标0开始计算位置(<em>hibernate</em>5之后不支持) ?,从顺序1开始计算位置 :命名参数 ...
Hibernate的sql语句,HQL写法。你应该知道的
最近刚进入项目,好多都不太熟悉,而且公司的项目框架大部分都是SSH。由于之前接触的大部分是SSM,所以好多也需要自己去学习。 没多长时间,上面就给我安排了一个追加功能,那就是对所有信息的一个统计--求平均值、总和。他们的写法是这样的。好多都是HQL写法,对这个不是很了解。自己也都是边做边学。 Finder f = Finder.create(&quot;from ChannelTrade a &quot;); ...
HQL QBC
一、HQL查询的from子句 from是最简单的语句,也是最基本的HQL语句。from关键字后紧跟持久化类的类名。 例如: from Person  <em>表</em>明从Person持久化类中选出全部的实例 推荐为Person持久化类的每个实例起别名,例如: from Person as p p作为Person的实例的别名,因此也应该遵守Java的命名规则:第一个单词的首字母
SQL语句改成HQL语句
select * from QuestionInfo where sort = '外科' 这个SQL语句再查询编辑器中运行都没有<em>问题</em> 将其改为HQL<em>使用</em>再<em>hibernate</em>中 运行且输出 list里就没有任何值 from QuestionInfo as qinfo where qinfo.sort = '外科' 这到底是怎么回事
Hibernate3学习笔记(4)——Hibernate查询技术之HQL语句
1、session中的get( )和load( )方法来查询对象。但其查询功能有限。 private void testGet(){ //1.初始化,读取配置文件<em>hibernate</em>.cfg.xml Configuration config=new Configuration().configure(); //2.读取并解析映射文件(Users.hbm.
hibernate hql 大全
Hibernate配备了一种非常强大的查询语言,这种语言看上去很像SQL。但是不要被语法结构 上的相似所迷惑,HQL是非常有意识的被设计为完全面向对象的查询,它可以理解如继承、多态 和<em>关联</em>之类的概念。  第 15 章 HQL: Hibernate查询语言Hibernate配备了一种非常强大的查询语言,这种语言看上去很像SQL。但是不要被语法结构 上的相似所迷惑,HQL是非常有意识的被设计为
HQL
规则<em>表</em>内容查询 select t.name as "规则<em>表</em>名",v.bind1 as "仓库",d.creator as "创建人",d.reference1 as "查找参考项",d.value1 as "值参考项" from thorn_rule_table_detail d inner join thorn_version v on v.id = d.version_id ...
hql 学习
1.什么是<em>hql</em>       HQL是   Hibernate Query Language  的缩写, 是适用于  <em>hibernate</em> 的 查询语句   2. <em>hql</em>和sql区别/异同    HQL                                                                                                ...
Hibernate的Hql语句使用in关键字
Hibernate的Hql语句<em>使用</em>in关键字
HQL语句--where(限制)
where子句:逻辑<em>表</em>达式。用来设置查询的条件来限制返回的查询结果。比较运算:将持久化类的属性与给定的查询条件来进行比较。 比较运算符: =、<>、、>=、<>)进行判断。x=null -> x is null; x<>null -> x is not null @Test public void test
hibernate HQL语句
HQL语句的几种处理情况 建立持久化类 public class Book { private Integer book_id; private String book_name; private Set&amp;lt;Category&amp;gt; categories = new HashSet&amp;lt;&amp;gt;(); public Book() { } public Intege...
Hibernate 执行HQL如何删除从的数据
我现在想用HQL,根据主<em>表</em>PK删除从<em>表</em>数据,如何去做, 因为<em>关联</em>的关系,在从<em>表</em>就没有<em>关联</em>字段,而是一个主<em>表</em>的对象。。 主<em>表</em>:KrSysRole(对象) // Fields private String
Hibernate 互相关联,注解实现以及两的更新
与article bean对应的<em>表</em>tbl_article 与category bean对应的<em>表</em>tbl_category Article bean/** * 信息类 */ @Entity @Table(name="tbl_article") public class Article { private Long id; //标题 private String titl
hql语句大全
此文档包含所有Hibernate里面能够用的HQL语句,让你正确掌握HQL与sql语句的异同!
hibernate hql查询语句
实体类一: public class User{ private Interger id; private String name; private Group group; /* get and s
求教一个hibernate 关联更新的问题
<em>问题</em>描述如下: 数据库中订单是一张<em>表</em>,字段有 订单号(主键),客户ID,客户名称,金额等等,然后客户是一张<em>表</em>,字段有客户ID(主键),客户名称,客户地址等等 2张<em>表</em>在数据库中无任何<em>关联</em>设置,在hibe
求教hql的left join结合条件的写法
对象A 对应 <em>表</em>A, 对象B 对应 <em>表</em>B, 其中对象A中设置属性@ManyToOne <em>关联</em>了对象B 但并不是所有A<em>表</em>数据都必然对应一个B<em>表</em>数据,即A<em>表</em>数据>=B<em>表</em>数据 现在想统计如下sql写法的数据:
hql语句:按年分组查询怎么写????
想把两个<em>表</em>的数据按年分组查询出来,然后在放在一个jsonList中。 如:2015: a<em>表</em>的1 b<em>表</em>的4 a<em>表</em>的3 b<em>表</em>的1 2014: a<em>表</em>的1 b<em>表</em>的4 a<em>表</em>的3 b<em>表</em>的1
hql update多条件更新。
2个<em>表</em>有1个相同字段做<em>关联</em>。
hibernate查询,如何写hql语句
有<em>表</em> hwk(hwk_id,hwk_name,hwk_dis,course_id) 学生<em>表</em> student(student_id,student_no,student_pwd,student_name
hibernate更新关联时,子并没有更新而是又insert两条记录
<!DOCTYPE <em>hibernate</em>-mapping PUBLIC "-//Hibernate/Hibernate M
HibernateCRUD基础框架(2)-HQL语句构造器(HqlQueryBuilder,HqlUpdateBuilder)
上篇讲述了最基本的实体类,本篇接着讲述HQL语句构造器,包括查询和更新等。 优点:通过面向对象的方式构造HQL语句,更快捷,不需要手动拼接HQL。 缺点:封装可能降低性能,只能支持常用的和较为简单的HQL构造。 部分功能不完善,待开发。 1.HQL语句构造器 package cn.fansunion.<em>hibernate</em>.sql; import org.apache.commons...
hibernate update方法无效(急)
我的<em>update</em>方法无效 后台输出 Hibernate: <em>update</em> Qs_Score set exendt=?, exmstate=?, extime=?, qsdate=?, scmeetw=?
[请教]HQL占位符?的问题
测试的时候出现的异常: org.<em>hibernate</em>.QueryParameterException: Position beyond number of declared ordinal parame
关于Hibernate 中出现 XXXX is not mapped 问题
网上都说是<em>hibernate</em>里针对实体类查询,比如user<em>表</em>,实体类为User,则<em>hql</em>语句应该是“from User u where u.uid=?”这样,大多错误都是因为User写成了<em>表</em>名user。 我已经仔细检查了许多遍,我的情况不是这个。 <em>hql</em>语句已经修改好,但仍然报Category is not mapped 下面贴一下代码,求大神指点一下。 Category实体类: ``` package com.models; public class Category { private String cid; private String cname; public String getCid() { return cid; } public void setCid(String cid) { this.cid = cid; } public String getCname() { return cname; } public void setCname(String cname) { this.cname = cname; } } ``` 映射文件: ``` <!DOCTYPE <em>hibernate</em>-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://<em>hibernate</em>.sourceforge.net/<em>hibernate</em>-mapping-3.0.dtd"> ``` <em>hibernate</em>配置文件: ``` <!DOCTYPE <em>hibernate</em>-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.<em>hibernate</em>.org/dtd/<em>hibernate</em>-configuration-3.0.dtd"> org.gjt.mm.mysql.Driver 123456 jdbc:mysql:///bookstore root org.<em>hibernate</em>.dialect.MySQL5InnoDBDialect true ``` CategoryDao方法: ``` ······ public Category findById(String cid) throws Exception { // TODO Auto-generated method stub QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource()); String <em>hql</em> = "from Category where cid = ?"; BaseDaoImpl bdi=new BaseDaoImpl(); String[] param= {cid}; return bdi.findOne(<em>hql</em>, param); } ············ ``` 报错信息: Message org.<em>hibernate</em>.<em>hql</em>.internal.ast.QuerySyntaxException: Category is not mapped [from Category where cid = ?] Description The server encountered an unexpected condition that prevented it from fulfilling the request. Exception java.lang.IllegalArgumentException: org.<em>hibernate</em>.<em>hql</em>.internal.ast.QuerySyntaxException: Category is not mapped [from Category where cid = ?] org.<em>hibernate</em>.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138) org.<em>hibernate</em>.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) org.<em>hibernate</em>.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) org.<em>hibernate</em>.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:713) org.<em>hibernate</em>.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23) com.dao.impl.BaseDaoImpl.findOne(BaseDaoImpl.java:128) com.dao.impl.CategoryDaoImpl.findById(CategoryDaoImpl.java:44) com.actions.AdminCategoryAction.findById(AdminCategoryAction.java:81) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:897) ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1299) ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68) com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:117) com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:108) ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1375) ognl.ASTMethod.getValueBody(ASTMethod.java:91) ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) ognl.SimpleNode.getValue(SimpleNode.java:258) ognl.Ognl.getValue(Ognl.java:470) ognl.Ognl.getValue(Ognl.java:434) com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:398) com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:450) com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:396) com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:430) com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:290) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:251) org.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:168) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265) org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:76) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.DateTextFieldInterceptor.intercept(DateTextFieldInterceptor.java:125) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:253) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:140) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:575) org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:81) org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99) Root Cause org.<em>hibernate</em>.<em>hql</em>.internal.ast.QuerySyntaxException: Category is not mapped [from Category where cid = ?] org.<em>hibernate</em>.<em>hql</em>.internal.ast.QuerySyntaxException.generateQueryException(QuerySyntaxException.java:79) org.<em>hibernate</em>.QueryException.wrapWithQueryString(QueryException.java:103) org.<em>hibernate</em>.<em>hql</em>.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:219) org.<em>hibernate</em>.<em>hql</em>.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:143) org.<em>hibernate</em>.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:119) org.<em>hibernate</em>.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:80) org.<em>hibernate</em>.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153) org.<em>hibernate</em>.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:595) org.<em>hibernate</em>.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:704) org.<em>hibernate</em>.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23) com.dao.impl.BaseDaoImpl.findOne(BaseDaoImpl.java:128) com.dao.impl.CategoryDaoImpl.findById(CategoryDaoImpl.java:44) com.actions.AdminCategoryAction.findById(AdminCategoryAction.java:81) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:897) ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1299) ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68) com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:117) com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:108) ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1375) ognl.ASTMethod.getValueBody(ASTMethod.java:91) ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) ognl.SimpleNode.getValue(SimpleNode.java:258) ognl.Ognl.getValue(Ognl.java:470) ognl.Ognl.getValue(Ognl.java:434) com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:398) com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:450) com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:396) com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:430) com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:290) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:251) org.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:168) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265) org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:76) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.DateTextFieldInterceptor.intercept(DateTextFieldInterceptor.java:125) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:253) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:140) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:575) org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:81) org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99) Root Cause org.<em>hibernate</em>.<em>hql</em>.internal.ast.QuerySyntaxException: Category is not mapped org.<em>hibernate</em>.<em>hql</em>.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:169) org.<em>hibernate</em>.<em>hql</em>.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:91) org.<em>hibernate</em>.<em>hql</em>.internal.ast.tree.FromClause.addFromElement(FromClause.java:79) org.<em>hibernate</em>.<em>hql</em>.internal.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:331) org.<em>hibernate</em>.<em>hql</em>.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3695) org.<em>hibernate</em>.<em>hql</em>.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3584) org.<em>hibernate</em>.<em>hql</em>.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:720) org.<em>hibernate</em>.<em>hql</em>.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:576) org.<em>hibernate</em>.<em>hql</em>.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:313) org.<em>hibernate</em>.<em>hql</em>.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:261) org.<em>hibernate</em>.<em>hql</em>.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:271) org.<em>hibernate</em>.<em>hql</em>.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:191) org.<em>hibernate</em>.<em>hql</em>.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:143) org.<em>hibernate</em>.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:119) org.<em>hibernate</em>.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:80) org.<em>hibernate</em>.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153) org.<em>hibernate</em>.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:595) org.<em>hibernate</em>.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:704) org.<em>hibernate</em>.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23) com.dao.impl.BaseDaoImpl.findOne(BaseDaoImpl.java:128) com.dao.impl.CategoryDaoImpl.findById(CategoryDaoImpl.java:44) com.actions.AdminCategoryAction.findById(AdminCategoryAction.java:81) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:897) ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1299) ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68) com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:117) com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:108) ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1375) ognl.ASTMethod.getValueBody(ASTMethod.java:91) ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) ognl.SimpleNode.getValue(SimpleNode.java:258) ognl.Ognl.getValue(Ognl.java:470) ognl.Ognl.getValue(Ognl.java:434) com.opensymphony.xwork2.ognl.OgnlUtil$3.execute(OgnlUtil.java:398) com.opensymphony.xwork2.ognl.OgnlUtil.compileAndExecuteMethod(OgnlUtil.java:450) com.opensymphony.xwork2.ognl.OgnlUtil.callMethod(OgnlUtil.java:396) com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:430) com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:290) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:251) org.apache.struts2.interceptor.DeprecationInterceptor.intercept(DeprecationInterceptor.java:41) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:168) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265) org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:76) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.DateTextFieldInterceptor.intercept(DateTextFieldInterceptor.java:125) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:253) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:140) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245) org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:575) org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:81) org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99) Note The full stack trace of the root cause is available in the server logs.
hibernate hql 大全
http://blog.chinaunix.net/article.php?articleId=47942&amp;amp;blogId=1655 HQL: Hibernate查询语言 Hibernate配备了一种非常强大的查询语言,这种语言看上去很像SQL。但是不要被语法结构 上的相似所迷惑,HQL是非常有意识的被设计为完全面向对象的查询,它可以理解如继承、多态 和<em>关联</em>之类的...
Hibernate——三种状态下的update()方法
1.transient状态 更新transient对象会报错。 更新自己设定id的transient对象可以(数据库有对应记录) 更新后除了设定更新的字段,其他字段会重置成null
hql关联和连接查询实例
Hibernate提供了强大的查询系统,<em>使用</em>Hibernate有多种查询方法可以选择:可以<em>使用</em>Hibernate的HQL查询,也可以<em>使用</em>条件查询,甚至可以<em>使用</em>原生的SQL查询语句。其中HQL查询时Hibernate配置的功能强大的查询语句。HQL是非常有意识的被设计为完全面向对象的查询,它可以理解如继承、多态 和<em>关联</em>之类的概念。        下面我们来看一下
MySQL 百万级分页优化
一般刚开始学SQL的时候,会这样写 SELECT * FROM table ORDER BY id LIMIT 1000, 10; 但在数据达到百万级的时候,这样写会慢死 SELECT * FROM table ORDER BY id LIMIT 1000000, 10; 也许耗费几十秒 网上很多优化的方法是这样的 SELECT * FROM
postgres 中limit 和offset 关键字的使用
1. select * from user limit  param1 ;    limit + 参数    要获取的数据条数 (从第一条数据开始)2 .select * from user limit param1  offset param2 ;  从(param2+1)条数据开始,取 param1条数据...
hibernate中HQL查询语句
参考https://www.oschina.net/code/snippet_1051545_36896 我的查询示例 参考我的项目示例: // 根据HQl语句查询 @Override public List findByHQL(String <em>hql</em>) { List list = new ArrayList<>();
HQL和SQL的区别
Hive和数据库的比较 由于 Hive 采用了 SQL 的查询语言 HQL,因此很容易将 Hive 理解为数据库。其实从结构上来看,Hive 和数据库除了拥有类似的查询语言,再无类似之处。本文将从多个方面来阐述 Hive 和数据库的差异。数据库可以用在 Online 的应用中,但是Hive 是为数据仓库而设计的,清楚这一点,有助于从应用角度理解 Hive 的特性。 查询语言 由于SQL被广泛...
HQL之关联查询---left join
HQL的<em>关联</em>查询Left Join 写法
Hibernate中使用HQL语句删除数据
http://justdo2008.iteye.com/blog/426272 在Hibernate 3中,增加了HQL删除语句,格式如下: Delete FROM <em>表</em>名 Where 列名=? 实例: <em>hibernate</em>.cfg.xml:Hibernate环境配置文件   Xml代码   xml version='1.0' enco
hql关联、map/list查询
介绍下关于HQL中的<em>关联</em><em>表</em>查询的用法吧,这个算是我自己摸索尝试出来的,也许不是最优化的,但还是可以和大家分享探讨下   之前由于对<em>hql</em>的了解不深,后来要<em>使用</em><em>关联</em><em>表</em>查询的时候,就特意查询了一些资料,其中http://www.cnblogs.com/gmh/archive/2008/03/22/1117910.html这篇文章让我受益匪浅,深受启发   这次主要是要<em>使用</em><em>关联</em><em>表</em>查询,项目中是使
HQL中两次 left join 后传值的问题
<em>使用</em>Hibernate sql 语句 两次 left join 后 持久化类竟然只能收到 前两次 left join <em>表</em>的数据; 话不多说贴出代码: public class ReportInfo i
SQL和HQL之间的区别
SQL和HQL之间的区别     SQL与HQL 结构化查询语言,通常也称为SQL,是一种<em>使用</em>关系数据库管理概念来管理数据的数据库语言。管理数据包括select(从单个或多个<em>表</em>中检索数据),insert(在<em>表</em>中添加一行或多行),<em>update</em>(负责更改<em>表</em>中一行或多行的值),delete(负责删除<em>表</em>中的一行或多行)和通过查询创建模式。 HQL或Hibernate查询语言将面向对象编程的概念扩...
hibernatehql如果要有多个order by 如何处理呢
比如说 按照createdate排序并且按照 用户id来排序 应该怎么写呢。。
hibernate的分页真的通用吗?我这种情况怎么分页?
public List queryImportedScore( int offset,int length,List idList){ List score
postgreSQL数据库limit分页、排序
postgreSQL数据库limit分页、排序 语法: select * from persons limit  A  offset  B; 解释: A就是你需要多少行; B就是查询的起点位置。 示例: select * from persons limit 5 offset 0 ; 意思是,起点0开始查询,返
hql查询 (条件查询)
先看一个例子   如果看不懂   ‘看不懂where是怎么回事写程序  其实挺简单  就是  想办法  把需求转换成sql语句   得到结果就行 写代码不难条件查询  ?号是  占位符  需要往里面设置值setparameter(,)里面有两个参数   代<em>表</em>的含义要明白 模糊查询...
hibernate多个关联同一问题
<em>hibernate</em>里面如果我有一张<em>表</em>(操作人<em>表</em>User),另外有几十张<em>表</em><em>关联</em>它,难道我要在user里面写几十个@OneToMany吗?,如果只用单向的多对一<em>关联</em>,怎么级联删除或者删除时外键置空呢?
Hibernate多查询
public PageModel getPage(int currentPage, int pageSize) { String <em>hql</em> = "from Orders,Users,Orderstate where Orders.clientid = Users.userid and Orders.progress = Orderstate.stateid"; String count = "select count(*) from Orders"; PageModel pageModel = this.getPage(<em>hql</em>, count, currentPage, pageSize); return pageModel; } 项目中<em>使用</em>的是<em>hibernate</em>框架,要进行多<em>表</em>查询,在DAO类方法中是这么写的,但是运行项目出现了错误,怎么解决,这个语句在数据库中可以执行,<em>hibernate</em>中会报错 Struts Problem Report Struts has detected an unhandled exception: Messages: Invalid path: 'null.clientid' [from com.scan918.printerordersystem.model.Orders,com.scan918.printerordersystem.model.Users,com.scan918.printerordersystem.model.Orderstate where Orders.clientid = Users.userid and Orders.progress = Orderstate.stateid] Invalid path: 'null.clientid' [from com.scan918.printerordersystem.model.Orders,com.scan918.printerordersystem.model.Users,com.scan918.printerordersystem.model.Orderstate where Orders.clientid = Users.userid and Orders.progress = Orderstate.stateid]; nested exception is org.<em>hibernate</em>.<em>hql</em>.ast.QuerySyntaxException: Invalid path: 'null.clientid' [from com.scan918.printerordersystem.model.Orders,com.scan918.printerordersystem.model.Users,com.scan918.printerordersystem.model.Orderstate where Orders.clientid = Users.userid and Orders.progress = Orderstate.stateid] File: org/<em>hibernate</em>/<em>hql</em>/ast/QuerySyntaxException.java Line number: 54 Stacktraces org.springframework.orm.<em>hibernate</em>3.HibernateQueryException: Invalid path: 'null.clientid' [from com.scan918.printerordersystem.model.Orders,com.scan918.printerordersystem.model.Users,com.scan918.printerordersystem.model.Orderstate where Orders.clientid = Users.userid and Orders.progress = Orderstate.stateid]; nested exception is org.<em>hibernate</em>.<em>hql</em>.ast.QuerySyntaxException: Invalid path: 'null.clientid' [from com.scan918.printerordersystem.model.Orders,com.scan918.printerordersystem.model.Users,com.scan918.printerordersystem.model.Orderstate where Orders.clientid = Users.userid and Orders.progress = Orderstate.stateid] org.springframework.orm.<em>hibernate</em>3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:657) org.springframework.orm.<em>hibernate</em>3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) org.springframework.orm.<em>hibernate</em>3.HibernateTemplate.doExecute(HibernateTemplate.java:424) org.springframework.orm.<em>hibernate</em>3.HibernateTemplate.executeFind(HibernateTemplate.java:343) com.scan918.printerordersystem.dao.impl.BaseDAO.pageQuery(BaseDAO.java:301) com.scan918.printerordersystem.dao.impl.BaseDAO.getPage(BaseDAO.java:323) com.scan918.printerordersystem.dao.impl.OrdersDAOImpl.getPage(OrdersDAOImpl.java:21) com.scan918.printerordersystem.service.impl.OrderServiceImpl.getPage(OrderServiceImpl.java:26) com.scan918.printerordersystem.action.admin.AOrderAction.getPage(AOrderAction.java:63) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:601) com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441) com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243) com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252) org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488) org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77) org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) java.lang.Thread.run(Thread.java:722) org.<em>hibernate</em>.<em>hql</em>.ast.QuerySyntaxException: Invalid path: 'null.clientid' [from com.scan918.printerordersystem.model.Orders,com.scan918.printerordersystem.model.Users,com.scan918.printerordersystem.model.Orderstate where Orders.clientid = Users.userid and Orders.progress = Orderstate.stateid] org.<em>hibernate</em>.<em>hql</em>.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54) org.<em>hibernate</em>.<em>hql</em>.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47) org.<em>hibernate</em>.<em>hql</em>.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82) org.<em>hibernate</em>.<em>hql</em>.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261) org.<em>hibernate</em>.<em>hql</em>.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185) org.<em>hibernate</em>.<em>hql</em>.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) org.<em>hibernate</em>.engine.query.HQLQueryPlan.(HQLQueryPlan.java:101) org.<em>hibernate</em>.engine.query.HQLQueryPlan.(HQLQueryPlan.java:80) org.<em>hibernate</em>.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94) org.<em>hibernate</em>.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156) org.<em>hibernate</em>.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135) org.<em>hibernate</em>.impl.SessionImpl.createQuery(SessionImpl.java:1651) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:601) org.springframework.orm.<em>hibernate</em>3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1293) $Proxy12.createQuery(Unknown Source) com.scan918.printerordersystem.dao.impl.BaseDAO$6.doInHibernate(BaseDAO.java:306) org.springframework.orm.<em>hibernate</em>3.HibernateTemplate.doExecute(HibernateTemplate.java:419) org.springframework.orm.<em>hibernate</em>3.HibernateTemplate.executeFind(HibernateTemplate.java:343) com.scan918.printerordersystem.dao.impl.BaseDAO.pageQuery(BaseDAO.java:301) com.scan918.printerordersystem.dao.impl.BaseDAO.getPage(BaseDAO.java:323) com.scan918.printerordersystem.dao.impl.OrdersDAOImpl.getPage(OrdersDAOImpl.java:21) com.scan918.printerordersystem.service.impl.OrderServiceImpl.getPage(OrderServiceImpl.java:26) com.scan918.printerordersystem.action.admin.AOrderAction.getPage(AOrderAction.java:63) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:601) com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441) com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243) com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252) org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488) org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77) org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) java.lang.Thread.run(Thread.java:722) You are seeing this page because development mode is enabled. Development mode, or devMode, enables extra debugging behaviors and reports to assist developers. To disable this mode, set: struts.devMode=false in your WEB-INF/classes/struts.properties file.  
left jion on(多个条件)
<em>问题</em>:如果有A<em>表</em>和B<em>表</em>,A<em>表</em>有a1,a2,a3....an字段,B<em>表</em>有b1,b2,b3....bn字段,想查出同时满足条件a1=b1,a2=b2,a3=b3这三个条件的所内容? 谢谢
Hibernate的hql查询
1. 什么是HQL?               HQL是Hibernate Query Language即Hibernate查询语言            [select/<em>update</em>/delete……] from Entity [where……] [group by……] [having……] [order by……] 2. 为什么<em>使用</em>HQL        不需要再编写繁复的SQL
hibernatehql多个查询条件如何快捷的拼接
比如说有个检索,可能要检索A,B,C,D,E五个属性,那么在<em>hql</em>中拼接的语句就应该是 from table where A=? and b=? and C=? and D=? and E=?这样子,但是现实情况是比较复杂的,如果手动去拼接这个字符串比较复杂,什么时候加where就是个<em>问题</em>了,更何况有的属性查询有的不查询,求各位大神有什么现成的解决方案吗?或者我自己写代码的话是什么思路呢?
常用的hql语句用法解析
解析内容清晰简单,让你对<em>hql</em>语句半天就可以掌握!!
SQLSERVER语句多关联查询超级慢,求优化方案!
``` SELECT distinct top 10 t0_1.FNAME as 产品型号, t0_3.FNAME as 晶片型号, isnull(t3.FREALQTY,0) as 销售数量, is
hql语句左连接查询报错 Path expected for join!
String <em>hql</em>=" select new Map(o.id as id,o.regno as regno,o.uniscid as uniscid , o.entname as entname,o.lerep as lerep ,o.estdate as estdate,o.dom as dom, o.tel as tel , o.datasource as datasource ,d.nr as djjg ) from DataQyfrEntity o LEFT JOIN ABmDjjgEntity d with (d.bm=o.djjg) "; ![图片说明](https://img-ask.csdn.net/upload/201703/21/1490059131_714652.png) ``` ```
Hibernate中HQL语句的left join的例子详解
1.com.jcuckoo.entity添加ShowBook类,用来封装界面显示的数据 public class ShowBook { @Id private int id; private String name; private String author; private String publisher; private double price; private Stri
Hibernate的left join fetch 查询条件问题
当A left join fecth B的时候,怎么对B的条件进行进一步的筛选? eg: <em>表</em>VoteGroup:投票组的信息 id, name <em>表</em>VoteStatus:用户对该组的投票的状态 id,
相见恨晚的超实用网站
相见恨晚的超实用网站 持续更新中。。。
经典的mfc教程下载
经典的mfc教程 文档类里面一章章包含了大量的知识 对初学者有很大的帮助 相关下载链接:[url=//download.csdn.net/download/lhxstrive/4816724?utm_source=bbsseo]//download.csdn.net/download/lhxstrive/4816724?utm_source=bbsseo[/url]
Proteus在MCS-51&ARM7系统中的应用百例下载
这个是那书的光盘资料,很不错的 哪位高手有那本书的PDF 联系我呀 <br>qiu_1123@163.com 谢谢哈 另外一半: http://download.csdn.net/source/331569 相关下载链接:[url=//download.csdn.net/download/qiu1123/331570?utm_source=bbsseo]//download.csdn.net/download/qiu1123/331570?utm_source=bbsseo[/url]
进程/作业调度:优先权调度算法下载
合肥工业大学课程设计 进程/作业调度:优先权调度算法。(1人)中级 1建立作业的数据结构描述; 2使用两种方式产生作业:(a)自动产生, (b)手工输入; 3在屏幕上显示每个作业的执行情况; 时间的流逝可用下面几种方法模拟:(a)按键盘,每按一次可认为过一个时间单位; (b) 响应WM_TIMER; 4计算并显示一批作业的周转时间、平均周转时间、带权周转时间、平均带权周转时间。 5将一批作业的执行情况存入磁盘文件,以后可以读出并重放 相关下载链接:[url=//download.csdn.net/download/hoogee/1442488?utm_source=bbsseo]//download.csdn.net/download/hoogee/1442488?utm_source=bbsseo[/url]
相关热词 c#委托 逆变与协变 c#新建一个项目 c#获取dll文件路径 c#子窗体调用主窗体事件 c# 拷贝目录 c# 调用cef 网页填表c#源代码 c#部署端口监听项目、 c#接口中的属性使用方法 c# 昨天
我们是很有底线的