[JBoss Portal] - jboss-portal-2.4.0-CR3-bundled does work with Oracle 9i
by 733nb
Environment:
JBoss Portal Version: jboss-portal-2.4.0-CR3-bundled
Download: Bundled Portal Software
JBoss AS Version: 4.0.4 GA
Database Vendor and Version: Oracle 9i
JDBC Connector and Version: Oracle 10.2.0.1
OS Platform: Windows 2000
Describe the problem: Portal blows up on CMS startup
Post the error messages: java.lang.ClassCastException on setBlob
Note: Try using newer version of JackRabbit - jackrabbit-core-1.0.1 with no luck.
See below stack trace:
18:22:04,439 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
18:22:04,459 INFO [SchemaExport] Running hbm2ddl schema export
18:22:04,469 INFO [SchemaExport] exporting generated schema to database
18:22:04,469 INFO [NamingHelper] JNDI InitialContext properties:{}
18:22:04,469 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
18:22:05,580 INFO [SchemaExport] schema export complete
18:22:05,580 INFO [JCRCMS] Starting JCR CMS
18:22:05,971 INFO [RepositoryImpl] Starting repository...
18:22:06,492 WARN [TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnec
tionEventListener@157e43[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1d0740e handles=1 lastUse=1155
252126472 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@735aa1 context=org.
jboss.resource.connectionmanager.InternalManagedConnectionPool@143294a xaResource=org.jboss.resource.connectionmanager.TxConnectionM
anager$LocalXAResource@4bdccc txSync=null]
java.lang.ClassCastException
at oracle.jdbc.driver.OraclePreparedStatement.setBlob(OraclePreparedStatement.java:6794)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setBlob(WrappedPreparedStatement.java:517)
at org.jboss.portal.jems.hibernate.CacheableBlobUserType.nullSafeSet(CacheableBlobUserType.java:97)
at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:145)
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1910)
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1887)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2117)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:993)
at org.jboss.portal.cms.hibernate.HibernateStore$1.close(HibernateStore.java:1051)
at sun.nio.cs.StreamEncoder$ConverterSE.implClose(Unknown Source)
at sun.nio.cs.StreamEncoder.close(Unknown Source)
at java.io.OutputStreamWriter.close(Unknown Source)
at org.apache.jackrabbit.core.RepositoryImpl.loadRootNodeId(RepositoryImpl.java:429)
at org.apache.jackrabbit.core.RepositoryImpl.(RepositoryImpl.java:214)
at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:483)
at org.jboss.portal.cms.impl.jcr.jackrabbit.JackrabbitJCRService.start(JackrabbitJCRService.java:102)
at org.jboss.portal.cms.impl.jcr.JCRCMS.startJCR(JCRCMS.java:200)
at org.jboss.portal.cms.impl.jcr.JCRCMS.startService(JCRCMS.java:167)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:72)
at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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.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.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964504#3964504
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3964504
19 years, 9 months
[EJB 3.0] - Association Class mapping with composite primary key
by celsogbj
Hi,
I am having a problem trying to mapping an association class with EJB 3 on JBoss.
I have a class A with a many-to-many mapping with B and an association class C which has an attribute. I implemented using an one-to-many mapping with A and C and another one bettwen C and B. So far so good.
My problem is that table C has a composite primary key made of a_id and b_id. So, when I implemented C I had to mark the relationships (C with A, C with B) as the primary key (with a primary key class) which resulted on a ?C_PK has no persistent id property? when deployed in JBoss.
Is there any way to mapping this association class with the primary key being composed by the relationship? Is there any workaround (without using surrogated keys)? Does anybody has any code as example to post? I?ve already searched the achieves and haven?t found anything really helpful.
Thanks in advance,
Celso
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964503#3964503
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3964503
19 years, 9 months
[JBoss Portal] - Role Management portlet broke in 2.4.0CR3
by PeterJ
Everytime I attempt to use the Role Management portlet to edit the member of a role, I get an exception:
2006-08-10 16:13:36,734 ERROR [org.jboss.portal.core.portlet.role.RolePortlet] The portlet threw an exception
| javax.portlet.PortletException: Nothing to invoke
| at org.jboss.portlet.JBossPortlet.processView(JBossPortlet.java:231)
| at org.jboss.portlet.JBossPortlet.processDispatch(JBossPortlet.java:134)
| at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:109)
| at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:379)
| at org.jboss.portal.portlet.container.PortletContainer.invokeAction(PortletContainer.java:494)
| at org.jboss.portal.portlet.container.PortletContainer.dispatch(PortletContainer.java:435)
| at org.jboss.portal.portlet.container.PortletContainerInvoker$1.dispatch(PortletContainerInvoker.java:143)
| at org.jboss.portal.portlet.invocation.PortletInvocation.dispatch(PortletInvocation.java:242)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
| at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.org$jboss$portal$core$aspects$portlet$TransactionInterceptor$invokeRequired$aop(TransactionInterceptor.java:105)
| at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_N4020346540025535540.invokeNext(TransactionInterceptor$invokeRequired_N4020346540025535540.java)
| at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
| at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:201)
| at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_N4020346540025535540.invokeNext(TransactionInterceptor$invokeRequired_N4020346540025535540.java)
| at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.invokeRequired(TransactionInterceptor.java)
| at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.core.aspects.portlet.HeaderInterceptor.invoke(HeaderInterceptor.java:50)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.portlet.aspects.portlet.ProducerCacheInterceptor.invoke(ProducerCacheInterceptor.java:45)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.portlet.aspects.portlet.ModesInterceptor.invoke(ModesInterceptor.java:59)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.portlet.aspects.portlet.WindowStatesInterceptor.invoke(WindowStatesInterceptor.java:55)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.portlet.aspects.portlet.PortletSessionSynchronizationInterceptor.invoke(PortletSessionSynchronizationInterceptor.java:76)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.portlet.aspects.portlet.ContextDispatcherInterceptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:124)
| at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
| ....
| 2006-08-10 16:13:36,765 ERROR [org.jboss.portal.core.command.InvokeWindowActionCommand] An portlet exception occured in portlet RolePortletInstance
| javax.portlet.PortletException: Nothing to invoke
| at org.jboss.portlet.JBossPortlet.processView(JBossPortlet.java:231)
| at org.jboss.portlet.JBossPortlet.processDispatch(JBossPortlet.java:134)
| at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:109)
| at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:379)
| at org.jboss.portal.portlet.container.PortletContainer.invokeAction(PortletContainer.java:494)
| at org.jboss.portal.portlet.container.PortletContainer.dispatch(PortletContainer.java:435)
| at org.jboss.portal.portlet.container.PortletContainerInvoker$1.dispatch(PortletContainerInvoker.java:143)
| at org.jboss.portal.portlet.invocation.PortletInvocation.dispatch(PortletInvocation.java:242)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:140)
| at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.org$jboss$portal$core$aspects$portlet$TransactionInterceptor$invokeRequired$aop(TransactionInterceptor.java:105)
| at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_N4020346540025535540.invokeNext(TransactionInterceptor$invokeRequired_N4020346540025535540.java)
| at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
| at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:201)
| at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_N4020346540025535540.invokeNext(TransactionInterceptor$invokeRequired_N4020346540025535540.java)
| at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.invokeRequired(TransactionInterceptor.java)
| at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.core.aspects.portlet.HeaderInterceptor.invoke(HeaderInterceptor.java:50)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.portlet.aspects.portlet.ProducerCacheInterceptor.invoke(ProducerCacheInterceptor.java:45)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.portlet.aspects.portlet.ModesInterceptor.invoke(ModesInterceptor.java:59)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.portlet.aspects.portlet.WindowStatesInterceptor.invoke(WindowStatesInterceptor.java:55)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.portlet.aspects.portlet.PortletSessionSynchronizationInterceptor.invoke(PortletSessionSynchronizationInterceptor.java:76)
| at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:37)
| at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:130)
| at org.jboss.portal.portlet.aspects.portlet.ContextDispatcherInterceptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:124)
| at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
| .....
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964501#3964501
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3964501
19 years, 9 months
[JBoss Messaging] - Re: SQLException: Invalid column index in CR4
by davidrh
I have dropped all the tables and restarted JBoss and I am still having issues. Initially I have tried queuing up just over 2,000 messages. They are queued up OK, and appear to be in the JMS_MESSAGE table (the number of rows in the table agrees with the JMX console count of the messages). If I then stop enqueuing messages and shut JBoss down, I get the exception (I've cut the stack trace down):
09:03:44,346 FATAL [RegularObjectPersister] error
java.lang.reflect.InvocationTargetException
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:324)
at org.jboss.serial.persister.RegularObjectPersister.writeSlotWithMethod(RegularObjectPersister.java:120)
When I start JBoss back up again, I get:
09:11:03,993 ERROR [JDBCChannelMapper] Failed to load queue state
java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:379)
at org.jboss.resource.adapter.jdbc.WrappedResultSet.getString(WrappedResultSet.java:865)
at org.jboss.messaging.core.plugin.JDBCPersistenceManager.getReferenceInfos(JDBCPersistenceManager.java:1431)
at org.jboss.messaging.core.ChannelSupport.load(ChannelSupport.java:1273)
at org.jboss.messaging.core.ChannelSupport.load(ChannelSupport.java:500)
at org.jboss.jms.server.plugin.JDBCChannelMapper.deployCoreDestination(JDBCChannelMapper.java:297)
I think my original problem in my load test was caused when the queue exceeded its full size and had to start paging messages back in from the database. It looks like the statements for inserting and deleting messages from the database table are OK, but something is wrong when it is forced to select messages from the table. I'm assuming that the select only needs to happen on startup or when the number of messages is greater than the full size of the queue and messages have to be paged.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964500#3964500
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3964500
19 years, 9 months