Home arrow Java arrow Querying Oracle 10G XE using Sun Java Creator 2

Querying Oracle 10G XE using Sun Java Creator 2

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.

Author Info:
By: Jayaram Krishnaswamy
Rating: 5 stars5 stars5 stars5 stars5 stars / 4
December 06, 2006
  1. · Querying Oracle 10G XE using Sun Java Creator 2
  2. · Creating a table in Oracle 10G XE
  3. · Adding an Oracle 10G XE data source to Creator 2
  4. · Adding data to the page
  5. · Displaying the Query results

print this article

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.

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