Overview
Cross-platform Java Database Connectivity JDBC implementations are commonly used to connect Java programs to any of the major databases available on the market today. There are several possibilities of connecting programs to databases. We’ll focus on JDBC here and are going to point out one of the key advantages: there is no client side software installation required.
More exactly, we do not need the Microsoft SQL Server client side installation. JDBC works just over your network. You may take a program to any of your PCs and run it directly from your CD. This works, of course, not only because we use JDBC, but also because we use Java.
Example:
Microsoft SQL Server is located on the machine in the centre of the following figure. Note that SQL Server 2000 is only running on Microsoft’s Server Operating Systems. Our test environment includes the following hardware: Windows 2000 Professional, SUN Solaris 8 and Redhat Linux 7.2.