
	Where results make sense

Topic: JDBC type 1 driver

Related Topics

JDBC type 2 driver

JDBC type 4 driver

JDBC type 3 driver

Java Database Connectivity

Flat file database

Java programming language

Database

Microsoft Access

Object database

Relational database

C plus plus

HyperCard

Database normalization

Charles Bachman

Ted Codd

	JDBC type 3 driver - Wikipedia, the free encyclopedia
		The JDBC type 3 driver, also known as the network-protocol driver is a database driver implementation which makes use of a middle-tier between the calling program and the database.
		This differs from the type 4 driver in that the protocol conversion logic resides not at the client, but in the middle-tier.
		The type 3 driver is platform-independent as the platform-related differences are taken care by the middleware.
	en.wikipedia.org /wiki/JDBC_type_3_driver (178 words)

	JDBC type 1 driver - Wikipedia, the free encyclopedia
		The JDBC type 1 driver, also known as the JDBC-ODBC bridge is a database driver implementation that employs the ODBC driver to connect to the database.
		Also, using this driver has got other dependencies such as ODBC must be installed on the computer having the driver and the database which is being connected to must support an ODBC driver.
		Type 1 is the simplest of all but platform specific i.e only to Microsoft platform.
	en.wikipedia.org /wiki/JDBC_type_1_driver (193 words)

	Easysoft JDBC-ODBC Bridge User Guide - Introduction
		Type 1 JDBC drivers are always written in platform-specific code and thus limit the potential of the application for cross-platform deployment.
		Type 3 JDBC drivers are client-server pairs which use a database-independent network protocol to bridge the network.
		Type 4 JDBC drivers are written entirely in Java and transmit database-specific messages direct to the DBMS, which cannot be changed without modifying or replacing the driver.
	www.easysoft.com /products/data_access/jdbc_odbc_bridge/manual/introduction.html (1560 words)

	JDBC—The Java Database API > JDBC—The Java Database API (Site not responding. Last check: 2007-10-18)
		As with the Type 1 driver, the native library tends to limit your cross-platform options because you might not be able to find a driver for your hardware platform.
		A Type 3 JDBC driver is pure Java and uses a database-independent protocol to communicate with a database gateway.
		Type 4 drivers are now the most popular because the JIT makes the driver perform at levels comparable to the native driver, and because the data doesn't pass through the JNI layer (that is, the driver doesn't need to translate data into Java objects), the Type 4 drivers typically outperform Type 2 drivers.
	www.samspublishing.com /articles/article.asp?p=131026 (956 words)

	[No title]
		Database flavor aside, JDBC drivers come in four distinct types, and the appropriateness of your choice of type for your particular environment is crucial.
		JDBC can pass any command from application to engine, so you can still access whatever database features you like, as long as you understand that you are sacrificing some of the abstraction you ostensibly sought in creating a database-independent interface.
		This driver was designed early on, to encourage the use of JDBC by making it compatible with the installed base of ODBC databases already in the marketplace.
	techrepublic.com.com /5102-6329-5195935.html (878 words)

	JDBC Drivers: How Do You Know What You Need? (Site not responding. Last check: 2007-10-18)
		Type 3 and Type 4 JDBC drivers are both pure Java drivers, and therefore, offer the best performance, portability, and range of features for Java developers.
		Type 1 drivers also don't support the complete Java command set and are limited by the functionality of the ODBC driver.
		Type 2 JDBC drivers are OS-specific and compiled, and although they offer more Java functionality and higher performance than Type 1 drivers, still require a controlled environment.
	archive.devx.com /dbzone/articles/dd_jdbc/sosinsky-2.asp (850 words)

	ONJava.com -- An Introduction to JDBC, Part 1
		JDBC drivers are available for most database platforms, from a number of vendors and in a number of different flavors.
		Type 1 drivers require some sort of non-Java software to be installed on the machine running your code, and they are implemented using native code.
		Type 2 drivers are implemented with native code, so they may perform better than all-Java drivers, but they also add an element of risk, as a defect in the native code can crash the Java Virtual Machine.
	www.onjava.com /pub/a/onjava/excerpt/javaentnut_2/index1.html (1597 words)

	JDBC drivers in the wild
		In that case, the type of driver depends on quite a few parameters: whether the application is Internet or intranet based, whether it needs to support heterogeneous databases, the number of concurrent users, and so on.
		Type 1 drivers may be useful for those companies that have an ODBC driver already installed on client machines.
		JDBC driver type 3 -- the net-protocol/all-Java driver -- follows a three-tiered approach whereby the JDBC database requests are passed through the network to the middle-tier server.
	www.javaworld.com /javaworld/jw-07-2000/jw-0707-jdbc.html (957 words)

	JDBC Basics: JDBC: Developer: Home (Site not responding. Last check: 2007-10-18)
		Type 4 drivers (such as DataDirect Connect for JDBC drivers) are the most common and are designed for a particular vendor's database.
		In contrast, a Type 3 driver is a single JDBC driver used to access a middleware server, which, in turn, makes the relevant calls to the database.
		Type 2 drivers require a native database API to be used.
	www.datadirect.com /developer/jdbc/basics/index.ssp (2058 words)

	A Brief Introduction to JDBC
		Since JDBC is just a specification (suggestions for writing and using JDBC drivers), third-party vendors develop JDBC drivers adhering to this specification.
		JDBC is there only to help you (a Java developer) develop data access applications without having to learn and use proprietary APIs provided by different RDBMS vendors.
		JDBC Type 2 Driver - They mainly use native API for data access and provide Java wrapper classes to be able to be invoked using JDBC drivers.
	www.stardeveloper.com /articles/display.html?article=2003082701&page=1 (665 words)

	JDBC type 2 driver (Site not responding. Last check: 2007-10-18)
		The JDBC type 2 driver, also known as the Native-API driver is a database driver implementation that uses the client-side libraries of the database.
		The type 2 driver is not written entirely in Java as it interfaces with non-Java code that makes the final database calls.
		However the type 2 driver provides more functionality and performance that the type 1 driver as it does not have the overhead of the additional ODBC function calls.
	encycl.opentopia.com /term/JDBC_type_2_driver (144 words)

	Create your own type 3 JDBC driver, Part 1
		Type 3 drivers shine when supporting Internet deployment in environments that connect to a variety of DBMS servers requiring numerous concurrently connected users where performance and scalability are major concerns.
		In the JDBC driver, RMI (Remote Method Invocation) serves as the net protocol for communicating between the driver's client and server tiers.
		The driver's server tier, an RMI server, uses the JDBC-ODBC Bridge—a type 1 driver—to finally communicate with the database.
	www.javaworld.com /javaworld/jw-05-2002/jw-0517-jdbcdriver.html (1116 words)

	JDBC Overview
		The JDBC API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases.
		The JDBC API contains two major sets of interfaces: the first is the JDBC API for application writers, and the second is the lower-level JDBC driver API for driver writers.
		With JDBC technology, businesses are not locked in any proprietary architecture, and can continue to use their installed databases and access information easily -- even if it is stored on different database management systems.
	java.sun.com /products/jdbc/overview.html (912 words)

	Overview of Java Development in DB2 UDB for Linux, UNIX, and Windows: Version 8.1 Update
		The JDBC drivers are categorized as the legacy/CLI drivers and the new Universal JDBC Drivers.
		One of the key reasons for using the driver in a type 2 architecture is for local application performance and for distributed transaction support.
		Because the Universal JDBC driver is independent of any particular JDBC driver-type connectivity or target platform, it supports both all-Java connectivity (type 4 driver) or JNI-based connectivity (type 2 driver) in a single driver instance to DB2 UDB.
	www-128.ibm.com /developerworks/db2/library/techarticle/0307zikopoulos/0307zikopoulos.html (2582 words)

	Java Database Connectivity Without Compromise (Site not responding. Last check: 2007-10-18)
		JDBC Driver performance and sophistication is solely dependent on the performance of the underlying ODBC Driver.
		JDBC Driver performance and sophistication is solely dependent on the performance of the underlying Native Driver and its database specific networking software.
		JDBC Driver performance and sophistication is solely dependent on the performance of the underlying database specific protocol implemented in Java by the relevant DBMS vendor.
	www.openlinksw.com /info/docs/opljdbc.htm (5806 words)

	An Overview of DB2 and Java DataBase Connectivity (JDBC)
		The JDBC Type 2 driver is a combination of Java and native code, and will therefore always yield better performance than a Java-only Type 3 or Type 4 implementation.
		This driver's implementation uses a Java layer that is bound to the native platform C libraries.
		The JDBC Type 4 driver is also a pure Java implementation that is just called a JDBC Type 4 driver for now, because there is no package for it in DB2 Version 7.
	www-128.ibm.com /developerworks/db2/library/techarticle/0203zikopoulos/0203zikopoulos.html (2016 words)

	JDBC \| TutorGig.co.uk Encyclopedia (Site not responding. Last check: 2007-10-18)
		The JDBC type 4 driver, also known as the native protocol driver is a database driver implementation that converts JDBC calls directly into the vendor specific database protocol.
		The JDBC type 3 driver, also known as the network protocol driver is a database driver implementation...
		J ava D ata b ase C onnectivity, or JDBC, is an API for the Java programming language that defines how a client may access a database.
	www.tutorgig.co.uk /encyclopedia/sencyclo.jsp?keywords=JDBC (455 words)

	PostgreSQL: Documentation: Manuals: PostgreSQL 7.3: JDBC Interface
		JDBC is a core API of Java 1.1 and later.
		Type 4 indicates that the driver is written in Pure Java, and communicates in the database system's own network protocol.
		For instance, I have an application that uses the JDBC driver to access a large database containing astronomical objects.
	www.postgresql.org /docs/7.3/static/jdbc.html (374 words)

	Chuck McDevitt's Type 4 JDBC driver for Teradata (Site not responding. Last check: 2007-10-18)
		This is where you can download my Type 4 JDBC driver for Teradata.
		If you use this driver, Let me know what problems you run in to, or let me know it is working for you, and what type of use you are using it for.
		I believe it's a good bit faster than their type 4 driver as well, and is much smaller.
	home.comcast.net /~chuck_mcdevitt/JDBC (573 words)

	ENT: Java Data Access - Technology Tutorial - Tutorial
		JDBC is based on a concept similar to ODBC.
		The driver presents a standard application programming interface to a Java application and is responsible for initiating and managing a database connection.
		Describing the spec is beyond the scope of this column, but I want to discuss the four types of JDBC drivers defined by Sun and describe their strengths and weaknesses.
	www.findarticles.com /p/articles/mi_m0FOX/is_16_4/ai_60369897 (394 words)

	Hyperion Developer Network : Resource Library : Tips and FAQs : Essbase Integration Services Release 7.0 Support Matrix
		JDBC Type 1 is installed when you install the Java Runtime Environment (included as an option in the Windows installation; included as a separate installation for UNIX).
		The JDBC Type 1 driver is not officially supported by Teradata; however, it works on all platforms except HP-UX.
		JDBC Type 4 drivers must be implemented when Oracle with OCI is being used.
	dev.hyperion.com /resource_library/tips_faqs/product_releases/integration_services_7.0_matrix.cfm (538 words)

	Java Skyline: Learn JDBC
		When the JDBC driver initially prepares a statement, it parses and error checks the statement and then sends execution plan information to the RDBMS, including the bindings of columns that you use in the statement.
		The JDBC API is quite extensive but even so, most of its actual work goes on under the hood inside the JDBC driver.
		To use the JDBC driver, you must 1) tell your program to load and activate the driver by class name and 2) specify where the driver is on the classpath.
	www.javaskyline.com /learnjdbc.html (1808 words)

	Data Access and Storage Developer Center: Microsoft SQL Server 2005 JDBC Driver
		The JDBC driver supports the use of JDBC basic and advanced data types within a Java application that uses SQL Server as its database.
		The JDBC driver can be used to work with data in a SQL Server database in a variety of ways.
		The JDBC driver can be used to run SQL statements against the database, or it can be used to call stored procedures in the database, using both input and output parameters.
	msdn.microsoft.com /data/jdbc/default.aspx (511 words)

	11. JDBC Components
		Driver for JDBC is implemented as a bridge to ODBC Drivers, thereby implementing the JDBC Driver classes through native methods, this is due to the fact that ODBC is a 'C' language based data access application programming interface.
		Thus, this driver format is inherently part Java and part Native, implying that it is inherently platform specific rather than independent.
		Driver for JDBC is implemented in Java sitting atop a database independent networking layer bridge also implemented in Java.
	docs.openlinksw.com /mt/OPLDriversUtilization.html (1382 words)

	7. JDBC Drivers (Site not responding. Last check: 2007-10-18)
		Driver for JDBC is implemented as a bridge to Native Database Call Level Interfaces, thereby implementing the JDBC Driver classes through native methods, this is due to the fact that Native Database Call Interfaces are either C/C++ language based data access application programming interfaces.
		JDBC Lite can be JDBC Types 1 or 2 only because you have to address platform specific database vender software beneath.
		This JDBC URL format is currently only supported by the OpenLink JDBC Agent for ODBC DSNs (JODBC Agent). DSN-Less connections require you to determine the ODBC connect string attributes for the ODBC Driver that you are using.
	www.openlinksw.com /info/docs/uda51/lite/OPLDriversUtilization.html (1538 words)

	JDBC Technology
		JDBC technology is an API (included in both J2SE and J2EE releases) that provides cross-DBMS connectivity to a wide range of SQL databases and access to other tabular data sources, such as spreadsheets or flat files.
		JDBC certification program.--> Our driver database is now searchable by supported JDBC API version, driver type, DBMS support, and features.
		JDBC Optional Package for CDC/Foundation Profile The JDBC API for CDC / FP Optional Package defines a subset of the JDBC 3.0 API that can be used in conjunction with the Java 2 Micro Edition (J2ME) Connected Device Configuration / Foundation Profile (CDC / FP).
	java.sun.com /products/jdbc/index.jsp (417 words)

	JDBC Type 1 Drivers (Site not responding. Last check: 2007-10-18)
		It translates commands from JDBC to ODBC, which then references the vendor code library, which must be on the client machine, and then sends the command on to the database server.
		This type of integration is good for a company that already has a database set up with an ODBC driver, and allows for quick integration into that database.
		Since there is not a direct link between JDBC and the database, the potential exists for decreased performance of the database interface.
	pigseye.kennesaw.edu /~agelder/type1.htm (266 words)

Try your search on: Qwika (all wikis)