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]
