Hello Everyone, I emailed a couple of months ago that I was trying to install and run Collection Space on Mac OS X.6, but consistently received a jdbc driver error when it came to the Apache-Ant database build. I very much appreciate the suggestions I received for correcting the error, and followed them all most carefully. I was not ever able to actually get around this difficulty, and chalked it up to my own inadequate skills with Java and JBoss. I recently made contact at my new institution with a software developer who agreed to help me with the installation, and he is quite familiar with the components involved in Collection Space. After starting with a clean computer with no previous installations of any of the component softwares, we came up against the same jdbc driver error (/Users/RBettivia/Downloads/jboss/v1.5/build.xml:217: Class Not Found: JDBC driver com.mysql.jdbc.Driver could not be loaded). When trying to do the ant build, the program is unable to find the jdbc driver when it hits somewhere around line 217 in the build.xml file. We tried setting global environment variables, paths and classpaths, and downloading and saving the driver in a number of places, to no avail. At this point, I am wondering if anyone else has successfully installed the program on a Mac, and if so how this was done. If not, can someone suggest how the build file might be modified or another step we might take in order to get past this step in the installation process? Many thanks, Rhiannon Bettivia Graduate School of Library and Information Science University of Illinois, Urbana-Champaign

        <classpath>
            <!-- Add the following line here: -->
            <echo message="path to database driver file=${db.driver.jar}" />
            <pathelement path="${db.driver.jar}"/>
        </classpath>

Hi Rhiannon, Thanks for writing again to the Talk list! Let's see if we can get you up and running this time. > When trying to do the ant build, the program is unable to find the jdbc > driver when it hits somewhere around line 217 in the build.xml file. Some steps to help remotely diagnose what may be at issue: If you type this command at a prompt in your Terminal application: echo $JBOSS_HOME Does this output the path to a directory, or a blank line? If that outputs the path to a directory, if you type this command: cd $JBOSS_HOME Do you successfully change into that directory, or do you see an error message? If that succeeds, if you type this command: cd $JBOSS_HOME/server/cspace/lib Do you successfully change into that directory, as well, or do you see an error message? If you can successfully change to that directory, when you type this command, are any files listed? Specifically, do you see a file named 'mysql-connector-java-5.1.7-bin.jar'? ls mysql* If that succeeds, can you copy and paste the output from typing these three (separate) commands into a follow-up message? echo $JBOSS_HOME pwd ls -l Thanks! Aron Roberts (for the CollectionSpace project team) P.S. Something else for you or your software developer to try might be to insert an 'echo' statement in the build.xml file, just before the line where the failure occurs; something like this: <classpath> <!-- Add the following line here: --> <echo message="path to database driver file=${db.driver.jar}" /> <pathelement path="${db.driver.jar}"/> </classpath> When you run 'ant create_db', what does this print out? Some background: According to the build.properties file, located in the same directory as the build.xml file, the value of the ${db.driver.jar} variable should be set to this path: db.driver.jar=${jboss.lib.cspace}/mysql-connector-java-5.1.7-bin.jar Effectively, that means this file should be present on your system: $JBOSS_HOME/server/cspace/lib/mysql-connector-java-5.1.7-bin.jar where $JBOSS_HOME, in turn, is an environment variable that should contain the full path to your JBoss folder. On Tue, Jun 28, 2011 at 5:32 PM, Rhiannon Bettivia <rhiannonbettivia@gmail.com> wrote: > Hello Everyone, > I emailed a couple of months ago that I was trying to install and run > Collection Space on Mac OS X.6, but consistently received a jdbc driver > error when it came to the Apache-Ant database build.   I very much > appreciate the suggestions I received for correcting the error, and followed > them all most carefully.  I was not ever able to actually get around this > difficulty, and chalked it up to my own inadequate skills with Java and > JBoss.  I recently made contact at my new institution with a software > developer who agreed to help me with the installation, and he is quite > familiar with the components involved in Collection Space.  After starting > with a clean computer with no previous installations of any of the component > softwares, we came up against the same jdbc driver error > (/Users/RBettivia/Downloads/jboss/v1.5/build.xml:217: Class Not Found: JDBC > driver com.mysql.jdbc.Driver could not be loaded). > When trying to do the ant build, the program is unable to find the jdbc > driver when it hits somewhere around line 217 in the build.xml file.  We > tried setting global environment variables, paths and classpaths, and > downloading and saving the driver in a number of places, to no avail. > At this point, I am wondering if anyone else has successfully installed the > program on a Mac, and if so how this was done.  If not, can someone suggest > how the build file might be modified or another step we might take in order > to get past this step in the installation process? > Many thanks, > Rhiannon Bettivia > Graduate School of Library and Information Science > University of Illinois, Urbana-Champaign > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org > >