0 Replies Latest reply: Jul 13, 2012 7:30 AM by amitpd RSS

    CCB algorithm customization

    amitpd
      Hi members,

      Please share a complete document which could help me in customizing an algorithm of CCB. I have a ppt supplied by Oracle but whatever it was saying in its document, i followed exactly, but the GenerateArtifact is not generating the required things. My console details after running GenerateArtifact is as follows. The error is in the last paragraph of the console details. Let me know what i am doing wrong, and if you have a concrete document regarding CCB algo customization, please share. I am in a deep crisis of a complete document for it.If you have a code for ccb algo customization, please share it.



      INFO: Loaded spl.properties from classpath: {spl.runtime.cobol.sql.cursoredCache.maxRows=10, spl.tools.loaded.applications=base,ccb,cm, spl.runtime.cobol.sql.disableQueryCache=false, spl.runtime.utf8Database=true, spl.runtime.fusionlook=true, spl.runtime.cobol.encoding=UTF8, spl.runtime.cobol.sql.cache.maxTotalEntries=1000, spl.runtime.cobol.cobrcall=false, spl.runtime.cobol.sql.fetchSize=150, spl.runtime.environ.init.dir=C:/spl/ccb/etc, spl.runtime.sql.highValue=?, spl.runtime.service.extraInstallationServices=CILTINCP, spl.runtime.oracle.statementCacheSize=300}
      - 2012-07-13 03:46:15,658 [main] INFO (tools.artifactgen.VelocityLogger) **************************************************************
      - 2012-07-13 03:46:15,658 [main] INFO (tools.artifactgen.VelocityLogger) Starting Jakarta Velocity v1.4
      - 2012-07-13 03:46:15,658 [main] INFO (tools.artifactgen.VelocityLogger) RuntimeInstance initializing.
      - 2012-07-13 03:46:15,658 [main] INFO (tools.artifactgen.VelocityLogger) Default Properties File: org\apache\velocity\runtime\defaults\velocity.properties
      - 2012-07-13 03:46:15,658 [main] INFO (tools.artifactgen.VelocityLogger) Trying to use logger class com.splwg.tools.artifactgen.VelocityLogger
      - 2012-07-13 03:46:15,658 [main] INFO (tools.artifactgen.VelocityLogger) Using logger class com.splwg.tools.artifactgen.VelocityLogger
      - 2012-07-13 03:46:15,674 [main] INFO (tools.artifactgen.VelocityLogger) Default ResourceManager initializing. (class org.apache.velocity.runtime.resource.ResourceManagerImpl)
      - 2012-07-13 03:46:15,674 [main] INFO (tools.artifactgen.VelocityLogger) Resource Loader Instantiated: org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
      - 2012-07-13 03:46:15,674 [main] INFO (tools.artifactgen.VelocityLogger) ClasspathResourceLoader : initialization starting.
      - 2012-07-13 03:46:15,674 [main] INFO (tools.artifactgen.VelocityLogger) ClasspathResourceLoader : initialization complete.
      - 2012-07-13 03:46:15,674 [main] INFO (tools.artifactgen.VelocityLogger) ResourceCache : initialized. (class org.apache.velocity.runtime.resource.ResourceCacheImpl)
      - 2012-07-13 03:46:15,674 [main] INFO (tools.artifactgen.VelocityLogger) Default ResourceManager initialization complete.
      - 2012-07-13 03:46:15,690 [main] INFO (tools.artifactgen.VelocityLogger) Loaded System Directive: org.apache.velocity.runtime.directive.Literal
      - 2012-07-13 03:46:15,690 [main] INFO (tools.artifactgen.VelocityLogger) Loaded System Directive: org.apache.velocity.runtime.directive.Macro
      - 2012-07-13 03:46:15,690 [main] INFO (tools.artifactgen.VelocityLogger) Loaded System Directive: org.apache.velocity.runtime.directive.Parse
      - 2012-07-13 03:46:15,690 [main] INFO (tools.artifactgen.VelocityLogger) Loaded System Directive: org.apache.velocity.runtime.directive.Include
      - 2012-07-13 03:46:15,705 [main] INFO (tools.artifactgen.VelocityLogger) Loaded System Directive: org.apache.velocity.runtime.directive.Foreach
      - 2012-07-13 03:46:15,768 [main] INFO (tools.artifactgen.VelocityLogger) Created: 20 parsers.
      - 2012-07-13 03:46:15,768 [main] INFO (tools.artifactgen.VelocityLogger) Velocimacro : initialization starting.
      - 2012-07-13 03:46:15,768 [main] INFO (tools.artifactgen.VelocityLogger) Velocimacro : allowInline = true : VMs can be defined inline in templates
      - 2012-07-13 03:46:15,768 [main] INFO (tools.artifactgen.VelocityLogger) Velocimacro : allowInlineToOverride = false : VMs defined inline may NOT replace previous VM definitions
      - 2012-07-13 03:46:15,768 [main] INFO (tools.artifactgen.VelocityLogger) Velocimacro : allowInlineLocal = false : VMs defined inline will be global in scope if allowed.
      - 2012-07-13 03:46:15,768 [main] INFO (tools.artifactgen.VelocityLogger) Velocimacro : messages on : VM system will output logging messages
      - 2012-07-13 03:46:15,768 [main] INFO (tools.artifactgen.VelocityLogger) Velocimacro : autoload off : VM system will not automatically reload global library macros
      - 2012-07-13 03:46:15,768 [main] INFO (tools.artifactgen.VelocityLogger) Velocimacro : initialization complete.
      - 2012-07-13 03:46:15,768 [main] INFO (tools.artifactgen.VelocityLogger) Velocity successfully started.
      - 2012-07-13 03:46:17,127 [main] INFO (hibernate.connection.ConnectionProviderFactory) Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider
      - 2012-07-13 03:46:17,127 [main] INFO (hibernate.connection.C3P0ConnectionProvider) C3P0 using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@10.32.14.59:1522:ccb
      - 2012-07-13 03:46:17,127 [main] INFO (hibernate.connection.C3P0ConnectionProvider) Connection properties: {user=cisadm, password=****}
      - 2012-07-13 03:46:17,127 [main] INFO (hibernate.connection.C3P0ConnectionProvider) autocommit mode: false
      - 2012-07-13 03:46:17,283 [main] INFO (v2.log.MLog) MLog clients using log4j logging.
      - 2012-07-13 03:46:17,518 [main] INFO (v2.c3p0.C3P0Registry) Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
      - 2012-07-13 03:46:17,658 [main] INFO (c3p0.impl.AbstractPoolBackedDataSource) Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@5008c852 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@cf961158 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2t4xur8ozi0oj55a54j5|7109c4, idleConnectionTestPeriod -> 0, initialPoolSize -> 1, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 300, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 150, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@d4a4529d [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 2t4xur8ozi0oj55a54j5|42552c, jdbcUrl -> jdbc:oracle:thin:@10.32.14.59:1522:ccb, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 2t4xur8ozi0oj55a54j5|19ce060, numHelperThreads -> 3 ]
      - 2012-07-13 03:46:18,518 [main] INFO (hibernate.dialect.Dialect) Using dialect: org.hibernate.dialect.Oracle10gDialect
      - 2012-07-13 03:46:18,533 [main] INFO (hibernate.transaction.TransactionFactoryFactory) Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
      - 2012-07-13 03:46:18,533 [main] INFO (hibernate.transaction.TransactionManagerLookupFactory) No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
      - 2012-07-13 03:46:18,611 [main] INFO (hibernate.impl.SessionFactoryImpl) building session factory
      - 2012-07-13 03:46:19,252 [main] INFO (hibernate.impl.SessionFactoryObjectFactory) Not binding factory to JNDI, no JNDI name configured
      - 2012-07-13 03:46:19,252 [main] INFO (tools.artifactgen.ArtifactGenerator)
      - 2012-07-13 03:46:19,330 [main] INFO (tools.artifactgen.ArtifactGenerator) Will generate all artifacts
      - 2012-07-13 03:46:19,330 [main] INFO (artifactgen.metadata.DatabaseRepository) Retrieving all fields for access by name
      - 2012-07-13 03:46:20,689 [main] INFO (artifactgen.metadata.DatabaseRepository) Done retrieving all fields, time 1,345.973 ms
      - 2012-07-13 03:46:20,689 [main] INFO (artifactgen.metadata.DatabaseRepository) Retrieving all lookupFields for access by name
      - 2012-07-13 03:46:20,736 [main] INFO (artifactgen.metadata.DatabaseRepository) Done retrieving all lookup fields, time 61.354 ms
      - 2012-07-13 03:46:20,736 [main] INFO (tools.artifactgen.ArtifactGenerator) Generating artifacts for the cm application
      - 2012-07-13 03:46:20,736 [main] INFO (tools.artifactgen.ArtifactGenerator) Initializing from input source files
      - 2012-07-13 03:46:20,752 [main] INFO (tools.artifactgen.ArtifactGenerator) Done deleting generated files for app base, time 3.354 ms
      - 2012-07-13 03:46:20,768 [main] INFO (tools.artifactgen.ArtifactGenerator) Done deleting generated files for app ccb, time 2.104 ms
      - 2012-07-13 03:46:20,799 [main] INFO (tools.artifactgen.ArtifactGenerator) Done deleting generated files for app cm, time 2.169 ms
      - 2012-07-13 03:46:20,830 [main] INFO (tools.artifactgen.ArtifactGenerator) Done initializing from input source files, time 81.079 ms
      - 2012-07-13 03:46:20,830 [main] INFO (tools.artifactgen.MetaDataLoader) Loading context managed data for application base
      - 2012-07-13 03:46:20,830 [main] INFO (tools.artifactgen.MetaDataLoader) Validating lookup MD matches base's generated lookups
      - 2012-07-13 03:46:24,799 [main] INFO (tools.artifactgen.MetaDataLoader) Done validating, time 3,969.478 ms
      - 2012-07-13 03:46:26,986 [main] INFO (shared.context.ContextLoader) Discovering lookups for base
      - 2012-07-13 03:46:26,986 [main] INFO (shared.context.ContextLoader) Done discovering base lookups (generated=208, manual=40), time 7.314 ms
      - 2012-07-13 03:46:27,627 [main] INFO (tools.artifactgen.MetaDataLoader) Registering 270 entities...
      - 2012-07-13 03:46:27,658 [main] INFO (tools.artifactgen.MetaDataLoader) Done registering entities, time 23.496 ms
      - 2012-07-13 03:46:27,658 [main] INFO (tools.artifactgen.MetaDataLoader) Done loading base context data, time 6,824.483 ms
      - 2012-07-13 03:46:27,658 [main] INFO (tools.artifactgen.MetaDataLoader) Loading context managed data for application ccb
      - 2012-07-13 03:46:27,658 [main] INFO (tools.artifactgen.MetaDataLoader) Validating lookup MD matches ccb's generated lookups
      - 2012-07-13 03:46:33,799 [main] INFO (tools.artifactgen.MetaDataLoader) Done validating, time 6,150.634 ms
      - 2012-07-13 03:46:39,595 [main] INFO (shared.context.ContextLoader) Discovering lookups for ccb
      - 2012-07-13 03:46:39,611 [main] INFO (shared.context.ContextLoader) Done discovering ccb lookups (generated=486, manual=126), time 9.907 ms
      - 2012-07-13 03:46:41,001 [main] INFO (tools.artifactgen.MetaDataLoader) Registering 633 entities...
      - 2012-07-13 03:46:41,033 [main] INFO (tools.artifactgen.MetaDataLoader) Done registering entities, time 23.765 ms
      - 2012-07-13 03:46:41,033 [main] INFO (tools.artifactgen.MetaDataLoader) Done loading ccb context data, time 13,370.874 ms
      - 2012-07-13 03:46:41,033 [main] INFO (tools.artifactgen.MetaDataLoader) Loading context managed data for application ccb
      - 2012-07-13 03:46:41,033 [main] INFO (tools.artifactgen.MetaDataLoader) Validating lookup MD matches ccb's generated lookups
      - 2012-07-13 03:46:47,298 [main] INFO (tools.artifactgen.MetaDataLoader) Done validating, time 6,266.891 ms
      - 2012-07-13 03:46:53,173 [main] INFO (shared.context.ContextLoader) Discovering lookups for ccb
      - 2012-07-13 03:46:53,189 [main] INFO (shared.context.ContextLoader) Done discovering ccb lookups (generated=486, manual=126), time 8.060 ms
      - 2012-07-13 03:46:53,204 [main] INFO (tools.artifactgen.MetaDataLoader) Registering 633 entities...
      - 2012-07-13 03:46:53,204 [main] ERROR (artifactgen.metadata.Table) Duplicate collection 'reviewLists' on entity 'accountManagementGroup', table 'CI_ACCT_MGMT_GR '
      com.splwg.shared.common.LoggedException: Duplicate collection 'reviewLists' on entity 'accountManagementGroup', table 'CI_ACCT_MGMT_GR '
           at com.splwg.shared.common.LoggedException.raised(LoggedException.java:65)
           at com.splwg.tools.artifactgen.metadata.Table.addCollection(Table.java:690)
           at com.splwg.tools.artifactgen.Entity.addCollection(Entity.java:182)
           at com.splwg.tools.artifactgen.Entity.populateOneToManyChildCollections(Entity.java:200)
           at com.splwg.tools.artifactgen.metadata.DatabaseRepository.registerEntities(DatabaseRepository.java:226)
           at com.splwg.tools.artifactgen.MetaDataLoader.registerEntities(MetaDataLoader.java:192)
           at com.splwg.tools.artifactgen.MetaDataLoader.loadMetadataFromStream(MetaDataLoader.java:129)
           at com.splwg.tools.artifactgen.MetaDataLoader.loadMetaDataFromJar(MetaDataLoader.java:117)
           at com.splwg.tools.artifactgen.MetaDataLoader.loadMetaData(MetaDataLoader.java:96)
           at com.splwg.tools.artifactgen.ArtifactGenerator.generateArtifacts(ArtifactGenerator.java:374)
           at com.splwg.tools.artifactgen.ArtifactGenerator.privateGenerate(ArtifactGenerator.java:271)
           at com.splwg.tools.artifactgen.ArtifactGenerator.doGenerateFromCommandLine(ArtifactGenerator.java:1057)
           at com.splwg.tools.artifactgen.ArtifactGenerator.main(ArtifactGenerator.java:1008)
      Exception in thread "main" com.splwg.shared.common.LoggedException: Duplicate collection 'reviewLists' on entity 'accountManagementGroup', table 'CI_ACCT_MGMT_GR '
           at com.splwg.shared.common.LoggedException.raised(LoggedException.java:65)
           at com.splwg.tools.artifactgen.metadata.Table.addCollection(Table.java:690)
           at com.splwg.tools.artifactgen.Entity.addCollection(Entity.java:182)
           at com.splwg.tools.artifactgen.Entity.populateOneToManyChildCollections(Entity.java:200)
           at com.splwg.tools.artifactgen.metadata.DatabaseRepository.registerEntities(DatabaseRepository.java:226)
           at com.splwg.tools.artifactgen.MetaDataLoader.registerEntities(MetaDataLoader.java:192)
           at com.splwg.tools.artifactgen.MetaDataLoader.loadMetadataFromStream(MetaDataLoader.java:129)
           at com.splwg.tools.artifactgen.MetaDataLoader.loadMetaDataFromJar(MetaDataLoader.java:117)
           at com.splwg.tools.artifactgen.MetaDataLoader.loadMetaData(MetaDataLoader.java:96)
           at com.splwg.tools.artifactgen.ArtifactGenerator.generateArtifacts(ArtifactGenerator.java:374)
           at com.splwg.tools.artifactgen.ArtifactGenerator.privateGenerate(ArtifactGenerator.java:271)
           at com.splwg.tools.artifactgen.ArtifactGenerator.doGenerateFromCommandLine(ArtifactGenerator.java:1057)
           at com.splwg.tools.artifactgen.ArtifactGenerator.main(ArtifactGenerator.java:1008)