Database on MS SQL 2000/2005 fail to be created due to too column length
------------------------------------------------------------------------
Key: MRM-735
URL: http://jira.codehaus.org/browse/MRM-735
Project: Archiva
Issue Type: Bug
Components: system
Affects Versions: 1.0.1, 1.0
Environment: Win XP
Tomcat 5.5
MS SQL 2000 / 2005
MS SQL 2005 JDBC Driver, v1.2
Reporter: Thomas Winkler
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
