Home arrow Java arrow Connecting to SQL 2005 Server from the Java Studio Creator

Connecting to SQL 2005 Server from the Java Studio Creator

Learn about connecting to SQL 2005 Server from the Java Studio Creator IDE, from one of the beta testers of the IDE. You'll also learn how to troubleshoot the connection, and more.

Author Info:
By: Jayaram Krishnaswamy
Rating: 5 stars5 stars5 stars5 stars5 stars / 1
August 29, 2006
  1. · Connecting to SQL 2005 Server from the Java Studio Creator
  2. · Reviewing the Java Studio Creator IDE
  3. · Connecting to SQL 2005 Server
  4. · Fixing the connectivity problem
  5. · Modifying a configured data source

print this article

Connecting to SQL 2005 Server from the Java Studio Creator
(Page 1 of 5 )


I was one of the early experimenters (well that is what I am) with Sun's Java Studio Creator Early Access Integrated web development environment for creating web applications. It went through modifications and final touches and emerged as Java Studio Creator not too long ago. This product is built on the NetBeans platform and indicated as a Java RAD tool for web applications and portlet development. It has built-in support for Ajaxing the JavaServerFaces and provides easy access to databases, and a number of other features.

This tutorial is about connecting to SQL 2005 Server from this IDE. I had also tested the connectivity with the previous beta version. Even at that time I had found it connected to the SQL 2000 Server without a hitch. Read my blog about this "Early Access" edition.

Sun Java Studio Creator

Sun Java Studio Creator is available for several platforms: Solaris OS (both SPARC and x86), Windows OS, Linux and Apple Macintosh. The recommended platform for Windows is an Intel Pentium 4 at 1 GHZ with 1 GB of RAM. The IDE comes bundled with J2SE 1.5.0_04 and Java 2 Platforms. For development it has everything needed (review the shortcut drop-down menu later in the tutorial).

The Visual environment is feature rich with lots of editors for HTML, CSS, source code, and more. The user experience will be no different from any experience using Microsoft products. Controls are edited with property sheets, property windows, and so forth, and it is possible to edit them directly in the code as well.

The data development related development is just as easy. Drag and drop a table onto the application, the query editor creates an appropriate query, for example. In a future tutorial some of these features, and more importantly the AJAX support, will be examined.

blog comments powered by Disqus

- Java Too Insecure, Says Microsoft Researcher
- Google Beats Oracle in Java Ruling
- Deploying Multiple Java Applets as One
- Deploying Java Applets
- Understanding Deployment Frameworks
- Database Programming in Java Using JDBC
- Extension Interfaces and SAX
- Entities, Handlers and SAX
- Advanced SAX
- Conversions and Java Print Streams
- Formatters and Java Print Streams
- Java Print Streams
- Wildcards, Arrays, and Generics in Java
- Wildcards and Generic Methods in Java
- Finishing the Project: Java Web Development ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials