hibernate 问题 org.hibernate.MappingException: No Dialect mapping for JDBC type: 3 我用的是sqlserver 2008 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 hibernate.cfg.xml中没有指定方言,你看看是不是 恩我也觉得你没有在hibernate中指定sql方言 但是我其他的模块能够运行 啊?我也没有用到映射文件啊?全都是sql语句 public List findProjectVariation(String[] str) { String sql = " select tbp.FName_l2 AS 员工名称,toa.FName_l2 as 业绩归属部门,torgp.FName_L2 as 职务, " + "ccbcp.CFBusinessType as 费用类别 ,ccbcpe.CFCostSubject as 科目名称,ccbcp.CFTotalPay as 金额 , " + "ckbu.FName_l2 AS 业务名称,cccd.CFMount as 业务合同金额 ,ccgp.CFGetMount as 业务收入金额 ," + "ccbcp.CFPayUnitID as 费用承担分所,ccaa.CFAdminOrgUnitID AS 费用承担部门 " + "from CT_COS_BusinessCostPay as ccbcp left join T_BD_Person as tbp " + "on ccbcp.CFCostPersonID=tbp.fid left join t_org_admin as toa " + "on toa.FID = ccbcp.CFPayUnitID left join CT_COS_BusinessCostPayEntry as ccbcpe " + "on ccbcp.FID=ccbcpe.FParentID left join CT_KW_BusinessUnit as ckbu " + "on ccbcp.CFBusinessNameID=ckbu.FID left join CT_KW_ProjectCard as ckpc " + "on ckpc.CFUnitID=ckbu.FID left join CT_CTA_ContractD as cccd " + "on ckpc.FID=cccd.CFProjectCardID left join CT_CTA_ContractDGetMount as cccdgm " + "on cccdgm.FParentID=cccd.FID left join CT_CTA_GetPay as ccgp " + "on cccdgm.CFEntryGetID=ccgp.FID left join T_ORG_Position as torgp " + "on torgp.FID=ckpc.CFMainlawyerPosID left join CT_COS_BusinessCPPAOU as ccaa " + "on ccaa.CFAdminOrgUnitID=toa.FID where 1=1 "; return Query(GetSql(str, sql)); } /** * 提取sql语句方法 描述 * * @param sql * @return * @author hjy 2011-5-18 下午04:31:55 */ public List Query(String sql) { Session session = null; List list = new ArrayList(); try { session = this.getSessionFactory().openSession(); SQLQuery query = session.createSQLQuery(sql); list = query.list(); } catch (Exception e) { e.printStackTrace(); } finally { session.close(); } return list; } public String GetSql(String[] str, String sql) { if (str[0] != null && str[0] != "") { sql += " and ccbcpe.CFCostSubject=" + str[0];// 科目 } if (str[1] != null && str[1] != "") { sql += " and ccbcp.CFBusinessType=" + str[1];// 费用 } if (str[2] != null && str[2] != "") { sql += " and torgp.FName_L2= " + str[2]; } if (str[3] != null && str[3] != "") { sql += " and ccbcp.FCreateTime > " + str[3]; } if (str[4] != null && str[4] != "") { sql += " and ccbcp.FCreateTime < " + str[4]; } if (str[5] != null && str[5] != "") { sql += " and ccbcp.FLastUpdateTime > " + str[5]; } if (str[6] != null && str[6] != "") { sql += " and ccbcp.FLastUpdateTime < " + str[6]; } return sql; }后台代码SQLQuery query = session.createSQLQuery(sql); list = query.list();在这两行报的错!!! org.hibernate.dialect.SQLServerDialect 这个我有啊 HttpServletRequest.getLocalAddr()问题。 发愁了一下午的问题。百度能看的都看了,还是不行,请高手。 mysql,spring+ibatis事务机制问题 请问swing 在1.6和1.5版本第区别 Exception in thread "main" java.lang.ClassFormatError错误. 初级问题请教 代码混淆指的是什么?有哪些 请教!如何在本地的客户端访问EJB的LOCAL接口? 急问高手!EJB,送分问题! 为什么ext grid加载后台数据只有一列空白列 乱码问题我咋弄都不对? apache 二级域名问题!
恩我也觉得你没有在hibernate中指定sql方言
String sql = " select tbp.FName_l2 AS 员工名称,toa.FName_l2 as 业绩归属部门,torgp.FName_L2 as 职务, "
+ "ccbcp.CFBusinessType as 费用类别 ,ccbcpe.CFCostSubject as 科目名称,ccbcp.CFTotalPay as 金额 , "
+ "ckbu.FName_l2 AS 业务名称,cccd.CFMount as 业务合同金额 ,ccgp.CFGetMount as 业务收入金额 ,"
+ "ccbcp.CFPayUnitID as 费用承担分所,ccaa.CFAdminOrgUnitID AS 费用承担部门 "
+ "from CT_COS_BusinessCostPay as ccbcp left join T_BD_Person as tbp "
+ "on ccbcp.CFCostPersonID=tbp.fid left join t_org_admin as toa "
+ "on toa.FID = ccbcp.CFPayUnitID left join CT_COS_BusinessCostPayEntry as ccbcpe "
+ "on ccbcp.FID=ccbcpe.FParentID left join CT_KW_BusinessUnit as ckbu "
+ "on ccbcp.CFBusinessNameID=ckbu.FID left join CT_KW_ProjectCard as ckpc "
+ "on ckpc.CFUnitID=ckbu.FID left join CT_CTA_ContractD as cccd "
+ "on ckpc.FID=cccd.CFProjectCardID left join CT_CTA_ContractDGetMount as cccdgm "
+ "on cccdgm.FParentID=cccd.FID left join CT_CTA_GetPay as ccgp "
+ "on cccdgm.CFEntryGetID=ccgp.FID left join T_ORG_Position as torgp "
+ "on torgp.FID=ckpc.CFMainlawyerPosID left join CT_COS_BusinessCPPAOU as ccaa "
+ "on ccaa.CFAdminOrgUnitID=toa.FID where 1=1 "; return Query(GetSql(str, sql)); } /**
* 提取sql语句方法 描述
*
* @param sql
* @return
* @author hjy 2011-5-18 下午04:31:55
*/
public List Query(String sql) {
Session session = null;
List list = new ArrayList();
try {
session = this.getSessionFactory().openSession();
SQLQuery query = session.createSQLQuery(sql);
list = query.list(); } catch (Exception e) {
e.printStackTrace();
} finally {
session.close();
}
return list;
} public String GetSql(String[] str, String sql) {
if (str[0] != null && str[0] != "") {
sql += " and ccbcpe.CFCostSubject=" + str[0];// 科目
}
if (str[1] != null && str[1] != "") {
sql += " and ccbcp.CFBusinessType=" + str[1];// 费用
}
if (str[2] != null && str[2] != "") {
sql += " and torgp.FName_L2= " + str[2];
}
if (str[3] != null && str[3] != "") {
sql += " and ccbcp.FCreateTime > " + str[3];
}
if (str[4] != null && str[4] != "") {
sql += " and ccbcp.FCreateTime < " + str[4];
}
if (str[5] != null && str[5] != "") {
sql += " and ccbcp.FLastUpdateTime > " + str[5];
}
if (str[6] != null && str[6] != "") {
sql += " and ccbcp.FLastUpdateTime < " + str[6];
}
return sql;
}后台代码SQLQuery query = session.createSQLQuery(sql);
list = query.list();在这两行报的错!!!
org.hibernate.dialect.SQLServerDialect 这个我有啊