sqlserver没有length函数

最新推荐文章于 2024-03-14 00:05:09 发布

qq_34412985

最新推荐文章于 2024-03-14 00:05:09 发布

阅读量3.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： sqlserver 文章标签： sqlserver

本文链接：https://blog.csdn.net/qq_34412985/article/details/109279302

sqlserver 专栏收录该内容

7 篇文章

订阅专栏

本文记录了一次在数据质量检查服务中遇到的SQL错误：'length'不是已识别的内置函数名。通过调整代码将'length'更改为'sql2003标准'中的'len'来解决问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2020-10-25 21:15:44.326 ERROR com.pc.data.dataqualitycheck.async.AsyncQalityCheckService Line:244 - 'length' is not a recognized built-in function name.
java.sql.SQLException: 'length' is not a recognized built-in function name.
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
        at com.pc.data.dataqualitycheck.async.AsyncQalityCheckService.insertProblem(AsyncQalityCheckService.java:478)
        at com.pc.data.dataqualitycheck.async.AsyncQalityCheckService.performCheckRules(AsyncQalityCheckService.java:241)
        at com.pc.data.dataqualitycheck.async.AsyncQalityCheckService.executeQalityCheckAsync(AsyncQalityCheckService.java:101)
        at com.pc.data.dataqualitycheck.async.AsyncQalityCheckService$$FastClassBySpringCGLIB$$7e349c9.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)