SocketJdbc

SocketJdbc is a 100% pure java socket-based client/server JDBC Driver that allows access to data sources over the Internet...
Download

SocketJdbc Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Shareware
  • Publisher Name:
  • 15377
  • Operating Systems:
  • Windows All
  • File Size:
  • Evaluation

SocketJdbc Tags


SocketJdbc Description

SocketJdbc is a server application and a client JDBC driver that allow access to data dources over the Internet. Since both the server and the client driver are written in java they are 100% platform independent. Unlike Sun's JDBC the SocketJdbc driver can be used in 1.0.2, 1.1 and 1.2 Java Virtual Machines (VM). SocketJdbc client and server work together they can't be used separetly. THE CLIENT The SocketJdbc client driver includes classes that implement the Sun's JDBC interfaces (e.g. ResultSet). It also includes the JDBC classes (e.g. DriverManager) since they are not part of the java 1.0.2 Virtual Machine (VM). These classes form the SocketJdbc driver. If the client is a Java applet one needs a Web server to initially fetch the html page that contains the APPLET tag and then fetch the java classes (executable) making up the applet. If the client is a Java application there is no need for a Web server since the application classes would reside on the client machine. Sun introduced JDBC with java 1.1, therefore JDBC requires a java 1.1 or 1.2 VM to run. Since many peoples are still using java 1.0.2 enabled browsers (e.g. Netscape 3.x and MSIE 3.x) using SocketJdbc driver in your applets allow you to reach a wider audience. The SocketJdbc driver classes can be executed by java 1.0.2, java 1.1 and java 1.2 Virtual Machines. They can therefore run in the following browsers without any special requirements (e.g. no plug-ins required): Netscape 3.x (java 1.0.2) MSIE 3.x (java 1.0.2) Netscape 4.x (java 1.1) MSIE 4.x/5.x (java 1.1) Starting with version 1.10, the client can now access the server from behind a proxy/firewall. If a standard socket connection cannot be established with the server, the driver will attempt to connect using http tunneling. This will work provided that the proxy server allows http connection on any TCP ports, that is ports other than 80. THE SERVER The SocketJdbcServer is a multi-threaded java application that needs to be run in a Java 1.1 or 1.2 Virtual Machine. It receives queries from SocketJdbc clients and forward them to data sources using the appropriate local JDBC driver. It then receives "responses" from data sources and forward them to SocketJdbc clients. As long as you have the JDBC driver for a given Data Source you can use SocketJdbc to access it over the Internet. Normally the JDBC driver is provided by the DBMS vendor (it's like a printer driver which is provided by the printer manufacturer). Sun's JDK 1.1 or 1.2 core API comes with a JDBC driver (JdbcOdbcDriver) that will allow the SocketJdbcServer to access any ODBC data source. In particular on Windows platforms the driver can connect to MS-Access, SQL Server, dBase, FoxPro, Paradox, Excel spreadsheets and more. Obviously these require that you have the corresponding native ODBC driver (no problem, it comes with the product). Because of its multi-threaded nature the SocketJdbcServer can accept many simultaneous connections from multiple clients. Platforms supported:Platform independentBenefits of registration:Allows JDBC programming in java 1.0.2 Virtual Machines. Faster than RMI which anyway requires java 1.1 VMs.


SocketJdbc Related Software