What MySql Version? Can you post your archiva.xml?
On Jan 7, 2008 10:57 AM, Zemian Deng <[EMAIL PROTECTED]> wrote: > Hi list, > I didn't see a separated list for archiva, so I post question here. > > I am installing archiva with default derby worked fine. Now I am trying to > configure to use Mysql. When I run my Tomcat server, I get the following > error: > > 2008-01-07 13:18:12,481 [main] INFO > org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/archiva] > - Loading plexus context properties from: '/WEB-INF/plexus.properties' > 2008-01-07 13:18:12,488 [main] INFO > org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/archiva] > - Could not load plexus context properties from: > '/WEB-INF/plexus.properties' > 2008-01-07 13:18:13,365 [main] INFO org.codehaus.plexus.PlexusContainer - > Loading on start [role,roleHint]: [ > org.apache.maven.archiva.web.startup.ArchivaStartup,default] > 2008-01-07 13:18:15,031 [main] WARN > net.sf.ehcache.config.ConfigurationFactory - No configuration found. > Configuring ehcache from ehcache-failsafe.xml found in the classpath: > jar:file:/opt/apache-tomcat-5.5.17 > /instances/buildman/webapps/archiva/WEB-INF/lib/ehcache- > 1.3.0.jar!/ehcache-failsafe.xml > 2008-01-07 13:18:16,497 [main] WARN JPOX.General - SQL warning: > java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use > 'ENGINE=storage_engine' instead > 2008-01-07 13:18:17,387 [main] ERROR JPOX.RDBMS - Error thrown executing > CREATE TABLE `SECURITY_OPERATIONS` > ( > `NAME` VARCHAR(256) BINARY NOT NULL, > `DESCRIPTION` VARCHAR(256) BINARY NULL, > `PERMANENT` BIT NOT NULL, > `RESOURCE_REQUIRED` BIT NOT NULL, > PRIMARY KEY (`NAME`) > ) TYPE=INNODB : BLOB/TEXT column 'NAME' used in key specification without > a > key length > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column > 'NAME' > used in key specification without a key length > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) > > I assume that I have to specific somewhere that I am using Mysql dialect? > Can't find where to configure this. Can someone help me here? Thanks. > > -Zemian > -- Thanks, Mick Knutson http://www.baselogic.com http://www.blincmagazine.com http://www.djmick.com http://www.myspace.com/mickknutson http://www.myspace.com/BLiNCMagazine http://tahoe.baselogic.com ---