appendix-a.html

linux-unix130.linux.and.unix.ebooks130 linux and unix ebookslinuxLearning Linux - Collection of 12 E

<P><FONT SIZE="+1"><B>Fire Up mSQL</B></FONT></P>
<P>Now that all this done, you can fire up mSQL. Just type the command:
</P>
<!-- CODE SNIP //-->
<PRE>
     /usr/local/Minerva/msqld &#38;
</PRE>
<!-- END CODE SNIP //-->
<P>Do not forget the <B>&#38;</B> at the end of the command: despite the fact that this is a daemon, you must run it in the background. If you wish, you can embed this command in file <B>/etc/rc.d/rc.local</B> to fire up mSQL whenever you reboot your system. Be absolutely sure, however, that you put the <B>&#38;</B> at the end of the command. If you do not, <B>rc.local</B> will never terminate and your system will hang.</P>
<H3><A NAME="Heading11"></A><FONT COLOR="#000077">Java Tools</FONT></H3>
<P>The CD-ROM includes a very useful set of tools for developing Java programs. The following describes how to install them.
</P>
<H4 ALIGN="LEFT"><A NAME="Heading12"></A><FONT COLOR="#000077">Java Development Kit</FONT></H4>
<P>The release of Linux that is included with this book includes a recent version of the Java Development Kit (JDK) for Linux. The JDK was ported to Linux by a devoted Linux programmer, Randy Chapman.
</P>
<P><FONT SIZE="+1"><B>Installation</B></FONT></P>
<P>If you are installing the package under an up-to-date version of Slackware Linux, such as that included on the CD-ROM, you can do the following:
</P>
<DL>
<DD><B>1.</B>&nbsp;&nbsp;Log in as the superuser <B>root</B>.
<DD><B>2.</B>&nbsp;&nbsp;Mount the CD-ROM.
<DD><B>3.</B>&nbsp;&nbsp;<B>cd</B> to the directory onto which you have mounted the CD-ROM.
<DD><B>4.</B>&nbsp;&nbsp;Type command:
<!-- CODE SNIP //-->
<PRE>
     installpkg java.tgz
</PRE>
<!-- END CODE SNIP //-->
</DL>
<P>If you are running a version of Linux other than Slackware, you must install the package by hand, as follows:
</P>
<DL>
<DD><B>1.</B>&nbsp;&nbsp;Log in as the superuser <B>root</B>.
<DD><B>2.</B>&nbsp;&nbsp;Mount the CD-ROM.
<DD><B>3.</B>&nbsp;&nbsp;From the CD-ROM&#146;s home directory, copy archive <B>contrib/java/java.tgz</B> into directory <B>/usr/local</B>.
<DD><B>4.</B>&nbsp;&nbsp;Use the following command to de-archive the kit:
<!-- CODE SNIP //-->
<PRE>
     tar xvzf java.tgz
</PRE>
<!-- END CODE SNIP //-->
<DD><B>5.</B>&nbsp;&nbsp;Read file <B>/usr/local/java/READ.ME</B> for detailed instructions on installation of the kit. Follow these instructions <I>exactly</I>. If you run into a problem, be sure to read the FAQ carefully.
</DL>
<P>For your own sanity, we strongly urge you to install the JDK into its default directory, which is <B>/usr/local/java</B>.</P>
<P><FONT SIZE="+1"><B>Latest Version</B></FONT></P>
<P>The Java world is changing rapidly, and it is quite possible that a newer version of the Java Development Kit will have been released between the time that this book was written and the time you read it. To get the latest information about programming Java under Linux, check out URL:
</P>
<!-- CODE SNIP //-->
<PRE>
     <A HREF="http://www.blackdown.org/java-linux.html">http://www.blackdown.org/java-linux.html</A>
</PRE>
<!-- END CODE SNIP //-->
<P>To download the latest version of the JDK, see URL:
</P>
<!-- CODE SNIP //-->
<PRE>
     <A HREF="http://www.blackdown.org/java-linux/mirrors.html">http://www.blackdown.org/java-linux/Mirrors.html</A>
