Subject How to set database page size in embedded mode?
Author Alec Lebedev
I am migrating my project to Firebird 2.1.6 which runs in an embedded mode. I receive the following exception when trying to create an index on a large table column, such as VARCHAR(2048).

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544351. unsuccessful metadata update
key size exceeds implementation restriction for index "IDX_1250473636589"

From the documentation I understood that the maximum size of an index key is 1/4 of the database page size. However, I cannot figure out how to set the page size when running in embedded mode? Here is my code:

// start embedded Firebird server
FBManager manager = new FBManager("EMBEDDED");
manager.start();
manager.setForceCreate(true);
manager.createDatabase(databaseDbFile.getAbsolutePath(), "", "");

Thanks,

Alec

[Non-text portions of this message have been removed]