Comments
yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Computing
Conference & Expo
November 2-4, 2009 NYC
Register Today and SAVE !..

2008 West
DIAMOND SPONSOR:
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
PLATINUM SPONSORS:
Red Hat
The Opening of Virtualization
GOLD SPONSORS:
Appsense
User Environment Management – The Third Layer of the Desktop
Cordys
Cloud Computing for Business Agility
EMC
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Intel
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Sensedia
Return on Assests: Bringing Visibility to your SOA Strategy
Symantec
Managing Hybrid Endpoint Environments
VMWare
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
PLATINUM SPONSORS:
Appcelerator
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
GOLD SPONSORS:
ICEsoft
How Can AJAX Improve Homeland Security?
Isomorphic
Beyond Widgets: What a RIA Platform Should Offer
Oracle
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
In many cases, the end of the year gives you time to step back and take stock of the last 12 months. This is when many of us take a hard look at what worked and what did not, complete performance reviews, and formulate plans for the coming year. For me, it is all of those things plus a time when I u...
SYS-CON.TV
Using Sybase WorkSpace on Eclipse with SQL Anywhere
Building a Java project

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
If you don't already have a copy of Sybase WorkSpace, you can download a free evaluation version from www.sybase.com/products/development/workspace.

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
Please follow the instructions in the book Sybase WorkSpace 1.7 Installation Guide found at http://sybooks.sybase.com/nav/detail.do?docset=1303.

Getting Started with SQL Anywhere Development
The following information is from the book Sybase WorkSpace Development found at the URL in the installation section. Only information relevant to SQL Anywhere Server will be presented here. Note: The SQL Anywhere Server database was called ASA in previous versions of the product.

1.  Start the SQL Anywhere database
•   Click Start | Programs | Sybase | Sybase WorkSpace | ASA 9.0 | Start ASA
2.  Open Sybase WorkSpace
•   Click Start | Programs | Sybase | Sybase WorkSpace | Sybase WorkSpace 1.7
3.  Create a SQL Anywhere connection profile
•   Click File | New | Other
•   Select Connection Profiles | Connection Profile, then click Next
•   Select Sybase ASA, then click Next
•   Enter a unique name for your new connection profile, enter a description if you choose, then click Next
•   You only need to modify fields on the connection details page if you start the database with non-default values. Confirm the connection by clicking Test Connection
•   If the ping succeeds, click Finish, otherwise check your connection information and make any necessary corrections
4.  Connect to your database
•   In the Service Development perspective, open the Enterprise Explorer view
•   Expand the Databases folder, right-click on the connection profile you just created, and click Connect. After connecting successfully, you should be able to browse your schema in the Enterprise Explorer view

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:

  • Getting Started
  • Service Development
  • Process Orchestration
  • Database Development
  • Web Application Development
  • Mobile Development
Creating Databases and Making Schema Changes
We can create databases using the Database Development perspective.

1.  Click Window | Open Perspective | Database Development
2.  Ensure you have the Enterprise Explorer view active
•   If not you can click Window | Show View | Enterprise Explorer
3.  To create a new SQL Anywhere Server database, right-click on a connection profile in the Enterprise Explorer View and select Create Database
•   Enter a database name, and select Sybase ASA as the connection profile type, then click Finish


About José Ramos
José Ramos is a product manager for Sybase iAnywhere and is responsible for the direction and life cycle planning of Sybase iAnywhere products. With more than seven years of experience, he also plays an active role in customer demonstrations and education to ensure the continued success of SQL Anywhere, the industry-leading database management and data movement technology built for frontline environments. José holds a Bachelor of Mathematics in Computer Science from the University of Waterloo in Ontario, Canada.

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1

SOA World Latest Stories
When building large, cloud-based applications that operate at a high scale, it’s important to maintain a high availability and resilience to failures. In order to do that, you must be tolerant of failures, even in light of failures in other areas of your application. “Fly two mistakes ...
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand usin...
Lori MacVittie is a subject matter expert on emerging technology responsible for outbound evangelism across F5's entire product suite. MacVittie has extensive development and technical architecture experience in both high-tech and enterprise organizations, in addition to network and sy...
Containers and Kubernetes allow for code portability across on-premise VMs, bare metal, or multiple cloud provider environments. Yet, despite this portability promise, developers may include configuration and application definitions that constrain or even eliminate application portabil...
Modern software design has fundamentally changed how we manage applications, causing many to turn to containers as the new virtual machine for resource management. As container adoption grows beyond stateless applications to stateful workloads, the need for persistent storage is founda...
Using new techniques of information modeling, indexing, and processing, new cloud-based systems can support cloud-based workloads previously not possible for high-throughput insurance, banking, and case-based applications. In his session at 18th Cloud Expo, John Newton, CTO, Founder an...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021


SYS-CON Featured Whitepapers
Most Read This Week
ADS BY GOOGLE