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 [EMAIL PROTECTED] */;
/*!40014 SET [EMAIL PROTECTED] */;
/*!40014 SET [EMAIL PROTECTED] */;


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

Reply via email to