Tom Thanks for the info, I figured that out when I was going through the code. It is a pity as I am using PostgreSQL :(
Thanks again <vignesh/> "Winning solutions find the right balance between market needs and technical needs" -----Original Message----- From: Thomas Dudziak [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 3:37 PM To: [email protected] Subject: Re: How to get table info from DynaBeans in Iterator returned in query() or fetch()? On 2/21/06, Vignesh Swaminathan <[EMAIL PROTECTED]> wrote: > I want to use the Platform.query() method and then get table info > (SqlDynaClass) from the dynabean contained in the returned Iterator. > Is this possible? If yes, how do it do it? > > Currently I get a ClassCastException if I try to cast SqlDynaBean for > DynaBean returned and also an exception is thrown when I try > Database.getDynaClassFor(DynaBean) Depending on the database you're working against, DdlUtils may not be able to determine the table from the result set alone. E.g. PostgreSQL does not provide enough info for this. This is why there are variants of the fetch/query methods where you gan give table hints to DdlUtils. Only if DdlUtils can resolve the table(s) and column(s) in the result, set, a SqlDynaClass/SqlDynaBean is used, otherwise it is a plain DynaBean. Tom *************************************************************************************************** The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. This email does not constitute any commitment from Cordys Holding BV or any of its subsidiaries except when expressly agreed in a written agreement between the intended recipient and Cordys Holding BV or its subsidiaries. ***************************************************************************************************
