3 Replies Latest reply on May 5, 2004 2:16 PM by sgwood

    Nukes Can't Find JDBC Driver For MySQL

    jiwils

      After running the Nukes installer and filling out the datasource page (while following the updated Wiki instructions), I get a can not find database driver "org.gjt.mm.mysql.Driver" error when I click the next button.

      After searching the forums, I tried downloading the MySQL JDBC driver from the MySQL site and placing it in the JBOSS_HOME/lib directory. After this, I still get the same error. Should I place the driver somewhere else?

      Furthermore, other posts seemed to indicate that other datasource setup was required (in earlier releases/snapshots), but it seems to me that the datasource page is asking me the questions it needs to generate this kind of setup. Is this a misunderstanding?

      Can anyone point me in the right direction?

        • 1. Re: Nukes Can't Find JDBC Driver For MySQL
          jiwils

          I got past the problem of driver recognition. The driver should have been placed in the server's "lib" directory not the JBOSS_HOME/lib directory.

          With that, I encountered this error with the latest snapshot:


          INSERT INTO nuke_sections(pn_secname, pn_secimage) VALUES ('Nukes','transparent.gif'): error Column not found, message from server: "Unknown column 'pn_secimage' in 'field list'"


          It appears that some of the SQL is out of synch?

          • 2. Re: Nukes Can't Find JDBC Driver For MySQL
            jiwils

            Further investigation appears to indicate that the statement:

            CREATE TABLE nuke_sections ( pn_secid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, pn_secname VARCHAR(40) DEFAULT '' NOT NULL, pn_image VARCHAR(50) DEFAULT '' NOT NULL );

            incorrectly names the column pn_image instead of pn_secimage based on the names of the other columns in the table (and the INSERT statement that would not work).

            • 3. Re: Nukes Can't Find JDBC Driver For MySQL


              Looking at the SectionEJB, the name should be 'pn_image'. I have changed the insert in setup.xml in CVS to reflect this.

              Sherman