outparams.out

derby database source code.good for you.

			getString(1) = 1332
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getObject(1) = 1332
	cs.registerOutParameter(1, FLOAT)
	setFLoat(1, 666)
	cs.execute()
			getBoolean(1) = true
			getBoolean(1) = true
			getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
			getShort(1) = 1332
			getInt(1) = 1332
			getLong(1) = 1332
			getFloat(1) = 1332.0
			getFloat(1) = 1332.0
			getDouble(1) = 1332.0
			getBigDecimal(1) = 1332
			getBigDecimal(1) = 1332
			getString(1) = 1332
			getString(1) = 1332
			getString(1) = 1332
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getObject(1) = 1332
	cs.registerOutParameter(1, REAL)
	setFLoat(1, 666)
	cs.execute()
			getBoolean(1) = true
			getBoolean(1) = true
			getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
			getShort(1) = 1332
			getInt(1) = 1332
			getLong(1) = 1332
			getFloat(1) = 1332.0
			getFloat(1) = 1332.0
			getDouble(1) = 1332.0
			getBigDecimal(1) = 1332
			getBigDecimal(1) = 1332
			getString(1) = 1332
			getString(1) = 1332
			getString(1) = 1332
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getObject(1) = 1332
	cs.registerOutParameter(1, DOUBLE)
	setDouble(1, 666)
	cs.execute()
			getBoolean(1) = true
			getBoolean(1) = true
			getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
			getShort(1) = 1332
			getInt(1) = 1332
			getLong(1) = 1332
			getFloat(1) = 1332.0
			getFloat(1) = 1332.0
			getDouble(1) = 1332.0
			getBigDecimal(1) = 1332
			getBigDecimal(1) = 1332
			getString(1) = 1332
			getString(1) = 1332
			getString(1) = 1332
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getObject(1) = 1332
	cs.registerOutParameter(1, NUMERIC)
	setBigDecimal(1, 666.666)
	cs.execute()
			getBoolean(1) = true
			getBoolean(1) = true
			getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
			getShort(1) = 1332
			getInt(1) = 1332
			getLong(1) = 1332
			getFloat(1) = 1332.0
			getFloat(1) = 1332.0
			getDouble(1) = 1332.0
			getBigDecimal(1) = 1332
			getBigDecimal(1) = 1332
			getString(1) = 1332
			getString(1) = 1332
			getString(1) = 1332
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getObject(1) = 1332
	cs.registerOutParameter(1, DECIMAL)
	setBigDecimal(1, 666.666)
	cs.execute()
			getBoolean(1) = true
			getBoolean(1) = true
			getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
			getShort(1) = 1332
			getInt(1) = 1332
			getLong(1) = 1332
			getFloat(1) = 1332.0
			getFloat(1) = 1332.0
			getDouble(1) = 1332.0
			getBigDecimal(1) = 1332
			getBigDecimal(1) = 1332
			getString(1) = 1332
			getString(1) = 1332
			getString(1) = 1332
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'INTEGER'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'INTEGER'.
			getObject(1) = 1332
	cs.registerOutParameter(1, CHAR)
	setString(1, "Set via setString()")
	Exception SQL Exception: Invalid character string format for type INTEGER.
	cs.registerOutParameter(1, VARCHAR)
	setString(1, "Set via setString()")
	Exception SQL Exception: Invalid character string format for type INTEGER.
	cs.registerOutParameter(1, LONGVARCHAR)
	setString(1, "Set via setString()")
	Exception SQL Exception: Invalid character string format for type INTEGER.
	cs.registerOutParameter(1, DATE)
	Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type INTEGER and they are incompatible.
	cs.registerOutParameter(1, TIME)
	Exception SQL Exception: Parameter 1 cannot be registered to be of type TIME because it maps to type INTEGER and they are incompatible.
	cs.registerOutParameter(1, TIMESTAMP)
	Exception SQL Exception: Parameter 1 cannot be registered to be of type TIMESTAMP because it maps to type INTEGER and they are incompatible.
	cs.registerOutParameter(1, BINARY)
	Exception SQL Exception: Parameter 1 cannot be registered to be of type BINARY because it maps to type INTEGER and they are incompatible.
	cs.registerOutParameter(1, VARBINARY)
	Exception SQL Exception: Parameter 1 cannot be registered to be of type VARBINARY because it maps to type INTEGER and they are incompatible.
	cs.registerOutParameter(1, LONGVARBINARY)
	Exception SQL Exception: Parameter 1 cannot be registered to be of type LONGVARBINARY because it maps to type INTEGER and they are incompatible.
	cs.registerOutParameter(1, OTHER)
	Exception SQL Exception: Parameter 1 cannot be registered to be of type OTHER because it maps to type INTEGER and they are incompatible.
------------------------------------
call takesLongPrimitive(?,?)
	cs.registerOutParameter(1, BIT)
	setBoolean(1, true)
	cs.execute()
			getBoolean(1) = true
			getBoolean(1) = true
			getByte(1) = 2
			getShort(1) = 2
			getInt(1) = 2
			getLong(1) = 2
			getFloat(1) = 2.0
			getFloat(1) = 2.0
			getDouble(1) = 2.0
			getBigDecimal(1) = 2
			getBigDecimal(1) = 2
			getString(1) = 2
			getString(1) = 2
			getString(1) = 2
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
			getObject(1) = 2
	cs.registerOutParameter(1, BOOLEAN)
	setBoolean(1, true)
	cs.execute()
			getBoolean(1) = true
			getBoolean(1) = true
			getByte(1) = 2
			getShort(1) = 2
			getInt(1) = 2
			getLong(1) = 2
			getFloat(1) = 2.0
			getFloat(1) = 2.0
			getDouble(1) = 2.0
			getBigDecimal(1) = 2
			getBigDecimal(1) = 2
			getString(1) = 2
			getString(1) = 2
			getString(1) = 2
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
			getObject(1) = 2
	cs.registerOutParameter(1, TINYINT)
	setByte(1, 6)
	cs.execute()
			getBoolean(1) = true
			getBoolean(1) = true
			getByte(1) = 12
			getShort(1) = 12
			getInt(1) = 12
			getLong(1) = 12
			getFloat(1) = 12.0
			getFloat(1) = 12.0
			getDouble(1) = 12.0
			getBigDecimal(1) = 12
			getBigDecimal(1) = 12
			getString(1) = 12
			getString(1) = 12
			getString(1) = 12
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
			getObject(1) = 12
	cs.registerOutParameter(1, SMALLINT)
	setShort(1, 66)
	cs.execute()
			getBoolean(1) = true
			getBoolean(1) = true
			getByte(1) = SQL Exception: The resulting value is outside the range for the data type TINYINT.
			getShort(1) = 132
			getInt(1) = 132
			getLong(1) = 132
			getFloat(1) = 132.0
			getFloat(1) = 132.0
			getDouble(1) = 132.0
			getBigDecimal(1) = 132
			getBigDecimal(1) = 132
			getString(1) = 132
			getString(1) = 132
			getString(1) = 132
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'BIGINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BIGINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'BIGINT'.