Subject Re: [Firebird-Java] Setting database page size
Author Alec Swan
Catalin, thank you for this great suggestion.
Dmitry, are you saying that I can execute CREATE DATABASE using just a jdbc
connection to the server and not the database? How would I specify where to
create the database file given that CREATE DATABASE statement does not take
it as a parameter?

Thanks,

Alec

On Wed, Aug 19, 2009 at 12:06 AM, Catalin Florean <catalin.florean@...
> wrote:

>
>
> Maybe you can use another approach, use a small dummy backup file as a
> template and use Jaybird (2.x) to restore it setting the number of
> pages and their size.
>
> Catalin.
>
>
> On Wed, Aug 19, 2009 at 5:24 AM, Dmitry
> Yemanov<dimitr@... <dimitr%40users.sourceforge.net>>
> wrote:
> >
> >
> > Mark Rotteveel wrote:
> >
> >> I don't think so. To execute a statement, you need a connection, for a
> >> connection you need an existing database (or you need to go low-level
> >> with Jaybird).
> >
> > CREATE DATABASE is an exception here, it should be executed with a NULL
> > connection handle (at the API level).
> >
> >> I am not even sure if CREATE DATABASE is available as DSQL
> >
> > It is. The question is whether Jaybird supports it directly.
> >
> > Dmitry
> >
> >
>
>
>


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