hibernate 问题

[y_0715]

org.hibernate.MappingException: No Dialect mapping for JDBC type: 3

我用的是sqlserver 2008 我其他的模块能够运行 啊？我也没有用到映射文件啊？全都是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;
}



后台代码
list = query.list();

在这两行报的错！！！

[qq14017152]

[JerryZhou_]

看到你的sql语句我 蛋定了、

[BUG胡汉三]

慢慢调试~~~先截取到你的sql 到数据库里面去运行看看！！！

[丶蒙圈丶]

[Quote=引用 4 楼 hzw2312 的回复:]

慢慢调试~~~先截取到你的sql 到数据库里面去运行看看！！！
[/Quote]

正解

[wl_ldy]

参考：http://blog.csdn.net/xiami9910/archive/2008/05/08/2414437.aspx

[guyuxuelang]

你一行一行调试吧，是数据类型对应不上。