datatypes in Derby embedded database

[Dave Mere]

Hi there,

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:

CREATE TABLE livcoll.alpine_data (alp_key INT, tax_name VARCHAR(255), com_name VARCHAR(255), appearance TEXT)

stack trace:

ERROR 42X01: Syntax error: Encountered "" at line 1, column 105.

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,

Dave

[Dave Mere]

Got it. The closest equivalent in Derby is the CLOB datatype.