On Thu, 9 Aug 2001 14:58:13 +1000, Heather wrote:
[delete Lob when no longer referenced]
>Shouldn't the JDBC driver fix up things like that though?
Its not an interface issue. You'll see exactly the same
behaviour using the interfaces for C/C++, Perl, Python etc.
This is not something an interf
Hi,
I am retrieving value of
"oid" field using "getBlob(columnName)" method of ResultSet .
It is working fine if that field contains some
"oid" reference . But if the field contains
NULL , then it is throwing following error
.
"FastPath call returned
ERROR: inv_open: large obje
Hello Barry,
Thanks a lot. I've incorporated your items
on http://lab.applinet.nl/postgresql-jdbc/
I'll also incorporate your postings from last week about bytea,
large objects and such.
Regards,
René Pijlman
On Wed, 08 Aug 2001 20:56:05 -0700, you wrote:
>Rene,
>
>First off, thank you for pul
Hi René Pijlman,
Thank you for your mail. Sorry for the delayed reply .
I am giving the details about my application .
> the CREATE TABLE statement used to create this particular
>table (or a description of the table from psql)
CREATE TABLE mytable (sno integer UNIQUE, image_id
Hi Barry,
Thank you for the mail.
In my application Blobs will not get deleted ever .
However "oid" references in first table will get deleted . But the same
"oid"s will be inserted and they will exist
in second table permanently.So as per your suggestion I can delete oids
from firs
Hello Ravi,
Thank you for the clarification. The best way to handle this
would be with the JDBC methods getArray and setArray.
Unfortunately, these methods are currently not implemented in
the JDBC driver. See also
http://lab.applinet.nl/postgresql-jdbc/ ("Array").
Regards,
René Pijlman
On Thu,
Hi,
I could not mention my
question clearly in my previous post.
My question is,
Will
rs.getInt("someBlobColumn") always return 0 when oid type column contains NULL
?
Ravi
- Original Message -
From:
RaviShankar K
To: [EMAIL PROTECTED]
Sent:
Todays impossible question =:-D
I really need an ARRAY but I am stuck with JDBC 1.0.
the table looks like this
festival| filmid
--
1979| 102, 103, 104
1980| 258, 369, 489, 568
ad nauseum
How can I simulate an ARRAY of thi
On Thu, 09 Aug 2001 12:07:41 +0200, you wrote:
>Surprising ! I deleted the errors.fr file and now the error diseaperead !
Hmmm... what happens when you replace the content of errors_fr
with the content of errors?
There are some funny SOH bytes in errors_fr: 0x01 and that's
pretty close to 0x00 :
This is typical. Until you do a vacuum the old versions of a row are
still in the db, so an update has to do an index query on an index to
get to the row that needs indexing, which returns a lot of pointers to
old entries, that then have to be tranversed until the valid one in
found. Then th
Using the jdbc 7.1.2 drivers:
Exception in thread "main" java.lang.NullPointerException
at org.postgresql.jdbc2.ResultSet.next(ResultSet.java:116)
that line is:
if (++current_row >= rows.size())
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targab
Joseph,
Can you post some code to reproduce the error please?
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Joseph Shraibman
Sent: August 9, 2001 9:27 PM
To: [EMAIL PROTECTED]
Subject: [JDBC] NullPointerException on next()
Using the jdbc 7.1.2
Check that you didn't close the statement before making this
call to next() in the ResultSet object.
Tom.
On Thu, Aug 09, 2001 at 09:34:51PM -0400, Dave Cramer wrote:
> Joseph,
>
> Can you post some code to reproduce the error please?
>
> Dave
>
> -Original Message-
> From: [EMAIL PRO
13 matches
Mail list logo
