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
1
vote
1 answer

how to compress text and image files using hibernate?

what mechanisms one can use to compress following ? Since I am using multiple databases I want it to be under the hood like how hibernate handle using Dialects. @Lob @Type(type = "org.hibernate.type.TextType") private String data; or…
Njax3SmmM2x2a0Zf7Hpd
  • 1,354
  • 4
  • 22
  • 44
1
vote
0 answers

LOB storage parameter query

This is for Oracle 11 I created a table by running a script like this: CREATE TABLE "SYSTEM"."Table12" ( "Column1" CLOB ) PCTFREE 0 PCTUSED 0 LOGGING NOCOMPRESS LOB("Column1") STORE AS (TABLESPACE "TEMP" STORAGE (INITIAL 65537) ENABLE STORAGE IN…
1
vote
0 answers

Why loading model which has a byte array field by hibernate gets null value?

A pojo for hibernate, which has a Lob field, and it's type is byte[]: import javax.persistence.*; import java.io.Serializable; import static javax.persistence.AccessType.FIELD; @Entity @Access(FIELD) @Table(name = "MYFILE") public class MyFile…
Freewind
  • 193,756
  • 157
  • 432
  • 708
1
vote
1 answer

JPA - How to select rows from a table but the BLOB types lazy?

I am using JPA hibernate, wicket, weblogic, and oracle 11. I have a Table, which has 8 columns, and one of them is a BLOB type. I store big XLS files in this BLOB. I am querying only 10 rows, but it takes a lot of time, I guess because of the big…
victorio
  • 6,224
  • 24
  • 77
  • 113
1
vote
1 answer

How to convert jpeg to PDF/A?

I want to convert jpeg file to PDF/A, because lob.com requires PDF/A format. https://www.lob.com/docs#prepping I use imagemagick for converting this, and is this PDF/A formatted file? $ pdfinfo ~/Desktop/foo.pdf Title: foo Producer: …
Matt - sanemat
  • 5,418
  • 8
  • 37
  • 41
1
vote
1 answer

CLOB storage Oracle 11g

I have a encountered very strange behavior of Oracle LOB. Situation: We have partitioned IOT that contains CLOB column. CLOB has separate LOB storage set up with LOGGING RETENTION and DISABLE IN ROW STORAGE options. CHUNK size is 8192bytes. PCTFREE…
Mike Nagy
  • 137
  • 1
  • 11
1
vote
0 answers

ORA-24811:While writing into a LOB, less data was provided than indicated

When ever I run my Pro*C code which insert a large buffer to table using CLOB. ORA-24811:While writing into a LOB, less data was provided than indicated. code is below OCIClobLocator *lob; ... EXEC SQL insert into TAB (MSG,STATUS ,ERROR_DESC…
1
vote
0 answers

ServiceStack, Silverlight, LOB. Interface & Service Impl. Assemblies - Best Practice

I am bit confused about the service contract definitions in ServiceStack. As mentioned here https://github.com/ServiceStack/ServiceStack/wiki/SilverlightServiceClient its possible to use a Portable Class Library or Linked Projects. (Ok, PCL has the…
MVCible
  • 391
  • 3
  • 14
1
vote
1 answer

Oracle 11g temporary lob not freeable

I´m using Oracle 11gR2, can someone tell me why the temporary lob isn´t freed? ... -- Apply stylesheet to DOM document outdomdocf := dbms_xslprocessor.processxsl(proc, xsl, indomdoc); outnode := dbms_xmldom.makenode(outdomdocf); …
chris
  • 600
  • 7
  • 21
1
vote
2 answers

Spring JDBC lob insertion fails: Invalid column type

The code: jdbcTemplate.update("MERGE INTO app_role_data x USING (select ? name, ? xml FROM dual) d ON (x.app_name = d.name) WHEN MATCHED THEN UPDATE SET x.xml_blob = d.xml WHEN NOT MATCHED THEN INSERT(app_name, xml_blob)…
nsayer
  • 16,925
  • 3
  • 33
  • 51
0
votes
2 answers

Retrieving a set of primitive types from a database using hibernate

I am using an informix database and I have two tables; instance and contact. Contact table has the following fields; contact_id, fname and lname. Instance table has the following fields, instance_id, name and contact_ids(contact_ids is an informix…
0
votes
1 answer

Is Umbraco suitable for a LOB application?

I wonder if Umbraco 5, which is based on MVC, is appropriate for a Line of Business application, mainly to handle extensibility. Would it be a good ideia to use Umbraco as a base, and create modules to be installed on it? Does Umbraco use MEF for…
pvieira
  • 1,687
  • 6
  • 17
  • 32
0
votes
2 answers

How to structure a LOB application/database for offline mode

I have a line of business application that constantly communicates to the database. I have a user that wants to operate multiple sites at remote locations all connected back to a central database. This setup is working but due to unreliable network…
Rex Bloom
  • 364
  • 4
  • 14
0
votes
0 answers

how to access data in a postgres database table that uses lob

just as the title says, im not sure how i should access info from a table that has a data column as oid. im trying to store info consumed through kafka (using spring boot) into a postgres database and the only option i have right now is using @lob,…
0
votes
1 answer

ORA-22992: cannot use LOB locators selected from remote tables even without using BLOB column

I have table which has one BLOB datatype column and i am using this table via dblink to insert into my schema table. But i dont use this BLOB datatype column in my insert query at all still i am getting error : ORA-22992: cannot use LOB locators…
Andrew
  • 3,632
  • 24
  • 64
  • 113