Subject | How to set database page size in embedded mode? |
---|---|
Author | Alec Lebedev |
Post date | 2009-08-17T02:00:03Z |
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]
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]