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

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(); } }