Series: Subject: Topic:
Question: 53 of 148

What is thin driver and thick driver. Why it is called so?

Asked by: mythilikumar | Member Since Mar-2006 | Asked on: Apr 4th, 2006

View all questions by mythilikumar

Showing Answers 1 - 8 of 8 Answers
S.V.D Kumar

Answered On : Apr 5th, 2006

I dont know about thick driver, but thin driver is a name given to one of the driver implemetaion, for java to be connected to Oracle. This is a type-4 driver where Java language call will be converted to network calls and will be sent to the Oracle DataBase Server.

Login to rate this answer.

Answered On : Apr 8th, 2006

hi,   thin driver is 4 type driver in java which r provide the connectivity between oracle and java.the main advantage is this driver is we connect the databse to java without create DSN.and it provide the all the host computer connectivity in the its r most important driver which we use in the java.prabahkar mishra

Login to rate this answer.

Answered On : Apr 8th, 2006

The JDBC Thin driver is typically easier to update/distribute, as installation consists of copying a .jar file or two. The only case where OCI has an advantage is in the use of Oracle's naming layer for database service abstraction. Of course this assumes the database server is listening for TCP/IP and not the legacy protocols that are only supported by OCI. Failover configurations using TAF are supported by OCI only. The newer 'Fast Connection Failover' feature of 10g RAC can also run over Thin though.

Login to rate this answer.

Answered On : Apr 15th, 2006

Basic difference between thin and thick client Oracle has a thin client driver, which mean you can connect to a oracle database without the Oracle client installed on your machine. Thick client would need the Oracle Client, database drivers,etc.. Drivers include JDBC-ODBC bridge drivers,JDBC drivers depending on tns resolution.Dominic

Yes  1 User has rated as useful.
Login to rate this answer.
Raghvendra Dwivedi

Answered On : May 9th, 2006


Login to rate this answer.
siva kumar reddy

Answered On : Aug 7th, 2006

hi guys and gals,i dont know correct reason ,i have to tell something about ittype1 and type2 drivers are thick drivers.bcoz these drivers are used some native methods(otherthan java language).type3 and type4 drivers are thin drivers.bcoz these drivers are used only java language.any correction occur please send to appropriate answers cheerssweet siva

Login to rate this answer.
asmita das

Answered On : Sep 7th, 2006

Thick driver - type 1 and type 2 JDBC drivers are called thick drivers. The reason for it is - it provides JDBC access via ODBC drivers. ODBC binary code, and in many cases, database client code, must be loaded on each client machine that uses such a driver. and as the program is connected to database by an extra layer, in the clint hence thay are called thick drivers.Thin drivers: This style of driver converts JDBC calls into the network protocol, used directly by DBMSs, allowing a direct call from the client machine to the DBMS server and providing a practical solution for intranet access. hence their conenction to DB is more direct and without any intermediate stage making them thin drivers. type 4 driver.

Yes  1 User has rated as useful.
Login to rate this answer.
prakash reddy

Answered On : Apr 21st, 2008

View all answers by prakash reddy

Major differences the number layers present between the java application and database

Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.