outparams.out

derby database source code.good for you.

==============================================
TESTING BOUNDARY CONDITIONS
==============================================
Expected exception SQL Exception: Parameter 2 cannot be registered as an OUT parameter because it is an IN parameter. 
Expected exception SQL Exception: The parameter position '9' is out of range.  The number of parameters for this prepared  statement is '2'.
Expected exception SQL Exception: The parameter position '0' is out of range.  The number of parameters for this prepared  statement is '2'.
Expected exception SQL Exception: Return output parameters cannot be set.
Expected exception SQL Exception: Return output parameters cannot be set.
Expected exception on setBigDecimal() on a return output param: SQL Exception: Return output parameters cannot be set.
Expected exception on prepare of '? = call returnsNothing()': SQL Exception: 'RETURNSNOTHING' is not recognized as a function or procedure.
==============================================
TESTING NULLS
==============================================
Test for bug 4317, passing null value for a parameter
==============================================
TESTING UPDATE COUNT
==============================================
executeUpdate on ? = call returnsIntegerP returned -1
getString(1) returned 666
==============================================
TESTING NORMAL OUTPUT PARAMETERS
==============================================
...starting doing setXXX for each type xxx
------------------------------------
{call takesNothing()}
	cs.registerOutParameter(1, BIT)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, BOOLEAN)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, TINYINT)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, SMALLINT)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, INTEGER)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, BIGINT)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, FLOAT)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, REAL)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, DOUBLE)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, NUMERIC)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, DECIMAL)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, CHAR)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, VARCHAR)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, LONGVARCHAR)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, DATE)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, TIME)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, TIMESTAMP)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, BINARY)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, VARBINARY)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, LONGVARBINARY)
	Exception SQL Exception: No input parameters.
	cs.registerOutParameter(1, OTHER)
	Exception SQL Exception: No input parameters.
------------------------------------
call takesShortPrimitive(?,?)
	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 'SMALLINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			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 'SMALLINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			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 'SMALLINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			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 'SMALLINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getObject(1) = 132
	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
			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 'SMALLINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getObject(1) = 1332
	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
			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 'SMALLINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			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 'SMALLINT'.
			getTime(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'SMALLINT'.
			getTimestamp(1) = SQL Exception: An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			getBytes(1) = SQL Exception: An attempt was made to get a data value of type 'byte[]' from a data value of type 'SMALLINT'.
			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