What is Type-3 Driver and when this driver is used?
Answers were Sorted based on User's Feedback
Answer / guest
Type-3 Driver is IntermediateDataAccess Driver.middleware
layers use this type of driver with the ability to connect
multiple clients with multiple servers.BEAWeblogic servers
use trhis type of driver.But architecturally this is very
flexible as intermediate driver can access the details of
the connection.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / devarathnam c,kotagudibanda(po
Type3 Driver:
It is also known as "Net Protocol driver" which is working
based on three-tier system.It requires a middle tire.Mainly
it is used in the "Network environment applications".It
will dependent on one of the application servers like
BEA Weblogic,IBM Websphere etc..
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chandrarekha
JDBC net pure java driver is the type-3 driver...the driver
is loaded at the client and server side and the driver uses
native class libraries to convert the jdbc calls into
native method calls and sends it to the CLI loaded at the
client side...this driver is used for applications over
web...
| Is This Answer Correct ? | 1 Yes | 5 No |
dear friends I have made connection with SQLSERVER where the following code is compiling properly but giving error at the runtime . I think error in this line where i am sending the value through string Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); import java.sql.*; //import mssqlserver.*; public class TestSQLCON { public TestSQLCON() throws Exception { // Get connection DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); System.out.println(); System.out.println("Successfully connected one"); System.out.println(); Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); if (connection != null) { System.out.println(); System.out.println("Successfully connected"); System.out.println(); // Meta data DatabaseMetaData meta = connection.getMetaData(); System.out.println("\nDriver Information"); System.out.println("Driver Name: " + meta.getDriverName()); System.out.println("Driver Version: " + meta.getDriverVersion()); System.out.println("\nDatabase Information "); System.out.println("Database Name: " + meta.getDatabaseProductName()); System.out.println("Database Version: "+ meta.getDatabaseProductVersion()); } } public static void main (String args[]) throws Exception { TestSQLCON test = new TestSQLCON(); } } so please help me
What is the meaning of “dirty read” in the database?
how can connection with oracle10g with java
What are different types of JDBC Drivers?
Why do I get UnsatisfiedLinkError when I try to use my JDBC driver?
Explain the necessary steps to connect to the database in java?
why we don't use the type 2 driver for connect to the database in jdbc?
What does the connection object represents?
How many types of resultset are there in jdbc?
How you restrict a user to cut and paste from the html page using java programing?
Where jdbc drivermanager class is used?
What is difference between jdbc and odbc?