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
