The fields you will need to change are described here: http://svn.apache.org/viewvc/archiva/branches/archiva-1.3.x/archiva-modules/archiva-base/archiva-model/src/main/mdo/archiva-base.xml?revision=900340&view=markup
To edit this in the installation, you would need to: a) unpack apps/archiva/WEB-INF/lib/archiva-model-1.3.4.jar to extract the file org/apache/maven/archiva/model/package.jdo b) edit the fields in there as needed c) add the file back into the model JAR and start archiva (The JAR is just a zip file) - Brett On 13/05/2011, at 2:53 AM, Huang, Joseph wrote: > Hi, > > We just installed Archiva for our developers and we have MSSQL for the > back-end database. Because some Java exception reported by our developers, we > noticed some tables are missing due to the column width exceeds the system > limit (8192 vs. 8000). I did some research online and found it is known > problem for various database servers (MSSQL, Oracle, etc.). However, it seems > there is no easy way to fix it. Since I'm not a Java programmer, I don't know > how to modify Archiva code to resolve this problem. I wonder whether there's > database schema (or DDL scripts) I can use to manually create those tables. > > Thanks in advance. > > JH > > -- Brett Porter br...@apache.org http://brettporter.wordpress.com/ http://au.linkedin.com/in/brettporter
