To be able to access, insert, update, and delete information in Oracle Database XE from a Java application, you first need to connect to the database using a Connection object. This chapter is the first in a series of five chapters, each of which describes how to create parts of this Java application. This chapter describes, in particular, how you can create code that helps you connect to the database.

• Jdbc Driver For Oracle 11g Express Edition Free Download Windows 10
• Jdbc Driver For Oracle 11g Express Edition Free Download Windows 7
• Jdbc Driver For Oracle 11g Express Edition Free Download Pdf

Jdbc Driver For Oracle 11g Express Edition Free Download Windows 10

This chapter includes the following sections:

Connecting to Oracle Database from JDeveloper

You can set up and manage database connections in JDeveloper to enable your application to communicate with external data sources, including Oracle Database and offline database objects. This is done using the Connection Navigator. The same navigator is also used to manage other connections your application needs, such as connections to application servers. The following subsections describe how you can use the Connection Navigator to view the database and its objects and to create a connection to the database:

JDeveloper Connection Navigator

Download Oracle Database 11g Express Edition for free. Oracle Database 11g Express Edition is a free program that provides a browser-based interface to administer databases, create tables, views and other database objects, import, export and view table data, run queries and SQL scripts, and generate reports. The database is in Oracle 11g, of which I am absolutely not familiar, and I have JDK 1.6. Will ojdbc4.jar do for my program? We're not allowed to connect to the Internet in the office and I can't download ojdbc6.jar, which I've read is more compatible with my setup.

The Connection Navigator displays all currently defined connections. To view the Connection Navigator, select the Connections tab in the navigator panel on the top left-hand side of the JDeveloper display, if it is displayed, or use the View menu. For an illustration of the default layout of the JDeveloper IDE, see Figure 1-1.

You can use the Connection Navigator to browse through the connections it displays. In particular, for a database schema, you can also view database objects, tables, views, and their contents.

Database connections are shown under the Database node. To view the objects in the database, expand the connection. Expanding a schema displays nodes for the object types in that schema. Expanding the node for an object type displays its individual objects. When you expand a table node, you can view the structure of the table and the data within the table.

Creating a Database Connection

You can connect to any database for which you have connection details. When you create a database connection, you must specify a user name and a password. By default, the connection allows you to browse only the schema of the user that you specify in the connection.

To create a connection, follow these steps:

1. Start JDeveloper.

2. From the View menu, select Connection Navigator. The Connection Navigator is displayed, showing you a list of the available connections.

3. Right-click Database, and from the shortcut menu, select New Database Connection. The Create Database Connection wizard is displayed. Click Next on the Welcome screen. The Step 1 screen is displayed.

4. In the Step 1 screen, do not change the default values for the connection name and type, DBConnection1 and Oracle (JDBC). Click Next. The Step 2 screen is displayed.

5. In the Step 2 screen, enter HR in both the Username and Password fields. Do not enter a value for Role, and select Deploy Password. Click Next.

6. In the Step 3 screen, you need to provide information about the computer where your database is located. Your database administrator should provide you with this information.

   Enter the following information:

   • Driver: thin

   • Host Name: Host name of the computer where Oracle Database XE is installed

   • JDBC Port: 1521

   • Service Name: XE

     If database server is on the same computer, then for the Host Name parameter, enter localhost. Figure 3-1 shows the Create Database Connection wizard screen where you enter these details.

     Figure 3-1 Specifying Connection Details

     
     Description of 'Figure 3-1 Specifying Connection Details'
     

7. In the Step 4 screen, you can test whether or not you can successfully connect to the database. Click Test Connection. If the connection is successful, the word Success! displays in the Status field.

8. Click Finish to create the connection and close the wizard.

Disconnecting and Reconnecting from Oracle Database in JDeveloper

To disconnect from the database in JDeveloper, in the Connection Navigator, right-click the connection name and select Disconnect. The display in the Connection Navigator now shows only the name of the connection, without the plus (+) symbol for expanding the node. To reconnect to the database, right-click the connection name and select Connect.

