Thread: JDBC and blobs
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello All, Does anyone know of any problems with the JDBC driver that could cause this error? After about 490is inserts of blobs, this error appears and will not allow me to insert any more with out shutting down the app server and restarting it. Thanks. Regards, Stephen, [PartBean] java.rmi.ServerException: Store failed; nested exception is: [PartBean] InputStream as parameter not supported [PartBean] InputStream as parameter not supported [PartBean] at org.postgresql.jdbc2.PreparedStatement.setBinaryStream(PreparedStatement.java:474) [PartBean] at org.opentools.minerva.jdbc.PreparedStatementInPool.setBinaryStream(PreparedStatementInPool.java:252) [PartBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java:326) [PartBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.setParameters(JDBCStoreEntityCommand.java:134) [PartBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159) [PartBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:97) [PartBean] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.storeEntity(JAWSPersistenceManager.java:156) [PartBean] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:401) [PartBean] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronization.beforeCompletion(EntitySynchronizationInterceptor.java:342) [PartBean] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228) [PartBean] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322) [PartBean] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) [PartBean] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:318) [PartBean] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) [PartBean] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:190) [PartBean] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) [PartBean] at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:323) [PartBean] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:392) [PartBean] at java.lang.reflect.Method.invoke(Native Method) [PartBean] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) [PartBean] at sun.rmi.transport.Transport$1.run(Transport.java:142) [PartBean] at java.security.AccessController.doPrivileged(Native Method) [PartBean] at sun.rmi.transport.Transport.serviceCall(Transport.java:139) [PartBean] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443) [PartBean] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643) [PartBean] at java.lang.Thread.run(Thread.java:484) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE7aUv/Pmm0AnNwb5MRAqTLAKCK0L5AriMREf4+8cn0TydkeVmkHgCcCRc5 1wi5VthDnQ0wNCr+L1dQUzY= =ApZK -----END PGP SIGNATURE-----
Please get newer driver from http://jdbc.fastcrypt.com -- Start of PGP signed section. > Hello All, > > Does anyone know of any problems with the JDBC driver that could cause this > error? After about 490is inserts of blobs, this error appears and will not > allow me to insert any more with out shutting down the app server and > restarting it. > > Thanks. > > Regards, > > Stephen, > > > > [PartBean] java.rmi.ServerException: Store failed; nested exception is: > [PartBean] InputStream as parameter not supported > [PartBean] InputStream as parameter not supported > [PartBean] at > org.postgresql.jdbc2.PreparedStatement.setBinaryStream(PreparedStatement.java:474) > [PartBean] at > org.opentools.minerva.jdbc.PreparedStatementInPool.setBinaryStream(PreparedStatementInPool.java:252) > [PartBean] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java:326) > [PartBean] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.setParameters(JDBCStoreEntityCommand.java:134) > [PartBean] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159) > [PartBean] at > org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:97) > [PartBean] at > org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.storeEntity(JAWSPersistenceManager.java:156) > [PartBean] at > org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:401) > [PartBean] at > org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronization.beforeCompletion(EntitySynchronizationInterceptor.java:342) > [PartBean] at > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228) > [PartBean] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322) > [PartBean] at > org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) > [PartBean] at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:318) > [PartBean] at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) > [PartBean] at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:190) > [PartBean] at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) > [PartBean] at > org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:323) > [PartBean] at > org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:392) > [PartBean] at java.lang.reflect.Method.invoke(Native Method) > [PartBean] at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) > [PartBean] at sun.rmi.transport.Transport$1.run(Transport.java:142) > [PartBean] at java.security.AccessController.doPrivileged(Native Method) > [PartBean] at sun.rmi.transport.Transport.serviceCall(Transport.java:139) > [PartBean] at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443) > [PartBean] at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643) > [PartBean] at java.lang.Thread.run(Thread.java:484) -- End of PGP signed section. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Thanks Guys, I cracked this problem. It is NOT a problem with the driver, or db. It is the programmer (ie ME). The drive had ran out of space and I got this error. I gave it more space and all is well again. Regards, Stephen. On Thursday 02 Aug 2001 11:09 pm, Bruce Momjian wrote: > Please get newer driver from > > http://jdbc.fastcrypt.com > > -- Start of PGP signed section. > > > Hello All, > > > > Does anyone know of any problems with the JDBC driver that could cause > > this error? After about 490is inserts of blobs, this error appears and > > will not allow me to insert any more with out shutting down the app > > server and restarting it. > > > > Thanks. > > > > Regards, > > > > Stephen, > > > > > > > > [PartBean] java.rmi.ServerException: Store failed; nested exception is: > > [PartBean] InputStream as parameter not supported > > [PartBean] InputStream as parameter not supported > > [PartBean] at > > org.postgresql.jdbc2.PreparedStatement.setBinaryStream(PreparedStatement. > >java:474) [PartBean] at > > org.opentools.minerva.jdbc.PreparedStatementInPool.setBinaryStream(Prepar > >edStatementInPool.java:252) [PartBean] at > > org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java > >:326) [PartBean] at > > org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.setParameters(JDBC > >StoreEntityCommand.java:134) [PartBean] at > > org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java: > >159) [PartBean] at > > org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreE > >ntityCommand.java:97) [PartBean] at > > org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.storeEntity(JAWSPersist > >enceManager.java:156) [PartBean] at > > org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceMan > >ager.java:401) [PartBean] at > > org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchroniz > >ation.beforeCompletion(EntitySynchronizationInterceptor.java:342) > > [PartBean] at > > org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228) > > [PartBean] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322) > > [PartBean] at > > org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) > > [PartBean] at > > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorC > >MT.java:318) [PartBean] at > > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) > > [PartBean] at > > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java > >:190) [PartBean] at > > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) > > [PartBean] at > > org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:323) > > [PartBean] at > > org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContain > >erInvoker.java:392) [PartBean] at > > java.lang.reflect.Method.invoke(Native Method) [PartBean] at > > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) > > [PartBean] at sun.rmi.transport.Transport$1.run(Transport.java:142) > > [PartBean] at java.security.AccessController.doPrivileged(Native > > Method) [PartBean] at > > sun.rmi.transport.Transport.serviceCall(Transport.java:139) [PartBean] > > at > > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443) > > [PartBean] at > > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.jav > >a:643) [PartBean] at java.lang.Thread.run(Thread.java:484) > > -- End of PGP signed section. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE7aejjPmm0AnNwb5MRAkUmAJ9U+RpRMMU+D4GYlZkU/9/JoBPC4QCfQlqp 8OrNKHQW76d9iLy7+YFCOLU= =3d/s -----END PGP SIGNATURE-----