You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@archiva.apache.org by "Dennis Kieselhorst (JIRA)" <ji...@codehaus.org> on 2008/02/04 14:34:57 UTC

[jira] Created: (MRM-680) User database cannot be used with MySQL

User database cannot be used with MySQL
---------------------------------------

                 Key: MRM-680
                 URL: http://jira.codehaus.org/browse/MRM-680
             Project: Archiva
          Issue Type: Bug
          Components: Users/Security
    Affects Versions: 1.0.1
         Environment: SunOS 5.8, JDK 1.5.0_06, MySQL 4.1.21
            Reporter: Dennis Kieselhorst


Changed database configuration in plexus.xml to MySQL. It works for the resource jdbc/archiva but not for the jdbc/users resource:

11587 [WrapperSimpleAppMain] 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:1027)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
        at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
        at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
        at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
        at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
        at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
        at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
        at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
        at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
        at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
        at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
        at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
        at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
        at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:77)
        at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:63)
        at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:210)
        at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:132)
        at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:457)
        at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
        at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
        at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
        at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
        at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
        at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
        at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
        at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
        at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
        at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
2)
        at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
        at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
        at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
        at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
        at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
        at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
        at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
        at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
        at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
        at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
2)
        at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
        at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
        at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
        at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
        at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327)
        at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java:68)
        at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:886)
        at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:834)
        at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:811)
        at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
        at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:260)
        at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
        at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:495)
        at org.mortbay.util.Container.start(Container.java:72)
        at org.codehaus.plexus.jetty.AbstractJettyServletContainer.startApplication(AbstractJettyServletContainer.java:209)
        at org.codehaus.plexus.service.jetty.JettyPlexusService.afterApplicationStart(JettyPlexusService.java:248)
        at org.codehaus.plexus.appserver.application.deploy.lifecycle.phase.AfterAppStartServiceSetupPhase.execute(AfterAppStartServiceSetupP
hase.java:28)
        at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:107)
        at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:88)
        at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase$1.onJarDiscovered(ApplicationDeploymentPhase.java:44)
        at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:100)
        at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:73)
        at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase.execute(ApplicationDeploymentPhase.java:58)
        at org.codehaus.plexus.appserver.DefaultApplicationServer.start(DefaultApplicationServer.java:218)
        at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:33)
        at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
        at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
        at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
        at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:69)
        at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:297)
        at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
        at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:155)
        at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:85)
        at org.codehaus.plexus.appserver.PlexusApplicationHost.main(PlexusApplicationHost.java:289)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
        at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
        at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)
        at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
        at java.lang.Thread.run(Thread.java:595)

11602 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.Schema  - An exception was thrown while adding/validating class(es) : BLOB/TEXT column 'NAME' u
sed 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:1027)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
        at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
        at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
        at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
        at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
        at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
        at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
        at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
        at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
        at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
        at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
        at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
        at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
        at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:77)
        at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:63)
        at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:210)
        at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:132)
        at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:457)
        at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
        at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
        at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
        at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
        at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
        at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
        at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
        at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
        at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
        at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
2)
        at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
        at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
        at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
        at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
        at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
        at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
        at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
        at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
        at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
        at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
2)
        at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
        at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
        at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
        at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
        at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327)
        at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java:68)
        at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:886)
        at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:834)
        at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:811)
        at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
        at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:260)
        at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
        at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:495)
        at org.mortbay.util.Container.start(Container.java:72)
        at org.codehaus.plexus.jetty.AbstractJettyServletContainer.startApplication(AbstractJettyServletContainer.java:209)
        at org.codehaus.plexus.service.jetty.JettyPlexusService.afterApplicationStart(JettyPlexusService.java:248)
        at org.codehaus.plexus.appserver.application.deploy.lifecycle.phase.AfterAppStartServiceSetupPhase.execute(AfterAppStartServiceSetupP
hase.java:28)
        at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:107)
        at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:88)
        at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase$1.onJarDiscovered(ApplicationDeploymentPhase.java:44)
        at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:100)
        at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:73)
        at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase.execute(ApplicationDeploymentPhase.java:58)
        at org.codehaus.plexus.appserver.DefaultApplicationServer.start(DefaultApplicationServer.java:218)
        at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:33)
        at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
        at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
        at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
        at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
        at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:69)
        at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:297)
        at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
        at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:155)
        at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:85)
        at org.codehaus.plexus.appserver.PlexusApplicationHost.main(PlexusApplicationHost.java:289)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (MRM-680) User database cannot be used with MySQL 4.1

