Re: [JDBC] Re: What needs to be done?

2001-08-02 Thread Ricardo Maia
So how whould I map the BLOB java type in the corresponding SQL type? I want to create a table with a BLOB attribute, but I want that my code can run for PostgreSQL, Oracle and other BD that handles BLOBs. So first I had to map the BLOB in the corresponding BD SQL type and then create the ta

Re: [JDBC] Re: What needs to be done?

2001-08-02 Thread Anders Bengtsson
On Thu, 2 Aug 2001, Barry Lind wrote: > There are actually a couple of reasons why the jdbc driver can't do this: > > 1) The client doesn't know that the column being deleted is a blob. All > it can know is that the data type of the column is oid. Oids can be > used for many reasons, one of whi

Re: [JDBC] Re: What needs to be done?

2001-08-02 Thread Bruce Momjian
> I actually consider the biggest problem the fact the the 'official' > postgres jdbc website is very much out of date > (http://jdbc.postgresql.org). (it doesn't even have the 7.1 drivers). > I feel that either someone needs to maintain this page; or someone needs > to create a new website a

Re: [JDBC] Re: What needs to be done?

2001-08-02 Thread Anders Bengtsson
On Wed, 1 Aug 2001, Barry Lind wrote: > Anders, > > What aspects of BLOB support do you consider broken? Are these aspects > that are broken in the JDBC layer or are 'broken' at the server layer? Now I've looked at the code and located the problem: The method setBinaryStream(...) in PreparedSt

Re: [JDBC] JDBC and blobs

2001-08-02 Thread Stephen J. Thompson
-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

[JDBC] errors while getting large objects...

2001-08-02 Thread chris markiewicz
hello. my application uses large objects frequently...to render the main page, it might load anywhere from zero to 10 large objects - mostly images or documents. recently i started stress testing this page (making it always load many LOs) and i frequently encounter two different problems. 1. fa

Re: [JDBC] JDBC and blobs

2001-08-02 Thread Bruce Momjian
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 mo

Re: [JDBC] Re: What needs to be done?

2001-08-02 Thread Bruce Momjian
Would someone summarize what items need to be added to the TODO list. > Ricardo, > > There are many other issues with postgres blobs that will not allow you > to acheive your goal easily. You are going to need different > implementations per database type to deal with the differences between

Re: [JDBC] Re: What needs to be done?

2001-08-02 Thread Tom Lane
Barry Lind <[EMAIL PROTECTED]> writes: > This is what I think needs to be done wrt large objects and binary data > support ... > [ much snipped ] > As you can probably guess I don't like the current implementation of > large objects in postgresql Yup, I got that ;-). While these seem like good

[JDBC] Re: Memory Leak / Prepared Statement

2001-08-02 Thread Barry Lind
My guess is that this is unlikely to be the result of the ThreadLocal issues and also I doubt 1.4 will have any effect. This sounds like a memory leak which could be in the driver or in your application code. I also doubt that the use of LIKE is the problem as the JDBC code doesn't parse the