Installing the JDBC Driver in Java

Drawer QR in Java Installing the JDBC Driver

Although Dreamweaver includes everything you need to use the Java JDBC driver classes for several databases, it doesn t include the code for the JDBC drivers To install the appropriate JDBC driver for your database, follow these steps:

Java packages are distributed as jar files See Table 5-2 to find out where to download the file you need

2 Copy the Java jar file to C:/program files/macromedia/

The name of the jar file may not exactly match the class that s supplied in the file For example, the name of the MySQL jar file is mysqlconnector-java-3112-binjar

After you install the database driver, you can create a dynamic page and the database connection in JSP, as described in the next section

Table 5-2

www-306ibmcom/ software/data/db2/ udb/ad/v8/java/ wwwmysqlcom/ products/ connector/j/ wwworaclecom/ technology/software/ tech/java/sqlj_jdbc/ htdocs/jdbc_10201 html wwwinetsoftwarede/ Downloadhtm Included with Dreamweaver

Because pages that work with a database are dynamic, Dreamweaver requires you to create a dynamic page before you can add a database connection Follow these steps to create a new dynamic JSP page:

2 On the General tab, select Dynamic Page from the Category list 3 Select JSP from the Dynamic Page list, as shown in Figure 5-1

4 Select a document type definition from the Document Type (DTD)

After you create a dynamic JSP page (as described in the previous section), follow these steps to create a database connection in JSP:

Expand the Application panel, if it s not already expanded, and then click the small triangle in the panel s title bar until it points downward

the drop-down list You can choose from the database types listed in Table 5-1 After you make a selection, a connection dialog box named for the type of connection appears The Driver and URL fields are prefilled for all the standard database driver types (see Figure 5-2, which shows the MySQL driver) The fields in the custom connection dialog box, shown in Figure 5-3, are all blank

Dreamweaver uses this name to reference your database connection The name can have letters, numbers, or an underscore: No other characters are allowed

The field is prepopulated for every database type except the Custom JDBC Database If you re setting up a custom connection, you can usually find the Java class name in the driver s documentation The class name tells Dreamweaver what Java code to call to access the database For example, using the MySQL driver, the class name is orggjtmmmysqlDriver If you re using a JDBC driver, you should have already downloaded it If you click the Test button and you get a Class not found alert, you need to download the class See Table 5-2 for a list of download locations

for your database If you re creating a custom connection, refer to the documentation that came with your JDBC driver for the format of this connection string The URL field contains all the information required to log in to the database in one long string For example, for the MySQL driver, it lists the following URL:

jdbc:mysql://[hostname]/[database name]

In this example, replace the bracketed values [hostname] and [database name] with the information for your database

This setting determines if the local machine or the remote application server s driver is used to connect to the database If you re using a Macintosh, you can ignore this setting: Macs always use the remote application server to connect

A dialog box confirms a successful connection or displays an error message if it couldn t connect If you received a Class was not found error message when you clicked the Test button, you don t have the driver installed for that type of database Download the Java package that corresponds to the type of database driver Table 5-2 lists where to find each driver on the Internet