Thread: JDBC and blobs

JDBC and blobs

From
"Stephen J. Thompson"
Date:
-----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-----

Re: JDBC and blobs

From
Bruce Momjian
Date:
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

Re: JDBC and blobs

From
"Stephen J. Thompson"
Date:
-----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-----