parametermapping.java

derby database source code.good for you.

				data[4] = (byte) 0x00;
				data[5] = (byte) 0x32;

			psi.setBinaryStream(1, new java.io.ByteArrayInputStream(data), 6);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		judge_setXXX(worked, sqleResult, 14, type);
		}	
		if (executeBatchTests) {
			s.execute("DELETE FROM PM.TYPE_AS");

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setBinaryStream() as batch ");
					byte[] data = new byte[6];
					data[0] = (byte) 0x82;
					data[1] = (byte) 0x43;
					data[2] = (byte) 0xca;
					data[3] = (byte) 0xfe;
					data[4] = (byte) 0x00;
					data[5] = (byte) 0x32;

				psi.setBinaryStream(1, new java.io.ByteArrayInputStream(data), 6);
				psi.addBatch();
				psi.executeBatch();
				getValidValue(psq, jdbcTypes[type]);

				worked = true;

			} catch (SQLException sqle) {
				sqleResult = sqle;
				worked = false;
			}
			judge_setXXX(worked, sqleResult, 14, type);
		}
		
		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setBinaryStream(null) ");
			psi.setBinaryStream(1, null, 0);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		judge_setXXX(worked, sqleResult, 14, type);
		}	
		if (executeBatchTests) {
			s.execute("DELETE FROM PM.TYPE_AS");

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setBinaryStream(null) as batch ");
				psi.setBinaryStream(1, null, 0);
				psi.addBatch();
				psi.executeBatch();
				getValidValue(psq, jdbcTypes[type]);

				worked = true;

			} catch (SQLException sqle) {
				sqleResult = sqle;
				worked = false;
			}
			judge_setXXX(worked, sqleResult, 14, type);
		}			

		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setCharacterStream() ");
			psi.setCharacterStream(1, new java.io.StringReader("89"), 2);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		judge_setXXX(worked, sqleResult, 15, type);
		}
		if (executeBatchTests) {
			s.execute("DELETE FROM PM.TYPE_AS");

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setCharacterStream() as batch ");
				psi.setCharacterStream(1, new java.io.StringReader("89"), 2);
				psi.addBatch();
				psi.executeBatch();
				getValidValue(psq, jdbcTypes[type]);

				worked = true;

			} catch (SQLException sqle) {
				sqleResult = sqle;
				worked = false;
			}
			judge_setXXX(worked, sqleResult, 15, type);
		}
		
		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setCharacterStream(null) ");
			psi.setCharacterStream(1, null, 0);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		judge_setXXX(worked, sqleResult, 15, type);
		}
		if (executeBatchTests) {
			s.execute("DELETE FROM PM.TYPE_AS");

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setCharacterStream(null) as batch ");
				psi.setCharacterStream(1, null, 0);
				psi.addBatch();
				psi.executeBatch();
				getValidValue(psq, jdbcTypes[type]);

				worked = true;

			} catch (SQLException sqle) {
				sqleResult = sqle;
				worked = false;
			}
			judge_setXXX(worked, sqleResult, 15, type);
		}
		
		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setClob() ");

			ResultSet rsc = s.executeQuery("SELECT C FROM PM.LOB_GET WHERE ID = 1");
			rsc.next();
			Clob tester = rsc.getClob(1);
			rsc.close();


			psi.setClob(1, tester);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		judge_setXXX(worked, sqleResult, 16, type);
		}
		if (executeBatchTests) {
			s.execute("DELETE FROM PM.TYPE_AS");

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setClob() as batch ");

				ResultSet rsc = s.executeQuery("SELECT C FROM PM.LOB_GET WHERE ID = 1");
				rsc.next();
				Clob tester = rsc.getClob(1);
				rsc.close();


				psi.setClob(1, tester);
				psi.addBatch();
				psi.executeBatch();
				getValidValue(psq, jdbcTypes[type]);

				worked = true;

			} catch (SQLException sqle) {
				sqleResult = sqle;
				worked = false;
			}
			judge_setXXX(worked, sqleResult, 16, type);
		}
		
		
		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setClob(null) ");

			psi.setClob(1, null);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		judge_setXXX(worked, sqleResult, 16, type);
		}
		if (executeBatchTests) {
			s.execute("DELETE FROM PM.TYPE_AS");

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setClob(null) as batch ");

				psi.setClob(1, null);
				psi.addBatch();
				psi.executeBatch();
				getValidValue(psq, jdbcTypes[type]);

				worked = true;

			} catch (SQLException sqle) {
				sqleResult = sqle;
				worked = false;
			}
			judge_setXXX(worked, sqleResult, 16, type);
		}
		{
		s.execute("DELETE FROM PM.TYPE_AS");
		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setBlob() ");

			ResultSet rsc = s.executeQuery("SELECT B FROM PM.LOB_GET WHERE ID = 1");
			rsc.next();
			Blob tester = rsc.getBlob(1);
			rsc.close();


			psi.setBlob(1, tester);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		judge_setXXX(worked, sqleResult, 17, type);
		}
		if (executeBatchTests) {
			s.execute("DELETE FROM PM.TYPE_AS");
			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setBlob() as batch ");

				ResultSet rsc = s.executeQuery("SELECT B FROM PM.LOB_GET WHERE ID = 1");
				rsc.next();
				Blob tester = rsc.getBlob(1);
				rsc.close();


				psi.setBlob(1, tester);
				psi.addBatch();
				psi.executeBatch();
				getValidValue(psq, jdbcTypes[type]);

				worked = true;

			} catch (SQLException sqle) {
				sqleResult = sqle;
				worked = false;
			}
			judge_setXXX(worked, sqleResult, 17, type);
		}
		{
		s.execute("DELETE FROM PM.TYPE_AS");
		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setBlob(null) ");

			psi.setBlob(1, null);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		judge_setXXX(worked, sqleResult, 17, type);
		}
		if (executeBatchTests) {
			s.execute("DELETE FROM PM.TYPE_AS");
			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setBlob(null) as batch ");

				psi.setBlob(1, null);
				psi.addBatch();
				psi.executeBatch();
				getValidValue(psq, jdbcTypes[type]);

				worked = true;

			} catch (SQLException sqle) {
				sqleResult = sqle;
				worked = false;
			}
			judge_setXXX(worked, sqleResult, 17, type);
		}
		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setUnicodeStream() ");
				byte[] data = new byte[6];
				data[0] = (byte) 0x82;
				data[1] = (byte) 0x43;
				data[2] = (byte) 0xca;
				data[3] = (byte) 0xfe;
				data[4] = (byte) 0x00;
				data[5] = (byte) 0x32;

			psi.setUnicodeStream(1, new java.io.ByteArrayInputStream(data), 6);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		judge_setXXX(worked, sqleResult, 14, type);
		}	
		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setUnicodeStream(null) ");
			psi.setUnicodeStream(1, null, 0);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		judge_setXXX(worked, sqleResult, 14, type);
		}


		// setObject(null)
		if (executeBatchTests) {
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			// should never work!
			System.out.print("  setObject(null) ");
			psi.setObject(1, null);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		System.out.println(worked ? " FAIL " : (" OK " + sqleResult.getMessage()));
		}
		if (executeBatchTests) {
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			// should never work!
			System.out.print("  setObject(null) as batch ");
			psi.setObject(1, null);
			psi.addBatch();
			psi.executeBatch();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		}
		System.out.println(worked ? " FAIL " : (" OK " + sqleResult.getMessage()));
		}

		setXXX_setObject(s, psi, psq, type, "46", "java.lang.String", 0, executeBatchTests);
		setXXX_setObject(s, psi, psq, type, BigDecimal.valueOf(72L), "java.math.BigDecimal", 1, executeBatchTests);
		setXXX_setObject(s, psi, psq, type, Boolean.TRUE, "java.lang.Boolean", 2, executeBatchTests);
		setXXX_setObject(s, psi, psq, type, new Integer(74), "java.lang.Integer", 3, executeBatchTests);
		setXXX_setObject(s, psi, psq, type, new Long(79), "java.lang.Long", 4, executeBatchTests);
		setXXX_setObject(s, psi, psq, type, new Float(76.3f), "java.lang.Float", 5, executeBatchTests);
		setXXX_setObject(s, psi, psq, type, new Double(12.33d), "java.lang.Double", 6, executeBatchTests);

		{
		byte[] data = {0x32, 0x39};
		setXXX_setObject(s, psi, psq, type, data, "byte[]", 7, executeBatchTests);
		}


		setXXX_setObject(s, psi, psq, type, java.sql.Date.valueOf("2004-02-14"), "java.sql.Date", 8, executeBatchTests);
		setXXX_setObject(s, psi, psq, type, java.sql.Time.valueOf("13:26:42"), "java.sql.Time", 9, executeBatchTests);
		setXXX_setObject(s, psi, psq, type, java.sql.Timestamp.valueOf("2004-02-23 17:14:24.097625551"), "java.sql.Timestamp", 10, executeBatchTests);
		s.getConnection().commit();

		if (!isDB2jNet) {
		{
			ResultSet rsc = s.executeQuery("SELECT B FROM PM.LOB_GET WHERE ID = 1");
			rsc.next();
			Blob tester = rsc.getBlob(1);
			rsc.close();
			setXXX_setObject(s, psi, psq, type, tester, "java.sql.Blob", 11, executeBatchTests);
		}

		{
			ResultSet rsc = s.executeQuery("SELECT C FROM PM.LOB_GET WHERE ID = 1");
			rsc.next();
			Clob tester = rsc.getClob(1);
			rsc.close();
			setXXX_setObject(s, psi, psq, type, tester, "java.sql.Clob", 12, executeBatchTests);
		}
		}
	}

	private static void setXXX_setObject(Statement s, PreparedStatement psi, PreparedStatement psq, int type, Object value, String className, int b5o,
			boolean executeBatchTests)
		throws SQLException, java.io.IOException
	{
		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setObject(" + className + ") ");
			psi.setObject(1, value);
			psi.executeUpdate();
			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		} catch (Throwable t) {
			System.out.println("FAIL " + t.getMessage());
			return;
		}
		judge_setObject(worked, sqleResult, b5o, type);
		}
		if (executeBatchTests) {
			s.execute("DELETE FROM PM.TYPE_AS");

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setObject(" + className + ") as batch ");
				psi.setObject(