Oracle瘦驱动程序与OCI驱动程序。优点和缺点？ [英] Oracle thin driver vs. OCI driver. Pros and Cons?

问题描述

当您开发一个与oracle DB对话的Java应用程序时，有两个选项吗？一个是oracle瘦驱动程序，另一个是需要自己安装的OCI驱动程序（如果我误解，请更正）。

When you develop a Java application that talks to oracle DBs, there are 2 options right? One is oracle thin driver, and the other is OCI driver that requires its own installation (please correct if I'm misunderstanding).

现在，有哪些优点和缺点？很明显，薄型驱动器在安装方面听起来要好得多，但是OCI可以做什么，薄的却不行？

Now, what are the pros and cons? Obviously thin driver sounds much better in terms of installation, but is there anything that OCI can and the thin one can't?

开发环境是Tomcat6 + Spring 3.0 + JPA（Hibernate）+ apache-DBCP

Develop environment is Tomcat6 + Spring 3.0 + JPA(Hibernate) + apache-DBCP

推荐答案

驱动程序的选择取决于几个因素。您对数据库的调用的性质（例如，您的应用程序似乎不会使用大量存储的proc调用），故障转移（例如，集群Oracle服务器）和分布式事务的要求。通常建议使用瘦驱动程序，但如果您必须拥有OCI驱动程序的某些特定功能，则可能必须考虑OCI驱动程序。还有人说Oracle 10及更高版本的驱动程序确实具有匹配功能，现代JVM几乎没有性能差异。

The choice of the driver depends several factors. The nature of your calls to database (e.g. it seem like your app won't be using lots of stored proc calls), requirements for failover (e.g. clustered Oracle servers) and distributed transactions. Generally it is recommended to use the thin driver, but if there is some specific feature of the OCI driver that you just must have you may have to consider the OCI driver. It also been said that drivers in Oracle 10 and higher do have matching capabilities and there is practically no performance difference on modern JVMs.

这篇关于Oracle瘦驱动程序与OCI驱动程序。优点和缺点？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！