On 2017-07-06 20:33, 'Steffen Heil (Mailinglisten)'
lists@... [Firebird-Java] wrote:

>> > How can I create a database with page size 16384 in jaybird?
>>
>> FBManager.setPageSize(int), this was added in Jaybird 3, see
>> https://www.firebirdsql.org/file/documentation/drivers_documentation/java/3.0.1/docs/org/firebirdsql/management/FBManager.h
>> tml#setPageSize-int-
>
> Is there any way to do it with jaybird 2 ?
> We are in the process of switching to firebird 3, but we want to stay
> with jaybird 2 for now, as we don't want to switch to another
> connection pool at the same time.

Jaybird 3 does not imply that you need to use Firebird 3, and the
reverse is only true if you want to use the new more secure
authentication model. Jaybird 3 supports Firebird 2 and higher (and
technically works fine with Firebird 1.0 and 1.5, it is just 'not
supported').

In any case, to get the same effect with Jaybird 2, you could subclass
FBManager or copy and modify the code and add the necessary info
yourself to createDatabase:
dpb.addArgument(ISCConstants.isc_dpb_page_size, <pagesize>), see
https://github.com/FirebirdSQL/jaybird/blob/Branch_2_2/src/main/org/firebirdsql/management/FBManager.java#L309

Note that copying the code might be simpler, because FBManager wasn't
really developed with subclassing in mind.

Mark