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.