Child pages
  • Database Connections

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
titleoraclelobfix.jar

The oraclelobfix.jar file in the ../application_server/drivers directory is not an Oracle JDBC driver, but a library containing a fix for an issue in the Oracle JDBC driver. When connecting to Oracle databases, it's still required to add the correct Oracle JDBC driver.

JDBC 3.0 vs. JDBC 4.0

There are two active versions of the JDBC specification, namely version 3 and version 4. The version 4 specification is compatible with Java 6 or higher, whereas version 3 is compatibly with Java 5 and higher. As Servoy is compatibly with Java 5 and higher, Servoy supports JDBC drivers that conform to the JDBC 3.0 specification. 

As of Servoy 5.2.9 Servoy will also support JDBC drivers that conform to the JDBC 4.0 specification. As JDBC 4.0 is not compatible with Java 5, the Servoy Application Server needs to be run under Java 6 or higher in order to be able to use these drivers.

(warning)  Note that JDBC 3.0 and JDBC 4.0 should not be mistaken for JDBC type 3 or 4: JDBC types (1 through 4) are an indication how the communication between the Java process and the database is implemented whereas JDBC 3.0 or JDBC 4.0 says something about the Java API exposed by the JDBC driver itself.

Configuring database access

...