You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ojb-dev@db.apache.org by John York <jr...@careersite.com> on 2003/04/26 05:11:02 UTC

[OJB] Issue #OJB163 - ojbtest-schema.xml has incorrect required fields for MySQL

You can view the issue detail at the following URL:
<http://scarab.werken.com/scarab/issues/id/OJB163>

Type :        Defect
Issue Id :    OJB163
Reported by: John York
             johnryork - (jry@careersite.com)

Details:

Platform: All
Operating system: Redhat
Summary: ojbtest-schema.xml has incorrect required fields for MySQL
Description: using MySQL 3.23.54, prepare-testdb fails with this error:

[torque-insert-sql] Failed to execute: CREATE TABLE REF_REPOSITORY_FK ( REP_ID INTEGER NOT NULL, REF_FK INTEGER, REFA_FK INTEGER, REFB_FK INTEGER, NAME VARCHAR (100), PRIMARY KEY(REP_ID,REF_FK,REFA_FK,REFB_FK) )
[torque-insert-sql] java.sql.SQLException: General error,  message from server: "All parts of a PRIMARY KEY must be NOT NULL;  If you need NULL in a key, use UNIQUE instead"

Adding required="true" to the three other primary key columns fixes this problem
Functional area: Setup