Posted by "Dennis Kieselhorst (JIRA)" <ji...@codehaus.org>.
    [ http://jira.codehaus.org/browse/MRM-680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=142570#action_142570 ] 

Dennis Kieselhorst commented on MRM-680:
----------------------------------------

Workaround
Copy SQL statements from exception, change length from 256 to 255 and execute these statements by hand. In my case:

CREATE TABLE `SECURITY_OPERATIONS`
(
    `NAME` VARCHAR(255) BINARY NOT NULL,
    `DESCRIPTION` VARCHAR(255) BINARY NULL,
    `PERMANENT` BIT NOT NULL,
    `RESOURCE_REQUIRED` BIT NOT NULL,
    PRIMARY KEY (`NAME`)
) TYPE=INNODB

CREATE TABLE `SECURITY_ROLES`
(
    `NAME` VARCHAR(255) BINARY NOT NULL,
    `ASSIGNABLE` BIT NOT NULL,
    `DESCRIPTION` VARCHAR(255) BINARY NULL,
    `PERMANENT` BIT NOT NULL,
    PRIMARY KEY (`NAME`)
) TYPE=INNODB

CREATE TABLE `SECURITY_PERMISSIONS`
(
    `NAME` VARCHAR(255) BINARY NOT NULL,
    `DESCRIPTION` VARCHAR(255) BINARY NULL,
    `OPERATION_NAME_OID` VARCHAR(255) BINARY NULL,
    `PERMANENT` BIT NOT NULL,
    `RESOURCE_IDENTIFIER_OID` VARCHAR(255) BINARY NULL,
    PRIMARY KEY (`NAME`)
) TYPE=INNODB

CREATE TABLE `SECURITY_RESOURCES`
(
    `IDENTIFIER` VARCHAR(255) BINARY NOT NULL,
    `PATTERN` BIT NOT NULL,
    `PERMANENT` BIT NOT NULL,
    PRIMARY KEY (`IDENTIFIER`)
) TYPE=INNODB

CREATE TABLE `SECURITY_ROLE_CHILDROLE_MAP`
(
    `NAME_OID` VARCHAR(255) BINARY NOT NULL,
    `STRING_ELE` VARCHAR(255) BINARY NULL,
    `INTEGER_IDX` INTEGER NOT NULL,
    PRIMARY KEY (`NAME_OID`,`INTEGER_IDX`)
) TYPE=INNODB

CREATE TABLE `SECURITY_ROLE_PERMISSION_MAP`
(
    `NAME_OID` VARCHAR(255) BINARY NOT NULL,
    `NAME_EID` VARCHAR(255) BINARY NULL,
    `INTEGER_IDX` INTEGER NOT NULL,
    PRIMARY KEY (`NAME_OID`,`INTEGER_IDX`)
) TYPE=INNODB

CREATE TABLE `SECURITY_USER_ASSIGNMENTS`
(
    `PRINCIPAL` VARCHAR(255) BINARY NOT NULL,
    `PERMANENT` BIT NOT NULL,
    `LAST_UPDATED` DATETIME NULL,
    PRIMARY KEY (`PRINCIPAL`)
) TYPE=INNODB

CREATE TABLE `SECURITY_USERASSIGNMENT_ROLENAMES`
(
    `PRINCIPAL_OID` VARCHAR(255) BINARY NOT NULL,
    `STRING_ELE` VARCHAR(255) BINARY NULL,
    `INTEGER_IDX` INTEGER NOT NULL,
    PRIMARY KEY (`PRINCIPAL_OID`,`INTEGER_IDX`)
) TYPE=INNODB

CREATE TABLE `JDOUSER`
(
    `USERNAME` VARCHAR(255) BINARY NOT NULL,
    `ACCOUNT_CREATION_DATE` DATETIME NULL,
    `COUNT_FAILED_LOGIN_ATTEMPTS` INTEGER NOT NULL,
    `EMAIL` VARCHAR(255) BINARY NULL,
    `ENCODED_PASSWORD` VARCHAR(255) BINARY NULL,
    `FULL_NAME` VARCHAR(255) BINARY NULL,
    `LAST_LOGIN_DATE` DATETIME NULL,
    `LAST_PASSWORD_CHANGE` DATETIME NULL,
    `LOCKED` BIT NOT NULL,
    `MODEL_ENCODING` VARCHAR(255) BINARY NULL,
    `USER_PASSWORD` VARCHAR(255) BINARY NULL,
    `PASSWORD_CHANGE_REQUIRED` BIT NOT NULL,
    `PERMANENT` BIT NOT NULL,
    `VALIDATED` BIT NOT NULL,
    PRIMARY KEY (`USERNAME`)
) TYPE=INNODB

CREATE TABLE `JDOUSER_PREVIOUSENCODEDPASSWORDS`
(
    `USERNAME_OID` VARCHAR(255) BINARY NOT NULL,
    `STRING_ELE` VARCHAR(255) BINARY NULL,
    `INTEGER_IDX` INTEGER NOT NULL,
    PRIMARY KEY (`USERNAME_OID`,`INTEGER_IDX`)
) TYPE=INNODB

CREATE TABLE `JDOAUTHENTICATIONKEY`
(
    `AUTHKEY` VARCHAR(255) BINARY NOT NULL,
    `DATE_CREATED` DATETIME NULL,
    `DATE_EXPIRES` DATETIME NULL,
    `FOR_PRINCIPAL` VARCHAR(255) BINARY NULL,
    `MODEL_ENCODING` VARCHAR(255) BINARY NULL,
    `PURPOSE` VARCHAR(255) BINARY NULL,
    PRIMARY KEY (`AUTHKEY`)
) TYPE=INNODB


This issue affects all MySQL versions before 5.0.3, see:
http://forums.mysql.com/read.php?10,113556,113638#msg-113638

> User database cannot be used with MySQL 4.1
> -------------------------------------------
>
>                 Key: MRM-680
>                 URL: http://jira.codehaus.org/browse/MRM-680
>             Project: Archiva
>          Issue Type: Bug
>          Components: Users/Security
>    Affects Versions: 1.0.1
>         Environment: SunOS 5.8, JDK 1.5.0_06, MySQL 4.1.21
>            Reporter: Dennis Kieselhorst
>             Fix For: 1.1.x
>
>
> Changed database configuration in plexus.xml to MySQL. It works for the resource jdbc/archiva but not for the jdbc/users resource:
> 11587 [WrapperSimpleAppMain] 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:1027)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
>         at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
>         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
>         at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
>         at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
>         at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
>         at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
>         at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
>         at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
>         at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
>         at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
>         at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:77)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:63)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:210)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:132)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:457)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327)
>         at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java:68)
>         at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:886)
>         at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:834)
>         at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:811)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:260)
>         at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
>         at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:495)
>         at org.mortbay.util.Container.start(Container.java:72)
>         at org.codehaus.plexus.jetty.AbstractJettyServletContainer.startApplication(AbstractJettyServletContainer.java:209)
>         at org.codehaus.plexus.service.jetty.JettyPlexusService.afterApplicationStart(JettyPlexusService.java:248)
>         at org.codehaus.plexus.appserver.application.deploy.lifecycle.phase.AfterAppStartServiceSetupPhase.execute(AfterAppStartServiceSetupP
> hase.java:28)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:107)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:88)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase$1.onJarDiscovered(ApplicationDeploymentPhase.java:44)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:100)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:73)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase.execute(ApplicationDeploymentPhase.java:58)
>         at org.codehaus.plexus.appserver.DefaultApplicationServer.start(DefaultApplicationServer.java:218)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:69)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:297)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:155)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:85)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.main(PlexusApplicationHost.java:289)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
>         at java.lang.Thread.run(Thread.java:595)
> 11602 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.Schema  - An exception was thrown while adding/validating class(es) : BLOB/TEXT column 'NAME' u
> sed 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:1027)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
>         at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
>         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
>         at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
>         at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
>         at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
>         at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
>         at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
>         at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
>         at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
>         at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
>         at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:77)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:63)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:210)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:132)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:457)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327)
>         at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java:68)
>         at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:886)
>         at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:834)
>         at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:811)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:260)
>         at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
>         at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:495)
>         at org.mortbay.util.Container.start(Container.java:72)
>         at org.codehaus.plexus.jetty.AbstractJettyServletContainer.startApplication(AbstractJettyServletContainer.java:209)
>         at org.codehaus.plexus.service.jetty.JettyPlexusService.afterApplicationStart(JettyPlexusService.java:248)
>         at org.codehaus.plexus.appserver.application.deploy.lifecycle.phase.AfterAppStartServiceSetupPhase.execute(AfterAppStartServiceSetupP
> hase.java:28)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:107)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:88)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase$1.onJarDiscovered(ApplicationDeploymentPhase.java:44)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:100)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:73)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase.execute(ApplicationDeploymentPhase.java:58)
>         at org.codehaus.plexus.appserver.DefaultApplicationServer.start(DefaultApplicationServer.java:218)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:69)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:297)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:155)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:85)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.main(PlexusApplicationHost.java:289)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (MRM-680) User database cannot be used with MySQL 4.1

