Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: <4A775BDD.4090108@amberpoint.com>
Date: Mon, 03 Aug 2009 14:51:25 -0700
From: Bryan Pendleton <bpendleton@amberpoint.com>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
To: derby-dev@db.apache.org
Subject: Re: problem with cast (null as int)
References: <316d38e80908021129y3c1d4d8ay8be3b2350f6f5be2@mail.gmail.com>
	 <316d38e80908030912k6b619f52jc8fd88f90f708208@mail.gmail.com>
	 <316d38e80908031210p5a5eee7fx454710714c5c29ac@mail.gmail.com>
 <316d38e80908031415ibfe81c1j555838eb76edf075@mail.gmail.com>
In-Reply-To: <316d38e80908031415ibfe81c1j555838eb76edf075@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

> Exception in thread "main" java.sql.SQLDataException: An attempt was 
> made to get a data value of type 'INTEGER' from a data value of type 'null'.

Hi Eranda,

I think this is DERBY-1938 (https://issues.apache.org/jira/browse/DERBY-1938).

Do you agree?

Can we change your program so that it calls the other version of setObject(),
so that we can pass the data type to setObject?

That is, I changed your program from

         for (int i = 1;
                 i <= rsmd.getColumnCount(); i++) {
             pSt.setObject(i, rs.getObject(i));
         }

to

         for (int i = 1;
                 i <= rsmd.getColumnCount(); i++) {
             pSt.setObject(i, rs.getObject(i), Types.INTEGER);
         }

And then the program does not give the exception.

Does this help?

thanks,

bryan