</PRE>
<!-- END CODE SNIP //-->
<H4 ALIGN="LEFT"><A NAME="Heading13"></A><FONT COLOR="#000077">JDBC</FONT></H4>
<P>To compile the Java examples in this book, you need to install JDBC onto your system. JDBC is comprised of two sets of Java objects: the driver-manager objects, which are supplied by Sun; and the driver objects for mSQL, which come from a third-party source.
</P>
<P><FONT SIZE="+1"><B>Copyrights</B></FONT></P>
<P>The full copyright statement for Sun&#146;s JDBC driver manager is kept in file <B>/usr/local/java/jdbc/License</B>. The following gives Sun&#146;s copyright statement for these objects:</P>
<P>&#147;The JDBC Java Database driver manager is owned and licensed exclusively by Sun Microsystems, Inc. Copyright (C) 1996 Sun Microsystems, Inc. All rights reserved. Java, Hotjava, JDBC, the Java and coffee cup Logos, Sun, Sun Microsystems, and the Sun Logo are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.&#148;</P>
<P>The mSQL Java objects included with this book were written by Darryl Collins, of the Department of Mining and Metallurgical Engineering, University of Queensland, Australia, and are copyrighted by him. The JDBC interface to these objects was written by George Reese of Imaginary Software, and is copyrighted by him. We thank Messrs. Collins and Reese for kindly permitting us to include their work on our disk. We ask you to read the copyright statements that are included with these objects, and to abide by their conditions.</P>
<P>A key bug fix to the Imaginary JDBC interface was provided by programmer Gerrit Griebel. We also wish to thank Mr. Griebel for kindly allowing us to patch his code into this release.</P>
<P><FONT SIZE="+1"><B>Installation</B></FONT></P>
<P>Installation is in two parts: installation of Sun&#146;s JDBC driver manager, and installation of the JDBC driver for mSQL. Please note that before you install JDBC onto your system, you must first have installed the JDK. If you have not yet installed the JDK onto your system, do so; then return to this section.
</P>
<P>To install the driver manager, do the following:</P>
<DL>
<DD><B>1.</B>&nbsp;&nbsp;Log in as the superuser <B>root</B>.
<DD><B>2.</B>&nbsp;&nbsp;Mount the CD-ROM.
<DD><B>3.</B>&nbsp;&nbsp;From the directory onto which you mounted the CD-ROM, copy file <B>database/sun_jdbc.tgz</B> into directory <B>/usr/local/java</B>.
<DD><B>4.</B>&nbsp;&nbsp;<B>cd</B> to directory <B>/usr/local/java</B>.
<DD><B>5.</B>&nbsp;&nbsp;Type the following command to de-archive the driver manager:
<!-- CODE SNIP //-->
<PRE>
     tar xvzf sun_jdbc.tgz
</PRE>
<!-- END CODE SNIP //-->
</DL>
<P>To install the mSQL JDBC driver, do the following:
</P>
<DL>
<DD><B>1.</B>&nbsp;&nbsp;Log in as the superuser <B>root</B>.
<DD><B>2.</B>&nbsp;&nbsp;Mount the CD-ROM.
<DD><B>3.</B>&nbsp;&nbsp;From the directory onto which you mounted the CD-ROM, copy file <B>database/mSQL-JDBC.tgz</B> into directory <B>/usr/local/java</B>.
<DD><B>4.</B>&nbsp;&nbsp;<B>cd</B> to directory <B>/usr/local/java</B>.
<DD><B>5.</B>&nbsp;&nbsp;Type the following command to de-archive the driver manager:
<!-- CODE SNIP //-->
<PRE>
     tar xvzf mSQL-JDBC.tgz
</PRE>
<!-- END CODE SNIP //-->
<DD><B>6.</B>&nbsp;&nbsp;Finally, you must set environmental variable <B>CLASSPATH</B>. Set it in file <B>/etc/profile</B> to include directories that hold the objects you have just installed, as follows:
<!-- CODE SNIP //-->
<PRE>
   export CLASSPATH=/usr/local/java/jdbc/classes:/usr/local/java/
mSQL-JDBC.0.9.4/classes:
</PRE>
<!-- END CODE SNIP //-->
</DL>
<P>If you have installed the Java development kit into a directory other than <B>/usr/local/java</B>, be sure to change this command appropriately.</P>
<H3><A NAME="Heading14"></A><FONT COLOR="#000077">Example Programs</FONT></H3>
<P>The example programs described in this book are kept in directory <B>database/examples</B>. Because some of the programs must be compiled to be usable, we suggest that you copy the files onto a directory on your hard disk.</P>
<H3><A NAME="Heading15"></A><FONT COLOR="#000077">Additional Programs</FONT></H3>
<P>Additional database software is kept on the CD-ROM, under directory <B>database</B>. To install a package that interests you, copy the appropriate archive into directory <B>/usr/src</B>. Then de-archive it and read the directions that are included within the archive.</P><P><BR></P>
<CENTER>
<TABLE BORDER>
<TR>
<TD><A HREF="ewtoc.html">Table of Contents</A></TD>
</TR>
</TABLE>
</CENTER>


</td>
</tr>
</table>
<!-- begin footer information -->



</body></html>