
|
 |
Page 4 -- Installing the JDBC Driver on
the Web Server
The Phakt PHP server model, which we'll be talking about shortly,
relies on a JDBC connection to the MySQL database for run-time
connections. These connections are used for such things as creating
the objects that appear in UltraDev's Data Bindings Inspector,
Live Data Preview, and the like. We'll need to install these drivers
to get it to work, and there are some pretty details steps involved
in doing so. Follow along closely with me now; watch the
wording:
- First, decompress the MM.MySQL Java archive (JAR) file that
you just downloaded. The latest version of the JDBC driver
as of the writing of this article is v2.0.8, and the JAR file
should be called something like mm.mysql-2.0.8-you-must-unjar-me.jar.
If you are using StuffIt Expander, it may have done this for
you already. There will likely be a folder on your desktop
called "mm.mysql-2.0.8-you-must-unjar-me Folder"
or something along that line that contains the objects we
need. If it hasn't been "un-JARred" for you yet,
drag the JAR file onto your Stuffit Expander application icon
or use your favorite decompression tool.
- From the Finder menu, select Go > Go To Folder...
and enter "/usr/local/" (without the quotes).
- Open the folder called "mysql-3.23.47" in
your /usr/local folder
- Open the folder called "mm.mysql-2.0.8-you-must-unjar-me
Folder" from the location into which it was decompressed
in Step 1, and find the folder named "mm.mysql-2.0.8."
- Copy the entire "mm.mysql-2.0.8" folder into
the "mysql-3.23.47" folder.
Installing the JDBC Driver for UltraDev
and OS 9 (Mac Ultradev Users Only)
The steps above install the JDBC driver for MySQL to use, but JDBC
is a two-way street. You also need to install the same JDBC driver
on the other end of the connection so that UltraDev (or other
applications) can use it. Note: This is for the Classic layer
(OS 9) to use.
- In the /usr/local/mysql-3.23.47/mm.mysql-2.0.8 folder
that was just installed above, find the file called mm.mysql-2.0.8-bin.jar.
- Place a copy of this file (not an alias of it) in Macintosh
HD : System Folder : Extensions : MRJ Libraries : MRJClasses.
If your system hard drive is named differently than that which
is shown above, or if OS 9 is installed on a different partition,
follow the path to the MRJClasses folder on that drive.
- Reboot your Mac for changes to take effect.
Let's install Phakt!
|