Sure, contents from [1]
<Config xmlns="http:///org.apache.tuscany.das.rdb/config.xsd";>
<!--Uncomment below for derby test-->
<ConnectionInfo>
<ConnectionProperties
driverClass="org.apache.derby.jdbc.EmbeddedDriver"
databaseURL="jdbc:derby:target/dastest; create = true"
loginTimeout="600000"/>
</ConnectionInfo>
<!--Uncomment below for MySQL test-->
<!--
<ConnectionInfo>
<ConnectionProperties
driverClass="com.mysql.jdbc.Driver"
databaseURL="jdbc:mysql://localhost/dastest"
userName="dastest"
password="dastest"
loginTimeout="600000"/>
</ConnectionInfo>
-->
<Command name="AllCustomers" SQL="select * from CUSTOMER" kind="Select"/>
<Table tableName="CUSTOMER">
<Column columnName="ID" primaryKey="true"/>
</Table>
<Command name="NamedCustomers" SQL="{call GETNAMEDCUSTOMERS(?,?)}"
kind="procedure">
<Parameter direction="IN" index="1"
columnType="commonj.sdo.String"/>
<Parameter direction="OUT" index="2"
columnType="commonj.sdo.IntObject"/>
</Command>
</Config>
[1]
https://svn.apache.org/repos/asf/incubator/tuscany/java/das/samples/customer/src/main/resources/Customers.xml
On 9/5/07, Eborn, Eric D <[EMAIL PROTECTED]> wrote:
> No, thank you for volunteering you assistance. I don't have access to
> outside svn's, would you mind posting the new Customer.xml file so I can
> verify its contents?
>
> > -----Original Message-----
> > From: Luciano Resende [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, September 05, 2007 10:16 AM
> > To: tuscany-user@ws.apache.org
> > Subject: Re: Help with Tuscany Customer's Demo using MySQL
> >
> > Great !!! I have also already applied the suggested changes for the
> > config file connection info under the latest version in trunk. Thanks
> > for finding that... and let me know if you find anything else, or have
> > any other questions.
> >
> > On 9/5/07, Eborn, Eric D <[EMAIL PROTECTED]> wrote:
> > > This is correct
> > >
> > > > -----Original Message-----
> > > > From: Luciano Resende [mailto:[EMAIL PROTECTED]
> > > > Sent: Wednesday, September 05, 2007 9:53 AM
> > > > To: tuscany-user@ws.apache.org
> > > > Subject: Re: Help with Tuscany Customer's Demo using MySQL
> > > >
> > > > Great !!! But just to be clear, the original config file [1] is
> not
> > > > using <ResultDescriptor>, right ?
> > > >
> > > > [1]
> > > >
> > >
> https://svn.apache.org/repos/asf/incubator/tuscany/java/das/samples/cust
> > > om
> > > > er/src/main/resources/Customers.xml
> > > >
> > > > On 9/5/07, Eborn, Eric D <[EMAIL PROTECTED]> wrote:
> > > > > Well I found the issue...
> > > > >
> > > > > Once again in my Config file:
> > > > >
> > > > > I had:
> > > > >
> > > > > <ResultDescriptor columnName="ID" tableName="MYCUSTOMER"
> > > > > columnType="commonj.sdo.Int"/>
> > > > >
> > > > > Changed it to:
> > > > >
> > > > > <ResultDescriptor columnName="ID" tableName="CUSTOMER"
> > > > > columnType="commonj.sdo.Int"/>
> > > > >
> > > > > And SUCCESS!!
> > > > >
> > > > > Is it really necessary for mysql to specify so much the Command
> and
> > > > > Table tags like it seems to be for oracle?
> > > > >
> > > > > If so, you can update the demo download for future users. I
> think
> > > it
> > > > > may be because if I don't replace the original:
> > > > >
> > > > > <Command name="AllCustomers" SQL="select * from CUSTOMER"
> > > > > kind="Select"/>
> > > > >
> > > > > <Table tableName="CUSTOMER">
> > > > > <Column columnName="ID" primaryKey="true"/>
> > > > > </Table>
> > > > >
> > > > > With:
> > > > >
> > > > > <Command name="AllCustomers" SQL="select * from CUSTOMER"
> > > > > kind="Select">
> > > > > <ResultDescriptor columnName="ID"
> > > tableName="CUSTOMER"
> > > > > columnType="commonj.sdo.Int"/>
> > > > > <ResultDescriptor columnName="LASTNAME"
> > > > > tableName="CUSTOMER" columnType="commonj.sdo.String"/>
> > > > > <ResultDescriptor columnName="ADDRESS"
> > > > > tableName="CUSTOMER" columnType="commonj.sdo.String"/>
> > > > > </Command>
> > > > >
> > > > > <Table tableName="CUSTOMER">
> > > > > <Column columnName = "ID" primaryKey="true" />
> > > > > <Column columnName = "LASTNAME" />
> > > > > <Column columnName = "ADDRESS" />
> > > > > </Table>
> > > > >
> > > > > I get that same java.lang.IllegalArgumentException: Class
> 'CUSTOMER'
> > > > > does not have a feature named 'ID' error
> > > > >
> > > > > Let others benefit from my struggles please. :)
> > > > >
> > > > > Great little product btw, once u get it workin
> > > > >
> > > > > Eric
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Eborn, Eric D
> > > > > > Sent: Wednesday, September 05, 2007 9:27 AM
> > > > > > To: tuscany-user@ws.apache.org
> > > > > > Subject: RE: Help with Tuscany Customer's Demo using MySQL
> > > > > >
> > > > > > Correct, that is the only error. I've been logging using root
> > > with
> > > > > all
> > > > > > access so I don't imagine that is the problem, though I'll try
> > > that
> > > > > too.
> > > > > > I've verified that it is correctly generating the table also
> > > (using
> > > > > > mysql toolset), also the Customer example correctly displays
> the
> > > SQL
> > > > > > Select results (just before it fails on the insert record).
> > > > > >
> > > > > > I've tried other approaches to find this problem, like
> commenting
> > > out
> > > > > > the problem insert command so that it jumps straight from the
> > > select
> > > > > > statement to the Update record command, where it also erred
> with:
> > > > > >
> > > > > > [java] Result:select all customers
> > > > > > [java] ID:0 LASTNAME:Eric ADDRESS:USA
> > > > > > [java] ID:0 LASTNAME:Amita ADDRESS:INDIA
> > > > > > [java] ID:0 LASTNAME:Patrick ADDRESS:UK
> > > > > > [java] ID:0 LASTNAME:Jane ADDRESS:UN
> > > > > > [java] Result:update first customer
> > > > > > [java] Exception in thread "main"
> java.lang.NullPointerException
> > > > > > [java] at
> > > > > >
> > > > >
> > >
> org.apache.tuscany.das.rdb.generator.impl.UpdateGenerator.fillParameter(
> > > > > > UpdateGenerator.java:205)
> > > > > > [java] at
> > > > > >
> > > > >
> > >
> org.apache.tuscany.das.rdb.generator.impl.UpdateGenerator.createParamete
> > > > > > r(UpdateGenerator.java:226)
> > > > > > [java] at
> > > > > >
> > > > >
> > >
> org.apache.tuscany.das.rdb.generator.impl.UpdateGenerator.getUpdateComma
> > > > > > nd(UpdateGenerator.java:104)
> > > > > > [java] at
> > > > > >
> > > > >
> > >
> org.apache.tuscany.das.rdb.impl.ChangeFactory.getUpdateCommand(ChangeFac
> > > > > > tory.java:154)
> > > > > > [java] at
> > > > > >
> > > > >
> > >
> org.apache.tuscany.das.rdb.impl.ChangeFactory.createUpdateOperation(Chan
> > > > > > geFactory.java:69)
> > > > > > [java] at
> > > > > >
> > > > >
> > >
> org.apache.tuscany.das.rdb.impl.ChangeSummarizer.createChange(ChangeSumm
> > > > > > arizer.java:115)
> > > > > > [java] at
> > > > > >
> > > > >
> > >
> org.apache.tuscany.das.rdb.impl.ChangeSummarizer.loadChanges(ChangeSumma
> > > > > > rizer.java:80)
> > > > > > [java] at
> > > > > >
> > > > >
> > >
> org.apache.tuscany.das.rdb.impl.ApplyChangesCommandImpl.execute(ApplyCha
> > > > > > ngesCommandImpl.java:64)
> > > > > > [java] at
> > > > > >
> > >
> org.apache.tuscany.das.rdb.impl.DASImpl.applyChanges(DASImpl.java:310)
> > > > > > [java] at
> > > > > >
> > > > >
> > >
> org.apache.tuscany.samples.das.customer.CustomerClient.changeFirstCustom
> > > > > > erName(CustomerClient.java:212)
> > > > > > [java] at
> > > > > >
> > > > >
> > >
> org.apache.tuscany.samples.das.customer.CustomerClient.main(CustomerClie
> > > > > > nt.java:131)
> > > > > > [java] Java Result: 1
> > > > > >
> > > > > > And then commented out the update, so it jumped straight to
> the
> > > delete
> > > > > > last record command, where it also erred by not deleting the
> last
> > > > > > record:
> > > > > >
> > > > > > [java] Result:select all customers
> > > > > > [java] ID:0 LASTNAME:Eric ADDRESS:USA
> > > > > > [java] ID:0 LASTNAME:Amita ADDRESS:INDIA
> > > > > > [java] ID:0 LASTNAME:Patrick ADDRESS:UK
> > > > > > [java] ID:0 LASTNAME:Jane ADDRESS:UN
> > > > > > [java] Result:delete last customer
> > > > > > [java] Deleting customer named: Jane
> > > > > > [java] ID:0 LASTNAME:Eric ADDRESS:USA
> > > > > > [java] ID:0 LASTNAME:Amita ADDRESS:INDIA
> > > > > > [java] ID:0 LASTNAME:Patrick ADDRESS:UK
> > > > > > [java] ID:0 LASTNAME:Jane ADDRESS:UN
> > > > > >
> > > > > > Perhaps we can triangulate the problem? There seems to be an
> > > issue
> > > > > with
> > > > > > applying the updates perhaps?
> > > > > >
> > > > > > It kind of baffles me seeing that you haven't experienced the
> same
> > > > > > issues, hmmm...
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: Luciano Resende [mailto:[EMAIL PROTECTED]
> > > > > > > Sent: Wednesday, September 05, 2007 8:52 AM
> > > > > > > To: tuscany-user@ws.apache.org
> > > > > > > Subject: Re: Help with Tuscany Customer's Demo using MySQL
> > > > > > >
> > > > > > > Hey Eric
> > > > > > >
> > > > > > > I had it working in my environment yesterday, and I
> thought
> > > you
> > > > > had
> > > > > > > it too after the changes on the connection info. In my case,
> I
> > > have
> > > > > a
> > > > > > > dastest user in mySQL, I created the empty database in mySQL
> and
> > > > > > > granted all the permissions to the dastest user. After that
> the
> > > > > > > customer sample worked fine. Maybe you could check if the
> mySQL
> > > > > table
> > > > > > > was created properly, and I can check further in my env. BTW
> the
> > > > > only
> > > > > > > issue you are having now is the
> > > > > > > exception below ?
> > > > > > >
> > > > > > > > [java] Exception in thread "main"
> > > > > > java.lang.IllegalArgumentException:
> > > > > > > > Class 'CUSTOMER' does not have a feature named 'ID'
> > > > > > >
> > > > > > >
> > > > > > > On 9/5/07, Eborn, Eric D <[EMAIL PROTECTED]> wrote:
> > > > > > > > Additional progress:
> > > > > > > >
> > > > > > > > Making the following additional changes to the
> Customers.xml
> > > file
> > > > > > > > allowed the program to create the graph it seems, at least
> it
> > > is
> > > > > > > > displaying the select all customers results now in the
> > > console:
> > > > > > > >
> > > > > > > > <Command name="AllCustomers" SQL="select * from
> CUSTOMER"
> > > > > > > > kind="Select">
> > > > > > > > <ResultDescriptor columnName="ID"
> > > tableName="MYCUSTOMER"
> > > > > > > > columnType="commonj.sdo.Int"/>
> > > > > > > > <ResultDescriptor columnName="LASTNAME"
> > > > > tableName="CUSTOMER"
> > > > > > > > columnType="commonj.sdo.String"/>
> > > > > > > > <ResultDescriptor columnName="ADDRESS"
> > > > > tableName="CUSTOMER"
> > > > > > > > columnType="commonj.sdo.String"/>
> > > > > > > > </Command>
> > > > > > > >
> > > > > > > > <Table tableName="CUSTOMER">
> > > > > > > > <Column columnName = "ID" primaryKey="true" />
> > > > > > > > <Column columnName = "LASTNAME" />
> > > > > > > > <Column columnName = "ADDRESS" />
> > > > > > > > </Table>
> > > > > > > >
> > > > > > > >
> > > > > > > > HOWEVER, note that I now get this error message:
> > > > > > > >
> > > > > > > > [java] Result:insert new customer
> > > > > > > > [java] Exception in thread "main"
> > > > > > java.lang.IllegalArgumentException:
> > > > > > > > Class 'CUSTOMER' does not have a feature named 'ID'
> > > > > > > > [java] at
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataO
> > > > > > > > bjectUtil.java:2104)
> > > > > > > > [java] at
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUt
> > > > > > > > il.java:2247)
> > > > > > > > [java] at
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.
> > > > > > > > java:1968)
> > > > > > > > [java] at
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUti
> > > > > > > > l.java:1883)
> > > > > > > > [java] at
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUti
> > > > > > > > l.java:1877)
> > > > > > > > [java] at
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil.setInt(DataObjectUtil.java:52
> > > > > > > > 7)
> > > > > > > > [java] at
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.impl.DataObjectImpl.setInt(DataObjectImpl.java:52
> > > > > > > > 5)
> > > > > > > > [java] at
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.samples.das.customer.CustomerClient.addCustomer(Custo
> > > > > > > > merClient.java:173)
> > > > > > > > [java] at
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.samples.das.customer.CustomerClient.main(CustomerClie
> > > > > > > > nt.java:126)
> > > > > > > > [java] Java Result: 1
> > > > > > > >
> > > > > > > > Stemming from the newCustomer.setInt("ID", 5);
> > > command.
> > > > > > (even
> > > > > > > > when I change the order to setString first, it says there
> is
> > > no
> > > > > > LASTNAME
> > > > > > > > feature...
> > > > > > > >
> > > > > > > > public final void addCustomer() {
> > > > > > > > Command read = das.getCommand("AllCustomers");
> > > > > > > > DataObject root = read.executeQuery();
> > > > > > > >
> > > > > > > > DataObject newCustomer =
> > > > > root.createDataObject("CUSTOMER");
> > > > > > > > newCustomer.setInt("ID", 5);
> > > > > > > > newCustomer.setString("LASTNAME", "Jenny");
> > > > > > > > newCustomer.setString("ADDRESS", "USA");
> > > > > > > >
> > > > > > > > das.applyChanges(root);
> > > > > > > > }
> > > > > > > >
> > > > > > > > Por Favor!!!!
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: Eborn, Eric D
> > > > > > > > > Sent: Wednesday, September 05, 2007 7:34 AM
> > > > > > > > > To: tuscany-user@ws.apache.org
> > > > > > > > > Subject: RE: Help with Tuscany Customer's Demo using
> MySQL
> > > > > > > > >
> > > > > > > > > I've had little luck with my remaining problem, however,
> any
> > > > > idea
> > > > > > what
> > > > > > > > > java.lang.IllegalArgumentException: Class 'CUSTOMER'
> does
> > > not
> > > > > have
> > > > > > a
> > > > > > > > > feature named 'ID' means I've done?
> > > > > > > > >
> > > > > > > > > It's creating the database, but perhaps never correctly
> > > > > > constructing
> > > > > > > > the
> > > > > > > > > data graph?
> > > > > > > > >
> > > > > > > > > If you notice, the program output is supposed to display
> the
> > > > > four
> > > > > > > > lines
> > > > > > > > > of db entries after each operation (as it does using
> derby),
> > > but
> > > > > > with
> > > > > > > > > mysql, none. :(
> > > > > > > > >
> > > > > > > > > I was reading about oracle and das this morning:
> > > > > > > > > https://issues.apache.org/jira/browse/TUSCANY-1355
> > > > > > > > >
> > > > > > > > > Is this problem applicable? I may tinker with those
> ideas
> > > in
> > > > > the
> > > > > > > > > meantime. Plz help, seems like it would be a common
> issue
> > > when
> > > > > > > > dealing
> > > > > > > > > with mysql. Especially since it's the most basic of the
> > > demos!
> > > > > > > > >
> > > > > > > > > -Eric
> > > > > > > > >
> > > > > > > > > > -----Original Message-----
> > > > > > > > > > From: Luciano Resende [mailto:[EMAIL PROTECTED]
> > > > > > > > > > Sent: Tuesday, September 04, 2007 3:01 PM
> > > > > > > > > > To: tuscany-user@ws.apache.org
> > > > > > > > > > Subject: Re: Help with Tuscany Customer's Demo using
> MySQL
> > > > > > > > > >
> > > > > > > > > > Thanks Eric, I'll update the customer.xml and steps on
> the
> > > > > > readme
> > > > > > > > for
> > > > > > > > > > better/simpler support of MySQL
> > > > > > > > > >
> > > > > > > > > > On 9/4/07, Eborn, Eric D <[EMAIL PROTECTED]>
> wrote:
> > > > > > > > > > > I never explained how I got over the other errors...
> > > sorry.
> > > > > > > > > Basically I
> > > > > > > > > > > just had to peck at the Customers.xml config file.
> It
> > > seems
> > > > > > > > rather
> > > > > > > > > > > outdated, perhaps someone could permanently modify
> the
> > > > > example
> > > > > > > > > download
> > > > > > > > > > > for future users, I made the following changes:
> > > > > > > > > > >
> > > > > > > > > > > <ConnectionInfo>
> > > > > > > > > > > <ConnectionProperties
> > > > > > > > > > >
> > > > > > driverClass="com.mysql.jdbc.Driver"
> > > > > > > > > > > password="foobar"
> > > > > > > > > > > userName="root"
> > > > > > > > > > >
> > > > > > > > > > > databaseURL="jdbc:mysql://localhost:3306/dastest"
> > > > > > > > > > >
> loginTimeout="600000">
> > > > > > > > > > > </ConnectionProperties>
> > > > > > > > > > > </ConnectionInfo>
> > > > > > > > > > >
> > > > > > > > > > > Note the difference:
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> https://svn.apache.org/repos/asf/incubator/tuscany/java/das/samples/cust
> > > > > > > > > > > omer/src/main/resources/Customers.xml
> > > > > > > > > > >
> > > > > > > > > > > Make sure that you've downloaded an installed the
> proper
> > > > > > > > > Connector/J,
> > > > > > > > > > > and that you have the path in your CLASSPATH env
> > > variable or
> > > > > > copy
> > > > > > > > > the
> > > > > > > > > > > jar to your JAVA_HOME/lib/ext dir.
> > > > > > > > > > >
> > > > > > > > > > > Also you'll likely have to manually create the
> dastest
> > > > > > database in
> > > > > > > > > mysql
> > > > > > > > > > > (leave it empty (without any tables), just create
> the
> > > db).
> > > > > > > > > > >
> > > > > > > > > > > > -----Original Message-----
> > > > > > > > > > > > From: Eborn, Eric D
> > > > > > > > > > > > Sent: Tuesday, September 04, 2007 12:31 PM
> > > > > > > > > > > > To: tuscany-user@ws.apache.org
> > > > > > > > > > > > Subject: RE: Help with Tuscany Customer's Demo
> using
> > > MySQL
> > > > > > > > > > > >
> > > > > > > > > > > > Update:
> > > > > > > > > > > >
> > > > > > > > > > > > I bypassed these errors as I will explain below.
> > > > > > > > > > > >
> > > > > > > > > > > > NOW I have new errors :) It seems to start
> running
> > > > > > correctly,
> > > > > > > > > I've
> > > > > > > > > > > > confirmed that it creates the dastest table
> CUSTOMER.
> > > And
> > > > > > fills
> > > > > > > > > it
> > > > > > > > > > > with
> > > > > > > > > > > > 4 records. However, it fails in
> CustomerClient.java
> > > at
> > > > > the
> > > > > > > > line:
> > > > > > > > > '171
> > > > > > > > > > > > newCustomer.setInt("ID", 5);'
> > > > > > > > > > > >
> > > > > > > > > > > > I had read in another message:
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> http://mail-archives.apache.org/mod_mbox/ws-tuscany-dev/200706.mbox/%3C1
> > > > > > > > > > > > [EMAIL PROTECTED]
> > > > > > > > > > > > Exception in thread "main"
> > > > > > java.lang.IllegalArgumentException:
> > > > > > > > > Class
> > > > > > > > > > > > 'DataGraphRoot'
> > > > > > > > > > > > does not have a feature named 'MYCUSTOMER'...
> which is
> > > > > > similar,
> > > > > > > > > but
> > > > > > > > > > > > seemed to stem from his use of oracle or SQLServer
> > > (not
> > > > > > mysql).
> > > > > > > > > Any
> > > > > > > > > > > > additional help is welcome... In the meantime,
> I'll
> > > > > continue
> > > > > > to
> > > > > > > > > work
> > > > > > > > > > > at
> > > > > > > > > > > > it.
> > > > > > > > > > > >
> > > > > > > > > > > > (error messages as follows)
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> D:\data\eeborn\Desktop\tuscany-das-1.0-incubating-beta1\samples\customer
> > > > > > > > > > > > >ant
> > > > > > > > > > > > Buildfile: build.xml
> > > > > > > > > > > >
> > > > > > > > > > > > build:
> > > > > > > > > > > > [javac] Compiling 1 source file to
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> D:\data\eeborn\Desktop\tuscany-das-1.0-incubating-beta1\samples\customer
> > > > > > > > > > > >
> > > > > > > > > > > > run:
> > > > > > > > > > > > [java] ********************** connection info
> > > from
> > > > > > config
> > > > > > > > > file
> > > > > > > > > > > > ************************
> > > > > > > > > > > > [java]
> > > > > databaseURL:jdbc:mysql://localhost:3306/dastest
> > > > > > > > > > > > userName:root password:foobar
> > > > > > > > > > > > [java]
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> ************************************************************************
> > > > > > > > > > > > ********
> > > > > > > > > > > > [java] [Messages.java 3params:
> > > > > > > > > > > > getBundle(com.mysql.jdbc.LocalizedErrorMessages)
> > > > > > > > > > > > [java] Setting up for mysql run!
> > > > > > > > > > > > [java] Dropping tables
> > > > > > > > > > > > [java] Dropping procedures
> > > > > > > > > > > > [java] Creating tables
> > > > > > > > > > > > [java] Creating procedures
> > > > > > > > > > > > [java] Inserting data in tables
> > > > > > > > > > > > [java] Database setup complete!
> > > > > > > > > > > > [java] log4j:WARN No appenders could be found
> for
> > > > > > logger
> > > > > > > > > > > > (org.apache.tuscany.das.rdb.impl.Parameters).
> > > > > > > > > > > > [java] log4j:WARN Please initialize the log4j
> > > system
> > > > > > > > > properly.
> > > > > > > > > > > > [java] Result:select all customers
> > > > > > > > > > > > [java] Result:insert new customer
> > > > > > > > > > > > [java] Exception in thread "main"
> > > > > > > > > > > > java.lang.IllegalArgumentException: Class
> 'CUSTOMER'
> > > does
> > > > > > not
> > > > > > > > have
> > > > > > > > > a
> > > > > > > > > > > > feature named 'ID'
> > > > > > > > > > > > [java] at
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.setFeatureName(DataO
> > > > > > > > > > > > bjectUtil.java:2104)
> > > > > > > > > > > > [java] at
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.process(DataObjectUt
> > > > > > > > > > > > il.java:2247)
> > > > > > > > > > > > [java] at
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.init(DataObjectUtil.
> > > > > > > > > > > > java:1968)
> > > > > > > > > > > > [java] at
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUti
> > > > > > > > > > > > l.java:1883)
> > > > > > > > > > > > [java] at
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil$Accessor.create(DataObjectUti
> > > > > > > > > > > > l.java:1877)
> > > > > > > > > > > > [java] at
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.util.DataObjectUtil.setInt(DataObjectUtil.java:52
> > > > > > > > > > > > 7)
> > > > > > > > > > > > [java] at
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.sdo.impl.DataObjectImpl.setInt(DataObjectImpl.java:52
> > > > > > > > > > > > 5)
> > > > > > > > > > > > [java] at
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.samples.das.customer.CustomerClient.addCustomer(Custo
> > > > > > > > > > > > merClient.java:172)
> > > > > > > > > > > > [java] at
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.samples.das.customer.CustomerClient.main(CustomerClie
> > > > > > > > > > > > nt.java:126)
> > > > > > > > > > > > [java] Java Result: 1
> > > > > > > > > > > >
> > > > > > > > > > > > BUILD SUCCESSFUL
> > > > > > > > > > > > Total time: 2 seconds
> > > > > > > > > > > >
> > > > > > > > > > > > > -----Original Message-----
> > > > > > > > > > > > > From: Eborn, Eric D
> > > > > > > > > > > > > Sent: Tuesday, September 04, 2007 11:36 AM
> > > > > > > > > > > > > To: tuscany-user@ws.apache.org
> > > > > > > > > > > > > Subject: Help with Tuscany Customer's Demo using
> > > MySQL
> > > > > > > > > > > > >
> > > > > > > > > > > > > I've run the demo using Derby, however, I've
> been
> > > > > > unsuccessful
> > > > > > > > > in
> > > > > > > > > > > > doing
> > > > > > > > > > > > > so with MySQL.
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > I'm running the latest mysql and connector/J,
> > > downloaded
> > > > > > them
> > > > > > > > > this
> > > > > > > > > > > > week.
> > > > > > > > > > > > >
> > > > > > > > > > > > > Please advise.
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > When I comment out the Derby config and
> uncomment
> > > the
> > > > > > MySql
> > > > > > > > > config,
> > > > > > > > > > > I
> > > > > > > > > > > > > get the following error:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > BUILD SUCCESSFUL
> > > > > > > > > > > > >
> > > > > > > > > > > > > Total time: 0 seconds
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > D:\data\eeborn\Desktop\TUSCAN~1.0-I\samples\customer>ant
> > > > > > > > > > > > >
> > > > > > > > > > > > > Buildfile: build.xml
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > run:
> > > > > > > > > > > > >
> > > > > > > > > > > > > [java] Exception in thread "main"
> > > > > > > > > java.lang.RuntimeException:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > org.eclipse.emf.ecore.resource.Resource$IOWrappedException:
> > > > > > > > > Feature
> > > > > > > > > > > > > 'user' not foun
> > > > > > > > > > > > >
> > > > > > > > > > > > > d. (http:///temp.xml <http://temp.xml> , 50, 33)
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > [java] at
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.das.rdb.util.ConfigUtil.loadConfig(ConfigUtil.java:54
> > > > > > > > > > > > > )
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > [java] at
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.samples.das.customer.CustomerClient.main(CustomerClie
> > > > > > > > > > > > > nt.java:86)
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > [java] Caused by:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > org.eclipse.emf.ecore.resource.Resource$IOWrappedException:
> > > > > > > > > Feature
> > > > > > > > > > > > > 'user' not found. (http:///temp.xml
> > > <http://temp.xml> ,
> > > > > > 50,
> > > > > > > > 33)
> > > > > > > > > > > > >
> > > > > > > > > > > > > ....90 more
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > I have this config Customers.xml
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > <!--Uncomment below for MySQL
> test-->
> > > > > > > > > > > > >
> > > > > > > > > > > > > <ConnectionInfo>
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > <ConnectionProperties
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > driverClass="com.mysql.jdbc.Driver"
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > databaseURL="jdbc:mysql://localhost:3306/test"
> > > > > > > > > > > > >
> > > > > > > > > > > > > user="root"
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> password="foobar"
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > loginTimeout="600000">
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> </ConnectionProperties>
> > > > > > > > > > > > >
> > > > > > > > > > > > > </ConnectionInfo>
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > <!-- ConnectionInfo
> > > > > > > > > > > > >
> > > > > > > > > > > > > dataSource="java:comp/env/jdbc/dastest" THIS
> > > SECTION
> > > > > IS
> > > > > > > > > COMMENTED
> > > > > > > > > > > > OUT
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > contextAvailable="false">
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > <ConnectionProperties
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > >
> > > dataSourceClass="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
> > > > > > > > > > > > >
> > > > > > > > > > > > > user="root"
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > password="foobar"
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > key="193-155-248-97-234-56-100-241"
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > databaseName="test"
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > loginTimeout="600000">
> > > > > > > > > > > > >
> > > > > > > > > > > > > </ConnectionProperties>
> > > > > > > > > > > > >
> > > > > > > > > > > > > </ConnectionInfo -->
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > The section of the config that is commented out
> also
> > > > > fails
> > > > > > > > with:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > run:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > [java] Exception in thread "main"
> > > > > > > > > java.lang.RuntimeException:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > org.eclipse.emf.ecore.resource.Resource$IOWrappedException:
> > > > > > > > > Feature
> > > > > > > > > > > > > 'contextAvailab
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > le' not found. (http:///temp.xml
> <http://temp.xml> ,
> > > 55,
> > > > > > 30)
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > [java] at
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > >
> > > > >
> > >
> org.apache.tuscany.das.rdb.util.ConfigUtil.loadConfig(ConfigUtil.java:54
> > > > > > > > > > > > >
> > > > > > > > > > > > > )
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > >
> > > > > >
> > >
> ---------------------------------------------------------------------
> > > > > > > > > > > > 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]
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > --
> > > > > > > > > > Luciano Resende
> > > > > > > > > > Apache Tuscany Committer
> > > > > > > > > > http://people.apache.org/~lresende
> > > > > > > > > > http://lresende.blogspot.com/
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > >
> > >
> ---------------------------------------------------------------------
> > > > > > > > > > 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]
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > >
> ---------------------------------------------------------------------
> > > > > > > > To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> > > > > > > > For additional commands, e-mail:
> > > [EMAIL PROTECTED]
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > Luciano Resende
> > > > > > > Apache Tuscany Committer
> > > > > > > http://people.apache.org/~lresende
> > > > > > > http://lresende.blogspot.com/
> > > > > > >
> > > > > > >
> > > > >
> > >
> ---------------------------------------------------------------------
> > > > > > > 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]
> > > > >
> > > > >
> > > > >
> > >
> ---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > Luciano Resende
> > > > Apache Tuscany Committer
> > > > http://people.apache.org/~lresende
> > > > http://lresende.blogspot.com/
> > > >
> > > >
> ---------------------------------------------------------------------
> > > > 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]
> > >
> > >
> >
> >
> > --
> > Luciano Resende
> > Apache Tuscany Committer
> > http://people.apache.org/~lresende
> > http://lresende.blogspot.com/
> >
> > ---------------------------------------------------------------------
> > 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]
>
>
--
Luciano Resende
Apache Tuscany Committer
http://people.apache.org/~lresende
http://lresende.blogspot.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
