| Summary: | DB Tool should prefix TIMERS table with db schema name. | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise SOA Platform 5 | Reporter: | Marek Baluch <mbaluch> |
| Component: | Tooling | Assignee: | Julian Coleman <jcoleman> |
| Status: | CLOSED NEXTRELEASE | QA Contact: | |
| Severity: | high | Docs Contact: | |
| Priority: | high | ||
| Version: | 5.2.0.ER3 | CC: | mbaluch |
| Target Milestone: | --- | ||
| Target Release: | 5.2.0 GA, 5.2.0.ER4 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| URL: | http://jira.jboss.org/jira/browse/SOA-3315 | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2011-09-22 11:55:57 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
Link: Added: This issue depends JBPAPP-7096 Link: Added: This issue relates to SOA-1597 Link: Removed: This issue depends JBPAPP-7096 Link: Removed: This issue relates to SOA-1597 Link: Added: This issue relates to SOA-1597 Resloved with revision 9930 of: soa-p/src/main/resources/soa-p/schema-tool/schema-tool/build.xml Commit message: SOA-3315 Also prepend the database user name to the EJB timers table name for DB2. Release Notes Text: Added: When using DB2 as the database, the EJB2 timers table name has been prefixed with the database user name, in order to avoid schema conflicts. Release Notes Docs Status: Added: Not Required Writer: Added: dlesage Hi Julian, why are we prepending the username instead of the database (schema) name? Am I missing something? Thanks! Verified on ER4. |
project_key: SOA Schema tool should prefix TIMERS table with schema name. The TIMERS table is defined in file deploy/ejb2-timer-service.xml. If the schema name is not present the plugin org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin may find the TIMERS table in a different database schema and produce the following exception: {noformat} 2011-08-30 10:40:54,013 DEBUG [org.jboss.ejb.txtimer.DatabasePersistencePolicy] (main) Creating jboss.ejb:service=EJBTimerService,persistencePolicy=database 2011-08-30 10:40:54,014 DEBUG [org.jboss.ejb.txtimer.DatabasePersistencePolicy] (main) Created jboss.ejb:service=EJBTimerService,persistencePolicy=database 2011-08-30 10:40:54,015 DEBUG [org.jboss.ejb.txtimer.EJBTimerServiceImpl] (main) Creating jboss.ejb:service=EJBTimerService 2011-08-30 10:40:54,015 DEBUG [org.jboss.ejb.txtimer.EJBTimerServiceImpl] (main) Created jboss.ejb:service=EJBTimerService 2011-08-30 10:40:54,016 DEBUG [org.jboss.ejb.txtimer.DatabasePersistencePolicy] (main) Starting jboss.ejb:service=EJBTimerService,persistencePolicy=database 2011-08-30 10:40:54,964 DEBUG [org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin] (main) Adding new column NEXTDATE to table TIMERS - executing DDL: alter table TIMERS ADD NEXTDATE TIMESTAMP 2011-08-30 10:40:55,100 DEBUG [org.jboss.ejb.txtimer.DatabasePersistencePolicy] (main) Starting failed jboss.ejb:service=EJBTimerService,persistencePolicy=database com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=RIFTSAW.TIMERS, DRIVER=4.9.78 at com.ibm.db2.jcc.am.fd.a(fd.java:676) at com.ibm.db2.jcc.am.fd.a(fd.java:60) at com.ibm.db2.jcc.am.fd.a(fd.java:127) at com.ibm.db2.jcc.am.en.c(en.java:2553) at com.ibm.db2.jcc.am.en.d(en.java:2541) at com.ibm.db2.jcc.am.en.b(en.java:1957) at com.ibm.db2.jcc.t4.cb.h(cb.java:221) at com.ibm.db2.jcc.t4.cb.b(cb.java:47) at com.ibm.db2.jcc.t4.q.b(q.java:38) at com.ibm.db2.jcc.t4.rb.h(rb.java:114) at com.ibm.db2.jcc.am.en.hb(en.java:1952) at com.ibm.db2.jcc.am.en.a(en.java:3040) at com.ibm.db2.jcc.am.en.c(en.java:711) at com.ibm.db2.jcc.am.en.executeUpdate(en.java:695) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249) at org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.createTableIfNotExists(GeneralPurposeDatabasePersistencePlugin.java:196) at org.jboss.ejb.txtimer.DatabasePersistencePolicy.startService(DatabasePersistencePolicy.java:104) at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376) at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322) at sun.reflect.GeneratedMethodAccessor110.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668) at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189) at $Proxy38.start(Unknown Source) at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42) at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37) at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62) at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71) at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51) at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:297) at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652) at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938) at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082) at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988) at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826) at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556) at org.jboss.system.ServiceController.doChange(ServiceController.java:688) at org.jboss.system.ServiceController.start(ServiceController.java:460) at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163) at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99) at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46) at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62) at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55) at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179) at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1454) at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1172) at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1193) at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1113) at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652) at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938) at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082) at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988) at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826) at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556) at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:789) at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:699) at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117) at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70) at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53) at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:403) at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652) at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938) at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082) at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988) at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:778) at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:543) at org.jboss.system.server.profileservice.repository.AbstractProfileService.registerProfile(AbstractProfileService.java:308) at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:256) at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461) at org.jboss.Main.boot(Main.java:221) at org.jboss.Main$1.run(Main.java:556) at java.lang.Thread.run(Thread.java:619) {noformat}