db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From TomohitoNakayama <tomon...@basil.ocn.ne.jp>
Subject Question around type in DRDA(Re: [jira] Commented: (DERBY-1610) Engine take it as type compatibility error to update column typed as CHAR to value passed via setBinaryStream(null), though Network Client and Network Server does not take it as error.)
Date Wed, 02 Aug 2006 15:04:12 GMT
Hello.

Concerning DERBY-1610, I'm surveying type definition part in current 
DRDA relating code.

I found there exists two word "DRDA_TYPE" and "FDOCA_TYPE".
Former was found in org.apache.derby.iapi.reference.DRDAConstants and
latter was found in org.apache.derby.client.net.FdocaConstants.

The latter seems to be FTYPE defined in FD:OCA Specifications.
However I'm not sure what former is....

Does any one know what is DRDA_TYPE is ?

Best regards.


Tomohito Nakayama (JIRA) wrote:

>    [ http://issues.apache.org/jira/browse/DERBY-1610?page=comments#action_12425235 ]

>            
>Tomohito Nakayama commented on DERBY-1610:
>------------------------------------------
>
>Reading the code, it seems that NetworkServer recognize the type of the parameter, according
to the SQL and not according to the method which passes the parameter value.
>
>SQL to be executed in the TestNullChar.java is as next and type of the parameter is recognized
as CHAR.
>INSERT INTO NULL_CHAR_TEST(CHAR_VALUE) VALUES(?)
>
>Ground of my reading is that type data is retrieved from Statement and not from FDODSC
of SQLDTA.
>
>  
>
>>Engine take it as type compatibility error to update column typed as CHAR to value
passed via setBinaryStream(null), though Network Client and Network Server does not take it
as error.
>>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>
>>                Key: DERBY-1610
>>                URL: http://issues.apache.org/jira/browse/DERBY-1610
>>            Project: Derby
>>         Issue Type: Bug
>>         Components: Network Server, Network Client
>>           Reporter: Tomohito Nakayama
>>        Assigned To: Tomohito Nakayama
>>        Attachments: TestNullChar.java
>>
>>
>>There exists difference between Engine and Network Client/Engine around type compatibility
judgement in character typed column when null value was passed as InputStream.
>>    
>>
>
>  
>

-- 
/*

        Tomohito Nakayama
        tomonaka@basil.ocn.ne.jp
        tomohito@rose.zero.ad.jp
        tmnk@apache.org

        Naka
        http://www5.ocn.ne.jp/~tomohito/TopPage.html

*/ 


Mime
View raw message