Browsing the Data Using the Connection Navigator

After you have successfully established a connection to the database, you can browse its contents through the Connection Navigator. The Connection Navigator displays a navigable, hierarchical tree structure for the database, its objects, their instances, and the contents of each. To view the contents at each level of the hierarchy of the database connection that you create, do the following:

1. The Database node in the Connection Navigator now shows a node with the name of your connection. Click the plus symbol (+) to the left of the connection name to expand the navigation tree. The name of the schema to which you connected, in this case HR, is displayed.

2. To view the list of all the objects in the HR schema, expand the HR navigation tree. To display a list of the instances of an object type, for example Tables, expand the Table navigation tree.

   Figure 3-2 Accessing Database Objects in the Connection Navigator

   
   Description of 'Figure 3-2 Accessing Database Objects in the Connection Navigator'
   

3. The Structure window below the navigator shows the detailed structure of any object selected in the navigator. Select a table in the navigator (for example Employees) to see the columns of that table in the Structure window.

   Figure 3-3 Structure Window

   
   Description of 'Figure 3-3 Structure Window'
   

4. If you double-click a table in the navigator, the structure of that table is displayed in the main editing area of the window. It includes details about all the columns, such as Name, Type, and Size, so you can browse the table definition.

   To view the data from a table, select the Data tab below the table structure. You can now view and browse through the table data.

5. You can also edit the objects in the Connection Navigator. To edit a table, right-click the table and select Edit from the shortcut menu. A dialog box allows you to make changes to the selected table.

Setting Up Applications and Projects in JDeveloper

In JDeveloper, you create your work in an application, within which you can organize your work into a number of projects. JDeveloper provides a number of application templates, to help you to create the project structure for standard types of application relatively quickly and easily. At the time you create your application in JDeveloper, you can choose the application template that matches the type of application you will be building.

The application template you select determines the initial project structure (the named project folders within the application) and the application technologies that will be included. You can then add any extra libraries or technologies you need for your particular application, and create additional projects if you need them.

Using the JDeveloper Application Navigator

The Application Navigator displays all your applications and projects. When you first start JDeveloper, the Application Navigator is displayed by default on the left side of the JDeveloper IDE.

To view the Application Navigator when it is not displayed, you can click the Applications tab in the navigator panel on the top left-hand side of the JDeveloper display, or select Application Navigator from the View menu.

The Application Navigator shows a logical grouping of the items in your projects. To see the structure of an individual item, you can select it and the structure is displayed in the Structure window.

From the Application Navigator, you can display items in an appropriate default editor. For example, if you double-click a Java file, the file opens in the Java Source Editor, and if you double-click a JavaServer Pages (JSP) file, it opens in the JSP/HTML Visual Editor.

Creating an Application and a Project

To get started with JDeveloper, you must create an application and at least one project in which to store your work as follows:

1. In the Application Navigator, right-click Applications, and select New Application from the shortcut menu. The Create Application Workspace dialog box is displayed, which is shown in Figure 3-4.

2. Enter HRApp in the Application Name field, and in the Application Template list, select No Template [All Technologies]. Click OK. The Create Project dialog box is displayed.

   Figure 3-4 Creating an Application Workspace

   
   Description of 'Figure 3-4 Creating an Application Workspace'
   

3. On the Create Project dialog box, enter view as the name of the project.

4. The new HRApp application is displayed in the Application Navigator.

5. Save your application. To do this, from the File menu, select Save All.

Viewing the Javadoc and Source Code Available in the Project Scope

You can view the Javadoc or the code for any of the classes available in the project technology scope within JDeveloper. In addition, you can view the details of all the methods available for those classes.

For example, to see the code or Javadoc for the Connection class, do the following:

1. /crossover-mac-directx-11.html. With your project selected in the Application Navigator, from the Navigate menu select Go to Java Class. You can also do this for a specific file in your project.

