- Connecting to Oracle

Connecting to Oracle

The connection properties that are unique to ORACLE are the URL, Driver, User ID, and Password.

They must be exactly as follows:

• • URL - jdbc:oracle:thin:@localhost:PJSYS64 (where localhost is your IP address and PJSYS64 is your database)

  • JDBC Driver - ORACLE (Remote) (oracle.jdbc.driver.OracleDriver)

  • User ID - Any valid user ID

  • Password - Any valid password

Here is a sample Oracle connection:

Oracle allows for some additional connection-related performance properties to be sent over in a connection and, in wow version 7.6, the OracleProperties{ } property group can be used inside the Properties section of the connection row.  The following values are allowed to be set from within this property group:

• defaultRowPrefetch

• remarksReporting

• batchValue

• includeSynonyms

One, any, or all of these properties can be included in the property group for the connection.

It functions just as any other property group in WOW:

OracleProperties {

  defaultRowPrefetch: 1000;

  remarksReporting: true;

  batchValue: 50;

  includeSynonyms: false;

}

Explanation of these performance properties can be found in the Oracle documentation here:

https://docs.oracle.com/cd/A87860_01/doc/java.817/a83724/basic1.htm#1006248

Oracle SQL Docs:  http://docs.oracle.com/cd/B19306_01/server.102/b14200/toc.htm

NOTE: Since Oracle has a different jar for each of their releases, Oracle users may have to manually upgrade

their JDBC jar with the version for their database. WOW’s default ojdbc14.jar needs to be the same one as the

one included in your installed Oracle version (e.g. oracle/product/10.2.0/db_1/jdbc/lib/ojdbc14.jar).