search

davemckain / qtiworks

**This project will be closed in early 2023!** IMS QTI 2.1 assessment delivery engine and Java development library (JQTI+). Supports the MathAssess extensions. Replacement for QTIEngine/JQTI and MathAssessEngine/JQTI. Note that this project has now ended and no further work is currently planned.
Other
67 stars 55 forks source link

DB column name 'public' is a reserved keyword in MSSQL #44

Closed davemckain closed 10 years ago

davemckain commented 10 years ago

One of the mapped database column names 'public' specified in the JPA annotations is a reserved word in Microsoft SQL Server, so is causing problems there.

This will need to be renamed. It would be worth checking all other mappings too to ensure they're not reserved in any of the most common DB products.

(Note that existing installations will need to make a schema change once this has been fixed.)

Thanks to Kevin Curley for pointing this out.

davemckain commented 10 years ago

This was fixed in commit 6737dd7, along with other potential name clashes taken from the list in [1].

NB: If you have an existing QTIWorks installation then you'll need to update your schema. There's a migration script (for PostgreSQL) in support/schema-migrations/beta5-to-beta6.sql

I'm not planning any more DB changes before the release of 1.0.0 final.

[1] https://drupal.org/node/141051