5 Replies Latest reply on Aug 19, 2006 12:42 PM by Mitch De Felice

    jboss-portal-2.4.0-CR3-bundled does work with Oracle 9i

    Mitch De Felice Newbie

      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)