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]