Posted by "Dennis Kieselhorst (JIRA)" <ji...@codehaus.org>.
    [ http://jira.codehaus.org/browse/MRM-680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=142567#action_142567 ] 

Dennis Kieselhorst commented on MRM-680:
----------------------------------------

Updated stacktrace for Archiva 1.1:

2008-07-21 08:50:51,891 [WrapperSimpleAppMain] 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:1026)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
        at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
        at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
        at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
        at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
        at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
        at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
        at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
        at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
        at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
        at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
        at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
        at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
        at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
        at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
        at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:75)
        at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:56)
        at org.codehaus.plexus.redback.role.DefaultRoleManager.loadApplication(DefaultRoleManager.java:178)
        at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:120)
        at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:427)
        at org.codehaus.plexus.spring.PlexusLifecycleBeanPostProcessor.postProcessAfterInitialization(PlexusLifecycleBeanPostProcessor.java:217)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowire
CapableBeanFactory.java:331)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.postProcessObjectFromFactoryBean(AbstractAutowireCapableBea
nFactory.java:1340)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport$1.run(FactoryBeanRegistrySupport.java:137)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:114)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:90)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1269)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:256)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
        at org.codehaus.plexus.spring.PlexusComponentFactoryBean.resolveRequirement(PlexusComponentFactoryBean.java:246)
        at org.codehaus.plexus.spring.PlexusComponentFactoryBean.createInstance(PlexusComponentFactoryBean.java:163)
        at org.codehaus.plexus.spring.PlexusComponentFactoryBean.getObject(PlexusComponentFactoryBean.java:108)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport$1.run(FactoryBeanRegistrySupport.java:119)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:114)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:90)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1269)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:256)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
        at org.codehaus.plexus.spring.PlexusToSpringUtils.lookupMap(PlexusToSpringUtils.java:148)
        at org.codehaus.plexus.spring.PlexusComponentFactoryBean.resolveRequirement(PlexusComponentFactoryBean.java:238)
        at org.codehaus.plexus.spring.PlexusComponentFactoryBean.createInstance(PlexusComponentFactoryBean.java:163)
        at org.codehaus.plexus.spring.PlexusComponentFactoryBean.getObject(PlexusComponentFactoryBean.java:108)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport$1.run(FactoryBeanRegistrySupport.java:119)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:114)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:90)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1269)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:256)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:888)
        at org.apache.maven.archiva.web.startup.ArchivaStartup.contextInitialized(ArchivaStartup.java:47)
        at org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:539)
        at org.mortbay.jetty.servlet.Context.startContext(Context.java:135)
        at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1216)
        at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:509)
        at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:447)
        at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
        at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
        at org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156)
        at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
        at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
        at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
        at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:117)
        at org.mortbay.jetty.Server.doStart(Server.java:222)
        at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
        at org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:977)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.mortbay.start.Main.invokeMain(Main.java:194)
        at org.mortbay.start.Main.start(Main.java:509)
        at org.mortbay.start.Main.main(Main.java:119)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
        at java.lang.Thread.run(Thread.java:595)


> User database cannot be used with MySQL 4.1
> -------------------------------------------
>
>                 Key: MRM-680
>                 URL: http://jira.codehaus.org/browse/MRM-680
>             Project: Archiva
>          Issue Type: Bug
>          Components: Users/Security
>    Affects Versions: 1.0.1
>         Environment: SunOS 5.8, JDK 1.5.0_06, MySQL 4.1.21
>            Reporter: Dennis Kieselhorst
>             Fix For: 1.1.x
>
>
> Changed database configuration in plexus.xml to MySQL. It works for the resource jdbc/archiva but not for the jdbc/users resource:
> 11587 [WrapperSimpleAppMain] 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:1027)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
>         at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
>         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
>         at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
>         at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
>         at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
>         at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
>         at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
>         at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
>         at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
>         at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
>         at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:77)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:63)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:210)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:132)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:457)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327)
>         at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java:68)
>         at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:886)
>         at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:834)
>         at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:811)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:260)
>         at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
>         at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:495)
>         at org.mortbay.util.Container.start(Container.java:72)
>         at org.codehaus.plexus.jetty.AbstractJettyServletContainer.startApplication(AbstractJettyServletContainer.java:209)
>         at org.codehaus.plexus.service.jetty.JettyPlexusService.afterApplicationStart(JettyPlexusService.java:248)
>         at org.codehaus.plexus.appserver.application.deploy.lifecycle.phase.AfterAppStartServiceSetupPhase.execute(AfterAppStartServiceSetupP
> hase.java:28)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:107)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:88)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase$1.onJarDiscovered(ApplicationDeploymentPhase.java:44)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:100)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:73)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase.execute(ApplicationDeploymentPhase.java:58)
>         at org.codehaus.plexus.appserver.DefaultApplicationServer.start(DefaultApplicationServer.java:218)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:69)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:297)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:155)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:85)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.main(PlexusApplicationHost.java:289)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
>         at java.lang.Thread.run(Thread.java:595)
> 11602 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.Schema  - An exception was thrown while adding/validating class(es) : BLOB/TEXT column 'NAME' u
> sed 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:1027)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
>         at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
>         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
>         at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
>         at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
>         at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
>         at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
>         at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
>         at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
>         at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
>         at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
>         at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:77)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:63)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:210)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:132)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:457)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327)
>         at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java:68)
>         at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:886)
>         at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:834)
>         at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:811)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:260)
>         at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
>         at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:495)
>         at org.mortbay.util.Container.start(Container.java:72)
>         at org.codehaus.plexus.jetty.AbstractJettyServletContainer.startApplication(AbstractJettyServletContainer.java:209)
>         at org.codehaus.plexus.service.jetty.JettyPlexusService.afterApplicationStart(JettyPlexusService.java:248)
>         at org.codehaus.plexus.appserver.application.deploy.lifecycle.phase.AfterAppStartServiceSetupPhase.execute(AfterAppStartServiceSetupP
> hase.java:28)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:107)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:88)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase$1.onJarDiscovered(ApplicationDeploymentPhase.java:44)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:100)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:73)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase.execute(ApplicationDeploymentPhase.java:58)
>         at org.codehaus.plexus.appserver.DefaultApplicationServer.start(DefaultApplicationServer.java:218)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:69)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:297)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:155)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:85)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.main(PlexusApplicationHost.java:289)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (MRM-680) User database cannot be used with MySQL 4.1

