SQL Server 2005's Type 4 JDBC driver provides database connectivity from a Java application. Though the driver class and connection URL are a bit different in this version, connectivity is a snap.

You could just implement a corresponding Java type that implements the SQLData interface and then tell the connection object the new SQL-Java type mapping via the Connection.setTypeMap() method.

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

Get an overview of JDBC's architecture, then learn how to connect to a database and handle SQL queries and responses with PreparedStatements, transactions, connection pooling, and more.

Create a database table named Player. Create a Java class with a main method that throws the generic Exception. Add an import for the required JDBC SQL classes. Code a database connection.

Every vendor provides a custom-built JDBC driver to marshal SQL queries back and forth from your Java app to their specific database. To connect to a MySQL database, you must download a MySQL JDBC ...