I'm developing a java system that is to read from a Derby embedded database, which will generate from a central Sybase database. I'm currently writing the code to create and populate this database. Some of the data fields in the central db are of the TEXT datatype (cos the data is 300-400 character length), and Derby seems to react poorly to this.
create table command:
Does anyone know if it is the TEXT datatype that is the problem here? Is there is an equivalent of TEXT n Derby? If not . . . any suggestions?
Many thanks in advance,
Joined: Oct 25, 2004
Got it. The closest equivalent in Derby is the CLOB datatype.