That C library, called OCI (Oracle Call Interface), interacts with an Oracle database. JDBC OCI client-side driver: This is a JDBC Type 2 driver that uses Java native methods to call entrypoints in an underlying C library. The OCI driver on the other hand is not java, require Oracle installation, platform dependent, performance is faster, and has a complete list of all the features. This is platform indipendent, and has good performance and some features. In the case with the Oracle, they provide a thin driver that is a 100% Java driver for client-side use without the need of an Oracle installation (maybe that's why we need to input server name and port number of the database server). Theoretically the thick driver should work. If this is the case,Īnd for example if all database connections were handled throughĪ configuration file with the above OCI connection string, then My understand, which obviously is sketchy, is that the thickĭriver is a superset of the thin driver. the thick driver is compatible with theĪpp servers) would there be something within the the thick/OCIĭriver that could limit functionality vs. Thick driver different from the thin driver? If everythingĮlse is "equal" (i.e. My question is, from an application perspective, how is the Oracle Then possible to direct a connection from the first server to To a Net8 service instead of a specific server:Ĭoupled with the FAILOVER=ON option configured in Net8, it is Using the Oracle OCI (thick) driver though, allows us to connect Servers and restart them with an updated string. That means we have to shut down our application In a disaster recovery mode, where we would switch the databaseįrom one server to another, the host name in the above string JDBC thin drivers to talk to the database, with a connection Currently, some of our apps use the Oracle We have severalĪpplications on several servers connecting to the Oracle database.įor redundancy, we're looking into setting up TAF (transparentĪpplication failover). We're in a Solais 8/Oracle 8.1.7.2 environment. thick driversĪnd how they might affect operations from an application perspective. I have a question concerning the Oracle JDBC thin vs. If any body is looking for this information.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |