Thanks for this post. I was also getting this today (using JTurbo). Bonnie MacKellar
-----Original Message----- From: BURT, RANDALL (CONTRACTOR) [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 3:05 PM To: OJB Users List Subject: MSSQL server - error in ojbtest-schema.xml Don't know if I should submit a bug report on this or not, but when I tried to run the prepare-testdb target using MSSQL server 2000 (MS's JDBC Driver), I would get the following error: [torque-insert-sql] Executing file: C:\java\utils\db-ojb-1.0.rc2\target\src\sql\ojbtest-schema.sql [torque-insert-sql] Failed to execute: /* ---------------------------------------------------------------------- */ [torque-insert-sql] /* REF_REPOSITORY_FK */ /* ---------------------------------------------------------------------- */ IF EXISTS (SELECT 1 ( ... ) [torque-insert-sql] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot define PRIMARY KEY constraint on nullable column in table 'REF_REPOSITORY_FK'. This was fixed by changing the REF_REPOSITORY_FK table description in ${OJB_HOME}\src\schema\ojbtest-schema.xml to make the required fields not null: <table name="REF_REPOSITORY_FK"> <column name="REP_ID" required="true" primaryKey="true" type="INTEGER"/> <column name="REF_FK" required="true" type="INTEGER" primaryKey="true"/> <column name="REFA_FK" required="true" type="INTEGER" primaryKey="true"/> <column name="REFB_FK" required="true" type="INTEGER" primaryKey="true"/> <column name="NAME" type="VARCHAR" size="100"/> </table> The tables now build correctly, though I am still tracking down some failed JUnit tests. Hope this helps somebody... --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
