Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Shivkumar
Super Advisor

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

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.
5 REPLIES
Alzhy
Honored Contributor

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

Then use Perl with the DBI/DBD extensions plus some other RDBMS tools.
Hakuna Matata.
Arunvijai_4
Honored Contributor

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

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
"A ship in the harbor is safe, but that is not what ships are built for"
Shivkumar
Super Advisor

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

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

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

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
"A ship in the harbor is safe, but that is not what ships are built for"
Ben Dehner
Trusted Contributor

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

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.
Trust me, I know what I'm doing