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]

Reply via email to