archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nore...@smtpwifi.sfr.fr
Subject Re: supported databases ?
Date Thu, 12 Oct 2006 09:51:03 GMT
With datasources usage, we want to support a maximum of databases.
For all exception found with a database, you need to create an issue and we'll look at it.
We probably need to add more informations in the jpox descriptor used for the database generation.

Emmanuel

Mohni, Daniel a écrit :
> 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