Creating Database Connections (SAP Library

Creating Database Connections

Use

You use this procedure to create a connection to the database you use for your persistent entities.

Note

If you defined your database tables using the Java Dictionary, you cannot use the DALI object-relational mapping tools to support you in developing your JPA application.

More information about using Open SQL to access tables in JPA applications: Running JPA Applications on the System DataSource

Procedure

Creating New Database Connections

Choose ...

1. Choose Window → Show View → Other.

2. Choose Data → Database Explorer in the Show View dialog.

3. Choose OK.

4. Select Connections in the Database Explorer.

5. Choose New Connection from the context menu. The New Connection dialog opens.

6. Select a database vendor, for example, if you are using the system database server, select MAXDB → 7.6.

7. Complete the Connection URL details fields:

a. Enter your database name, for example, if you are using the system database, JP1.

b. Enter the JDBC driver class, for example, the system driver class com.sap.dbtech.jdbc.DriverSapDB.

c. Enter the location of the JDBC driver class on the file system, for example, if you wish to use the system driver, <SAP DB installation location>\programs\runtime\jar\sapdbc.jar.

d. Enter the connection URL, for example, jdbc:sapdb://<DB Host Name>/JP1?timeout=0.

8. Enter the user name and password for the database in the User ID and Password fields, respectively.

Note

You should use the same user name and password that you specified for connecting to the database in the definition of your DataSource.

9. Choose Finish. The database connection appears in the Connections tree in the Database Explorer.

This graphic is explained in the accompanying text

The New Connection Dialog

Connecting to Existing Database Connections

...

1. To connect to an existing database connection, select the connection in the Database Explorer.

2. Choose Connect from the context menu.