lob

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? ...

WPF Best Practice for DataEntry Window

hi, 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) <Grid Margin="2,2,2,2"> <Grid.ColumnDefinitions> <ColumnDefinition Width="Auto"></ColumnDefinition> <Colu...

WPF UI Layout for LOB Applications

I have been trying to find some resource on this topic for a while now but to no avail so what is the best way to construct a WPF UI for LOB (Line of Business) applications? specifically Customers, Orders, Products, etc.. I have seen many single window WPF application examples that don't need to be anything else but a single window and i...

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 be: class MyType { // ... @Basic(fetch=FetchType.LAZY) @Lob public String getBlob() ...

LOBs in BerkeleyDB

Hi, what's the usual way to store a CLOB (a few 100KB) inside Berkeley DB? ...

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 average. The operation is also neither I/O nor CPU nor network bound judging from my observatio...

Spring MVC + Oracle LOBs + Streaming

Hi there, I have to send a binary stream of a blob by means of a ServletOutputStream. I'm using the following technologies and software: Oracle 11, WebSphere 7, Springframework 2.5.5, Hibernate 3.3.SP1. There are two Oracle databases. The first one contains tables for description of documents I have to transfer, and the second one - ...

Cross-DB LOB's in row or separate table?

Best Practices Are Not That said, about to undertake a schema with some LOBs and many folks have requested a separate table for LOB data. Most LOB data when working with Oracle exceeds 4k bytes and can be declared to be stored out-of-row. For a cross-DB availability, a good idea to simply put the LOB data out of row logically? ...