Stack Overflow
Stack Overflow

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
47
votes
2 answers

What is the difference between CLOB and NCLOB?

Can you state any difference between the CLOB and NCLOB?
Loga
  • 658
  • 1
  • 7
  • 17
31
votes
13 answers

Third party WPF controls: Devexpress vs Telerik

I would like to hear your opinion about the two control providers. To put it in a nutshell: I am building a classic LOB desktop application. The app will be created entirely in WPF. PRISM 4.0 will be used heavily. Whenever possible, I will try to…
Sebastjan
  • 142
  • 1
  • 5
  • 13
30
votes
1 answer

What is the point of dbms_lob.createtemporary()?

I don't quite get the point of the dbms_lob.createtemporary() function. How is: DECLARE myclob CLOB; BEGIN myclob := 'foo'; END; any different from: DECLARE myclob CLOB; BEGIN dbms_lob.createtemporary( myclob, TRUE ); myclob :=…
eaolson
  • 14,717
  • 7
  • 43
  • 58
29
votes
2 answers

How do I display the full content of LOB column in Oracle SQL*Plus?

When I try to display the contents of a LOB (large object) column in SQL*Plus, it is truncated. How do I display the whole thing?
Anonymoose
  • 5,662
  • 4
  • 33
  • 41
16
votes
4 answers

WPF Best Practice for DataEntry Window

i`m currently playing around with WPF and now i wonder what would be the layout for a typical dataentry window (20+ textboxes and stuff). atm i`m using a grid object like this (basic sample) …
marc.d
  • 3,804
  • 5
  • 31
  • 46
16
votes
4 answers

Lazily loading a clob in hibernate

There's a lot one can find about this googling a bit but I haven't quite found a workable solution to this problem. Basically what I have is a big CLOB on a particular class that I want to have loaded on demand. The naive way to do this would…
wds
  • 31,873
  • 11
  • 59
  • 84
10
votes
1 answer

Cannot store Euro-sign into LOB String property with Hibernate/PostgreSQL

I am having trouble writing and reading back special characters like the Euro-sign (€) into LOB String properties in PostgreSQL 8.4 with Hibernate 3.6.10. What I know is that PostgreSQL provides two distinct ways to store large character objects in…
Franck de Bruijn
  • 311
  • 1
  • 2
  • 11
10
votes
2 answers

How to drop Oracle LOB

The following query can be used to list the database objects of the user: select object_name, object_type from user_objects; There are couple of entries where the object_type is LOB. How can these LOB objects be dropped in Oracle?
byneri
  • 4,050
  • 5
  • 27
  • 28
9
votes
4 answers

Oracle CLOB performance

I am running queries against an Oracle 10g with JDBC (using the latest drivers and UCP as DataSource) in order to retrieve CLOBs (avg. 20k characters). However the performance seems to be pretty bad: the batch retrieval of 100 LOBs takes 4s in…
yawn
  • 8,014
  • 7
  • 29
  • 34
7
votes
2 answers

JBoss6 JPA: Entity with @Lob results in GenericJDBCException

I have a simple EntityBean with a @Lob annotation. If I delete this annotation I get no errors on JBossAS 6.0.0.Final and MySQL5. But if I annotate it with @Lob (because mt contains about 100 to 5000 characters in my case) I get errors in my testing…
Thor
  • 6,607
  • 13
  • 62
  • 96
7
votes
3 answers

Why do I get org.hibernate.HibernateException: IOException occurred reading a binary value

I found this exception in my logs I have never seen it before, Im using Hibernate 4.1.7 Does this indicate that my database is corrupted , or this a bug in Hibernate. I found a reference to this error at…
Paul Taylor
  • 13,411
  • 42
  • 184
  • 351
6
votes
1 answer

JPA @Lob property encoding not working with PostgreSQL text

JPA Mapping I'm Using JPA with Hibernate. I have an entity with a @Lob property @Column(nullable=false) @Lob private String text; I'm using PostgreSQL 8.4 and the Entity was correctly mapped with the column "text" text NOT NULL My view pages are…
Rafael Takashima
  • 111
  • 2
  • 4
6
votes
3 answers

Working with very large text data and CLOB column

According to documentation CLOB and NCLOB datatype columns, can store up to 8 terabytes of character data. I have text, which contains 100 000 character, how can I run query like this: UPDATE my_table SET clob_column = 'text, which contains 100…
Oto Shavadze
  • 40,603
  • 55
  • 152
  • 236
6
votes
1 answer

How to download huge Oracle LOB with cx_Oracle on memory constrained system?

I'm developing part of a system where processes are limited to about 350MB of RAM; we use cx_Oracle to download files from an external system for processing. The external system stores files as BLOBs, and we can grab them doing something like…
Chris Herborth
  • 293
  • 1
  • 3
  • 9
5
votes
1 answer

Hibernate4 & Lobhandler

According to this post i changed my session factory definition from
Hons
  • 3,804
  • 3
  • 32
  • 50
1
2 3
…
9 10