Yeah that looks fine, as mentioned below, I just had to modify the Command and Table Tags with additional attributes. (although it seems you did not)
> -----Original Message----- > From: Luciano Resende [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 05, 2007 11:07 AM > To: tuscany-user@ws.apache.org > Subject: Re: Help with Tuscany Customer's Demo using MySQL > > 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/cust om > er/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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]