I was wondering if anyone had any working sample code of inserting a blob
into a table and then retrieving one from a table for viewing?
I'm using Postgres 8.2, the jdbc is postgresql-8.2-504.jdbc3, and the Java
is 1.6.
I'm also running on a Windows XP Pro box if that matters.
Thanks,
Marc
Marc Horvath, 14.03.2008 12:35:
I was wondering if anyone had any working sample code of inserting a
blob into a table and then retrieving one from a table for viewing?
I’m using Postgres 8.2, the jdbc is postgresql-8.2-504.jdbc3, and the
Java is 1.6.
I’m also running on a Windows XP Pro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/17/07 23:16, Merlin Moncure wrote:
On 8/18/07, Ron Olson [EMAIL PROTECTED] wrote:
The language is Java. I've made some tests and they work very well for 25meg
filesworks exactly the way it should, first time. MySQL had all kinds of
nasty
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/17/07 23:16, Merlin Moncure wrote:
On 8/18/07, Ron Olson [EMAIL PROTECTED] wrote:
The language is Java. I've made some tests and they work very well for 25meg
filesworks exactly the way it should, first time. MySQL had
On Wednesday 2007-08-15 05:52, Gregory Stark wrote:
Ron Olson [EMAIL PROTECTED] writes:
Hi all-
I am evaluating databases for use in a large project that will hold image
data as blobs. I know, everybody says to just store pointers to files on
the disk...
Well not everyone. I usually
On 8/15/07, Ron Olson [EMAIL PROTECTED] wrote:
Hi all-
I am evaluating databases for use in a large project that will hold image
data as blobs. I know, everybody says to just store pointers to files on the
disk...can't do it here...the images are of a confidential nature and access
to the
The language is Java. I've made some tests and they work very well for 25meg
filesworks exactly the way it should, first time. MySQL had all kinds of
nasty surprises for me when I first started working with blobs, but I can
say that I took my code, changed the driver, and it all works like a
On 8/18/07, Ron Olson [EMAIL PROTECTED] wrote:
The language is Java. I've made some tests and they work very well for 25meg
filesworks exactly the way it should, first time. MySQL had all kinds of
nasty surprises for me when I first started working with blobs, but I can
say that I took my
Ron Olson [EMAIL PROTECTED] writes:
Hi all-
I am evaluating databases for use in a large project that will hold image
data as blobs. I know, everybody says to just store pointers to files on the
disk...
Well not everyone. I usually do, but if you're not handling these blobs under
heavy load
Hi all-
I am evaluating databases for use in a large project that will hold image
data as blobs. I know, everybody says to just store pointers to files on the
disk...can't do it here...the images are of a confidential nature and access
to the database (and resulting client app) will be highly
So turning to Postgresql, can I get any recommendations, suggestions and
tips on blob handling in the database? The image sizes will be pretty
variable, from a few kilobytes to several hundred megabytes, so I need
something that will handle the various file sizes, hopefully transparently.
On Jul 4, 2007, at 11:34 , Cesar Alvarez wrote:
is there a way to store pictures or executables in postgres??
From the PostgreSQL FAQ
4.10) What is the difference between the various character types?
http://www.postgresql.org/docs/faqs.FAQ.html#item4.10
From the PostgreSQL Documentation
hello every one
is there a way to store pictures or executables in postgres??
Cesar Alvarez.
begin:vcard
fn:Cesar Alvarez
n:;Cesar Alvarez
title:Web Development Asesor and Software Enginner
version:2.1
end:vcard
---(end of broadcast)---
TIP 6:
On 04/07/2007 17:34, Cesar Alvarez wrote:
is there a way to store pictures or executables in postgres??
http://www.postgresql.org/docs/8.2/static/datatype-binary.html
---
Raymond O'Donnell, Director of Music, Galway Cathedral,
Thanx for ur suggestion... But I face a new problem
now...
connection.setAutoCommit works well with postgresql
7.3 .. but with postgresql 7.4 I am getting the
error...
Error in connection == ERROR: SET AUTOCOMMIT TO OFF
is no longer supported
I have tried pg73jdbc1.jar and pg73jdbc3.jar .. both
Thanks a lot for the clue... Now I am comfortably
handling the Lrge Objects thru SQL...
But unfortunately I could not extract this data to
frontend thru java... I tried in two ways but got the
same error...after getting the data in Blob or Large
Object.
Error in connection == FastPath call
On Sat, 20 Dec 2003, [iso-8859-1] Nilabhra Banerjee wrote:
But unfortunately I could not extract this data to
frontend thru java... I tried in two ways but got the
same error...after getting the data in Blob or Large
Object.
Error in connection == FastPath call returned ERROR:
invalid
[EMAIL PROTECTED] says...
That's a good discussion, but it left out at least one useful bit of
info about managing large objects: there's a contrib utility
(contrib/vacuumlo) that can find and remove large objects that are not
referenced anywhere in the database.
What is the URL for the
On Thu, 2 Oct 2003, Tom Lane wrote:
Howard Lowndes [EMAIL PROTECTED] writes:
On Wed, 1 Oct 2003, Tom Lane wrote:
No, because pg_restore has logic to adjust the references to match the
new BLOB OIDs. If you have a test case where this fails to work, let's
see it ...
No, I don't have
Howard Lowndes [EMAIL PROTECTED] writes:
OK, I'm convinced, except for one small, but not insignificant hiccup.
When you dump a database with the BLOBs, even with the -c option, and then
restore that database again with the -c option, you get double the BLOBs.
The original BLOBs are there
On 2 Oct 2003, Doug McNaught wrote:
Howard Lowndes [EMAIL PROTECTED] writes:
OK, I'm convinced, except for one small, but not insignificant hiccup.
When you dump a database with the BLOBs, even with the -c option, and then
restore that database again with the -c option, you get double
My situation is that I am interacting PHP 4.1.2 to PostgreSQL 7.2.2
I have no difficulty inserting and managing BLOBs into the Large Object
system table, and I have a user table called images which maintains the
relationship between the BLOB loid and the identity that relates to it in
my user
On Wed, 1 Oct 2003, Joshua D. Drake wrote:
Hello,
We usually have a table called something like file_objects that
contains information like the loid, content-type, filesize etc...
that we reference.
Yes, that's what I also have got:
test= \d images
Table images
Howard Lowndes [EMAIL PROTECTED] writes:
Now, my concern is that if I use pg_dump with the --clean or --create, and
the --blobs options, and then try a pg_restore from the resulting archive
file, I believe the BLOBs will take up a different loid to the one they
came from, and hence the
On Wed, 1 Oct 2003, Tom Lane wrote:
Howard Lowndes [EMAIL PROTECTED] writes:
Now, my concern is that if I use pg_dump with the --clean or --create, and
the --blobs options, and then try a pg_restore from the resulting archive
file, I believe the BLOBs will take up a different loid to the
Howard Lowndes [EMAIL PROTECTED] writes:
On Wed, 1 Oct 2003, Tom Lane wrote:
No, because pg_restore has logic to adjust the references to match the
new BLOB OIDs. If you have a test case where this fails to work, let's
see it ...
No, I don't have any example, it is an enquiry. What I am
Any examples available, please?
On all of creating, insertion, updateing, setting it to null?
From: Alex Pilosov [EMAIL PROTECTED]
To: Richard Church [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Blobs in PostgreSQL
Date: Wed, 27 Jun 2001 08:43:33 -0400 (EDT)
SQL syntax
Hi,
In june, I had to migrate a web site using paradox tables on a winNT to
a Linux box. I had chosen first postgresql 7.0 for its solid-based
features.
But unfortunately, when I started to migrate my tables, a problem raised
: the implementation of blobs in Postgre. My tables stored lots of
I recently ran into a big problems regarding blobs and rollback with postgreSQL 6.5.3
A table contains many entries and each entry includes a single
blob-oid. In a databaseprocessing perlscript I need to delete such a
blob and perform the lo_unlink and later I rollback the session without
29 matches
Mail list logo