RE: Problems using SQL Server and Archiva - Solved/Hacked

[Daniel King <dk...@vurv.com>]

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:dking@vurv.com] 
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