2. In the Go to Java Class dialog box, select Source or Javadoc.

3. Enter the name of the class you want to view, in the Name field, or click Browse to find the class. For the Connection class, start to enter Connection, and from the displayed list select Connection (java.sql).

   Figure 3-5 Selecting the Class to View the Javadoc in JDeveloper

   
   Description of 'Figure 3-5 Selecting the Class to View the Javadoc in JDeveloper'
   

4. Click OK.

   Figure 3-6 Javadoc Display in JDeveloper

   
   Description of 'Figure 3-6 Javadoc Display in JDeveloper'
   

Connecting to the Database from a Java Application

So far, you have seen how to connect to the database from JDeveloper. To initiate a connection from the Java application, you use the Connection object from the JDBC application programming interface (API).

This section describes connecting to the database from the Java application in the following subsections:

Overview of Connecting to Oracle Database

In Java, you use an instance of the DataSource object to get a connection to the database. The DataSource interface provides a complete replacement for the previous JDBC DriverManager class. Oracle implements the javax.sql.DataSource interface with the OracleDataSource class in the oracle.jdbc.pool package. The overloaded getConnection method returns a physical connection to the database.

Note:

You can either set properties using appropriate setxxx methods for the DataSource object or use the getConnection method that accepts these properties as input parameters.

Important DataSource Properties are listed in Table 3-1.

Table 3-1 Standard Data Source Properties

If you choose to set the url property of the DataSource object with all necessary parameters, then you can connect to the database without setting any other properties or specifying any additional parameters with the getDBConnection method. For more information on setting the database URL, refer to the Specifying Database URLs section.

Note:

Jdbc Driver For Oracle 11g Express Edition Free Download Windows 7

See Also:

Specifying Database URLs

Database URLs are strings that you specify for the value of the url property of the DataSource object. The complete URL syntax is:

The first part of the URL specifies which JDBC driver is to be used. The supported driver_type values for client-side applications are thin and oci. The brackets indicate that the user name and password pair is optional. The database_specifier value identifies the database to which the application is connected.

The syntax for thin-style service names that are supported by the JDBC Thin Driver is as follows:

For the sample application created in this guide, if you include the user name and password, and if the database server is hosted locally, then the database connection URL is as shown in Example 3-1.

Example 3-1 Specifying the Database URL Using a non-XE Client Installation

Connecting from the Oracle Database XE Client

Oracle Database XE comes with a new connection feature. If you install the Oracle Database XE client, then you need not specify all the details in the database_specifier part of the connection URL. Under certain conditions, the Oracle Database XE connection adapter requires only the host name of the computer where the database is installed.

Because of this feature introduced in Oracle Database XE, the connection string syntax is as shown in Example 3-2.

Example 3-2 Specifying the Database URL Using the XE Client Installation

In this URL:

• // is optional.

• :port is optional.

  Specify this only if the default Oracle Net listener port (1521) is not used.

• /XE, or the service name, is not required.

  The connection adapter for the Oracle Database XE Client connects to the default service on the host. On the host, this is set to XE in the listener.ora file.

Default service is a new feature of Oracle Database XE. If you use any other Oracle Database client to connect to Oracle Database XE, then you must specify the service name.

For example, if you connect to a local database using port number 1522 for the listener, then your database URL changes to:

And if you use all other defaults, but connect to a database on a remote computer (called testserver.oracle.com for example), then the connection URL is as shown in Example 3-3.

Example 3-3 Connection URL for a Remote Database with Default Port

Creating a Java Class in JDeveloper

The first step in building a Java application is to create a Java class. The following instructions describe how you can create a class called DataHandler, which will contain the methods for querying the database and modifying the data in it.

1. In the Application Navigator, right-click the View project, and from the shortcut menu, select New.

2. In the New Gallery, select the General category. In the Items list, select Java Class, and click OK. The Create Java Class dialog box is displayed.

