Super Simple SimpleDB Example using Java and Typica

Articles & Tutorials>Amazon SimpleDB>Super Simple SimpleDB Example using Java and Typica
Community Contributed Software

  • Amazon Web Services provides links to these packages as a convenience for our customers, but software not authored by an "@AWS" account has not been reviewed or screened by AWS.
  • Please review this software to ensure it meets your needs before using it.

These examples illustrate using SimpleDB in a step-by-step approach. They should serve as a quick start introduction and tutorial. The goal is for each program to be small and east to understand. Includes a JSP and HTML page to put sample data into YUI Data Table

Details

Submitted By: carmen delessio jr
AWS Products Used: Amazon SimpleDB
Language(s): Java
License: MIT License
Source Control Access: http://github.com/CarmenD/simple-db-example/tree/master
Created On: March 3, 2009 7:07 PM GMT
Last Updated: March 18, 2009 3:52 PM GMT
Download
What is here?

3 Java programs that run on command line or in IDE:
SimpleDBCreateDomain.java - creates an Amazon Simple DB domain called example
SimpleDBLoadData.java - loads sample records in example domain
SimpleDBShowData.java - shows loaded data in pipe-delimited format

Web Example
SimpleDBShowData.jsp - JSP that returns data in pipe-delimited format
yuitest.html - Yahoo data table displays data supplied by SimpleDBShowData.jsp

The 3 Java programs interact with SimpleDB using Typica in a very straightforward way. Note that the actual Access Code and secret key are not included. You will need to replace KEY and SECRET to run these examples.

Pipe-delimited data is returned from SimpleDBShowData.java and SimpleDBShowData.jsp.

That was done to illustrate loading the data into the YUI data table using a text model. The YUI data table also accepts XML or JSON.


Limitations, questions, and things to try
I edited the sample data to exclude single quotes and asterisks. Those are special characters that need to be escaped to work properly.
I am including attributes with multiple values like keyword, but this can be done better
I am very deliberately building the data output in the required format, is there a slicker way to do this?
What about output in JSON or XML?
What about using a raw XML format to dump to the YUI data table?

Helpful Links:
Typica Project
Typica JavaDoc
YUI Data Control
©2014, Amazon Web Services, Inc. or its affiliates. All rights reserved.