Please see our nightly build if you can download from there - (last successful is on Sep 5th) http://incubator.apache.org/tuscany/tuscany-downloads-documentations.html
http://vmbuild.apache.org:8080/continuum/workingCopy.action?projectId=36&projectName=Apache+Tuscany+DAS+Implementation+project&userDirectory=distribution/binary/target For having all customer records in one xml file - you are using the same stream in a loop to write each serialized data object. But I guess you will need to a bit of file manipulation to remove repeated headers like below, <?xml version="1.0" encoding="ASCII"?> <cust1:cust1 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > xmlns:cust1="cust1" > xmlns:this="http:///org.apache.tuscany.das.rdb.test/customer.xsd" > xsi:type="this:Customer"> Or you can loop through all DO records as of now, but instead of directly serializing each DO in XML, do getInt("ID"), getString("LASTNAME"),.... in a file - OR if you are using static SDO approach (i.e. have say customer.xsd and use static SDO APIS) CUSTOMET.getId(), CUSTOMER.getLastName()... But I am not sure about any simpler alternative right now. Regards, Amita On 9/7/07, Eborn, Eric D <[EMAIL PROTECTED]> wrote: > > I am using beta1. However, the proxy I connect through disallows > external SVN servers. Is there an HTTP download of the trunk binary? > > That xml output looks good, except, is it possible to have it display > all 4 customer records in the single XML file? > > > -----Original Message----- > > From: Amita Vadhavkar [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 06, 2007 11:25 PM > > To: tuscany-user@ws.apache.org > > Subject: Re: RDB DAS read, then write XML file for data export > > > > Hi , > > Will you please try the example with latest SDO and DAS code from svn > > trunk, > > > > There are some differences in DAS-beta1 (older releases) and the > current > > one > > from > > https://svn.apache.org/repos/asf/incubator/tuscany/java/. These > > differences > > are due to some > > changes in SDO. With the latest one, I am getting something like > below- > > for > > > System.out.println(XMLHelper.INSTANCE.save(((DataObject)customers.iterat > or > > ().next()), > > "cust1", "cust1")); > > > > Result - > > > > <?xml version="1.0" encoding="ASCII"?> > > <cust1:cust1 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > xmlns:cust1="cust1" > > xmlns:this="http:///org.apache.tuscany.das.rdb.test/customer.xsd" > > xsi:type="this:Customer"> > > <ID>1</ID> > > <lastName>Williams</lastName> > > <address>1212 foobar lane</address> > > </cust1:cust1> > > > > Are you using DAS-beta1? > > > > Regards, > > Amita > > On 9/6/07, Eborn, Eric D <[EMAIL PROTECTED]> wrote: > > > > > > I came across this excellent article about how to do basics with SDO > > > including writing out a datagraph to an XML document. > > > > > > > http://www.ibm.com/developerworks/xml/library/ws-sdoxmlschema/index.html > > > > > > What I wish to do is similar, I wish to read data from a MySQL > database > > > using RDB DAS and then store that information into an XML file using > > > XMLHelper (I suppose this is the preferred way). This XML data will > > > eventually be destined for a JMS message for export to its > destination. > > > > > > I'm building off of the sample Customers for now until I get a > working > > > model... > > > > > > So far I've added this code to my Customer sample code: > > > > > > private void outputXML() throws Exception { > > > > > > Command readAll = das.getCommand("AllCustomers"); > > > CUSTOMER = readAll.executeQuery(); > > > DataObject resultSet = > > > DataFactory.INSTANCE.create(RES_NAMESPACE, "resultSetType"); > > > > > > OutputStream stream = new FileOutputStream(RES_XML); > > > > > > List allCustomers = CUSTOMER.getList("CUSTOMER"); > > > int i = 1; > > > for(i=0; i<allCustomers.size(); i++) > > > { > > > > > > XMLHelper.INSTANCE.save((DataObject)allCustomers.get(i), > RES_NAMESPACE, > > > "CUSTOMER", stream); > > > stream.write(13); > //writes > > > a carraige return to the XML file. > > > stream.write(10); > > > } > > > > > > } > > > > > > This does generate an XML file, but its contents are all wrong... I > > > want it to follow the XSD: > > > > > > <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" > > > xmlns="http://www.example.com/RESULTSET" > > > targetNamespace="http://www.example.com/RESRESULTSET"> > > > > > > <xsd:element name="CUSTOMER" type="resultSetType"/> > > > > > > <xsd:complexType name="resultSetType"> > > > <xsd:sequence> > > > <xsd:element name="LASTNAME" type="xsd:string"/> > > > <xsd:element name="ADDRESS" type="xsd:string"/> > > > <xsd:element name="ID" type="xsd:positiveInteger"/> > > > </xsd:sequence> > > > </xsd:complexType> > > > > > > </xsd:schema> > > > > > > But my program outputs: > > > <?xml version="1.0" encoding="ASCII"?> > > > <resSS:CUSTOMER > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > > xmlns:das="http:///org.apache.tuscany.das.rdb/das" > > > xmlns:resSS="http://www.example.com/resSS" > xsi:type="das:CUSTOMER" > > > ID="1" LASTNAME="John" ADDRESS="USA"/> > > > <?xml version="1.0" encoding="ASCII"?> > > > <resSS:CUSTOMER > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > > xmlns:das="http:///org.apache.tuscany.das.rdb/das" > > > xmlns:resSS="http://www.example.com/resSS" > xsi:type="das:CUSTOMER" > > > ID="2" LASTNAME="BlueBerry" ADDRESS="INDIA"/> > > > <?xml version="1.0" encoding="ASCII"?> > > > <resSS:CUSTOMER > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > > xmlns:das="http:///org.apache.tuscany.das.rdb/das" > > > xmlns:resSS="http://www.example.com/resSS" > xsi:type="das:CUSTOMER" > > > ID="3" LASTNAME="Patrick" ADDRESS="UK"/> > > > <?xml version="1.0" encoding="ASCII"?> > > > <resSS:CUSTOMER > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > > xmlns:das="http:///org.apache.tuscany.das.rdb/das" > > > xmlns:resSS="http://www.example.com/resSS" > xsi:type="das:CUSTOMER" > > > ID="4" LASTNAME="Jane" ADDRESS="UN"/> > > > <?xml version="1.0" encoding="ASCII"?> > > > <resSS:CUSTOMER > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > > xmlns:das="http:///org.apache.tuscany.das.rdb/das" > > > xmlns:resSS="http://www.example.com/resSS" > xsi:type="das:CUSTOMER" > > > ID="5" LASTNAME="Jenny" ADDRESS="USA"/> > > > > > > I'm hoping that someone has done something similar and could point > me in > > > the right direction because at the moment im generating content for > 5 > > > different xml files into one file, when I'd like to have all the > rows of > > > data contained in one xml file in the format: > > > > > > <XML> > > > <CUSTOMER> > > > <ID>1</ID> > > > <LASTNAME>John</LASTNAME> > > > <ADDRESS>USA</ADDRESS> > > > </CUSTOMER> > > > <CUSTOMER> > > > <ID>2</ID> > > > <LASTNAME>Blueberry</LASTNAME> > > > <ADDRESS>India</ADDRESS> > > > </CUSTOMER> > > > > > > Etc... > > > > > > Thanks > > > Eric > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >