Archives of the TeradataForum

Message Posted: Thu, 15 Jun 2006 @ 09:43:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

That is unfortunate.

For what it is worth, your program works using JDBC 3.1 and V2R6.0 (V2R.06.00.00.03). For standalone testing I modified it as follows:

* Removed the subclassing of TestCase

* added a "public void static main" method

* Replaced "throws Exception" with the specific exceptions that can be thrown and caught them explicitly. I did this to access the errorcode and errormessage properties in the SQLException.

Have you tried contacting your NCR support organisation?

BTW. You didn't supply a table definition. So I made the following one up. Initially I had problems ("Invalid operation on an ANSI Datetime or Interval value.") because I defined Effective_DT as a timestamp. The code assumes it is a DATE.

Are you 1,000% sure your table's data types match the test code? Here is the table definition.

     create table Partner (PARTNER_NM varchar(40),
          PARTNER_DESC varchar(40),
          PARTNER_TYPE varchar(40),
          PARTNER_PROG_CD varchar(40),
          DEFAULT_ACTIVITY_TYPE_CD varchar(40),
          EFFECTIVE_DT date,
          STATUS varchar(40),
          Address_Line_1 varchar(40),
          Address_Line_2 varchar(40),
          City varchar(40),
          State_CD varchar(40),
          ZIP_CD varchar(40),
          Phone_Nbr varchar(40),
          ROW_CRT_DTTM timestamp,
          ROW_CRT_USER_ID varchar(40),
          ROW_LAST_PROC_ID varchar(40),
          ROW_UPDT_DTTM timestamp,
          ROW_UPDT_USER_ID varchar(40),
          PARTNER_ID varchar(40)
     )

Regards

Glenn Mc

	<Prev	Next>		<<First	<Prev	Next>	Last>>