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=60 /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
RE: Help with Tuscany Customer's Demo using MySQL
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 thenewCustomer.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=60
/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
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 thenewCustomer.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
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
RE: Help with Tuscany Customer's Demo using MySQL
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
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/customer/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
RE: Help with Tuscany Customer's Demo using MySQL
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
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
RE: Help with Tuscany Customer's Demo using MySQL
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
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=60/
/ConnectionInfo
!--Uncomment below for MySQL test--
!--
ConnectionInfo
ConnectionProperties
driverClass=com.mysql.jdbc.Driver
databaseURL=jdbc:mysql://localhost/dastest
userName=dastest
password=dastest
loginTimeout=60/
/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
RE: Help with Tuscany Customer's Demo using MySQL
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=60/
/ConnectionInfo
!--Uncomment below for MySQL test--
!--
ConnectionInfo
ConnectionProperties
driverClass=com.mysql.jdbc.Driver
databaseURL=jdbc:mysql://localhost/dastest
userName=dastest
password=dastest
loginTimeout=60/
/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
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\customerant 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=60 /ConnectionProperties /ConnectionInfo !-- ConnectionInfo dataSource=java:comp/env/jdbc/dastestTHIS SECTION IS COMMENTED OUT contextAvailable=false ConnectionProperties
RE: Help with Tuscany Customer's Demo using MySQL
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=60 /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\customerant Buildfile: build.xml run
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=60 /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
