某一应用,websphere6.0下连oracle 9i进行查询操作没有问题,换成连oracle 10g就报java.sql.SQLException: Invalid scale size. Cannot be less than zero
at javax.sql.rowset.RowSetMetaDataImpl.setScale(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.initMetaData(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.populate(Unknown Source)
查询的表结构:
CREATE TABLE T_REP_TASK
(
N_TASK_ID INTEGER NOT NULL,
N_TASK_STATUS INTEGER NOT NULL,
C_SCHEDULE_TAG CHAR(1 BYTE) NOT NULL,
N_SCHEDULE_DAY NUMBER(3),
N_REPORT_ID NUMBER(4) NOT NULL,
C_USER VARCHAR2(12 BYTE) NOT NULL,
N_TID NUMBER(8),
C_DPT_CDE VARCHAR2(14 BYTE),
C_DMS_STR VARCHAR2(600 BYTE),
C_FILTER_STR VARCHAR2(200 BYTE),
T_START_TIME DATE NOT NULL,
T_INVOKE_TIME DATE,
T_FINISH_TM DATE,
R_REP_ARGUMENT BLOB,
C_COST_EST CHAR(1 BYTE) NOT NULL,
T_TASK_TM DATE NOT NULL,
C_ISSHARE CHAR(1 BYTE) NOT NULL,
C_AUTO_DEL CHAR(1 BYTE) NOT NULL,
N_XMLFILE_SIZE NUMBER DEFAULT 0,
N_ROW_NUM NUMBER DEFAULT 0
)
at javax.sql.rowset.RowSetMetaDataImpl.setScale(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.initMetaData(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.populate(Unknown Source)
查询的表结构:
CREATE TABLE T_REP_TASK
(
N_TASK_ID INTEGER NOT NULL,
N_TASK_STATUS INTEGER NOT NULL,
C_SCHEDULE_TAG CHAR(1 BYTE) NOT NULL,
N_SCHEDULE_DAY NUMBER(3),
N_REPORT_ID NUMBER(4) NOT NULL,
C_USER VARCHAR2(12 BYTE) NOT NULL,
N_TID NUMBER(8),
C_DPT_CDE VARCHAR2(14 BYTE),
C_DMS_STR VARCHAR2(600 BYTE),
C_FILTER_STR VARCHAR2(200 BYTE),
T_START_TIME DATE NOT NULL,
T_INVOKE_TIME DATE,
T_FINISH_TM DATE,
R_REP_ARGUMENT BLOB,
C_COST_EST CHAR(1 BYTE) NOT NULL,
T_TASK_TM DATE NOT NULL,
C_ISSHARE CHAR(1 BYTE) NOT NULL,
C_AUTO_DEL CHAR(1 BYTE) NOT NULL,
N_XMLFILE_SIZE NUMBER DEFAULT 0,
N_ROW_NUM NUMBER DEFAULT 0
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货