3. In the Create Java Class dialog box, enter DataHandler as the class Name, and hr as the Package. Do not change the default values of the Optional Attributes, and click OK. The Create Java Class dialog box with the appropriate values specified is shown in Figure 3-7.

   Figure 3-7 Creating a Java Class

   
   Description of 'Figure 3-7 Creating a Java Class'
   

4. The skeleton DataHandler class is created and is displayed in the Java Source Editor. The package declaration, the class declaration, and the default constructor are created by default. Figure 3-8 shows the class displayed in the Java Source Editor, ready for you to add your Java code:

   Figure 3-8 Java Source Editor

   
   Description of 'Figure 3-8 Java Source Editor'
   

Java Libraries

Oracle JDeveloper comes with standard libraries to help Java application programming. These libraries include API support for Application Development Framework (ADF), Apache Ant, Apache Batik, Oracle libraries for JDBC, JavaServer Pages (JSP), and so on. To use these libraries in your application, you need to import them into your project.

In order for the project to be able to use JDBC, you must add the Oracle JDBC library to the project. In addition, to use JSP technology, you need the JSP Runtime library.

Oracle JDBC Library

Important packages of the Oracle JDBC Library include:

• oracle.jdbc: The interfaces of the oracle.jdbc package define the Oracle extensions to the interfaces in java.sql. These extensions provide access to Oracle SQL-format data and other Oracle-specific features, including Oracle performance enhancements.

• oracle.sql: The oracle.sql package supports direct access to data in SQL format. This package consists primarily of classes that provide Java mappings to SQL data types and their support classes.

• oracle.jdbc.pool: This package includes the OracleDataSource class that is used to get a connection to the database. The overloaded getConnection method returns a physical connection to the database.

JSP Runtime Library

This library includes the classes and tag libraries required to interpret and run JSP pages on the OC4J server that comes with JDeveloper.

Adding JDBC and JSP Libraries

To include libraries in your project, perform the following steps:

1. Double-click the View project in the Application Navigator to display the Project Properties dialog box.

2. Click Libraries, and then click Add Library. The Add Library dialog box is displayed with a list of the available libraries for the Java2 Platform, Standard Edition (J2SE) version is displayed.

3. In the Add Library dialog box, scroll through the list of libraries in the Extension folder. Select the JSP Runtime library and click OK to add it to the list of selected libraries for your project. Similarly, add the Oracle JDBC library. Figure 3-9 shows the Oracle JDBC library added to the view project.

   Figure 3-9 Importing Libraries

   
   Description of 'Figure 3-9 Importing Libraries'
   

4. Click OK.

Note:

Importing the JDBC Packages

To use JDBC in the Java application, import the following JDBC packages:

1. If the DataHandler.java class is not already open in the Java Source Editor, in the Application Navigator, expand the View project, Application Sources, and your package (hr) and double-click DataHandler.java.

2. At the end of the generated package declaration, on a new line, enter the import statements shown in Example 3-4.

Example 3-4 Importing Packages in a Java Application

Declaring Connection-Related Variables

Connection information is passed to the connection method by using the following connection variables: the connection URL, a user name, and the corresponding password.

Jdbc Driver For Oracle 11g Express Edition Free Download Pdf

Use the Java Source Editor of JDeveloper to edit the DataHandler.java class as follows:

1. After the DataHandler constructor, on a new line, declare the three connection variables as follows:

   These variables will be used in the application to contain values supplied by the user at login to authenticate the user and to create a connection to the database. The jdbcUrl variable is used to hold the URL of the database from which a connection is to be obtained. The userid and password variables are used to authenticate the user and identify the schema to be used for the session.

   Note:

   The login variables have been set to null to secure the application. Until the section where the application login functionality is built into the application, to test the application, you can set values in these variables as follows:Set the jdbcUrl variable to the connect string for your database. If you have installed the Oracle Database XE Client and are using the default listener port, then you can use the default service feature as described in Connecting from the Oracle Database XE Client. In this case, the jdbcUrl value can be set to:

   If you are not connecting to the default listener port on the database server, include the port number. Set the variables userid and password to hr as follows:

   Make sure you reset these back to null as soon as you finish testing.

   For more information on security features and practices, refer to Oracle Database Security Guide and the vendor-specific documentation for your development environment.

