84 Advanced Java JDBC Tutorial | Type 3 JDBC Driver | Java Database Connectivity | adv java

Publicado el: 23 septiembre 2017
en el canal de: tech fort

651

Advanced Java JDBC Tutorial : adv java Java Database Connectivity
Type 3 JDBC Driver is protocol cum driver to interact with proxy server/webserver/application server. (IDS server)

This server internally uses type 1/2/4/5 drivers to interact with Database software.

while working with type 3 driver the client application does not interact with database software directly, but it interacts with proxy server & makes proxy server to interact with database software.

I.D.S. Server:(Internet Database Access Server)(To work with Type 3 driver)
=============
Type : Proxy Server for JDBC & .net environment useful to work with jdbc type 3 driver.
Version: 4.2.2LE
Commercial Software :30 Days trial Version
Vendor: Microsoft & Sun Micorsystem(Oracle)
For Help & docs: www.idssoftware.com

Default port no : 12

The IDS server internally uses Type 1 JDBC driver to interact with Database software & to create connection pool/ConnectionFactory.

IDS Server 4.2 is an Internet database access server that enables both Java and .NET applications to connect to databases. It offers three client components:
1)IDS JDBC Driver, a compact, platform neutral and high performance Type-3 JDBC driver that implements the Java Database Connectivity (JDBC) 3.0 API.

2)IDS .NET Data Provider, allows ADO.NET applications to access databases base on the standard .NET Data Provider architecture.

3) IDS .NET SQL Driver defines and implements a powerful and feature rich database access API for all.

procedure to work with Type 3 JDBC driver by using IDS server as mediator/proxy server between java JDBC application & database software.
====================================================================
Step 1) Install IDS server & make sure that its in running mode.

Step 2) Create .mdb file in MS-Access having records.

Step 3) Create The DSN for MS-Access driver pointing to student.mdb database file

Step 4) Develop JDBC Application by using IDS supplied Type 3 driver

Step 5) Add following path to environment Variable of ur computer

Stpe 6) compile & run

*1 Here DriverManager Service uses the given IDS type 3 driver to intearact with IDS server & get the connection object given by IDS server.

import java.sql.*;
public class Type3Test
{
public static void main(String[] args) throws Exception
{
Class.forName("ids.sql.IDSDriver"); //type 3 driver class
Connection con=DriverManager.getConnection("jdbc:ids://localhost:12/conn?dsn='accdsn'"); //*1
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from bestudent");
while(rs.next())
{
System.out.println(rs.getInt(1)+"\t"+rs.getString(2)+"\t"+ rs.getString(3));
}
st.close();
con.close();
}
}

En esta página del sitio puede ver el video en línea 84 Advanced Java JDBC Tutorial | Type 3 JDBC Driver | Java Database Connectivity | adv java de Duración hora minuto segunda en buena calidad , que subió el usuario tech fort 23 septiembre 2017, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 651 veces y le gustó 63 a los espectadores. Disfruta viendo!