Thanks for good suggestion Eric, code modified to:
if (f2.length() < Integer.MAX_VALUE)
{
.. do insert
}
but my files are smaller than MAX_SIZE, e.g.
FileSize: 5629061 Integer.MAX_SIZE: 2147483647
and still setBinaryStream just goes to sleep. Nothing obvious in the postgres server log either.
-----Original Message-----
From: Éric Paré [mailto:paree@LEXUM.UMontreal.CA]
Sent: 27 November 2004 13:57
To: jonathan.lister@vaisala.com
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Is there a size limit on setBinaryStream?
Check to see if f2.length() is larger than Integer.MAX_SIZE with your
big file.
--
Éric Paré for/pour LexUM
Université de Montréal
Centre de recherche en droit public
C.P. 6128, succ. Centre-ville
Montréal (Qc) Canada H3C 3J7
+1 514-343-6111 #0873
paree@lexum.umontreal.ca