Having problem with null values in my DAS

["Chu, Wing (Exchange)" <WC...@Bear.com>]

I am wondering if anyone came across this.

 

I have a simple select A,B,C from TABLE1 where A=?

 

I have no problem get the DataObject back when all the values are not
null.

 

However, if any one of the value is null. I would get an object but the
values and the list is null.

 

This seems not right to me. Is there a configuration that I miss?

 

I am working with Oracle 10g

 

Thanks,

Wing

Re: Having problem with null values in my DAS

[litaojian <li...@21cn.com>]

You could check the config file ,  maybe has the command definition , omit the table definition,  
for example :
<config>
    <Command name="getAll" SQL="select * from DEMO " kind="Select">
            <resultDescription ...../> 
            .....
    </Command>
    <Table tableName="DEMO">>
            <Column columnName="xxx"></column>
             ......   
    </Table>
</config>




litaojian
2007-09-04



发件人： Chu, Wing (Exchange)
发送时间： 2007-08-30 06:34:17
收件人： tuscany-user@ws.apache.org
抄送： 
主题： Having problem with null values in my DAS

I am wondering if anyone came across this.
 
I have a simple select A,B,C from TABLE1 where A=?
 
I have no problem get the DataObject back when all the values are not null.
 
However, if any one of the value is null. I would get an object but the values and the list is null.
 
This seems not right to me. Is there a configuration that I miss?
 
I am working with Oracle 10g
 
Thanks,
Wing

Re: Having problem with null values in my DAS

[Amita Vadhavkar <am...@gmail.com>]

Will you please share the config file and the data/table info here, so I can
simulate
the condition. When tried with a simple sample, it seems that - when any
other column
other that the one mentioned in DAS as PK has null value, DAS is producing
correct
result. So, your details will help. Also, will you please see if the query
is including PK
in the SELECT clause.

Regards,
Amita

On 8/30/07, Chu, Wing (Exchange) <WC...@bear.com> wrote:
>
>  I am wondering if anyone came across this.
>
>
>
> I have a simple select A,B,C from TABLE1 where A=?
>
>
>
> I have no problem get the DataObject back when all the values are not
> null.
>
>
>
> However, if any one of the value is null. I would get an object but the
> values and the list is null.
>
>
>
> This seems not right to me. Is there a configuration that I miss?
>
>
>
> I am working with Oracle 10g
>
>
>
> Thanks,
>
> Wing
>
>
>
> ***********************************************************************
> Bear Stearns is not responsible for any recommendation, solicitation,
> offer or agreement or any information about any transaction, customer
> account or account activity contained in this communication.
> ***********************************************************************
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-user-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-user-help@ws.apache.org
>