Querying Oracle 10G XE using Sun Java Creator 2

In the Server's window, make a right click on the Data Sources node to add a new data source as shown in the next picture by clicking on the drop-down menu item, Add Data Source....

This opens up the window Add Data Source. Insert the information as shown. The name of the data source is Ora10GXE; this gets added to the server node when this window is closed after furnishing the validation table name. Oracle 10G XE is installed on the machine named Hodentek. You also need to put in the User ID and the Password. Now to provide a name for the validation table, click on the Select button.

This opens the list of tables in Oracle 10G XE as shown. Identify the validation table you created in an earlier step, HR.ORAVAL and click on the Add button.

This opens up the connection status window as shown. For the details supplied earlier and the validation table chosen, the connection status is showing OK. Click on the OK button and the Ora10gxe datasource gets added to the data source node in the server.

Now you can expand the Oracle 10G XE dataSource in the Server's window and review all the tables, views and so on you can access from inside Creator 2.