parametermapping.java

derby database source code.good for you.

			judge_setXXX(worked, sqleResult, 8, type);
			}
		
		// null String
		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setString(null) ");
			psi.setString(1, null);
			psi.executeUpdate();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		} catch (Throwable t) {
			// JCC has some bugs
			System.out.println(t.getMessage());
			worked = false;
			sqleResult = null;

		}
		judge_setXXX(worked, sqleResult, 8, type);
		}
		// null String as batch
		if (executeBatchTests) {
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setString(null) as batch ");
			psi.setString(1, null);
			psi.addBatch();
			psi.executeBatch();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

		} catch (SQLException sqle) {
			sqleResult = sqle;
			worked = false;
		} catch (Throwable t) {
			// JCC has some bugs
			System.out.println(t.getMessage());
			worked = false;
			sqleResult = null;

		}
		judge_setXXX(worked, sqleResult, 8, type);
		}
		{
		 s.execute("DELETE FROM PM.TYPE_AS");	
		
		 // Set Invalid String for nonString types (DERBY-149)
		 testSetStringInvalidValue(type,psi);
		}
		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setBytes() ");
			byte[] data = {(byte) 0x04, (byte) 0x03, (byte) 0xfd, (byte) 0xc3, (byte) 0x73};
			psi.setBytes(1, data);
			psi.executeUpdate();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

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

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setBytes() as batch");
				byte[] data = {(byte) 0x04, (byte) 0x03, (byte) 0xfd, (byte) 0xc3, (byte) 0x73};
				psi.setBytes(1, data);
				psi.addBatch();
				psi.executeBatch();

				getValidValue(psq, jdbcTypes[type]);

				worked = true;

			} catch (SQLException sqle) {
				sqleResult = sqle;
				worked = false;
			}
			judge_setXXX(worked, sqleResult, 9, type);
			}
		// null byte[]
		{
		s.execute("DELETE FROM PM.TYPE_AS");

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setBytes(null) ");
			psi.setBytes(1, null);
			psi.executeUpdate();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

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

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

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setBytes(null) as batch");
				psi.setBytes(1, null);
				psi.addBatch();
				psi.executeBatch();

				getValidValue(psq, jdbcTypes[type]);

				worked = true;

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

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setDate() ");
			psi.setDate(1, java.sql.Date.valueOf("2004-02-14"));
			psi.executeUpdate();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

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

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setDate() as batch ");
				psi.setDate(1, java.sql.Date.valueOf("2004-02-14"));
				psi.addBatch();
				psi.executeBatch();

				getValidValue(psq, jdbcTypes[type]);

				worked = true;

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

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setDate(null) ");
			psi.setDate(1, null);
			psi.executeUpdate();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

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

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setDate(null) as batch ");
			psi.setDate(1, null);
			psi.addBatch();
			psi.executeBatch();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

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

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setTime() ");
			psi.setTime(1, java.sql.Time.valueOf("13:26:42"));
			psi.executeUpdate();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

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

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setTime() as batch ");
				psi.setTime(1, java.sql.Time.valueOf("13:26:42"));
				psi.addBatch();
				psi.executeBatch();

				getValidValue(psq, jdbcTypes[type]);

				worked = true;

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

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

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setTime(null) ");
			psi.setTime(1, null);
			psi.executeUpdate();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

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

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setTime(null) as batch ");
				psi.setTime(1, null);
				psi.addBatch();
				psi.executeBatch();

				getValidValue(psq, jdbcTypes[type]);

				worked = true;

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

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setTimestamp() ");
			psi.setTimestamp(1, java.sql.Timestamp.valueOf("2004-02-23 17:14:24.097625551"));
			psi.executeUpdate();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

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

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setTimestamp() as batch ");
				psi.setTimestamp(1, java.sql.Timestamp.valueOf("2004-02-23 17:14:24.097625551"));
				psi.addBatch();
				psi.executeBatch();

				getValidValue(psq, jdbcTypes[type]);

				worked = true;

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

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

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setTimestamp(null) ");
			psi.setTimestamp(1, null);
			psi.executeUpdate();

			getValidValue(psq, jdbcTypes[type]);

			worked = true;

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

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setTimestamp(null) as batch ");
				psi.setTimestamp(1, null);
				psi.addBatch();
				psi.executeBatch();

				getValidValue(psq, jdbcTypes[type]);

				worked = true;

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

		SQLException sqleResult = null;
		boolean worked;
		try {
			System.out.print("  setAsciiStream() ");
				byte[] data = new byte[6];
				data[0] = (byte) 0x65;
				data[1] = (byte) 0x67;
				data[2] = (byte) 0x30;
				data[3] = (byte) 0x31;
				data[4] = (byte) 0x32;
				data[5] = (byte) 0x64;

			psi.setAsciiStream(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, 13, type);
		}
		if (executeBatchTests){
			s.execute("DELETE FROM PM.TYPE_AS");

			SQLException sqleResult = null;
			boolean worked;
			try {
				System.out.print("  setAsciiStream() as batch ");
					byte[] data = new byte[6];
					data[0] = (byte) 0x65;
					data[1] = (byte) 0x67;
					data[2] = (byte) 0x30;
					data[3] = (byte) 0x31;
					data[4] = (byte) 0x32;
					data[5] = (byte) 0x64;

				psi.setAsciiStream(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, 13, type);
		}
		
		
		{
		s.execute("DELETE FROM PM.TYPE_AS");

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

			worked = true;

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

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

				worked = true;

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

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