db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John York <...@careersite.com>
Subject [OJB] Issue #OJB163 - ojbtest-schema.xml has incorrect required fields for MySQL
Date Sat, 26 Apr 2003 03:11:02 GMT
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


Mime
View raw message