NutzCN Logo
问答 MySQL数据库方言问题
发布于 2690天前 作者 cafebabe 2086 次浏览 复制 上一个帖子 下一个帖子
标签:

生产环境下,出现以下报错。但是数据明明是MySQL 这里感觉识别成Oracle了?(没法给出其他日志信息了)

!Nutz SQL Error: 'SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM account WHERE name=?) T) AS A WHERE ROWNUM BETWEEN 1 AND 1
| 1 |
|-------------|
| 3kft_214633 |
For example:> "SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM account WHERE name='3kft_214633') T) AS A WHERE ROWNUM BETWEEN 1 AND 1 "'
PreparedStatement:
'SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM account WHERE name=?) T) AS A WHERE ROWNUM BETWEEN 1 AND 1 '
CaseMessage=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() AS ROWNUM, T.* FROM ( SELECT * FROM account WHERE name='3kft_214633') T) AS ' at line 1

8 回复

对了 数据库用的是腾讯云数据库

Nutz版本为nutz-1.b.53.jar

考虑更新到最新版吗?

如果不考虑,可以把nutz源码里面的nutz_jdbc_expert.js拷贝到源码文件夹/或者maven项目下的resources目录,改里面的映射信息

那还是考虑更新到最新版本吧

话说nutz_jdbc_expert.js在那个包下@wendal

“改里面的映射信息” 是什么意思 @wendal

打开看里面内容应该能明白

添加回复
请先登陆
回到顶部