Creating connection objects in JDBC applications
The first step in any database application is establishing a connection to the database. DB2 provides different methods to create a database connection. In general, we have two types of database connectivity:
Type-2 connectivity: This type of connectivity needs a database client installed on the host machine. It can only connect to local databases. If we want to use this type of connectivity to connect to a database available over the network, then we need to catalog that database on the client application host and then use this type of connectivity. The only specification provided to establish a connection is that the database name should be available in a local database directory.
Type-4 connectivity: This type of connectivity can be used to connect to any database over the network. It can also connect to a local database, but through its network address. The specification required to establish a connection includes a network address,...