outparams.out

derby database source code.good for you.

			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.0
			getBigDecimal(1) = 12.0
			getString(1) = 12.0
			getString(1) = 12.0
			getString(1) = 12.0
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getObject(1) = 12.0
	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.0
			getBigDecimal(1) = 132.0
			getString(1) = 132.0
			getString(1) = 132.0
			getString(1) = 132.0
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getObject(1) = 132.0
	cs.registerOutParameter(1, INTEGER)
	setInt(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.0
			getBigDecimal(1) = 1332.0
			getString(1) = 1332.0
			getString(1) = 1332.0
			getString(1) = 1332.0
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getObject(1) = 1332.0
	cs.registerOutParameter(1, BIGINT)
	setLong(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.0
			getBigDecimal(1) = 1332.0
			getString(1) = 1332.0
			getString(1) = 1332.0
			getString(1) = 1332.0
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getObject(1) = 1332.0
	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.0
			getBigDecimal(1) = 1332.0
			getString(1) = 1332.0
			getString(1) = 1332.0
			getString(1) = 1332.0
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getObject(1) = 1332.0
	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.0
			getBigDecimal(1) = 1332.0
			getString(1) = 1332.0
			getString(1) = 1332.0
			getString(1) = 1332.0
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getObject(1) = 1332.0
	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.0
			getBigDecimal(1) = 1332.0
			getString(1) = 1332.0
			getString(1) = 1332.0
			getString(1) = 1332.0
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getObject(1) = 1332.0
	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) = 1333
			getInt(1) = 1333
			getLong(1) = 1333
			getFloat(1) = 1333.332
			getFloat(1) = 1333.332
			getDouble(1) = 1333.33203125
			getBigDecimal(1) = 1333.332
			getBigDecimal(1) = 1333.332
			getString(1) = 1333.332
			getString(1) = 1333.332
			getString(1) = 1333.332
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getObject(1) = 1333.332
	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) = 1333
			getInt(1) = 1333
			getLong(1) = 1333
			getFloat(1) = 1333.332
			getFloat(1) = 1333.332
			getDouble(1) = 1333.33203125
			getBigDecimal(1) = 1333.332
			getBigDecimal(1) = 1333.332
			getString(1) = 1333.332
			getString(1) = 1333.332
			getString(1) = 1333.332
			getDate(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Date' from a data value of type 'REAL'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'REAL'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'REAL'.
			getObject(1) = 1333.332
	cs.registerOutParameter(1, CHAR)
	setString(1, "Set via setString()")
	Exception SQL Exception: Invalid character string format for type REAL.
	cs.registerOutParameter(1, VARCHAR)
	setString(1, "Set via setString()")
	Exception SQL Exception: Invalid character string format for type REAL.
	cs.registerOutParameter(1, LONGVARCHAR)
	setString(1, "Set via setString()")
	Exception SQL Exception: Invalid character string format for type REAL.
	cs.registerOutParameter(1, DATE)
	Exception SQL Exception: Parameter 1 cannot be registered to be of type DATE because it maps to type REAL 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 REAL 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 REAL 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 REAL 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 REAL 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 REAL 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 REAL and they are incompatible.
------------------------------------
call takesDoublePrimitive(?,?)
	cs.registerOutParameter(1, BIT)
	setBoolean(1, true)
	cs.execute()
			getBoolean(1) = true
			getBoolean(1) = true
			getByte(1) = 2
			getShort(1) = 2
			getInt(1) =