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: [email protected] > 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: [email protected] > > > 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: [email protected] > > > > 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]
