db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [jira] Commented: (DERBY-203) setNull(x,JDBCType.DATE) does not work when batching is turned on
Date Sat, 30 Apr 2005 00:34:51 GMT
Assign the bug to yourself, to indicate you are working on it. I have
added you to 'derby-developer' list now.

Satheesh

Shreyas Kaushik wrote:

> I am planning to work on this may be this week, but definitely next
> week. I did a similar fix for Blob and Timestamp. But as a part of the
> patch for this I want to solve this problem not just for this specific
> case but for all DataTypes where this problem could occur.
>
> ~ Shreyas
>
> Shreyas Kaushik (JIRA) wrote:
>
>>     [
>> http://issues.apache.org/jira/browse/DERBY-203?page=comments#action_63028
>> ]
>>     Shreyas Kaushik commented on DERBY-203:
>> ---------------------------------------
>>
>> I had fixed smilar problem with Blob and Timestamp. I will look into
>> this and other types with which this problem can arise.
>>
>>  
>>
>>> setNull(x,JDBCType.DATE) does not work when batching is turned on
>>> -----------------------------------------------------------------
>>>
>>>         Key: DERBY-203
>>>         URL: http://issues.apache.org/jira/browse/DERBY-203
>>>     Project: Derby
>>>        Type: Bug
>>>  Components: JDBC
>>>    Versions: 10.0.2.1
>>> Environment: ------------------ Java Information ------------------
>>> Java Version:    1.4.2_07
>>> Java Vendor:     Sun Microsystems Inc.
>>> Java home:       /usr/local/java/j2sdk1.4.2_07/jre
>>> Java classpath: 
>>> /home/oleg/prg/cs/lib/derby.jar:/home/oleg/prg/cs/lib/derbytools.jar:
>>> OS name:         Linux
>>> OS architecture: i386
>>> OS version:      2.6.8.1-24mdk
>>> Java user name:  oleg
>>> Java user home:  /home/oleg
>>> Java user dir:   /usr/local/home/oleg/prg/cs/frameworks/embedded/bin
>>> --------- Derby Information --------
>>> [/usr/local/home/oleg/prg/cs/lib/derby.jar] 10.0.2.0 - (30301)
>>> [/usr/local/home/oleg/prg/cs/lib/derbytools.jar] 10.0.2.0 - (30301)
>>> ------------------------------------------------------
>>> ----------------- Locale Information -----------------
>>> ------------------------------------------------------
>>>    Reporter: Oleg Anastasyev
>>>   
>>
>>
>>  
>>
>>> Trying to execute batch on which setNull(x,DATE) was called gives
>>> the following exception:
>>> SQL Exception: An attempt was made to get a data value of type
>>> 'DATE' from a data value of type 'null'.
>>>        at
>>> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
>>>        at
>>> org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
>>>        at
>>> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
>>>        at
>>> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
>>>
>>>        at
>>> org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(ConnectionChild.java)
>>>
>>>        at
>>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(EmbedPreparedStatement.java)
>>>
>>>        at
>>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.setObject(EmbedPreparedStatement.java)
>>>
>>>        at org.apache.derby.iapi.types.DataType.setInto(DataType.java)
>>>        at
>>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeBatchElement(EmbedPreparedStatement.java)
>>>
>>>        at
>>> org.apache.derby.impl.jdbc.EmbedStatement.executeBatch(EmbedStatement.java)
>>>
>>>        at
>>> net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
>>>
>>> DATE column is nullable in db schema, so it should pass there ok. I
>>> believe the problem is in org.apache.derby.iapi.types.SQLDate, which
>>> does not implement setInto method, so DataType.setInto method is
>>> executed, calling setObject(x,null). setObject thinks this is JDBC
>>> spec violation and fails on exception.
>>> Problem exists in both 10.0.2.1 and 10.0.2.0
>>>   
>>
>>
>>  
>>
>
>
>


Mime
View raw message