archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mohni, Daniel" <daniel.mo...@ch.unisys.com>
Subject RE: supported databases ?
Date Thu, 12 Oct 2006 08:40:54 GMT
Hi Arnaud 

>    What databases are supported ? Only Derby or I can try to 
> connect archiva
> to another one like mySQL ?
> 

I tryed with mySQL using this ressource definition:

    <Resource name="jdbc/users" auth="Container"
type="javax.sql.DataSource"
        username="archiva"
        password="archiva"
        driverClassName="com.mysql.jdbc.Driver"
        url="jdbc:mysql://localhost/archiva?autoReconnect=true"
       />

with a local mysql instance with catalog archiva and user
archiva/archiva

when accesing localhost:8080/archiva I get an exception, the logs will
show this:

2006-10-12 10:02:52,078 [http-8080-Processor24] INFO
Interceptor:pssSecureActionInterceptor -
org.codehaus.plexus.security.ui.web.interceptor.SecureActionInterceptor
initialized!
2006-10-12 10:02:52,078 [http-8080-Processor24] INFO
Interceptor:pssSecureActionInterceptor -
org.codehaus.plexus.security.ui.web.interceptor.SecureActionInterceptor
initialized!
2006-10-12 10:02:52,421 [http-8080-Processor24] ERROR VelocityComponent
- ResourceManager : unable to find resource 'VM_global_library.vm' in
any resource loader.
2006-10-12 10:02:55,281 [http-8080-Processor24] WARN  General
- SQL warning: java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated;
use 'ENGINE=storage_engine' instead
2006-10-12 10:02:55,812 [http-8080-Processor24] WARN  General
- SQL warning: java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated;
use 'ENGINE=storage_engine' instead
2006-10-12 10:02:56,515 [http-8080-Processor24] ERROR RDBMS
- Error thrown executing CREATE TABLE `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
java.sql.SQLException: BLOB/TEXT column 'NAME' used in key specification
without a key length
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
	at com.mysql.jdbc.Statement.execute(Statement.java:535)
	at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatem
ent.java:261)
	at
org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTab
le.java:561)
	at
org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(Abstrac
tTable.java:516)
	at
org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:244)
	at
org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:287)
	at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(R
DBMSManager.java:3006)
	at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2540)
	at
org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.j
ava:2397)
	at
org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:603)
	at
org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:617)
	at
org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1016)
	at
org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1134)
	at
org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager
.java:2216)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll
Objects(JdoTool.java:199)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll
Objects(JdoTool.java:182)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.trigge
rInit(JdoTool.java:131)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getPer
sistenceManager(JdoTool.java:118)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getObj
ectById(JdoTool.java:236)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.object
ExistsById(JdoTool.java:283)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoRbacManager
.roleExists(JdoRbacManager.java:124)
	at
org.codehaus.plexus.rbac.profile.AbstractDynamicRoleProfile.getRole(Abst
ractDynamicRoleProfile.java:164)
	at
org.codehaus.plexus.rbac.profile.DefaultRoleProfileManager.getDynamicRol
e(DefaultRoleProfileManager.java:87)
	at
org.apache.maven.archiva.web.check.RoleExistanceEnvironmentCheck.validat
eEnvironment(RoleExistanceEnvironmentCheck.java:74)
	at
org.codehaus.plexus.security.ui.web.interceptor.EnvironmentCheckIntercep
tor.init(EnvironmentCheckInterceptor.java:78)
	at
org.codehaus.plexus.xwork.PlexusObjectFactory.buildInterceptor(PlexusObj
ectFactory.java:101)
	at
com.opensymphony.xwork.config.providers.InterceptorBuilder.constructInte
rceptorReference(InterceptorBuilder.java:48)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.lookupI
nterceptorReference(XmlConfigurationProvider.java:702)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptorStack(XmlConfigurationProvider.java:569)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptorStacks(XmlConfigurationProvider.java:582)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptors(XmlConfigurationProvider.java:603)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.addPack
age(XmlConfigurationProvider.java:204)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadCon
figurationFile(XmlConfigurationProvider.java:676)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.init(Xm
lConfigurationProvider.java:91)
	at
com.opensymphony.xwork.config.impl.DefaultConfiguration.reload(DefaultCo
nfiguration.java:85)
	at
com.opensymphony.xwork.config.ConfigurationManager.getConfiguration(Conf
igurationManager.java:54)
	at
com.opensymphony.xwork.DefaultActionProxy.<init>(DefaultActionProxy.java
:57)
	at
com.opensymphony.xwork.DefaultActionProxyFactory.createActionProxy(Defau
ltActionProxyFactory.java:46)
	at
com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dispat
cherUtils.java:216)
	at
com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDisp
atcher.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.
java:118)
	at
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.j
ava:52)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Action
ContextCleanUp.java:88)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
	at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
	at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
	at java.lang.Thread.run(Unknown Source)

2006-10-12 10:02:56,531 [http-8080-Processor24] ERROR SCHEMA
- An exception was thrown while adding/validating class(es) : BLOB/TEXT
column 'NAME' used in key specification without a key length
java.sql.SQLException: BLOB/TEXT column 'NAME' used in key specification
without a key length
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
	at com.mysql.jdbc.Statement.execute(Statement.java:535)
	at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatem
ent.java:261)
	at
org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTab
le.java:561)
	at
org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(Abstrac
tTable.java:516)
	at
org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:244)
	at
org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:287)
	at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(R
DBMSManager.java:3006)
	at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2540)
	at
org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.j
ava:2397)
	at
org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:603)
	at
org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:617)
	at
org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1016)
	at
org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1134)
	at
org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager
.java:2216)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll
Objects(JdoTool.java:199)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll
Objects(JdoTool.java:182)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.trigge
rInit(JdoTool.java:131)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getPer
sistenceManager(JdoTool.java:118)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getObj
ectById(JdoTool.java:236)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.object
ExistsById(JdoTool.java:283)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoRbacManager
.roleExists(JdoRbacManager.java:124)
	at
org.codehaus.plexus.rbac.profile.AbstractDynamicRoleProfile.getRole(Abst
ractDynamicRoleProfile.java:164)
	at
org.codehaus.plexus.rbac.profile.DefaultRoleProfileManager.getDynamicRol
e(DefaultRoleProfileManager.java:87)
	at
org.apache.maven.archiva.web.check.RoleExistanceEnvironmentCheck.validat
eEnvironment(RoleExistanceEnvironmentCheck.java:74)
	at
org.codehaus.plexus.security.ui.web.interceptor.EnvironmentCheckIntercep
tor.init(EnvironmentCheckInterceptor.java:78)
	at
org.codehaus.plexus.xwork.PlexusObjectFactory.buildInterceptor(PlexusObj
ectFactory.java:101)
	at
com.opensymphony.xwork.config.providers.InterceptorBuilder.constructInte
rceptorReference(InterceptorBuilder.java:48)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.lookupI
nterceptorReference(XmlConfigurationProvider.java:702)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptorStack(XmlConfigurationProvider.java:569)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptorStacks(XmlConfigurationProvider.java:582)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptors(XmlConfigurationProvider.java:603)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.addPack
age(XmlConfigurationProvider.java:204)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadCon
figurationFile(XmlConfigurationProvider.java:676)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.init(Xm
lConfigurationProvider.java:91)
	at
com.opensymphony.xwork.config.impl.DefaultConfiguration.reload(DefaultCo
nfiguration.java:85)
	at
com.opensymphony.xwork.config.ConfigurationManager.getConfiguration(Conf
igurationManager.java:54)
	at
com.opensymphony.xwork.DefaultActionProxy.<init>(DefaultActionProxy.java
:57)
	at
com.opensymphony.xwork.DefaultActionProxyFactory.createActionProxy(Defau
ltActionProxyFactory.java:46)
	at
com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dispat
cherUtils.java:216)
	at
com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDisp
atcher.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.
java:118)
	at
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.j
ava:52)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Action
ContextCleanUp.java:88)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
	at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
	at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
	at java.lang.Thread.run(Unknown Source)

2006-10-12 10:02:56,531 [http-8080-Processor24] ERROR SCHEMA
- java.sql.SQLException: BLOB/TEXT column 'NAME' used in key
specification without a key length
2006-10-12 10:02:56,796 [http-8080-Processor24] ERROR DispatcherUtils
- Could not find action
Caught Exception while registering Interceptor class
pssEnvironmentCheckInterceptor - [unknown location]
	at
org.codehaus.plexus.xwork.PlexusObjectFactory.buildInterceptor(PlexusObj
ectFactory.java:134)
	at
com.opensymphony.xwork.config.providers.InterceptorBuilder.constructInte
rceptorReference(InterceptorBuilder.java:48)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.lookupI
nterceptorReference(XmlConfigurationProvider.java:702)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptorStack(XmlConfigurationProvider.java:569)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptorStacks(XmlConfigurationProvider.java:582)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptors(XmlConfigurationProvider.java:603)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.addPack
age(XmlConfigurationProvider.java:204)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadCon
figurationFile(XmlConfigurationProvider.java:676)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.init(Xm
lConfigurationProvider.java:91)
	at
com.opensymphony.xwork.config.impl.DefaultConfiguration.reload(DefaultCo
nfiguration.java:85)
	at
com.opensymphony.xwork.config.ConfigurationManager.getConfiguration(Conf
igurationManager.java:54)
	at
com.opensymphony.xwork.DefaultActionProxy.<init>(DefaultActionProxy.java
:57)
	at
com.opensymphony.xwork.DefaultActionProxyFactory.createActionProxy(Defau
ltActionProxyFactory.java:46)
	at
com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dispat
cherUtils.java:216)
	at
com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDisp
atcher.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.
java:118)
	at
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.j
ava:52)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Action
ContextCleanUp.java:88)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
	at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
	at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
	at java.lang.Thread.run(Unknown Source)
Caused by: javax.jdo.JDODataStoreException: An exception was thrown
while adding/validating class(es) : BLOB/TEXT column 'NAME' used in key
specification without a key length
java.sql.SQLException: BLOB/TEXT column 'NAME' used in key specification
without a key length
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
	at com.mysql.jdbc.Statement.execute(Statement.java:535)
	at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatem
ent.java:261)
	at
org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTab
le.java:561)
	at
org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(Abstrac
tTable.java:516)
	at
org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:244)
	at
org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:287)
	at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(R
DBMSManager.java:3006)
	at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2540)
	at
org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.j
ava:2397)
	at
org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:603)
	at
org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:617)
	at
org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1016)
	at
org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1134)
	at
org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager
.java:2216)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll
Objects(JdoTool.java:199)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll
Objects(JdoTool.java:182)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.trigge
rInit(JdoTool.java:131)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getPer
sistenceManager(JdoTool.java:118)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getObj
ectById(JdoTool.java:236)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.object
ExistsById(JdoTool.java:283)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoRbacManager
.roleExists(JdoRbacManager.java:124)
	at
org.codehaus.plexus.rbac.profile.AbstractDynamicRoleProfile.getRole(Abst
ractDynamicRoleProfile.java:164)
	at
org.codehaus.plexus.rbac.profile.DefaultRoleProfileManager.getDynamicRol
e(DefaultRoleProfileManager.java:87)
	at
org.apache.maven.archiva.web.check.RoleExistanceEnvironmentCheck.validat
eEnvironment(RoleExistanceEnvironmentCheck.java:74)
	at
org.codehaus.plexus.security.ui.web.interceptor.EnvironmentCheckIntercep
tor.init(EnvironmentCheckInterceptor.java:78)
	at
org.codehaus.plexus.xwork.PlexusObjectFactory.buildInterceptor(PlexusObj
ectFactory.java:101)
	at
com.opensymphony.xwork.config.providers.InterceptorBuilder.constructInte
rceptorReference(InterceptorBuilder.java:48)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.lookupI
nterceptorReference(XmlConfigurationProvider.java:702)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptorStack(XmlConfigurationProvider.java:569)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptorStacks(XmlConfigurationProvider.java:582)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadInt
erceptors(XmlConfigurationProvider.java:603)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.addPack
age(XmlConfigurationProvider.java:204)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.loadCon
figurationFile(XmlConfigurationProvider.java:676)
	at
com.opensymphony.xwork.config.providers.XmlConfigurationProvider.init(Xm
lConfigurationProvider.java:91)
	at
com.opensymphony.xwork.config.impl.DefaultConfiguration.reload(DefaultCo
nfiguration.java:85)
	at
com.opensymphony.xwork.config.ConfigurationManager.getConfiguration(Conf
igurationManager.java:54)
	at
com.opensymphony.xwork.DefaultActionProxy.<init>(DefaultActionProxy.java
:57)
	at
com.opensymphony.xwork.DefaultActionProxyFactory.createActionProxy(Defau
ltActionProxyFactory.java:46)
	at
com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dispat
cherUtils.java:216)
	at
com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDisp
atcher.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.
java:118)
	at
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.j
ava:52)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Action
ContextCleanUp.java:88)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
	at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
	at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
	at java.lang.Thread.run(Unknown Source)

NestedThrowables:
java.sql.SQLException: BLOB/TEXT column 'NAME' used in key specification
without a key length
	at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(R
DBMSManager.java:3113)
	at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2540)
	at
org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.j
ava:2397)
	at
org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:603)
	at
org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:617)
	at
org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1016)
	at
org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1134)
	at
org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager
.java:2216)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll
Objects(JdoTool.java:199)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getAll
Objects(JdoTool.java:182)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.trigge
rInit(JdoTool.java:131)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getPer
sistenceManager(JdoTool.java:118)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.getObj
ectById(JdoTool.java:236)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoTool.object
ExistsById(JdoTool.java:283)
	at
org.codehaus.plexus.security.authorization.rbac.store.jdo.JdoRbacManager
.roleExists(JdoRbacManager.java:124)
	at
org.codehaus.plexus.rbac.profile.AbstractDynamicRoleProfile.getRole(Abst
ractDynamicRoleProfile.java:164)
	at
org.codehaus.plexus.rbac.profile.DefaultRoleProfileManager.getDynamicRol
e(DefaultRoleProfileManager.java:87)
	at
org.apache.maven.archiva.web.check.RoleExistanceEnvironmentCheck.validat
eEnvironment(RoleExistanceEnvironmentCheck.java:74)
	at
org.codehaus.plexus.security.ui.web.interceptor.EnvironmentCheckIntercep
tor.init(EnvironmentCheckInterceptor.java:78)
	at
org.codehaus.plexus.xwork.PlexusObjectFactory.buildInterceptor(PlexusObj
ectFactory.java:101)
	... 35 more
Caused by: java.sql.SQLException: BLOB/TEXT column 'NAME' used in key
specification without a key length
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
	at com.mysql.jdbc.Statement.execute(Statement.java:535)
	at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatem
ent.java:261)
	at
org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTab
le.java:561)
	at
org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(Abstrac
tTable.java:516)
	at
org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:244)
	at
org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:287)
	at
org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(R
DBMSManager.java:3006)
	... 54 more

this was tested with daily build of today (20061012)

- Daniel
 

Mime
View raw message