You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@continuum.apache.org by witek wolejszo <ww...@TouK.pl> on 2005/11/03 14:38:55 UTC

running continuum on mysql

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 */;


-- 
witek wołejszo
http://touk.pl