The method of connecting to the database in MyEclipse

  
The process of connecting the database resource manager to the database is a two-step process. First, configure the database resource manager driver for your database and then open a database connection. The driver configuration is a one-time configuration task for each database you want to use. In this tutorial, you will learn: Configuring a JDBC database driver to create a database configuration file and connecting without MyEclipse? Xiaobian recommended "MyEclipse crack version download" First, configure the database connection This tutorial uses the Oracle database as an example. The process of creating connections for all other JDBC drivers is similar. For more details on JDBC, please visit the Sun website. 1. Select Window>Open Perspective>MyEclipse Database Explorer. When you first open the perspective, the database browser view shown on the left contains only the pre-configured MyEclipse Derby driver. Database Explorer's perspective tool You need to create a new driver for each individual connection to the database. 2. Click on the DB browser view and select New. Add a new driver 3. Select Oracle (Thin Driver) from the drop-down list of driver templates. 4. The name field of the driver is Oracle. 5. Modify the provided URL template to the correct connection string. In this example, the local Oracle server is jdbc:oracle:thin:@localhost:1521:dbtest.6. Fill in the appropriate username and password fields for your server. If you don't want to save your password, you don't need to fill in the password field. Database driver details 7. Click the Add JARs button. 8. When browsing the location of the JDBC driver's JAR file or folder class, select it and click Open. Select the JAR file for the Oracle JDBC driver. Note: In this case, the Oracle JDBC Connector is considered part of the Oracle installation files. 9. Check the value of the driver class name. The ojdbc6.jar file contains two possible drive classes that can be selected from the drop-down menu of the driver class name. 10. Select oracle.jdbc.driver.OracleDriver from the drop-down list of driver class names, and click Finish. The new driver appears in the DB browser view. DB Viewer View for Oracle Driver 2. Open Database Connection Open a connection when MyEclipse starts or the database connection causes any events to be dropped. For example, the database server is restarted. 1. Right-click on the driver and select Open Connection. Open a database connection If the connection profile is configured to disable the Save password option, open the Database Connection Wizard. Enter your username and password 2. Enter your password. 3. If you need to commit the changes to the database immediately, select the Auto Submit check box. You can set auto-commit to the default settings in the MyEclipse Database Explorer preferences. 4. Click OK to start the database connection process, and the new database connection opens and displays in the DB browser. New database connection in DB Explorer Note: If you close the database browser view or switch to a different perspective, the connection remains open. This article comes from [System Home] www.xp85.com
Copyright © Windows knowledge All Rights Reserved