Catalog VALUES('catalog2', 'Oracle
Magazine', 'Oracle Publishing', 'Nov-Dec 2004',
'From ADF UIX to JSF', 'Jonas Jacobi');
INSERT INTO OE.Catalog VALUES('catalog3', 'Oracle
Magazine', 'Oracle Publishing', 'March-April
2005', 'Starting with Oracle ADF ', 'Steve Muench');
26 2 Developing an Ajax Web Application
Next, define a JDBC Connection with the Oracle database in the
Databases window. To create a JDBC connection, right-click on the IDE
Connections node and select New Connection as shown in Fig. 2.10.
Fig. 2.10 Creating New Connection
The Create Database Connection wizard gets started. Specify a
Connection Name and select the default Connection Type, Oracle
(JDBC). Specify Username as OE, because the database table was
created in OE schema, and specify the Password for OE schema. In the
Oracle JDBC Settings header, select the thin Driver, specify Host Name
as localhost, and JDBC Port as 1521. Specify the SID as ORCL.
Click on Test Connection. If a JDBC connection gets established a
???Success??? message gets displayed. Click on OK as shown in Fig. 2.11.
2.2 Setting the Environment 27
Fig. 2.11 Configuring a Connection
A node for the connection gets added to IDE Connections node in
Databases window as shown in Fig. 2.12. The Catalog table may be
modified if required using the SQL Worksheet.
28 2 Developing an Ajax Web Application
Fig. 2.12 New Database Connection
Connection AjaxConnection in Databases window is available as
datasource with JNDI name jdbc/AjaxConnectionDS.
Pages:
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46