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
