Subject | Re: [Firebird-Java] Setting database page size |
---|---|
Author | Alec Swan |
Post date | 2009-08-20T15:05:17Z |
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@...
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:[Non-text portions of this message have been removed]
>
>
> 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
> >
> >
>
>
>