2. On a new line, declare a connection instance as follows:

   Your Java class should now contain the code in Example 3-5.

   Example 3-5 Declaring Connection Variables and the Connection Object

Creating the Connection Method

To connect to the database, you need to create a method as follows:

1. Add the following method declaration after the connection declaration

   Java Code Insight displays a message reminding you to import the SQLException error handling package. Press Alt+Enter keys to import it. The import java.sql.SQLException statement is added to the list of import packages.

2. At the end of the same line, add an open brace ({) and then press the Enter key. JDeveloper automatically creates the closing brace, and positions the cursor in a new empty line between the braces.

3. On a new line, declare an OracleDataSource instance as follows:

4. Enter the following to create a new OracleDataSource object:

5. Start to enter the following to set the URL for the DataSource object:

   Java Code Insight prompts you by providing you with a list of available OracleDataSource methods. Scroll through the list to select the setURL(String) method, and press Enter to select it into your code. In the parentheses for this function, enter jdbcUrl.

   Figure 3-10 shows how the Java Code Insight feature in JDeveloper helps you with inserting code.

   Figure 3-10 Java Code Insight

   
   Description of 'Figure 3-10 Java Code Insight'
   

6. On the next line, enter the following:

   As usual, Java Code Insight will prompt you with a list of methods for ds. This time, select getConnection(String,String). In the parentheses, enter userid,password. End the line with a semicolon (;).

   Your code should look similar to the code in Example 3-6.

   Example 3-6 Adding a Method to Connect to the Database

7. Compile your class to ensure that there are no syntax errors. To do this, right-click in the Java Source Editor, and select Make from the shortcut menu. A Successful compilation message is displayed in the Log window below the Java Source Editor window.

Related Topics:

Install Oracle Database 11g XE for ojdbc.jar Test
How to download and install Oracle Database 11g XE on my local computer to test ojdbc Oracle Driver? If you want to test ojdbc Oracle Driver and do not have any Oracle database to access, you can follow these steps to download and install Oracle Database 11g XE on your local computer. 1. Download Or.. 2018-03-28, 1771👍, 0💬

ShowJdbcDrivers.java - ojdbc Oracle Driver Example
How to verify if ojdbc Oracle Driver is loaded corrected from the classpath? I want to see a Java program example. Here is an example program, ShowJdbcDrivers.java, that can be used to verify if ojdbc Oracle Driver is loaded corrected from the classpath or not: // Copyright (c) FYIcenter.com import .. 2018-03-13, 1597👍, 0💬

What is Oracle Database 11g XE (Express Edition)
What is Oracle Database 11g XE (Express Edition)? Oracle Database 11g XE (Express Edition) is a free starter database for: Developers working on Node.js, Python, PHP, Java, .NET, XML, and Open Source applications DBAs who need a free, starter database for training and deployment Independent Software.. 2018-03-13, 1219👍, 0💬

ojdbc Oracle Driver Connection URL String
What is the correct format ojdbc Oracle Driver Connection URL string? I am getting exceptions when calling the DriverManager.getConnection(ur l)method. When you are calling the DriverManager.getConnection(ur l)method to establish a connection to a Oracle database through the ojdbc Oracle Driver, you.. 2018-03-13, 1038👍, 0💬

Start Oracle Database 11g XE on Windows
How to start Oracle Database 11g XE on my local Windows computer? I have installed it earlier. If you have Oracle Database 11g XE (Express Edition) installed on your local Windows computer, you can follow these steps to start and stop Oracle Database 11g server: 1. Run 'Start > All Programs &.. 2018-03-28, 933👍, 0💬