rdbms drivers; thin type, odbc, and oci on hpux11i

[Shivkumar]

Few years ago i read somewhere that ODBC driver have issues on unix world and we should be using thin type of JDBC drivers. i guess we get various types of thin jdbc drivers such as type 1, type 2 .. etc. Also OCI types drivers are inferior to thin types drivers.. right ??

appreciate any suggestion.

[Alzhy]

Then use Perl with the DBI/DBD extensions plus some other RDBMS tools.

[Arunvijai_4]

Hi Shiv,

Since Java is platform independant, JDBC is good on both Windows and Unix world. If you want to know more about JDBC drivers,

http://java.sun.com/products/jdbc/index.jsp

-Arun

[Shivkumar]

Someone said that OWP (Oracle Wire Protocol) runs on ODBC only..is it true ?

[Arunvijai_4 · Accepted solution]

Hi Shiv,

Yes, it is true. OWP works only on ODBC. But, you can use ODBC_JDBC connectors.

http://media.datadirect.com/download/docs/odbc/odbcref/oracle.html

-Arun

[Ben Dehner]

Most ODBC drivers for Unix that I know of are proprietary products that you need to buy. (Most) JDCB drivers are provided for free by the vendors, or at least with the database products.

As for OCI verses thin, it depends on your application. Thin drivers are a single JAR file that contain all of the stuff to connect to a database; nice, tight and portable. However, now you have an independent Oracle client that you have to configure for connectivity.

In the case of Oracle, OCI drivers are a pass-through to the thick client. We're an Oracle shop, and, for server-based applications, I prefer the OCI driver, because it looks and acts like every other type of Oracle client. It uses the same OID naming service and other settings as all of my other server-based Oracle applications, so I only have to configure my Oracle client behavior in one place.