myeclipse报java.sql.SQLSyntaxErrorException:ORA-00905:缺少关键字 求大神帮助
List<easybuyproduct> alltypesp=null;
String sql=" select * from easybuy_product p left outer join easybuy_product_category c"+
"on p.epc_id=c.epc_id where p.epc_id=(select epc_id from EASYBUY_PRODUCT_CATEGORY where epc_name=?) ";
alltypesp=jdbcTemplate.query(sql, new Object[]{str}, new RowMapper() {
@Override
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
easybuyproduct sp=new easybuyproduct();
sp.setEpid(rs.getInt(1));
sp.setEpname(rs.getString(2));
sp.setEpdescription(rs.getString(3));
sp.setEpprice(rs.getDouble(4));
sp.setEpstock(rs.getInt(5));
sp.setEpcid(rs.getInt(6));
sp.setEpcchildid(rs.getInt(7));
sp.setEpfilename(rs.getString(8));
return sp;
}
});