Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
Message-ID: <40ED53BD.4080006@ronald-dauster.de>
Date: Thu, 08 Jul 2004 16:01:33 +0200
From: Ronald Dauster <rpd@ronald-dauster.de>
User-Agent: Mozilla Thunderbird 0.7 (Windows/20040616)
MIME-Version: 1.0
To: Jakarta Commons Users List <commons-user@jakarta.apache.org>
Subject: Re: [DBUtils] Setting NULL values [was: SQL Server null]
References: <20040708130903.72157.qmail@web50406.mail.yahoo.com>
In-Reply-To: <20040708130903.72157.qmail@web50406.mail.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

David Graham wrote:

>Thanks for the testing!  Which of the 4 columns did you try to insert null
>into?  
>
All three simultaneously, but for Oracle I've also tried individual columns

>In my testing, Oracle worked with INTEGER but maybe it was a
>  
>
The problem is with the DATE column, probably because there's no 
conversion from INTEGER
to DATE. The error is ORA-00932 and it's the 
PreparedStatement.executeUpdate that fails
(in contrast to Types.OTHER, where the PreparesStatement.setNull throws 
an exception).

 Types.INTEGER works for VARCHAR2 and NUMBER columns.

Driver and database are both version 9.2.0.1.0

>different driver version.  It looks like we'll have to babysit Oracle and
>use VARCHAR.  Please let us know the results of SQL Server and Oracle 10.
>
>David
>  
>
Ronald

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org