⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 resultset.out

📁 derby database source code.good for you.
💻 OUT
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
getBytes(dc) got exception 
Data Conversion SQLException
getDate(10) got exception 
Data Conversion SQLException
getDate(dc) got exception 
Data Conversion SQLException
getDouble(10): 10.1
getDouble(dc): 10.1
getFloat(10): 10.1
getFloat(dc): 10.1
getInt(10): 10
getInt(dc): 10
getLong(10): 10
getLong(dc): 10
getObject(10): 10.10
getObject(dc): 10.10
getShort(10): 10
getShort(dc): 10
getString(10): 10.10
getString(dc): 10.10
getTime(10) got exception 
Data Conversion SQLException
getTime(dc) got exception 
Data Conversion SQLException
getTimestamp(10) got exception 
Data Conversion SQLException
getTimestamp(dc) got exception 
Data Conversion SQLException
getBigDecimal(11,1): 11
beetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)
getBigDecimal(bi,1): 11
getBoolean(11): true
getBoolean(bi): true
getByte(11): 11
getByte(bi): 11
getBytes(11) got exception 
Data Conversion SQLException
getBytes(bi) got exception 
Data Conversion SQLException
getDate(11) got exception 
Data Conversion SQLException
getDate(bi) got exception 
Data Conversion SQLException
getDouble(11): 11.0
getDouble(bi): 11.0
getFloat(11): 11.0
getFloat(bi): 11.0
getInt(11): 11
getInt(bi): 11
getLong(11): 11
getLong(bi): 11
getObject(11): 11
getObject(bi): 11
getShort(11): 11
getShort(bi): 11
getString(11): 11
getString(bi): 11
getTime(11) got exception 
Data Conversion SQLException
getTime(bi) got exception 
Data Conversion SQLException
getTimestamp(11) got exception 
Data Conversion SQLException
getTimestamp(bi) got exception 
Data Conversion SQLException
getBigDecimal(12,1) got exception 
Data Conversion SQLException
beetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)
getBigDecimal(cbd,1) got exception 
Data Conversion SQLException
getBoolean(12) got exception 
Data Conversion SQLException
getBoolean(cbd) got exception 
Data Conversion SQLException
getByte(12) got exception 
Data Conversion SQLException
getByte(cbd) got exception 
Data Conversion SQLException
getBytes(12): 0x007400770065006C0076
getBytes(cbd): 0x007400770065006C0076
getDate(12) got exception 
Data Conversion SQLException
getDate(cbd) got exception 
Data Conversion SQLException
getDouble(12) got exception 
Data Conversion SQLException
getDouble(cbd) got exception 
Data Conversion SQLException
getFloat(12) got exception 
Data Conversion SQLException
getFloat(cbd) got exception 
Data Conversion SQLException
getInt(12) got exception 
Data Conversion SQLException
getInt(cbd) got exception 
Data Conversion SQLException
getLong(12) got exception 
Data Conversion SQLException
getLong(cbd) got exception 
Data Conversion SQLException
getObject(12) is ok
getObject(cbd) is ok 
getShort(12) got exception 
Data Conversion SQLException
getShort(cbd) got exception 
Data Conversion SQLException
getString(12): 007400770065006c0076
getString(cbd): 007400770065006c0076
getTime(12) got exception 
Data Conversion SQLException
getTime(cbd) got exception 
Data Conversion SQLException
getTimestamp(12) got exception 
Data Conversion SQLException
getTimestamp(cbd) got exception 
Data Conversion SQLException
getBigDecimal(13,1) got exception 
Data Conversion SQLException
beetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)
getBigDecimal(vbd,1) got exception 
Data Conversion SQLException
getBoolean(13) got exception 
Data Conversion SQLException
getBoolean(vbd) got exception 
Data Conversion SQLException
getByte(13) got exception 
Data Conversion SQLException
getByte(vbd) got exception 
Data Conversion SQLException
getBytes(13): 0x0033007400650065006E
getBytes(vbd): 0x0033007400650065006E
getDate(13) got exception 
Data Conversion SQLException
getDate(vbd) got exception 
Data Conversion SQLException
getDouble(13) got exception 
Data Conversion SQLException
getDouble(vbd) got exception 
Data Conversion SQLException
getFloat(13) got exception 
Data Conversion SQLException
getFloat(vbd) got exception 
Data Conversion SQLException
getInt(13) got exception 
Data Conversion SQLException
getInt(vbd) got exception 
Data Conversion SQLException
getLong(13) got exception 
Data Conversion SQLException
getLong(vbd) got exception 
Data Conversion SQLException
getObject(13) is ok
getObject(vbd) is ok 
getShort(13) got exception 
Data Conversion SQLException
getShort(vbd) got exception 
Data Conversion SQLException
getString(13): 0033007400650065006e
getString(vbd): 0033007400650065006e
getTime(13) got exception 
Data Conversion SQLException
getTime(vbd) got exception 
Data Conversion SQLException
getTimestamp(13) got exception 
Data Conversion SQLException
getTimestamp(vbd) got exception 
Data Conversion SQLException
getBigDecimal(14,1) got exception 
Data Conversion SQLException
beetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)
getBigDecimal(lvbd,1) got exception 
Data Conversion SQLException
getBoolean(14) got exception 
Data Conversion SQLException
getBoolean(lvbd) got exception 
Data Conversion SQLException
getByte(14) got exception 
Data Conversion SQLException
getByte(lvbd) got exception 
Data Conversion SQLException
getBytes(14): 0x0034007400650065006E
getBytes(lvbd): 0x0034007400650065006E
getDate(14) got exception 
Data Conversion SQLException
getDate(lvbd) got exception 
Data Conversion SQLException
getDouble(14) got exception 
Data Conversion SQLException
getDouble(lvbd) got exception 
Data Conversion SQLException
getFloat(14) got exception 
Data Conversion SQLException
getFloat(lvbd) got exception 
Data Conversion SQLException
getInt(14) got exception 
Data Conversion SQLException
getInt(lvbd) got exception 
Data Conversion SQLException
getLong(14) got exception 
Data Conversion SQLException
getLong(lvbd) got exception 
Data Conversion SQLException
getObject(14) is ok
getObject(lvbd) is ok 
getShort(14) got exception 
Data Conversion SQLException
getShort(lvbd) got exception 
Data Conversion SQLException
getString(14): 0034007400650065006e
getString(lvbd): 0034007400650065006e
getTime(14) got exception 
Data Conversion SQLException
getTime(lvbd) got exception 
Data Conversion SQLException
getTimestamp(14) got exception 
Data Conversion SQLException
getTimestamp(lvbd) got exception 
Data Conversion SQLException
getBigDecimal(15,1): null
beetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)
getBigDecimal(cl,1): null
getBoolean(15): false
getBoolean(cl): false
getByte(15): 0
getByte(cl): 0
getBytes(15): null
getBytes(cl): null
getDate(15): null
getDate(cl): null
getDouble(15): 0.0
getDouble(cl): 0.0
getFloat(15): 0.0
getFloat(cl): 0.0
getInt(15): 0
getInt(cl): 0
getLong(15): 0
getLong(cl): 0
getObject(15) is ok
getObject(cl) is ok 
getShort(15): 0
getShort(cl): 0
getString(15): null
getString(cl): null
getTime(15): null
getTime(cl): null
getTimestamp(15): null
getTimestamp(cl): null
getBigDecimal(16,1): null
beetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)
getBigDecimal(bl,1): null
getBoolean(16): false
getBoolean(bl): false
getByte(16): 0
getByte(bl): 0
getBytes(16): null
getBytes(bl): null
getDate(16): null
getDate(bl): null
getDouble(16): 0.0
getDouble(bl): 0.0
getFloat(16): 0.0
getFloat(bl): 0.0
getInt(16): 0
getInt(bl): 0
getLong(16): 0
getLong(bl): 0
getObject(16) is ok
getObject(bl) is ok 
getShort(16): 0
getShort(bl): 0
getString(16): null
getString(bl): null
getTime(16): null
getTime(bl): null
getTimestamp(16): null
getTimestamp(bl): null
rs.next() on closed result set got exception 
Result Set Closed Exception
just auto commit
  bug4810 1, 1
  bug4810 1, 2
  LOCK TABLE
