I am trying to use a @Lob column with a Java String type to map its content to TEXT inside Postgres. Here is the relevant entity: @Entity(name="metadata") public class Metadata { @Id @G...

Can you state any difference between the CLOB and NCLOB?

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

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

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

Using NHibernate 3.1 with both SQL Server and Oracle DBs, we need to store a text string that is longer than 4000 characters. The text is actually XML, but that is not important - we just want to t...

I need to get the smallest element in a std::map. I'm aware that there is plenty of documentation available; however, I can't seem to get any to work. I have two maps, bid and ask, both of which a...

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

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

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

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

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

Entity class: public class CustomerSurvey implements Serializable { @Id @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="CUSTOMER_SURVEY_SEQUENCE") @Column(name = "SURVEYID", nulla...

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

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

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?

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

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) &lt...