Tagged Questions

A BLOB is a collection of binary data stored as a single entity in a database management system.

learn more… | top users | synonyms

45
votes
4answers
6k views

Windows Azure Storage Certificate Expired

The certificate for our Azure blob storage expired today. This is not a certificate provided by us but provided by Microsoft as show in the picture below. How does one go about fixing this? I have ...
36
votes
4answers
18k views

proper hibernate annotation for byte[]

I have an application using hibernate 3.1 and JPA annotations. It has a few objects with byte[] attributes (1k - 200k in size). It uses the JPA @Lob annotation, and hibernate 3.1 can read these just ...
32
votes
6answers
10k views

Checking if a blob exists in Azure Storage

I've got a very simple question (I hope!) - I just want to find out if a blob (with a name I've defined) exists in a particular container. I'll be downloading it if it does exist, and if it doesn't ...
24
votes
8answers
16k views

Storing Documents as Blobs in a Database - Any disadvantages?

The requirements for my document management system were: Must be secure from theft by simple copying of directories, files etc. Must be secure against traditional virus infection (infection of ...
24
votes
8answers
23k views

Overcomplicated oracle jdbc BLOB handling

When I search the web for inserting BLOBs into Oracle database with jdbc thin driver, most of the webpages suggest a 3-step approach: insert empty_blob() value. select the row with for update. ...
23
votes
4answers
52k views

How do I get textual contents from BLOB in Oracle SQL

I am trying to see from an SQL console what is inside an Oracle BLOB. I know it contains a somewhat large body of text and I want to just see the text, but the following query only indicates that ...
23
votes
2answers
6k views

How to store images in your filesystem

Currently, I've got images (max. 6MB) stored as BLOB in a InnoDB table. As the size of the data is growing, the nightly backup is growing slower and slower hindering normal performance. So, the ...
21
votes
6answers
30k views

How to insert a blob into a database using sql server management studio

How can I easily insert a blob into a varbinary(MAX) field? for argument sake: assume the thing I want to insert is: c:\picture.png the table is mytable the column is mypictureblob and the place is ...
19
votes
5answers
5k views

How to persist LARGE BLOBs (>100MB) in Oracle using Hibernate

I'm struggling to find a way to insert LARGE images (>100MB, mostly TIFF format) in my Oracle database, using BLOB columns. I've searched thoroughly across the web and even in StackOverflow, without ...
16
votes
3answers
28k views

How do i store and retrieve a blob from sqlite

I have used sqlite in c++, python and now (perhaps) in C#. In all of these i have no idea how to insert a blob into a table. How do i store and retrieve a blob in sqlite?
16
votes
1answer
10k views

JPA, Mysql Blob returns data too long

I've got some byte[] fields in my entities, e.g.: @Entity public class ServicePicture implements Serializable { private static final long serialVersionUID = 2877629751219730559L; // seam-gen ...
16
votes
2answers
23k views

Text Field using Hibernate Annotation

I am having trouble setting the type of a String, it goes like public void setTextDesc(String textDesc) { this.textDesc = textDesc; } @Column(name="DESC") @Lob public String getTextDesc() { return ...
15
votes
4answers
24k views

how to store Image as blob in Sqlite & how to retrieve it?

I want to store an image(from url) into a sqlite database. For that I use: db = new DataBase(getApplicationContext()); URL url = new URL("http://sree.cc/wp-content/uploads/schogini_team.png"); ...
14
votes
14answers
8k views

To Do or Not to Do: Store Images in a Database [duplicate]

In the context of a web application, my old boss always said put a reference to an image in the database, not the image itself. I tend to agree that storing an url vs. the image itself in the DB is a ...
13
votes
6answers
12k views

Git - get all commits and blobs they created

Is there a git command that can output for every commit: id subject blobs it created with they path and size (like git ls-tree -l -r <commit> but only for created blobs)

1 2 3 4 5 … 119
15 30 50 per page