Posted by "Wendy Smoak (JIRA)" <ji...@codehaus.org>.
     [ http://jira.codehaus.org/browse/MRM-680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wendy Smoak updated MRM-680:
----------------------------

    Summary: User database cannot be used with MySQL 4.1  (was: User database cannot be used with MySQL)

Editing the summary to say MySQL 4.1, as we're successfully using it with MySQL 5.0.

> User database cannot be used with MySQL 4.1
> -------------------------------------------
>
>                 Key: MRM-680
>                 URL: http://jira.codehaus.org/browse/MRM-680
>             Project: Archiva
>          Issue Type: Bug
>          Components: Users/Security
>    Affects Versions: 1.0.1
>         Environment: SunOS 5.8, JDK 1.5.0_06, MySQL 4.1.21
>            Reporter: Dennis Kieselhorst
>             Fix For: 1.0.x
>
>
> Changed database configuration in plexus.xml to MySQL. It works for the resource jdbc/archiva but not for the jdbc/users resource:
> 11587 [WrapperSimpleAppMain] 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:1027)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
>         at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
>         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
>         at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
>         at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
>         at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
>         at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
>         at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
>         at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
>         at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
>         at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
>         at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:77)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:63)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:210)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:132)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:457)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327)
>         at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java:68)
>         at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:886)
>         at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:834)
>         at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:811)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:260)
>         at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
>         at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:495)
>         at org.mortbay.util.Container.start(Container.java:72)
>         at org.codehaus.plexus.jetty.AbstractJettyServletContainer.startApplication(AbstractJettyServletContainer.java:209)
>         at org.codehaus.plexus.service.jetty.JettyPlexusService.afterApplicationStart(JettyPlexusService.java:248)
>         at org.codehaus.plexus.appserver.application.deploy.lifecycle.phase.AfterAppStartServiceSetupPhase.execute(AfterAppStartServiceSetupP
> hase.java:28)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:107)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:88)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase$1.onJarDiscovered(ApplicationDeploymentPhase.java:44)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:100)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:73)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase.execute(ApplicationDeploymentPhase.java:58)
>         at org.codehaus.plexus.appserver.DefaultApplicationServer.start(DefaultApplicationServer.java:218)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:69)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:297)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:155)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:85)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.main(PlexusApplicationHost.java:289)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
>         at java.lang.Thread.run(Thread.java:595)
> 11602 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.Schema  - An exception was thrown while adding/validating class(es) : BLOB/TEXT column 'NAME' u
> sed 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:1027)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
>         at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
>         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
>         at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
>         at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
>         at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
>         at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
>         at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
>         at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
>         at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
>         at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
>         at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:77)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:63)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:210)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:132)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:457)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327)
>         at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java:68)
>         at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:886)
>         at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:834)
>         at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:811)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:260)
>         at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
>         at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:495)
>         at org.mortbay.util.Container.start(Container.java:72)
>         at org.codehaus.plexus.jetty.AbstractJettyServletContainer.startApplication(AbstractJettyServletContainer.java:209)
>         at org.codehaus.plexus.service.jetty.JettyPlexusService.afterApplicationStart(JettyPlexusService.java:248)
>         at org.codehaus.plexus.appserver.application.deploy.lifecycle.phase.AfterAppStartServiceSetupPhase.execute(AfterAppStartServiceSetupP
> hase.java:28)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:107)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:88)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase$1.onJarDiscovered(ApplicationDeploymentPhase.java:44)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:100)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:73)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase.execute(ApplicationDeploymentPhase.java:58)
>         at org.codehaus.plexus.appserver.DefaultApplicationServer.start(DefaultApplicationServer.java:218)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:69)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:297)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:155)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:85)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.main(PlexusApplicationHost.java:289)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (MRM-680) User database cannot be used with MySQL

