java查询数据比Oracle少_在java中通过sql语句查询oracle表数据，报错ORA-00907: 缺失右括号...

在java中通过sql语句查询oracle表数据，报错ORA-00907: 缺失右括号0

wbufp2015.04.01浏览111次分享举报

错误信息为：

WARN[http-8080-6](JDBCExceptionReporter.java:233)- SQL Error: 907, SQLState: 42000

ERROR[http-8080-6](JDBCExceptionReporter.java:234)- ORA-00907: 缺失右括号

我的System.out.println(sql);输出语句为：

select a.khfz khfz,a.ssbz bzmc,a.gzmc gzmc,b.khcj khcj,b.px px,b.rq rq,b.id from gzkhzd_gz a,gzkh_khhz b where 1=1 and a.gzmc=b.gzmc and a.bzmc ='岗位' and a.khfz ='班组' group by khfz,ssbz,a.gzmc,khcj,px,rq,id order by khfz,bzmc,px

我的此部分JAVA代码为：

public void queryBzpx(PageResult page, Map criteriaMap) {

try {

StringBuffer sql = new StringBuffer();

sql = sql.append("select a.khfz khfz,a.ssbz bzmc,a.gzmc gzmc,b.khcj khcj,b.px px,b.rq rq,b.id from gzkhzd_gz a,gzkh_khhz b where 1=1 and a.gzmc=b.gzmc ");

sql = sql.append(" group by khfz,ssbz,a.gzmc,khcj,px,rq,id order by khfz,bzmc,px ");

System.out.println(sql);

this.baseDao.getSqlPageResult(sql, page);

} catch (Exception e) {

e.printStackTrace();

}

}