You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by TomohitoNakayama <to...@basil.ocn.ne.jp> on 2006/08/02 17:04:12 UTC

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.)

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

*/

Re: 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.)

Posted by TomohitoNakayama <to...@basil.ocn.ne.jp>.
Thanx.

I found it.

Best regards.

Dag H. Wanvik wrote:

>Hi,
>
>TomohitoNakayama <to...@basil.ocn.ne.jp> writes:
>
>  
>
>>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 ?
>>    
>>
>
>The DRDA_TYPE values in DRDAConstants correspond to the meta data
>reference values, cf. section 5.7 "FD:OCA Meta Data Summary", table
>5-11 "MDD References Used in Early Environmental Descriptors" in
>"DRDA, Version 3, Volume 1".
>
>Dag
>
>
>  
>

-- 
/*

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

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

*/

Re: 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.)

Posted by "Dag H. Wanvik" <Da...@Sun.COM>.
Hi,

TomohitoNakayama <to...@basil.ocn.ne.jp> writes:

> 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 ?

The DRDA_TYPE values in DRDAConstants correspond to the meta data
reference values, cf. section 5.7 "FD:OCA Meta Data Summary", table
5-11 "MDD References Used in Early Environmental Descriptors" in
"DRDA, Version 3, Volume 1".

Dag