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

["Olivier Dassaud (JIRA)" <ji...@codehaus.org>]

    [ http://jira.codehaus.org/browse/MRM-735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_127446 ] 

Olivier Dassaud commented on MRM-735:
-------------------------------------

Hello,

In fact, there is the same problem with Oracle system... the 4000 bytes limit.

A ticket has been set and a solution is now described :
http://jira.codehaus.org/browse/MRM-657

Olivier.

> 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.0.1
>         Environment: Win XP
> Tomcat 5.5
> MS SQL 2000 / 2005
> MS SQL 2005 JDBC Driver, v1.2
>            Reporter: Thomas Winkler
>             Fix For: 1.0.x
>
>
> 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