| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues |
| Date: | 2012-01-08 18:50:12 |
| Message-ID: | jecofg$jia$1@dough.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
Stefan Keller wrote on 08.01.2012 19:13:
>> I think you are better off using bytea unless you need to access only parts
>> of the blob regularly.
>
> That's a valid tip. But it's to the current JDBC implementation to
> take action because it currently leads to disk space leakage when
> using JDBC and JPA/Hibernate.
But only if you use large objects.
From my perspective bytea is the (only) data type that matches the JDBC BLOB type.
And none of the problems you have occur when using bytea.
There is no match for PG's large objects in the JDBC API so I don't see your claim that it's a fault of the driver.
What's the reason for you to stick with LargeObjects?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Keller | 2012-01-08 19:35:04 | Re: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues |
| Previous Message | Stefan Keller | 2012-01-08 18:13:07 | Re: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Keller | 2012-01-08 19:35:04 | Re: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues |
| Previous Message | Stefan Keller | 2012-01-08 18:13:07 | Re: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues |