Re: [JDBC] blobs in a client/server environment

2001-09-27 Thread Pete Jewell
Matt Fair [EMAIL PROTECTED] writes: Hello, I have been playing around with storing images with setBinaryStream and getBinaryStream for a couple of days now, but I am continually running into a problem. I don't know if I am getting the data in the right format or not, but I am not able to

Re: [JDBC] Re. conection error

2001-09-27 Thread Nick Fankhauser
Hi Russ- The first line in my pg_hba.conf file is: local alltrust I don't think this line authorizes TCP/IP socket connections, but rather, only Unix sockets. Since JDBC uses TCP/IP even if you are on the same machine, you'll need a similar auth record

[JDBC] Fix for broken JDBC's getColumn() (take 2)

2001-09-27 Thread Vianen, Jeroen van
Hi, What's the status of this patch I sent two weeks ago? I got no reply last week for the same question. My original mail can be found at http://fts.postgresql.org/db/mw/msg.html?mid=1034457 Thanks, Jeroen -Original Message- From: Jeroen van Vianen [mailto:[EMAIL PROTECTED]]

Re: [JDBC] blobs in a client/server environment

2001-09-27 Thread Matt Fair
Hello, I did set the encoding to UNICODE and it still does not show the blob image. My error from the JIMI library is the following: Error getting remote image: Cannot find encoder for type: png com.sun.jimi.core.JimiException: Cannot find encoder for type: png at

Re: [JDBC] blobs in a client/server environment

2001-09-27 Thread Matt Fair
Does anyone know if it is nessesary to have objects stored into the database encoded as unicode that you had to compile the database with the following opions: --enable-unicode-conversion --enable-multibyte Thanks, Matt Matt Fair wrote: Hello, I did set the encoding to UNICODE and it

Re: [JDBC] Help: OutOfMemoryError

2001-09-27 Thread Barry Lind
Since you are doing a select * without any where clause, postgres is going to return the entire table back to the client all at once. The client then needs to store the entire result in memory, thus you will need enough memory to hold the entire table in memory. A better way to do this in

Re: [JDBC] [PATCHES] Fix for broken JDBC's getColumn() (take 2)

2001-09-27 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. Hi, Per the recent discussion there's been some code changes in JDBC's DatabaseMetaData.getColumn(). I proposed a