Subject | Creating a database with a predefined page size |
---|---|
Author | Steffen Heil (Mailinglisten) |
Post date | 2017-07-06T09:08:09Z |
Hi
I want to do the following in Java:
CREATE DATABASE 'filename.fdb'
USER 'SYSDBA' PASSWORD 'password'
PAGE_SIZE 16384
DEFAULT CHARACTER SET UTF8;
I got so far:
FBManager manager = new FBManager();
manager.setDialect( 3 );
manager.setServer("127.0.0.1" );
manager.setPort( 3050 );
manager.start();
manager.createDatabase( "filename.fdb", "SYSDBA", "password" );
manager.stop();
So I created a database. Then I need to commit one of the following statements, depending on the firebird version:
UPDATE RDB$DATABASE SET RDB$CHARACTER_SET_NAME='UTF8';
ALTER DATABASE SET DEFAULT CHARACTER SET UTF8;
But I did not find any way to set the PAGE_SIZE, which as I understand needs to be set during creation.
How can I create a database with page size 16384 in jaybird?
Best regards,
Steffen
[Non-text portions of this message have been removed]
I want to do the following in Java:
CREATE DATABASE 'filename.fdb'
USER 'SYSDBA' PASSWORD 'password'
PAGE_SIZE 16384
DEFAULT CHARACTER SET UTF8;
I got so far:
FBManager manager = new FBManager();
manager.setDialect( 3 );
manager.setServer("127.0.0.1" );
manager.setPort( 3050 );
manager.start();
manager.createDatabase( "filename.fdb", "SYSDBA", "password" );
manager.stop();
So I created a database. Then I need to commit one of the following statements, depending on the firebird version:
UPDATE RDB$DATABASE SET RDB$CHARACTER_SET_NAME='UTF8';
ALTER DATABASE SET DEFAULT CHARACTER SET UTF8;
But I did not find any way to set the PAGE_SIZE, which as I understand needs to be set during creation.
How can I create a database with page size 16384 in jaybird?
Best regards,
Steffen
[Non-text portions of this message have been removed]