This discussion is archived
1 Reply Latest reply: Apr 5, 2013 5:38 AM by 975753 RSS

Error starting CC&B witha remote database

975753 Newbie
Currently Being Moderated
Hi everybody,

I installed the CC&B demo database on a remote machine "A", and CC&B in another one "B", i configured the net manager and i can do a tnsping from the machine B , also i can connect to the database using CISADM. But when starting the application i get the following errors:

this is my spl_web.log:


- 2013-04-05 14:09:19,315 [main] INFO (shared.context.ApplicationMode) Application set to development mode
- 2013-04-05 14:09:19,315 [main] INFO (web.startup.SPLWebStartup) Initializing SPL web application
- 2013-04-05 14:09:19,315 [main] INFO (web.dynamicui.TransformServletHelper) Disable UIPage Compression set to false
- 2013-04-05 14:09:19,331 [main] INFO (support.context.ContextFactory) Creating default context
- 2013-04-05 14:09:19,814 [main] INFO (support.context.ContextFactory) Loading lookups for runtime discovery of implemented lookups in application
- 2013-04-05 14:09:20,017 [main] INFO (support.context.ContextFactory) Done loading lookups for discovery, time 206,994 ms
- 2013-04-05 14:09:21,234 [main] INFO (shared.context.ContextLoader) Discovering lookups for base
- 2013-04-05 14:09:21,421 [main] INFO (shared.context.ContextLoader) Done discovering base lookups (generated=210, manual=42), time 177,072 ms
- 2013-04-05 14:09:24,572 [main] INFO (shared.context.ContextLoader) Discovering lookups for ccb
- 2013-04-05 14:09:24,806 [main] INFO (shared.context.ContextLoader) Done discovering ccb lookups (generated=486, manual=126), time 221,505 ms
- 2013-04-05 14:09:24,822 [main] WARN (shared.environ.ContextManagedObjectSet) Could not load resource com/splwg/cm/domain/contextManagedObjects.xml on classpath. This may be harmless but could mean a problem with the classpath. Please verify that the classpath for application cm is correctly configured.
- 2013-04-05 14:09:32,247 [main] INFO (support.context.ContextFactory) Registering lookups
- 2013-04-05 14:09:32,606 [main] INFO (support.context.ContextFactory) 662 lookups registered, time 355,508 ms
- 2013-04-05 14:09:32,606 [main] INFO (support.context.ComponentContainerLookupHelper) Initializing constants on 696 lookup interface classes
- 2013-04-05 14:09:33,199 [main] INFO (support.context.ComponentContainerLookupHelper) Done initializing lookup constants, time 584,504 ms
- 2013-04-05 14:09:33,199 [main] INFO (support.context.ContextFactory) Registering Entities
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) 898 entities registered, time 1 034,161 ms
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) Registering Code Description queries
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) 52 code/description queries registered, time 0,063 ms
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) Registering algorithm spots
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) 248 algorithm spots registered, time 0,312 ms
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) Registering algorithm components
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) 114 algorithm components registered, time 0,062 ms
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) Registering batch jobs
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) 33 batch jobs registered, time 0,050 ms
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) Registering Components
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) 757 components registered, time 3,567 ms
- 2013-04-05 14:09:34,229 [main] INFO (support.context.ContextFactory) Registering Change Handlers
- 2013-04-05 14:09:34,244 [main] INFO (support.context.ContextFactory) 275 handlers registered, time 0,525 ms
- 2013-04-05 14:09:34,244 [main] INFO (support.context.ContextFactory) Registering Services
- 2013-04-05 14:09:34,244 [main] INFO (support.context.ContextFactory) 561 services registered, time 5,460 ms
- 2013-04-05 14:09:34,244 [main] INFO (support.context.ContextFactory) Registering cobol programs
- 2013-04-05 14:09:34,790 [main] INFO (support.context.ContextFactory) 571 cobol copybooks registered, time 553,638 ms
- 2013-04-05 14:09:34,790 [main] INFO (support.context.ContextFactory) Registering cobol programs
- 2013-04-05 14:09:34,806 [main] INFO (support.context.ContextFactory) 167 cobol programs registered, time 0,095 ms
- 2013-04-05 14:09:34,806 [main] INFO (support.context.ApplicationContext) Building hibernate configuration
- 2013-04-05 14:09:34,806 [main] INFO (support.context.ApplicationContext) Loaded hibernate.properties from external file C:\spl\env_ccb\etc\conf\root\WEB-INF\classes\hibernate.properties
- 2013-04-05 14:09:34,806 [main] INFO (support.context.ApplicationContext) Adding 898 hibernate mappings
- 2013-04-05 14:09:35,414 [main] INFO (support.context.ApplicationContext) Added 100 mappings
- 2013-04-05 14:09:35,835 [main] INFO (support.context.ApplicationContext) Added 200 mappings
- 2013-04-05 14:09:36,241 [main] INFO (support.context.ApplicationContext) Added 300 mappings
- 2013-04-05 14:09:36,631 [main] INFO (support.context.ApplicationContext) Added 400 mappings
- 2013-04-05 14:09:37,037 [main] INFO (support.context.ApplicationContext) Added 500 mappings
- 2013-04-05 14:09:37,427 [main] INFO (support.context.ApplicationContext) Added 600 mappings
- 2013-04-05 14:09:37,785 [main] INFO (support.context.ApplicationContext) Added 700 mappings
- 2013-04-05 14:09:38,207 [main] INFO (support.context.ApplicationContext) Added 800 mappings
- 2013-04-05 14:09:38,581 [main] INFO (support.context.ApplicationContext) Added 898 mappings
- 2013-04-05 14:09:38,581 [main] INFO (support.context.ApplicationContext) Done building hibernate configuration, time 3 788,101 ms
- 2013-04-05 14:09:38,581 [main] INFO (support.context.ApplicationContext) Building hibernate session factory
- 2013-04-05 14:09:39,111 [main] INFO (hibernate.connection.ConnectionProviderFactory) Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider
- 2013-04-05 14:09:39,111 [main] INFO (hibernate.connection.C3P0ConnectionProvider) C3P0 using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@WIN-1MFKWP6YW2A:1521:CCB01
- 2013-04-05 14:09:39,111 [main] INFO (hibernate.connection.C3P0ConnectionProvider) Connection properties: {user=cisadm, password=****}
- 2013-04-05 14:09:39,111 [main] INFO (hibernate.connection.C3P0ConnectionProvider) autocommit mode: false
- 2013-04-05 14:09:39,127 [main] INFO (v2.log.MLog) MLog clients using log4j logging.
- 2013-04-05 14:09:39,174 [main] INFO (v2.c3p0.C3P0Registry) Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
- 2013-04-05 14:09:39,221 [main] INFO (c3p0.impl.AbstractPoolBackedDataSource) Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@a93b41ca [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@5608568d [ 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 -> 1hge18v8t1oik7d316my32|723592, 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@a648c40e [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1hge18v8t1oik7d316my32|139e19c, jdbcUrl -> jdbc:oracle:thin:@WIN-1MFKWP6YW2A:1521:CCB01, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1hge18v8t1oik7d316my32|10b589d, numHelperThreads -> 3 ]
- 2013-04-05 14:09:39,314 [main] INFO (hibernate.dialect.Dialect) Using dialect: org.hibernate.dialect.Oracle10gDialect
- 2013-04-05 14:09:39,314 [main] INFO (hibernate.transaction.TransactionFactoryFactory) Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
- 2013-04-05 14:09:39,314 [main] INFO (hibernate.transaction.TransactionManagerLookupFactory) No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
- 2013-04-05 14:09:39,345 [main] INFO (hibernate.impl.SessionFactoryImpl) building session factory
- 2013-04-05 14:09:44,712 [main] INFO (hibernate.impl.SessionFactoryObjectFactory) Not binding factory to JNDI, no JNDI name configured
- 2013-04-05 14:09:44,712 [main] INFO (support.context.ApplicationContext) Done building hibernate session factory, time 6 121,809 ms
- 2013-04-05 14:09:45,133 [main] INFO (web.startup.SPLWebStartup) Shutting Down the JMX Connectors...
- 2013-04-05 14:09:45,133 [main] INFO (web.startup.SPLWebStartup) JMX Connectors shutdown successfully
- 2013-04-05 14:09:45,133 [main] INFO (web.startup.SPLWebStartup) Shutting Down the Application Context...
- 2013-04-05 14:09:45,133 [main] INFO (hibernate.impl.SessionFactoryImpl) closing
- 2013-04-05 14:09:45,133 [main] INFO (web.startup.SPLWebStartup) Application Context shutdown successfully

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points