I fixed this issue by doing the following using WinRARA (great tool!): Open apache-archiva-1.0.2.war file Go to WEB-INF\lib directory Open archiva-model-1.0.2.jar file Drag and drop a copy of package.jdo to desktop Open package.jdo Replace 8192 with 8000 (There should be two occurences - SQL Server has a limit of 8000 for varchar) Save the file and replace it in the archiva-model-1.0.2.jar file Replace this archiva-model-1.0.2.jar file in the apache-archiva-1.0.2.war file
Then I deployed the new war and all the tables were created and correct. Is there anyway that a specific JDO file could be created for specific databases like SQL Server, Oracle, etc because Oracle has a 4000 varchar limit? Thanks, Daniel King Vurv The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify me immediately by replying to the message and deleting it from your computer. Thank you. -----Original Message----- From: Daniel King [mailto:[EMAIL PROTECTED] Sent: Friday, April 18, 2008 11:51 AM To: archiva-users@maven.apache.org Subject: Problems using SQL Server and Archiva Where can I get the scripts that are used to create the archiva and user databases? I can't use Derby and have to use SQL Server. The problem I'm having is that SQL Server has a 8,000 character limit on varchar and a few tables have set the varchar at 8,192. So right now I'm just looking in the archiva.log for the errors and creating the tables. However this doesn't give me the foreign key relationships. Thanks, Daniel