Microsoft ASP.NET 2.0 provides an excellent platform for developing data centric applications. Data manipulation within the IDE is supported by an excellent query editor. Sun Java Studio Creator IDE with the JSF framework also has excellent support and this article shows how it is carried out.
Querying Oracle 10G XE using Sun Java Creator 2 (Page 1 of 5 )
For this tutorial the data comes from Oracle 10G XE. With Oracle 10G XE and Sun Java Studio Creator 2 being free downloads, it will be worth working these for those who want to acquire skill in these products. For VB programmers who want to branch out to Java this is an excellent path to pursue. Readers will benefit from reading the previous article, Displaying Data from a Data-centric Web Page with Sun Java Creator 2.
The Query Editor Project
This project is called the Query Editor Project. You may create this as a New Java Server Faces Web Application from the main menu item File and the drop-down from it, the New Project. Java Server Faces is a server-side program resembling ASP or JSP; if you are new to using this IDE, you may review the following article. It provides the necessary framework for graphic user interface based applications based on Java. You provide the name in the window that pops up when you create a new project.
Creating a Validation table in Oracle 10G Xe
The validation table is necessary for the IDE to make sure that a connection exists and is still valid. The application in Creator 2 obtains its database connections from the Sun Java application server's connection pool. The application server queries the validation table to make sure that the connection is valid. The Test Connection button (which you will see in a later window) also does the same behind the scenes. This table must exist. Although any table can be used, it better be a table which is accessible, and very small. Therefore before you bring data into Creator 2, short for Sun Java Studio Creator 2, you must create a Validation table, a tiny table with no data used just for the express purpose of establishing connection.