[ http://jira.jboss.com/jira/browse/EJBTHREE-136?page=comments#action_12316863 ] Heiko W. Rupp commented on EJBTHREE-136: ----------------------------------------
Blobs generally suck in Oracle. You might try a ojdbc14.jar from a 10g installation. Sometimes this helps. > Blob Example don't work with Oracle9.2.0.6.0 > -------------------------------------------- > > Key: EJBTHREE-136 > URL: http://jira.jboss.com/jira/browse/EJBTHREE-136 > Project: EJB 3.0 > Type: Bug > Versions: Preview 5 > Reporter: ouafaa choufane > > > 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] [EMAIL > PROTECTED], [EMAIL PROTECTED], 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) -- 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 - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_ide95&alloc_id396&op=click _______________________________________________ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development
