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