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
