Using Sybase WorkSpace on Eclipse with SQL Anywhere
Building a Java project
By: José Ramos
Oct. 10, 2007 12:00 PM
This tutorial shows you how to get started with SQL Anywhere using Sybase WorkSpace tools in an Eclipse development environment. It doesn't describe how to code with JDBC or how to code in Java; there are many resources available to assist you with these topics. Rather, this document will help you build a Java project by putting together the required components in the Eclipse IDE. More specifically, this is a step-by-step tutorial that takes you through creating a new Java project and using it with Sybase WorkSpace.
SQL Anywhere is a suite of databases and data exchange technologies that pack a lot of power and performance into a small footprint. The SQL Anywhere Server database supports 64-bit and 32-bit servers on all the major platforms all the way down to small handheld devices. Many ISVs embed the SQL Anywhere Server database into their applications because it can scale from client/server environments with hundreds, even thousands, of users and storing hundreds of gigabytes of data, but can also be easily hidden in an application that runs on laptop computers requiring little or no IT support. You can learn more about SQL Anywhere by visiting www.ianywhere.com/sqlanywhere.
WorkSpace is a development tool that plugs into Eclipse. In fact, part of its functionality builds on the Eclipse Data Tooling Platform (DTP) project. It offers a wide range of tools and capabilities including enterprise modeling, database development, Web application development, SOA development, and mobile development all in the one package. You can learn more about WorkSpace by visiting www.sybase.com/products/development/workspace.
Before You Begin
Sybase WorkSpace will automatically install a compatible version of Eclipse 3.1.2, Java 1.4, and SQL Anywhere 9.0.2 Developer Edition. It's best if you accept these default installations. Advanced users can choose to configure Sybase WorkSpace to use existing copies of those software packages if they already have them.
Installation of Sybase Workspace
Getting Started with SQL Anywhere Development
1. Start the SQL Anywhere database
Now that you're set up with your connection profile, you can begin using all of Sybase WorkSpace's enterprise caliber development tools. Please read the "Sybase WorkSpace Development" chapter at http://sybooks.sybase.com/nav/detail.do?docset=1303.
This chapter contains sections that describe the following topics in full detail:
We can create databases using the Database Development perspective.
1. Click Window | Open Perspective | Database Development
Reader Feedback: Page 1 of 1
SOA World Latest Stories
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
SYS-CON Featured Whitepapers
Most Read This Week