-
1. Re: Nukes Can't Find JDBC Driver For MySQL
jiwils May 5, 2004 1:54 PM (in response to 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 May 5, 2004 2:08 PM (in response to 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
sgwood May 5, 2004 2:16 PM (in response to jiwils)
Looking at the SectionEJB, the name should be 'pn_image'. I have changed the insert in setup.xml in CVS to reflect this.
Sherman