[MRM-735] Database on MS SQL 2000/2005 fail to be created due to too column length

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.0, 1.0.1
• Component/s: system
• Environment: Win XP; Tomcat 5.5; MS SQL 2000 / 2005; MS SQL 2005 JDBC Driver, v1.2
• Assignee: Brett Porter
• Reporter: Thomas Winkler
• Created: 10/Mar/08 11:34
• Updated: 23/Feb/10 02:23
• Resolved: 23/Feb/10 02:23

Description

Some column lengths in the datamodel exceed the restrictions of MS SQL Server using the default String jdbc-mapping of jpox (varchar)

These are according to package.jdo:

• Table: ARCHIVA_PROJECT
  -> Columns: description
• Table: ARCHIVA_LICENSES
  -> Columns: comments
• Table: ARCHIVA_REPOSITORY_PROBLEMS
  -> Columns: message

The 2005 Jdbc driver uses the nvarchar datatype in case of varchar jdbc types. The maximum length here would be 4000 bytes.

Some other db systems should have the same problem, as I could see from their specs, but I'm not an expert (Oracle: 4000 bytes, DB2: 4-32k depending on page size).

A possible fix for MS SQL is, not to provide any length. Instead we could use the jdo jdbc-type. I tested it with using the jdbc-type="LONGVARCHAR". Then jpox uses ntext column types for those fields.

Unfortunatly, there is no way to define this parameter within modello.

Issue Links

• is superceded by: MRM-1025 remove the archiva database