What Steve says is true concerning the Oracle JDBC shipped with Glassfish.
The key differences between Progress DataDirect Connect for JDBC Oracle
driver and Oracle's thin JDBC driver are:
Superior performance - Across a wide variety of test scenarios the Progress
DataDirect JDBC driver delivers more throughput while being more CPU
efficient
Codeless enterprise feature support - Not only does the Progress DataDirect
JDBC driver support all critical Oracle functionality, but features like
Bulk Load - all without requiring application code changes
100% Java architecture - Oracle thin is only an option if you don't plan to
use features like TAF or Kerberos, which will require the Type 2 "fat" JDBC
driver from Oracle. By contrast, the Progress DataDirect JDBC driver
supports all features with Type 4 architecture
You can read more about the Progress DataDirect JDBC driver here:
http://www.datadirect.com/products/jdbc/oracle/index.ssp
Good luck!
Mike Frost
Progress DataDirect
Steve Essery wrote:
>
>
> The sm*.jar files are effectively Sun-branded/licensed versions of
> DataDirect's JDBC drivers. The "limited" is simply the fact that
> those
> JDBC driver/database combinations have not been tested by Sun, as its
> impossible to test all combinations of driver/database without
> excessive delays to the QA/release process. One thing to be aware of
> with the Oracle drivers is that they are not Java EE compliant out of
> the box, you will need to define a java system property
> oracle.jdbc.J2EE13Compliant=true to change the behaviour of the drivers
> (yes the naming of the property implies its for J2EE 1.3, but its
> needed for J2EE 1.4, Java EE 5 and 6 even in the latest 11g drivers).
>
> On 17/02/2010 22:28, NBW wrote:
> OK - I found them included in the GF 2.1.1 Enterprise
> Server with HADB support. So my only question really is what's the
> difference between those drivers and the oracle thin ojdbc drivers?
> Thanks.
>
> On Wed, Feb 17, 2010 at 5:19 PM, NBW < emailnbw_at_gmail.com >
> wrote:
> The
> documentation for GF 2.1.1 [1]
> references smbase.jar, smoracle.jar,
> and smutil.jar as
> the required driver JARs to install for Oracle support as opposed to
> the thin driver (ojdbc[4-6]) which are listed in the 'limted' support
> section. Where can I get these? How are they different from the
> 'limited' support thin client drivers? Thanks.
>
>
> [1] - http://docs.sun.com/app/docs/doc/821-0185/beamz?a=view
>
>
--
View this message in context: http://old.nabble.com/Oracle-JDBC-driver-question-tp27631270p27722169.html
Sent from the java.net - glassfish users mailing list archive at Nabble.com.