Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what does Transient means for a column in View Object selected columns?

legolas_wNov 28 2006 — edited Nov 28 2006
Hi
Thank you for reading my post
I have a view Object which I add two Business components to it
-Bankpayment
-AccountType

In the query that i write to select some of required field i add all fields from those two compoents.
here is the sql statement:
SELECT Bankpayment.id,
       Bankpayment.amount,
       Bankpayment.sourceBankCode,
       Bankpayment.invoiceCode,
       Bankpayment.invoiceDate,
       Bankpayment.startDate,
       Bankpayment.endData,
       Bankpayment.serviceType,
       Bankpayment.additionDate,
case Bankpayment.approved
when 1 then 'Yes'
when 0 then 'No'
end as approved2,
case        Bankpayment.defered
when 1 then 'Yes'
when 0 then 'No'
end as defered2,

case Bankpayment.status
when '0' then 'Pending'
when '1' then 'Approved'
when '2' then 'Rejected'
end as status2,


       Bankpayment.approveDate,
       Bankpayment.deferDate,
	Bankpayment.defer_reason,
       Bankpayment.user_ID,
AccountType.account_type,
AccountType.Account_description
FROM BANKPAYMENT Bankpayment,AccountType AccountType
WHERE user_ID=? and        Bankpayment.serviceType=AccountType.id
something is odd that Account_type is not shown under attributes node and also i should say that all fields of the second component are marked as Transient , also some of the first table columns are marked Transient .
can some one tell me wht does it means ?

the other odd thing is that, when i execute the above query in Mysql manager, it shows the correct result for all columns but when i use it in an ADF table (binding) it does not shows second table column's values.
is it related to that Transient stuff?

The other thing is that, i used Database physical fields name for my query, is it ok?

here is an image which show the View object with cmplete details

http://i14.tinypic.com/48eec6v.jpg

Thanks
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2006
Added on Nov 28 2006
2 comments
559 views