Thanks For help. I used following function Platform.fetch(Database model, String sql, Table[] queryHints)
Now its working. Thanks a lot for help .I was trying for this for a long time. -----Original Message----- From: Thomas Dudziak [mailto:[EMAIL PROTECTED] Sent: Sunday, November 27, 2005 4:45 PM To: ddlutils-dev@db.apache.org Subject: Re: How can I write the data into xml file On 11/27/05, ravi <[EMAIL PROTECTED]> wrote: > I am not able to write the data into xml file. > > I am using DataWriter class for that.Code is as follows. > > DataWriter dw = new DataWriter(os ); > List list = platform.fetch(db,"SELECT * FROM DEPT"); > dw.write(list); > > I am getting error as > > Nov 27, 2005 4:27:48 PM org.apache.ddlutils.io.DataWriter write > WARNING: Cannot write normal dyna beans (type: result) Some JDBC drivers do not return enough metadata to identify the tables/columns returned, and thus DdlUtils cannot associate them to the model elements. Please use the fetch variant with table hints, and supply the table object for DEPT. Tom
