Subject Re: [Firebird-Java] How to reate a database with different PAGE_SIZE on-the-fly
Author Helen Borrie
At 04:06 PM 10/05/2007, RR wrote:

>For those who might know something:
>For some reason FB ignores page size that is passed in DPB while
>creating a database via isc_create_database call and so far I was not
>able to do isc_dsql_exec_immediate without database attachment... How
>does isql do this?

You must make sure you send isc_detach_database() calls for all
databases your app is currently connected to. This should set the
database handle[s] to null. Perhaps your driver is somehow retaining
database handles?

Once the database handle you want to use is NULL, you can call
isc_dsql_immediate() or isc_dsql_immed2() with your CREATE DATABASE
string in parameter 5 (including the PAGE_SIZE attribute). If the
operation succeeds, you will be connected to the new database and its
handle will no longer be null.