oracle查找数据库中的无效数字,1、selectPage 方法 in查询不能查出数据；2、in中参数是字符类型，数据库字段是数字类型，会报错：无效数字。...

最新推荐文章于 2024-04-17 17:05:55 发布

怪异少年

最新推荐文章于 2024-04-17 17:05:55 发布

阅读量1.5k

点赞数

文章标签： oracle查找数据库中的无效数字

当前使用版本(必须填写清楚，否则不予处理)

3.2.0

该问题是怎么引起的？(最新版上已修复的会直接close掉)

1、selectPage 方法 in查询不能查出数据，但是把sql语句在Oracle 是可以查询出来的。

2、把sql语句在Oracle 是可以查询出来的

重现步骤

报错信息

无报错。

: ==> Preparing: SELECT COUNT(1) FROM VIEW_RTP_RETAIL01 WHERE (retailid IN (?, ?, ?, ?, ?, ?) AND comid = ? AND shopid = ?)

: {conn-10001, pstmt-20049} created. SELECT COUNT(1) FROM VIEW_RTP_RETAIL01 WHERE (retailid IN (?, ?, ?, ?, ?, ?) AND comid = ? AND shopid = ?)

: ==> Parameters: '64167208146219008'(String), '64167064176734208'(String), '63446729715548160'(String), '63446664573812736'(String), '59718590542192640'(String), '59456827698520064'(String), 320401000004(Long), 1009001(Long)

: {conn-10001, pstmt-20049} Parameters : ['64167208146219008', '64167064176734208', '63446729715548160', '63446664573812736', '59718590542192640', '59456827698520064', 320401000004, 1009001]

: {conn-10001, pstmt-20049} Types : [VARCHAR, VARCHAR, VARCHAR, VARCHAR, VARCHAR, VARCHAR, BIGINT, BIGINT]

: {conn-10001, pstmt-20049, rs-50045} query executed. 2.889954 millis. SELECT COUNT(1) FROM VIEW_RTP_RETAIL01 WHERE (retailid IN (?, ?, ?, ?, ?, ?) AND comid = ? AND shopid = ?)

: {conn-10001, pstmt-20049, rs-50045} open

: {conn-10001, pstmt-20049, rs-50045} Header: [COUNT(1)]

: {conn-10001, pstmt-20049, rs-50045} Result: [0]

: {conn-10001, pstmt-20049, rs-50045} closed

: {conn-10001, pstmt-20049} closed

: {conn-10001} pool-recycle