Uploaded image for project: 'EJB 3.0'
  1. EJB 3.0
  2. EJBTHREE-136

Blob Example don't work with Oracle9.2.0.6.0

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • EJB 3.0 Beta 1
    • Preview 5
    • None
    • None

    Description

      The blob example in EJB3 Preview5 don't work with Oracle9.2.0.6.0.

      Here the error message:

      2005-04-12 13:25:34,426 DEBUG [org.jboss.remoting.transport.socket.ServerThread] WAKEUP in SERVER THREAD
      2005-04-12 13:25:34,426 DEBUG [org.jboss.remoting.transport.socket.ServerThread] beginning dorun
      2005-04-12 13:25:34,466 DEBUG [org.jboss.ejb3.entity.HibernateSessionFactory] GETTING NEW HIBERNATE SESSION
      2005-04-12 13:25:34,466 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4560097830772736
      2005-04-12 13:25:34,466 DEBUG [org.hibernate.impl.SessionImpl] setting flush mode to: COMMIT
      2005-04-12 13:25:34,466 DEBUG [org.hibernate.event.def.DefaultSaveOrUpdateEventListener] saving transient instance
      2005-04-12 13:25:34,466 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 5)
      2005-04-12 13:25:34,466 DEBUG [org.hibernate.jdbc.AbstractBatcher] opening JDBC connection
      2005-04-12 13:25:34,516 DEBUG [org.hibernate.jdbc.JDBCContext] successfully registered Synchronization
      2005-04-12 13:25:34,516 DEBUG [org.hibernate.SQL] select hibernate_sequence.nextval from dual
      2005-04-12 13:25:34,516 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.id.SequenceGenerator] Sequence identifier generated: 2930
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 6)
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] generated identifier: 2930, using strategy: org.hibernate.id.SequenceGenerator
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] saving org.jboss.tutorial.blob.bean.BlobEntity#2930
      2005-04-12 13:25:34,526 DEBUG [org.jboss.ejb3.entity.HibernateSessionFactory] ************** flushing.....
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] flushing session
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushing entities and processing referenced collections
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Processing unreferenced collections
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Scheduling collection removes/(re)creates/updates
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 1 insertions, 0 updates, 0 deletions to 1 objects
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.pretty.Printer] listing entities:
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.pretty.Printer] org.jboss.tutorial.blob.bean.BlobEntity

      {blobby=org.hibernate.lob.SerializableBlob@163b102, clobby=org.hibernate.lob.SerializableClob@1fa19ca, id=2930}

      2005-04-12 13:25:34,526 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] executing flush
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.persister.entity.BasicEntityPersister] Inserting entity: org.jboss.tutorial.blob.bean.BlobEntity#2930
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 5)
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.SQL] insert into BlobEntity (blobby, clobby, id) values (?, ?, ?)
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.persister.entity.BasicEntityPersister] Dehydrating entity: org.jboss.tutorial.blob.bean.BlobEntity#2930
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.type.LongType] binding '2930' to parameter: 3
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.jdbc.AbstractBatcher] Adding to batch
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 6)
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement
      2005-04-12 13:25:34,526 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not insert: [org.jboss.tutorial.blob.bean.BlobEntity] [insert into BlobEntity (blobby, clobby, id) values (?, ?, ?)]
      java.sql.SQLException: opération interdite: streams type cannot be used in batching
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3775)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.addBatch(WrappedPreparedStatement.java:333)
      at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:29)
      at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1858)
      at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2205)
      at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
      at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:678)
      at org.jboss.ejb3.entity.HibernateSessionFactory$SessionSynchronization.beforeCompletion(HibernateSessionFactory.java:84)
      at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1384)
      at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1076)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
      at org.jboss.aspects.tx.TxSupport.endTransaction(TxSupport.java:215)
      at org.jboss.aspects.tx.TxSupport.invokeInOurTx(TxSupport.java:153)
      at org.jboss.aspects.tx.TxSupport$Required.serverInvoke(TxSupport.java:438)
      at org.jboss.aspects.tx.TxInterceptor.internalInvoke(TxInterceptor.java:112)
      at org.jboss.aspects.tx.TxInterceptor.invoke(TxInterceptor.java:60)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:66)
      at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:72)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:66)
      at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:36)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:66)
      at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:80)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:66)
      at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:90)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:66)
      at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:165)
      at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:107)
      at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:74)
      at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:325)
      at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:201)
      at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:259)
      at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:313)
      at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:147)
      2005-04-12 13:25:34,526 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 17090, SQLState: null
      2005-04-12 13:25:34,536 ERROR [org.hibernate.util.JDBCExceptionReporter] opération interdite: streams type cannot be used in batching
      2005-04-12 13:25:34,536 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
      org.hibernate.exception.GenericJDBCException: could not insert: [org.jboss.tutorial.blob.bean.BlobEntity]
      at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
      at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1874)
      at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2205)
      at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
      at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
      at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:678)
      at org.jboss.ejb3.entity.HibernateSessionFactory$SessionSynchronization.beforeCompletion(HibernateSessionFactory.java:84)
      at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1384)
      at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1076)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
      at org.jboss.aspects.tx.TxSupport.endTransaction(TxSupport.java:215)
      at org.jboss.aspects.tx.TxSupport.invokeInOurTx(TxSupport.java:153)
      at org.jboss.aspects.tx.TxSupport$Required.serverInvoke(TxSupport.java:438)
      at org.jboss.aspects.tx.TxInterceptor.internalInvoke(TxInterceptor.java:112)
      at org.jboss.aspects.tx.TxInterceptor.invoke(TxInterceptor.java:60)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:66)
      at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:72)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:66)
      at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:36)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:66)
      at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:80)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:66)
      at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:90)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:66)
      at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:165)
      at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:107)
      at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:74)
      at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:325)
      at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:201)
      at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:259)
      at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:313)
      at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:147)
      Caused by: java.sql.SQLException: opération interdite: streams type cannot be used in batching
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:3775)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.addBatch(WrappedPreparedStatement.java:333)
      at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:29)
      at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1858)
      ... 34 more
      2005-04-12 13:25:34,856 DEBUG [org.jboss.ejb3.entity.HibernateSessionFactory] ************** closing hibernate session **************
      2005-04-12 13:25:34,856 DEBUG [org.hibernate.impl.SessionImpl] closing session
      2005-04-12 13:25:34,856 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing JDBC connection (open PreparedStatements: 0, globally: 5) (open ResultSets: 0, globally: 0)

      Attachments

        Activity

          People

            Unassigned Unassigned
            oc.star.be ouafaa choufane (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: