[jboss-jira] [JBoss JIRA] Commented: (JBPORTAL-1375) Bug creating jbp tables using Oracle as the database server
Prabhat Jha (JIRA)
jira-events at lists.jboss.org
Tue May 1 14:53:30 EDT 2007
[ http://jira.jboss.com/jira/browse/JBPORTAL-1375?page=comments#action_12361053 ]
Prabhat Jha commented on JBPORTAL-1375:
---------------------------------------
Chris, I have asked Alex K. to crate a database for you to play with on oracle9i instance we have. I will send you the details once I have it.
> Bug creating jbp tables using Oracle as the database server
> -----------------------------------------------------------
>
> Key: JBPORTAL-1375
> URL: http://jira.jboss.com/jira/browse/JBPORTAL-1375
> Project: JBoss Portal
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Portal WSRP
> Affects Versions: 2.6.CR1
> Environment: Solaris or Windows XP
> Reporter: Stephen Westbom
> Assigned To: Chris Laprun
> Priority: Blocker
> Fix For: 2.6 Final
>
>
> 09:43:03,493 WARN [EhCacheProvider] Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
> 09:43:03,633 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
> 09:43:03,633 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
> 09:43:03,665 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
> 09:43:03,665 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
> 09:43:03,680 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
> 09:43:03,680 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
> 09:43:03,696 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
> 09:43:03,696 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
> 09:43:03,711 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
> 09:43:03,711 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
> 09:43:03,711 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
> 09:43:03,727 INFO [SchemaExport] Running hbm2ddl schema export
> 09:43:03,743 INFO [SchemaExport] exporting generated schema to database
> 09:43:03,743 INFO [NamingHelper] JNDI InitialContext properties:{}
> 09:43:03,743 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
> 09:43:03,899 ERROR [SchemaExport] Unsuccessful: create table JBP_ENDPOINT_INFO (PK number(19,0) not null, SD_URL varchar2(255 char) not null, M_URL varchar2(255 char) not null, PM_URL varchar2(255 char), R_URL varchar2(255 char), WSDL_URL varchar2(255 char), primary key (PK))
> 09:43:03,899 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment in tablespace RJDATA
> 09:43:03,915 ERROR [SchemaExport] Unsuccessful: create table JBP_PRODUCER_INFO (PK number(19,0) not null, ENDPOINT_ID number(19,0) not null unique, REGISTRATION_ID number(19,0) unique, EXPIRATION_CACHE_SECONDS number(10,0), active number(1,0) not null, id varchar2(255 char) not null unique, primary key (PK))
> 09:43:03,915 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment in tablespace RJDATA
> 09:43:03,930 ERROR [SchemaExport] Unsuccessful: create table JBP_REGISTRATION_INFO (PK number(19,0) not null, CONSUMER_NAME varchar2(255 char) not null, HANDLE varchar2(255 char), STATE raw(255), primary key (PK))
> 09:43:03,930 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment in tablespace RJDATA
> 09:43:03,946 ERROR [SchemaExport] Unsuccessful: create table JBP_REG_PROPERTY (PK number(19,0) not null, name varchar2(255 char) not null, value varchar2(255 char) not null, invalid number(1,0), lang varchar2(255 char), DESC_PK number(19,0) unique, REG_PK number(19,0) not null, primary key (PK))
> 09:43:03,946 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment in tablespace RJDATA
> 09:43:03,946 ERROR [SchemaExport] Unsuccessful: create table JBP_REG_PROP_DESC (PK number(19,0) not null, name varchar2(255 char) not null, type varchar2(255 char) not null, SCHEMA varchar2(255 char), DESC_VALUE varchar2(255 char), DESC_LOCALE varchar2(255 char), DESC_RES varchar2(255 char), HINT_VALUE varchar2(255 char), HINT_LOCALE varchar2(255 char), HINT_RES varchar2(255 char), LABEL_VALUE varchar2(255 char), LABEL_LOCALE varchar2(255 char), LABEL_RES varchar2(255 char), primary key (PK))
> 09:43:03,946 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment in tablespace RJDATA
> 09:43:03,961 ERROR [SchemaExport] Unsuccessful: create table JBP_REG_PROP_DESC_ALIASES (PK number(19,0) not null, ALIAS varchar2(255 char) not null, IDX number(10,0) not null, primary key (PK, IDX))
> 09:43:03,961 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment in tablespace RJDATA
> 09:43:03,977 ERROR [SchemaExport] Unsuccessful: create table JBP_REG_PROP_DESC_USAGES (PK number(19,0) not null, USAGE varchar2(255 char) not null, IDX number(10,0) not null, primary key (PK, IDX))
> 09:43:03,977 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment in tablespace RJDATA
> 09:43:03,977 ERROR [SchemaExport] Unsuccessful: alter table JBP_PRODUCER_INFO add constraint FK7282A754747FC32F foreign key (ENDPOINT_ID) references JBP_ENDPOINT_INFO
> 09:43:03,977 ERROR [SchemaExport] ORA-00942: table or view does not exist
> 09:43:03,993 ERROR [SchemaExport] Unsuccessful: alter table JBP_PRODUCER_INFO add constraint FK7282A7544EE0278D foreign key (REGISTRATION_ID) references JBP_REGISTRATION_INFO
> 09:43:03,993 ERROR [SchemaExport] ORA-00942: table or view does not exist
> 09:43:03,993 ERROR [SchemaExport] Unsuccessful: alter table JBP_REG_PROPERTY add constraint FKC86C78072FBF86B2 foreign key (REG_PK) references JBP_REGISTRATION_INFO
> 09:43:03,993 ERROR [SchemaExport] ORA-00942: table or view does not exist
> 09:43:03,993 ERROR [SchemaExport] Unsuccessful: alter table JBP_REG_PROPERTY add constraint FKC86C78072F43055 foreign key (DESC_PK) references JBP_REG_PROP_DESC
> 09:43:03,993 ERROR [SchemaExport] ORA-00942: table or view does not exist
> 09:43:03,993 ERROR [SchemaExport] Unsuccessful: alter table JBP_REG_PROP_DESC_ALIASES add constraint FKB556AC9AA6289FE7 foreign key (PK) references JBP_REG_PROP_DESC
> 09:43:03,993 ERROR [SchemaExport] ORA-00942: table or view does not exist
> 09:43:04,008 ERROR [SchemaExport] Unsuccessful: alter table JBP_REG_PROP_DESC_USAGES add constraint FKFF0F31B6A6289FE7 foreign key (PK) references JBP_REG_PROP_DESC
> 09:43:04,008 ERROR [SchemaExport] ORA-00942: table or view does not exist
> 09:43:04,024 INFO [SchemaExport] schema export complete
> 09:43:04,165 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
> 09:43:04,165 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
> 09:43:04,196 WARN [ServiceController] Problem starting service portal.wsrp:service=ConsumerRegistry
> org.hibernate.exception.SQLGrammarException: could not execute query using iterate
> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:444)
> at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:380)
> at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java:224)
> at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1192)
> at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:46)
> at org.jboss.portal.wsrp.consumer.ConsumerRegistryService.org$jboss$portal$wsrp$consumer$ConsumerRegistryService$startService$aop(ConsumerRegistryService.java:183)
> at org.jboss.portal.wsrp.consumer.ConsumerRegistryService$startService_N522319811864268586.invokeNext(ConsumerRegistryService$startService_N522319811864268586.java)
> at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
> at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
> at org.jboss.portal.wsrp.consumer.ConsumerRegistryService$startService_N522319811864268586.invokeNext(ConsumerRegistryService$startService_N522319811864268586.java)
> at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
> at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
> at org.jboss.portal.wsrp.consumer.ConsumerRegistryService$startService_N522319811864268586.invokeNext(ConsumerRegistryService$startService_N522319811864268586.java)
> at org.jboss.portal.wsrp.consumer.ConsumerRegistryService.startService(ConsumerRegistryService.java)
> at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
> at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
> at org.jboss.portal.jems.as.system.AbstractJBossService.start(AbstractJBossService.java:73)
> at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.execute(JBossServiceModelMBean.java:428)
> at org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.startService(JBossServiceModelMBean.java:394)
> at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
> at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
> at org.jboss.portal.jems.as.system.JBossServiceModelMBean$5.invoke(JBossServiceModelMBean.java:316)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
> at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
> at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
> 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:659)
> at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
> at $Proxy0.start(Unknown Source)
> at org.jboss.system.ServiceController.start(ServiceController.java:417)
> at org.jboss.system.ServiceController.start(ServiceController.java:435)
> at org.jboss.system.ServiceController.start(ServiceController.java:435)
> at org.jboss.system.ServiceController.start(ServiceController.java:435)
> at org.jboss.system.ServiceController.start(ServiceController.java:435)
> at org.jboss.system.ServiceController.start(ServiceController.java:435)
> at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
> at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
> at $Proxy4.start(Unknown Source)
> at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
> 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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
> at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
> at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
> 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:659)
> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
> at $Proxy160.start(Unknown Source)
> at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
> at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
> at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
> at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
> 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:659)
> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
> at $Proxy8.deploy(Unknown Source)
> at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
> at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
> at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
> at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
> at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
> at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
> at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
> at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
> at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
> at $Proxy0.start(Unknown Source)
> at org.jboss.system.ServiceController.start(ServiceController.java:417)
> at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
> at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
> at $Proxy4.start(Unknown Source)
> at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
> 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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
> at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
> at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
> 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:659)
> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
> at $Proxy5.deploy(Unknown Source)
> at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
> at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
> at org.jboss.Main.boot(Main.java:200)
> at org.jboss.Main$1.run(Main.java:490)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
> at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
> at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
> at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
> at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
> at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:421)
> ... 132 more
> 09:43:04,211 INFO [NamingHelper] JNDI InitialContext properties:{}
> 09:43:04,211 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
> 09:43:04,211 INFO [SettingsFactory] RDBMS: Oracle, version: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.5.0 - Production
> 09:43:04,211 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.2.0.2.0
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the jboss-jira
mailing list