jdbc to oracle connection modle program

shams@ hi sushil JDBC is a set of classes and interfaces written in Java that allows Java programs to send SQL statements to a database like Oracle. Oracle provides three categories of JDBC drivers: JDBC Thin Driver (no local SQL*Net installation required/ handy for applets) JDBC OCI for writing stand-alone Java applications JDBC KPRB driver (default connection) for Java Stored Procedures and Database JSPs. All three drivers support the same syntax and APIs. Oracle needs three drivers to support different deployment options. Looking at the source code, they will only differ in the way you connect to the database. Remember, you must use a JDBC version that matches the version of your Java Development Kit. [edit] Thin driver Oracle's JDBC Thin driver uses Java sockets to connect directly to Oracle. It provides its own TCP/IP version of Oracle's SQL*Net protocol. Because it is 100% Java, this driver is platform independent and can also run from a Web Browser (applets). There are 2 URL syntax, old syntax which will only work with SID and the new one with Oracle service name.

1 Upvote 1 Upvote 0 Downvotes

• • Report Abuse
• Comment