九月 10, 2019 10:18:06 上午 org.apache.catalina.core.ApplicationContext log
信息: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the varchar value '通用版' to data type int.
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into [AIS20170720092224].[dbo].qc_report(poInterId,poEntryId,operatorId,report_audit_status,report_verifier,report_verifierDate,reprotId,FVersion) select a.FInterID,FEntryID,NULL,?,?, getdate(), ? , ? from [AIS20170720092224].[dbo].POInStock a inner join [AIS20170720092224].[dbo].t_Supplier b on a.FSupplyID=b.FItemID inner join [AIS20170720092224].[dbo].POInStockEntry c on a.FInterID=c.FInterID inner join [AIS20170720092224].[dbo].t_ICItem d on c.FItemID=d.FItemID where b.FName=? and d.FNumber=? and FDate=? and FEntrySelfP0385=? and ((a.FBillNo like '%DD000017%' and c.FEntryID = 1))
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the varchar value '通用版' to data type int.
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the varchar value '通用版' to data type int.
已解决
最后发现是数据库的表名对不上。