Eclipse Configuration Data Source Explorer

I. Configuring the Oracle database Connection 1, opening the configuration window

In the Window menu, select "Other" from "Show windows" and select "Data Source Explorer" in the popup to configure the database connection.

2. New Database connection

Right-click on the "Database Connections" folder icon in the Data Source Explorer tab bar and select "New". Select Oracle in the new pop-up window and set the name of the connection.

3. New Driver information

Right-click the New button in the New Connection profile window, select the corresponding Oracle database version, and name driver name.

4. Configure the JAR package

Remove the Ojdbc14, and import the drive packages that are included with the Oracle itself . Otherwise, eclipse will not stop prompting for an error. The ODBC driver package directory is: Oracle11g\product\11.2.0\dbhome_1\jdbc\lib.

Figure 1-4-1 Deleting the old jar package

Figure 1-4-2 New driver package for Oracle itself

Figure 1-4-3 No error is displayed after importing the driver package

5, Configuration driver information

Click "Properties" to configure the full information of the connection URL, database Name, UserID, password and other data flow connections in the interface.

Second, test configuration results

After the database connection information is completed, the database instance and the database listener service starts, click "Test Connection", if the connection is successful, the "Ping succeeded" prompt window will pop up.

Click Finish and the data Source Explorer is configured to complete.

Eclipse Configuration Data Source Explorer