Locks are held
  bug4810 1, 3
  LOCK TABLE
Locks are held
  LOCK TABLE
commit with auto commit
  bug4810 1, 1
  bug4810 1, 2
commit
  LOCK TABLE
Result Set Closed Exception
  LOCK TABLE
  LOCK TABLE
rollback with auto commit
  bug4810 1, 1
  bug4810 1, 2
rollback
  LOCK TABLE
Result Set Closed Exception
  LOCK TABLE
  LOCK TABLE
START testMutableValues
CHECKING on getXXX()
ROW 1
ROW 2
ROW 3
OK EQUALITY OBJECT RETURNED column 4 existing 1
OK EQUALITY OBJECT RETURNED column 5 existing 1
OK EQUALITY OBJECT RETURNED column 6 existing 1
CHECKING on getObject()
ROW 1
ROW 2
ROW 3
OK EQUALITY OBJECT RETURNED column 4 existing 1
OK EQUALITY OBJECT RETURNED column 5 existing 1
OK EQUALITY OBJECT RETURNED column 6 existing 1
COMPLETE testMutableValues
Run select * from s ss (f, e, d, c, b, a) where f = 0 and then try getTableName and getSchemaName on columns
getTableName(1): S
getSchemaName(1): APP
Run select * from (select * from s) a and then try getTableName and getSchemaName on columns
getTableName(1): S
getSchemaName(1): APP
Run select * from s1.t1 as abc and then try getTableName and getSchemaName on columns
Table name of first column is T1
Schema name of first column is S1
Table name of second column is T1
Schema name of second column is S1
Run select abc.c11 from s1.t1 as abc and then try getTableName and getSchemaName on columns
Table name of first column is T1
Schema name of first column is S1
Run select bcd.a, abc.c11 from s1.t1 as abc, s as bcd and then try getTableName and getSchemaName on columns
Table name of first column is S
Schema name of first column is APP
Table name of second column is T1
Schema name of second column is S1
Run select app1.t1.c11, app2.t1.c11 from app1.t1, app2.t1 and then try getTableName and getSchemaName on columns
Table name of first column is T1
Schema name of first column is APP1
Table name of second column is T1
Schema name of second column is APP2
Tests to check metadata information of nullif column
Set up by creating table for testing all datatypes combinations
create table AllDataTypesTable (SMALLINTCOL SMALLINT,INTEGERCOL INTEGER,BIGINTCOL BIGINT,DECIMALCOL DECIMAL(10,5),REALCOL REAL,DOUBLECOL DOUBLE,CHARCOL CHAR(60),VARCHARCOL VARCHAR(60),LONGVARCHARCOL LONG VARCHAR,CHARFORBITCOL CHAR(60) FOR BIT DATA,VARCHARFORBITCOL VARCHAR(60) FOR BIT DATA,LVARCHARFORBITCOL LONG VARCHAR FOR BIT DATA,CLOBCOL CLOB(1k),DATECOL DATE,TIMECOL TIME,TIMESTAMPCOL TIMESTAMP,BLOBCOL BLOB(1k))
insert into AllDataTypesTable values(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -