Hi,
Iam Using Hibernate 3 and PostgreSQL 8.1 as backend.
I have written a class in java in which i have declared
public String PhaseDescription = "";

The above line will create a feild in the Database table.
It is creating a feild of length 255 only.
How do i declare the below given declaration to create a feild of 500000 characters
public String PhaseDescription = new String();


Here is my class
@Entity(access = AccessType.FIELD)
@Table(name = "Phase")
public class Phase {

@Id
public String PhaseID = "";

public String PhaseName = "";

public String PhaseCode = "";

public String PhaseDescription = new String();

public String EntryCriteria = "";

public String ExitCriteria = "";

}

Please help me

Are you using mapping files or annotations? Not sure how to do it using annotations, but the mapping file version isYou might be able to use a varchar, but I doubt it, I don't think any DB server allows that much space for one in-row field. You could also use type="text", I think that's equivalent to a clob, can't say for sure, though.

Note that there are all sorts of special rules for dealing with lobs, and things like them. You'll have to read up on that in your DB documentations, but basically it's because the data aren't stored directly in the row with the other values, they're stored elsewhere, and the row just contains a pointer to the data.