Customer J2SE sample application

This stand-alone sample demonstrates the RDB Data Access Service in the context of a simple java application.

Building and Running

• Apache Ant latest version installed.
  • Download Apache Ant latest version on and extract into folder <apache_ant_folder>. You can find it here: http://ant.apache.org/bindownload.cgi.
  • Add <apache_ant_folder>/bin directory to your OS path variable.

• On console change the actual directory to <tuscany_das_java_distribution>/samples/customer/ and execute ant application:
  • <tuscany_das_java_distribution>/samples/customer/> ant

The sample will run and output the following:

Buildfile: build.xml

run:
     [java] ************* Initializing database *************
     [java] ** DB type  : derby
     [java] ** Database : jdbc:derby:target/dastest; create = true
     [java] ** User     :
     [java] ** Password :
     [java] ************************************************
     [java] Setting up for derby run!
     [java] Dropping tables
     [java] Dropping procedures
     [java] Creating tables
     [java] Creating procedures
     [java] Inserting data in tables
     [java] Database setup complete!
     [java]
     [java] Result:select all customers
     [java]    ID:1 LASTNAME:John ADDRESS:USA
     [java]    ID:2 LASTNAME:Amita ADDRESS:INDIA
     [java]    ID:3 LASTNAME:Patrick ADDRESS:UK
     [java]    ID:4 LASTNAME:Jane ADDRESS:UN
     [java]
     [java] Result:insert new customer
     [java]    ID:1 LASTNAME:John ADDRESS:USA
     [java]    ID:2 LASTNAME:Amita ADDRESS:INDIA
     [java]    ID:3 LASTNAME:Patrick ADDRESS:UK
     [java]    ID:4 LASTNAME:Jane ADDRESS:UN
     [java]    ID:5 LASTNAME:Jenny ADDRESS:USA
     [java]
     [java] Result:update first customer
     [java]    ID:1 LASTNAME:BlueBerry ADDRESS:USA
     [java]    ID:2 LASTNAME:Amita ADDRESS:INDIA
     [java]    ID:3 LASTNAME:Patrick ADDRESS:UK
     [java]    ID:4 LASTNAME:Jane ADDRESS:UN
     [java]    ID:5 LASTNAME:Jenny ADDRESS:USA
     [java]
     [java] Result:delete last customer
     [java] Deleting customer named: Jenny
     [java]    ID:1 LASTNAME:BlueBerry ADDRESS:USA
     [java]    ID:2 LASTNAME:Amita ADDRESS:INDIA
     [java]    ID:3 LASTNAME:Patrick ADDRESS:UK
     [java]    ID:4 LASTNAME:Jane ADDRESS:UN

BUILD SUCCESSFUL

Observation:The build.xml ant file only works on DAS Java binary distribution.

Running Sample with MySQL

The sample is pre-configured to run using an embedded Derby database.Follow below instructions to run the sample on another database (e.g MySQL).

• Expand sample-customer.jar under /samples/customer to access CustomersConfig.xml
• Change CustomersConfig.xml - comment Derby connection info and uncomment MySQL connection info. Check for correct userName, password, and other configuration information
• Change /samples/customer /build.xml to replace pathelement location from Derby jar to MySQL jar like -
  • <pathelement location="mysql-connector-java-5.0.4.jar"/>
• Create new sample-customer.jar to use the changed CustomersConfig.xml , replacing the one from binary distribution under /samples/customer.
• Place required mysql jar (e.g. mysql-connector-java-5.0.4.jar) under /samples/customer.
• From command prompt run the sample application using ant -
  • <tuscany_das_java_distribution>/samples/customer/> ant

Observations:

• These instructions apply only for DAS Java binary distribution.
• MySQL Database will be created and populated with necessary structure and data if not present