continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emmanuel Venisse <emman...@venisse.net>
Subject Re: running continuum with mysql
Date Thu, 03 Nov 2005 07:41:10 GMT
I think you are the first one that try to run continuum on mysql. you can filed a jira issue.

Known databases used actually by user are Derby (the default), hsqldb and posgres

Emmanuel

witek wolejszo a écrit :
> Hello,
> 
> Has anyone succeeded in running Continuum-1.0 on mysql database?
> 
> Environment:
> 
> Debian GNU/Linux 2.6.8-2-k7
> MySQL 4.0.24_Debian-10-log
> MySQL-AB JDBC Driver, version=mysql-connector-java-3.1.11 ( $Date: 
> 2005-09-21 18:20:03 +0000 (Wed, 21 Sep 2005) $,  $Revision: 4287 $ ), 
> major=3, minor=1
> 
> application.xml:
> 
>  <component>
>       <role>org.codehaus.plexus.jdo.JdoFactory</role> 
> <implementation>org.codehaus.plexus.jdo.DefaultJdoFactory</implementation>
>       <configuration>
>  <properties>
>           <!-- JPOX and JDO configuration -->
>           <property>
>             <name>javax.jdo.PersistenceManagerFactoryClass</name>
>             <value>org.jpox.PersistenceManagerFactoryImpl</value>
>           </property>
>           <property>
>             <name>org.jpox.autoCreateSchema</name>
>             <value>true</value>
>           </property>
>           <property>
>             <name>org.jpox.autoStartMechanism</name>
>             <value>SchemaTable</value>
>           </property>
>           <property>
>             <name>org.jpox.autoStartMechanismMode</name>
>             <value>Ignored</value>
>           </property>
>           <!-- Apache Derby Configuration -->
>           <property>
>             <name>javax.jdo.option.ConnectionDriverName</name>
>             <value>com.mysql.jdbc.Driver</value>
>           </property>
>           <property>
>             <name>javax.jdo.option.ConnectionURL</name>
>             <value>jdbc:mysql://localhost/continuum</value>
>           </property>
>           <property>
>             <name>javax.jdo.option.ConnectionUserName</name>
>             <value>continuum</value>
>           <property>
>             <name>javax.jdo.option.ConnectionPassword</name>
>             <value>######</value>
>           </property>
> 
> LOGS:
> 
> 1    [WrapperSimpleAppMain] DEBUG org.codehaus.plexus.PlexusContainer  - 
> Found 3 components to load on start
> 4    [WrapperSimpleAppMain] INFO  org.codehaus.plexus.PlexusContainer  - 
> Loading on start [role]: [org.apache.maven.continuum.Continuum]
> 175  [WrapperSimpleAppMain] INFO  org.codehaus.plexus.jdo.JdoFactory  - 
> Initializing JDO.
> 365  [WrapperSimpleAppMain] INFO  JPOX.JDO  - PersistenceManagerFactory 
> - Vendor: JPOX  Version: 1.1.0-beta-4
> 366  [WrapperSimpleAppMain] INFO  JPOX.JDO  - PersistenceManagerFactory 
> initialised for datastore URL=jdbc:mysql://localhost/continuum 
> driver=com.mysql.jdbc.Driver userName=continuum
> 598  [WrapperSimpleAppMain] INFO  org.apache.maven.continuum.Continuum - 
> Initializing Continuum.
> 598  [WrapperSimpleAppMain] INFO  org.apache.maven.continuum.Continuum - 
> Showing all projects:
> 1064 [WrapperSimpleAppMain] INFO  JPOX.RDBMS  - RDBMS Adapter 
> initialised : MySQLAdapter : MySQL version=4.0.24_Debian-10-log, 
> major=4, minor=0, revision=240
> Identifier Names : UPPERCASE
> Driver name=MySQL-AB JDBC Driver, version=mysql-connector-java-3.1.11 ( 
> $Date: 2005-09-21 18:20:03 +0000 (Wed, 21 Sep 2005) $, $Revision: 4287 $ 
> ), major=3, minor=1
> Identifier Max Lengths : Table=64  Column=64  Constraint=64  Index=64 
> Delimeters=`
> Identifier Support in DDL : catalog=false  schema=false
> 1815 [WrapperSimpleAppMain] INFO  JPOX.RDBMS  - Creating table 
> DELETEME1130932289923
> 1921 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Schema Name could 
> not be determined for this datastore
> 1921 [WrapperSimpleAppMain] INFO  JPOX.RDBMS  - Dropping table 
> DELETEME1130932289923
> 1937 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Initialising 
> Catalog "continuum", Schema "" using "SchemaTable" auto-start option
> 1953 [WrapperSimpleAppMain] INFO  JPOX.RDBMS  - Creating table JPOX_TABLES
> 2034 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Catalog 
> "continuum", Schema "" initialised - managing 0 classes
> 2111 [WrapperSimpleAppMain] INFO  JPOX.MetaData  - Parsing MetaData from 
> file 
> "file:/home/continuum/continuum-1.0/bin/linux/../../apps/continuum/lib/continuum-model-1.0.jar!/META-INF/package.jdo"

> 
> 2733 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : 
> org.apache.maven.continuum.model.system.Installation [Table : 
> INSTALLATION, InheritanceStrategy : new-table]
> 2945 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : org.apache.maven.continuum.model.project.Profile 
> [Table : PROFILE, InheritanceStrategy : new-table]
> 2989 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : org.apache.maven.continuum.model.project.Schedule 
> [Table : SCHEDULE, InheritanceStrategy : new-table]
> 3006 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : 
> org.apache.maven.continuum.model.project.BuildDefinition [Table : 
> BUILDDEFINITION, InheritanceStrategy : new-table]
> 3009 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : org.apache.maven.continuum.model.scm.ChangeFile 
> [Table : CHANGEFILE, InheritanceStrategy : new-table]
> 3024 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : org.apache.maven.continuum.model.scm.ChangeSet 
> [Table : CHANGESET, InheritanceStrategy : new-table]
> 3040 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : org.apache.maven.continuum.model.scm.ScmResult 
> [Table : SCMRESULT, InheritanceStrategy : new-table]
> 3050 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : 
> org.apache.maven.continuum.model.project.BuildResult [Table : 
> BUILDRESULT, InheritanceStrategy : new-table]
> 3065 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : 
> org.apache.maven.continuum.model.project.ProjectDependency [Table : 
> PROJECTDEPENDENCY, InheritanceStrategy : new-table]
> 3067 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : 
> org.apache.maven.continuum.model.project.ProjectDeveloper [Table : 
> PROJECTDEVELOPER, InheritanceStrategy : new-table]
> 3070 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : 
> org.apache.maven.continuum.model.project.ProjectNotifier [Table : 
> PROJECTNOTIFIER, InheritanceStrategy : new-table]
> 3097 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : 
> org.apache.maven.continuum.model.project.ProjectGroup [Table : 
> PROJECTGROUP, InheritanceStrategy : new-table]
> 3104 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Class : org.apache.maven.continuum.model.project.Project 
> [Table : PROJECT, InheritanceStrategy : new-table]
> 3177 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Field : 
> org.apache.maven.continuum.model.project.ProjectNotifier.configuration 
> [Table : PROJECTNOTIFIER_CONFIGURATION]
> 3236 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Field : 
> org.apache.maven.continuum.model.project.ProjectGroup.buildDefinitions 
> [Table : PROJECTGROUP_BUILDDEFINITIONS]
> 3262 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Field : 
> org.apache.maven.continuum.model.project.ProjectGroup.notifiers [Table : 
> PROJECTGROUP_NOTIFIERS]
> 3303 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Field : 
> org.apache.maven.continuum.model.project.Project.buildDefinitions [Table 
> : PROJECT_BUILDDEFINITIONS]
> 3330 [WrapperSimpleAppMain] INFO  JPOX.RDBMS.SCHEMA  - Managing 
> Persistence of Field : 
> org.apache.maven.continuum.model.project.Project.notifiers [Table : 
> PROJECT_NOTIFIERS]
> 3379 [WrapperSimpleAppMain] ERROR JPOX.RDBMS.SCHEMA  - An exception was 
> thrown while adding/validating class(es) : null
> java.lang.NullPointerException
>     at java.lang.StringBuffer.<init>(StringBuffer.java:104)
>     at org.jpox.util.StringUtils.replaceAll(StringUtils.java:37)
>     at 
> org.jpox.store.rdbms.sqlidentifier.SQLIdentifier.setSQLIdentifier(SQLIdentifier.java:206)

> 
>     at 
> org.jpox.store.rdbms.sqlidentifier.SQLIdentifier.<init>(SQLIdentifier.java:68)

> 
>     at 
> org.jpox.store.rdbms.sqlidentifier.TableIdentifier.<init>(TableIdentifier.java:29)

> 
>     at 
> org.jpox.store.rdbms.sqlidentifier.IdentifierFactory.newIdentifier(IdentifierFactory.java:98)

> 
>     at 
> org.jpox.store.rdbms.RDBMSManager.refreshColumnInfo(RDBMSManager.java:1639)
>     at 
> org.jpox.store.rdbms.RDBMSManager.getColumnInfoForTable(RDBMSManager.java:1545) 
> 
>     at 
> org.jpox.store.rdbms.table.TableImpl.initializeDefault(TableImpl.java:94)
>     at 
> org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2486)

> 
>     at 
> org.jpox.store.rdbms.RDBMSManager$ClassAdder.execute(RDBMSManager.java:2055) 
> 
>     at 
> org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:1928) 
> 
>     at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:497)
>     at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:510)
>     at 
> org.jpox.store.rdbms.RDBMSManager.getDatastoreClass(RDBMSManager.java:831)
>     at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1016)
>     at 
> org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2028) 
> 
>     at 
> org.apache.maven.continuum.store.JdoContinuumStore.getAllObjectsDetached(JdoContinuumStore.java:770)

> 
>     at 
> org.apache.maven.continuum.store.JdoContinuumStore.getAllProjectsByName(JdoContinuumStore.java:517)

> 
>     at 
> org.apache.maven.continuum.DefaultContinuum.initialize(DefaultContinuum.java:1550) 
> 
>     at 
> org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:16)

> 
>     at 
> org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:101)

> 
>     at 
> org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:105)

> 
>     at 
> org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:95)

> 
>     at 
> org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:92)

> 
>     at 
> org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327) 
> 
>     at 
> org.codehaus.plexus.DefaultPlexusContainer.loadComponentsOnStart(DefaultPlexusContainer.java:884)

> 
>     at 
> org.codehaus.plexus.DefaultPlexusContainer.start(DefaultPlexusContainer.java:772) 
> 
>     at 
> org.codehaus.plexus.application.deploy.DefaultApplicationDeployer.deployApplicationDirectory(DefaultApplicationDeployer.java:366)

> 
>     at 
> org.codehaus.plexus.application.deploy.DefaultApplicationDeployer.deployJar(DefaultApplicationDeployer.java:212)

> 
>     at 
> org.codehaus.plexus.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:136)

> 
>     at 
> org.codehaus.plexus.application.deploy.DefaultApplicationDeployer.deploy(DefaultApplicationDeployer.java:116)

> 
>     at 
> org.codehaus.plexus.application.DefaultApplicationServer$2.onJarDiscovered(DefaultApplicationServer.java:117)

> 
>     at 
> org.codehaus.plexus.application.supervisor.DefaultSupervisor.scanDirectory(DefaultSupervisor.java:89)

> 
>     at 
> org.codehaus.plexus.application.supervisor.DefaultSupervisor.scan(DefaultSupervisor.java:68)

> 
>     at 
> org.codehaus.plexus.application.DefaultApplicationServer.start(DefaultApplicationServer.java:146)

> 
>     at 
> org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute(StartPhase.java:16)

> 
>     at 
> org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start(AbstractLifecycleHandler.java:101)

> 
>     at 
> org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle(AbstractComponentManager.java:105)

> 
>     at 
> org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance(AbstractComponentManager.java:95)

> 
>     at 
> org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent(ClassicSingletonComponentManager.java:92)

> 
>     at 
> org.codehaus.plexus.DefaultPlexusContainer.lookup(DefaultPlexusContainer.java:327) 
> 
>     at 
> org.codehaus.plexus.application.PlexusApplicationHost.start(PlexusApplicationHost.java:109)

> 
>     at 
> org.codehaus.plexus.application.PlexusApplicationHost.main(PlexusApplicationHost.java:236)

> 
>     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.classworlds.Launcher.launchEnhanced(Launcher.java:315)
>     at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
>     at 
> org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
>     at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
>     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:136)
>     at java.lang.Thread.run(Thread.java:595)
> 
> Following database content is created:
> 
> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, 
> FOREIGN_KEY_CHECKS=0 */;
> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;
> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `continuum`;
> USE `continuum`;
> CREATE TABLE `JPOX_TABLES` (
>   `CLASS_NAME` varchar(128) binary NOT NULL default '',
>   `TABLE_NAME` varchar(128) binary NOT NULL default '',
>   `TYPE` varchar(4) binary NOT NULL default '',
>   `OWNER` char(2) binary NOT NULL default '',
>   `VERSION` varchar(20) binary NOT NULL default '',
>   UNIQUE KEY `CLASS_NAME` (`CLASS_NAME`)
> ) TYPE=InnoDB;
> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
> /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
> 
> 


Mime
View raw message