Skip to Content

Database Compatibility and Comparisons-Oracle

Last modified by Pascal Robert on 2007/09/03 20:59

Since WebObjects make use of JDBC to connect to the Oracle server, it is fully compliant with Oracle 9i and 10g (and 8i for the most).

Last year (2005), a quite huge WebObjects deployment (40 XServes) has been demoed in combination with Oracle 10g RAC (Real Application Cluster).
 Press release:
http://www.oracle.com/global/eu/pressreleases/10gonmac.html

What was interesting is that the standard WebObjects deployment is clustered-like, and so is 10g in its RAC version. The performances and the load-handling were quite impressive.

PS: Would you like more info on WebObjects + 10g RAC, you are more than welcome to drop a question at http://www.intelli-core.com. Probably, your Oracle rep will welcome you, too

To manage Oracle (create tables and constraints, view table statistics, etc.), you can use Oracle SQL Developer.  It's a Java-based application that works quite well. Please note that you need the 10g JDBC driver, or else the latest versions of SQL Developer won't display any tables or views if you are using an older JDBC driver.  We use the 10g driver with our 9.2.06 Standard Edition One server without any problems.

In the mailing list, David den Boer from Apple noticed us of the following gotcha :

What type of column is your date column? Is it TIMESTAMP or DATE, and what version of Oracle is it?
 The reason I ask is that when you bind an NSTimestamp into a DATE column, Oracle has to do conversion on it from TIMESTAMP to DATE. What we had to do to solve that problem is set the property :oracle.jdbc.V8Compatible=trueAnd it solved our problems  completely. We went from seconds down to milliseconds in all cases where it was slow.What that does is has Oracle jdbc driver do the conversion (like it used to in drivers up to 9.2.0.3) instead of at the database level.