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