Posted by "Brett Porter (JIRA)" <ji...@codehaus.org>.
     [ http://jira.codehaus.org/browse/MRM-680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brett Porter updated MRM-680:
-----------------------------

    Fix Version/s: 1.0.x

> User database cannot be used with MySQL
> ---------------------------------------
>
>                 Key: MRM-680
>                 URL: http://jira.codehaus.org/browse/MRM-680
>             Project: Archiva
>          Issue Type: Bug
>          Components: Users/Security
>    Affects Versions: 1.0.1
>         Environment: SunOS 5.8, JDK 1.5.0_06, MySQL 4.1.21
>            Reporter: Dennis Kieselhorst
>             Fix For: 1.0.x
>
>
> Changed database configuration in plexus.xml to MySQL. It works for the resource jdbc/archiva but not for the jdbc/users resource:
> 11587 [WrapperSimpleAppMain] 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:1027)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
>         at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
>         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
>         at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
>         at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
>         at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
>         at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
>         at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
>         at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
>         at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
>         at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
>         at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:77)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:63)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:210)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:132)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:457)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327)
>         at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java:68)
>         at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:886)
>         at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:834)
>         at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:811)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:260)
>         at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
>         at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:495)
>         at org.mortbay.util.Container.start(Container.java:72)
>         at org.codehaus.plexus.jetty.AbstractJettyServletContainer.startApplication(AbstractJettyServletContainer.java:209)
>         at org.codehaus.plexus.service.jetty.JettyPlexusService.afterApplicationStart(JettyPlexusService.java:248)
>         at org.codehaus.plexus.appserver.application.deploy.lifecycle.phase.AfterAppStartServiceSetupPhase.execute(AfterAppStartServiceSetupP
> hase.java:28)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:107)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:88)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase$1.onJarDiscovered(ApplicationDeploymentPhase.java:44)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:100)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:73)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase.execute(ApplicationDeploymentPhase.java:58)
>         at org.codehaus.plexus.appserver.DefaultApplicationServer.start(DefaultApplicationServer.java:218)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:69)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:297)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:155)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:85)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.main(PlexusApplicationHost.java:289)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)
>         at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
>         at java.lang.Thread.run(Thread.java:595)
> 11602 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.Schema  - An exception was thrown while adding/validating class(es) : BLOB/TEXT column 'NAME' u
> sed 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:1027)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2466)
>         at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:735)
>         at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
>         at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
>         at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
>         at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3065)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
>         at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
>         at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
>         at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
>         at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
>         at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1218)
>         at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1357)
>         at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2328)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:205)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getAllObjects(JdoTool.java:188)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.triggerInit(JdoTool.java:131)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getPersistenceManager(JdoTool.java:118)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.getObjectById(JdoTool.java:292)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoTool.objectExistsById(JdoTool.java:340)
>         at org.codehaus.plexus.redback.rbac.jdo.JdoRbacManager.resourceExists(JdoRbacManager.java:467)
>         at org.codehaus.plexus.redback.rbac.cached.CachedRbacManager.resourceExists(CachedRbacManager.java:622)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.processResources(DefaultRoleModelProcessor.java:77)
>         at org.codehaus.plexus.redback.role.processor.DefaultRoleModelProcessor.process(DefaultRoleModelProcessor.java:63)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:210)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.loadRoleModel(DefaultRoleManager.java:132)
>         at org.codehaus.plexus.redback.role.DefaultRoleManager.initialize(DefaultRoleManager.java:457)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:333)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.findRequirement(AbstractComponentComposer.java:241)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirementToField(FieldComponentComposer.java:66)
>         at org.codehaus.plexus.component.composition.FieldComponentComposer.assignRequirement(FieldComponentComposer.java:57)
>         at org.codehaus.plexus.component.composition.AbstractComponentComposer.assembleComponent(AbstractComponentComposer.java:143)
>         at org.codehaus.plexus.component.composition.DefaultComponentComposerManager.assembleComponent(DefaultComponentComposerManager.java:7
> 2)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.CompositionPhase.execute(CompositionPhase.java:46)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327)
>         at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute(StartLoadOnStartComponentsPhase.java:68)
>         at org.codehaus.plexus.DefaultPlexusContainer.initializePhases(DefaultPlexusContainer.java:886)
>         at org.codehaus.plexus.DefaultPlexusContainer.initialize(DefaultPlexusContainer.java:834)
>         at org.codehaus.plexus.DefaultPlexusContainer.construct(DefaultPlexusContainer.java:811)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:222)
>         at org.codehaus.plexus.DefaultPlexusContainer.<init>(DefaultPlexusContainer.java:260)
>         at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized(PlexusLifecycleListener.java:76)
>         at org.mortbay.jetty.servlet.WebApplicationContext.doStart(WebApplicationContext.java:495)
>         at org.mortbay.util.Container.start(Container.java:72)
>         at org.codehaus.plexus.jetty.AbstractJettyServletContainer.startApplication(AbstractJettyServletContainer.java:209)
>         at org.codehaus.plexus.service.jetty.JettyPlexusService.afterApplicationStart(JettyPlexusService.java:248)
>         at org.codehaus.plexus.appserver.application.deploy.lifecycle.phase.AfterAppStartServiceSetupPhase.execute(AfterAppStartServiceSetupP
> hase.java:28)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:107)
>         at org.codehaus.plexus.appserver.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:88)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase$1.onJarDiscovered(ApplicationDeploymentPhase.java:44)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:100)
>         at org.codehaus.plexus.appserver.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:73)
>         at org.codehaus.plexus.appserver.lifecycle.phase.ApplicationDeploymentPhase.execute(ApplicationDeploymentPhase.java:58)
>         at org.codehaus.plexus.appserver.DefaultApplicationServer.start(DefaultApplicationServer.java:218)
>         at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:33)
>         at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:128)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:142)
>         at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:132)
>         at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:90)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:147)
>         at org.codehaus.plexus.DefaultComponentLookupManager.lookup(DefaultComponentLookupManager.java:69)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:297)
>         at org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:291)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:155)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.start(PlexusApplicationHost.java:85)
>         at org.codehaus.plexus.appserver.PlexusApplicationHost.main(PlexusApplicationHost.java:289)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira