问题描述
大家好，
我是SQL编程的新手，在现场网站中遇到并发布。
我在日志文件中有以下SQL错误。
本地异常堆栈：
异常[EclipseLink-4002]（ Eclipse Persistence Services - 2.4.2.v20130514-5956486）：org.eclipse.persistence.exceptions.DatabaseException
内部异常：com.microsoft.sqlserver.jdbc.SQLServerException：转换nvarchar值时转换失败'2686000.75'到数据类型int。
错误代码：245
调用：SELECT t0.DFY004_MDL_D，MAX（CAST（t1.DFY006_ATTR_VAL_X AS int）），MIN（CAST （t1.DFY006_ATTR_VAL_X AS int））FROM VDFY006_DERTV_ATTR t1 LEFT OUTER JOIN VDFY003_DERTV t0 ON（t1.DFY003_DERTV_D = t0.DFY003_DERTV_D）WHERE（（（（（t0.DFY004_MDL_D IN（？，？，？，？，？））AND（ t1.DFY005_ATTR_D =？））AND（t1.DFY006_ATTR_VAL_X IS NOT NULL））AND（t1.DFY006_IS_DEL_F =？））AND（t0.DFY014_STAT_D =？））GROUP BY t0.DFY004_MDL_D
bind => [8个参数绑定]
查询：ReportQuery（referenceClass = DerivativeAttribute sql =SELECT t0.DFY004_MDL_D，MAX（CAST（t1.DFY006_ATTR_VAL_X AS int）），MIN（CAST（t1.DFY006_ATTR_VAL_X AS int）） ）FROM VDFY006_DERTV_ATTR t1 LEFT OUTER JOIN VDFY003_DERTV t0 ON（t1.DFY003_DERTV_D = t0.DFY003_DERTV_D）WHERE（（（（（t0.DFY004_MDL_D IN？）AND（t1.DFY005_ATTR_D =？））AND（t1.DFY006_ATTR_VAL_X IS NOT NULL）） AND（t1.DFY006_IS_DEL_F =？））AND（t0.DFY014_STAT_D =？））GROUP BY t0.DFY004_MDL_D）
需要帮助才能理解问题和步骤解决这个问题。
我尝试了什么：
[]
[]
Hi All,
I am newbie to SQL programming and encountering and issue in one of live site.
I have the following SQL error in the log file.
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the nvarchar value '2686000.75' to data type int.
Error Code: 245
Call: SELECT t0.DFY004_MDL_D, MAX(CAST(t1.DFY006_ATTR_VAL_X AS int)), MIN(CAST(t1.DFY006_ATTR_VAL_X AS int)) FROM VDFY006_DERTV_ATTR t1 LEFT OUTER JOIN VDFY003_DERTV t0 ON (t1.DFY003_DERTV_D = t0.DFY003_DERTV_D) WHERE (((((t0.DFY004_MDL_D IN (?,?,?,?,?)) AND (t1.DFY005_ATTR_D = ?)) AND (t1.DFY006_ATTR_VAL_X IS NOT NULL)) AND (t1.DFY006_IS_DEL_F = ?)) AND (t0.DFY014_STAT_D = ?)) GROUP BY t0.DFY004_MDL_D
bind => [8 parameters bound]
Query: ReportQuery(referenceClass=DerivativeAttribute sql="SELECT t0.DFY004_MDL_D, MAX(CAST(t1.DFY006_ATTR_VAL_X AS int)), MIN(CAST(t1.DFY006_ATTR_VAL_X AS int)) FROM VDFY006_DERTV_ATTR t1 LEFT OUTER JOIN VDFY003_DERTV t0 ON (t1.DFY003_DERTV_D = t0.DFY003_DERTV_D) WHERE (((((t0.DFY004_MDL_D IN ?) AND (t1.DFY005_ATTR_D = ?)) AND (t1.DFY006_ATTR_VAL_X IS NOT NULL)) AND (t1.DFY006_IS_DEL_F = ?)) AND (t0.DFY014_STAT_D = ?)) GROUP BY t0.DFY004_MDL_D")
Need help to understand the issue and steps to resolve this.
What I have tried:
SQL Server Helper[^]
[^]
推荐答案
这篇关于日志文件中的SQL错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！