Questions tagged [lob]

Lob refers to a set of web services, APIs, and tools provided by the company of the same name. You can embed direct mail (postcards, letters, checks, etc.) functionality into web and mobile applications with just a few lines of code. There are several helper libraries and resources listed below to make it easy integrate.

Documentation & Resources

Libraries / Language Support

Examples are included in each wrapper and in the API Reference.

143 questions
0
votes
2 answers

Python LOB to List

Using: cur.execute(SQL) response= cur.fetchall() //response is a LOB object names = response[0][0].read() i have following SQL response as String names: 'Mike':'Mike' 'John':'John' 'Mike/B':'Mike/B' As you can see it comes formatted. It is…
Constantine
  • 193
  • 1
  • 3
  • 11
0
votes
1 answer

Are the entities with @Lob fields cacheable in Hibernate?

I use Hibernate and MySQL and I need to store the articles in database. The article entity has a field: @Lob @Basic(fetch=EAGER) @Column(name="CONTENT") private byte[] content; Is this entity cacheable in Hibernate?
0
votes
0 answers

Seeking Oracle SQL procedure to read a LONG datatype column from a file

I have built the following procedure to read data into a CLOB (see code example below). Now I would like to have the same functionality to do that for a LONG column. I know that LONGs are deprecated in ORACLE but for my particular case it is…
Krischu
  • 1,024
  • 2
  • 15
  • 35
0
votes
1 answer

ORA-3113 after updating CLOB

I am trying to get acquainted to using LOBs in Oracle (coming from RdB which should be migrated). I now face a problem when I try to make an update on an existing entry with a CLOB column named AN.BEMERKUNG: Code extract: OCIClobLocator *clob ; long…
0
votes
0 answers

eclipselink and weblogic12g CLOB ClassCastException

I have an application deployed in a Weblogic 12g, and a datasource configured against an oracle RAC. It uses as JPA provider; EclipseLink 2.4.1. The problem is this exception; Caused by: Exception [EclipseLink-3001] (Eclipse Persistence Services -…
0
votes
1 answer

When to use Securefile LOB deduplication and compression?

I have a table with BLOB column and SDO_GEOMETRY column (Spatial data). The BLOBs are stored as securefiles (Oracle 11g) I may be having quite a few repetitive columns of BLOB data. I am contemplating about adding compression or deduplication or…
Revan
  • 95
  • 1
  • 5
0
votes
2 answers

How do I get a sideload product key in order to deploy windows store app into Windows 8 pro and windows RT

I have 300 or more tablets I need to roll out my newly created metro style app to. I've done these steps but what is next: Go to the Visual Studio store menu Select Create app packages When prompted for whether the package is for the store…
Lyle
  • 419
  • 1
  • 6
  • 26
0
votes
1 answer

Is partitioning necessary for LOB columns?

My boss has a concern that creating LOB columns in our database tables could result in effectively permanent storage overhead if we do not partition the table and drop the partitions over time (as opposed to just deleting the records). He thinks…
thesquaregroot
  • 1,414
  • 1
  • 21
  • 35
0
votes
2 answers

Retrieve image stored in Oracle database as lob through PHP

I have to show an image which is stored in Oracle database as OCI-Lob Object. I have used following code: if(oci_fetch_array($rssqlclass,OCI_ASSOC | OCI_RETURN_LOBS)) { $a = oci_result($rssqlclass,"image"); } header('Content-type:…
Blue Rose
  • 523
  • 1
  • 3
  • 14
0
votes
0 answers

Win8 apps with certificate expired

one year ago we have deployed a windows 8 app signed by a test certificate to our customer,who installed this app after importing the .cer certificate on every involved tablet. Now this .cer certificate will expire in a few days. On test device we…
bargno
  • 1
0
votes
0 answers

How to save a big file to and read it from database with hibernate with low-memory usage?

I want to save some file content to database with hibernate, my model for hibernate is: import javax.persistence.*; import java.io.Serializable; import static javax.persistence.AccessType.FIELD; @Entity @Access(FIELD) @Table(name = "MYFILE") public…
Freewind
  • 193,756
  • 157
  • 432
  • 708
0
votes
1 answer

Accessing a Lob property from postgres in the view

I have a standard Spring Framework (v3.1.2) java (v1.6) database backed (postgres v9.1) web application, which runs on Apache Tomcat (v6.0). Please note that I am using Hibernate 3.6.10.Final and Spring Data JPA 1.2.0.RELEASE. I have two database…
Jazz
  • 307
  • 1
  • 2
  • 20
0
votes
1 answer

LOBs in BerkeleyDB

what's the usual way to store a CLOB (a few 100KB) inside Berkeley DB?
Buttercup
  • 2,007
  • 2
  • 15
  • 9
0
votes
1 answer

"invalid stream header" exception - Lob with JPA and MySQL

I have a field defined like this @MappedSupperclass public abstract class BaseItem { ... @Lob @Basic(fetch=FetchType.EAGER) private String description; ... } @Entity public class Item extends BaseItem { } I'm using MySQL 5 and…
Adrian Ber
  • 20,474
  • 12
  • 67
  • 117
0
votes
2 answers

Blob size limit when using HSQLDB from spring

I'm using HSQLDB for testing. The database is created from spring by scanning the models. One of the models is a message which contains an attachment (Thus resulting in a lob). When trying to save a message with an attachment it results in a :…
Daniel Carabott
  • 129
  • 2
  • 10
1 2 3
9
10