Subject | Re: another Proble with Embedded Server |
---|---|
Author | Jan Losinski |
Post date | 2004-04-25T16:50:05Z |
It works But A Querry like this:
SELECT meldungen.id id, vor_nam, fam_nam, geschl, geb_dat, akl.bez
akl_id, str, ort, plz, land.name land_id, verein.name verein_id,
email, bemerk FROM meldungen, akl, land, verein WHERE
meldungen.akl_id = akl.id AND land_id = land.id AND verein_id =
verein.id ORDER BY meldungen.id
wouldnt be executed. There is no error or Exception, it only return
at this point without any Result or Message!
Why is this so?? And: WHY IS THERE NO DOCUMENTATION???
Is it SO difficult to write a little Documentation or make 1 or two
working examples public?
I love Firebird, I use it with Delphi, Java and sometimes PHP But
there is less support!
--- In Firebird-Java@yahoogroups.com, "ebender1985"
<jan.losinski@g...> wrote:
SELECT meldungen.id id, vor_nam, fam_nam, geschl, geb_dat, akl.bez
akl_id, str, ort, plz, land.name land_id, verein.name verein_id,
email, bemerk FROM meldungen, akl, land, verein WHERE
meldungen.akl_id = akl.id AND land_id = land.id AND verein_id =
verein.id ORDER BY meldungen.id
wouldnt be executed. There is no error or Exception, it only return
at this point without any Result or Message!
Why is this so?? And: WHY IS THERE NO DOCUMENTATION???
Is it SO difficult to write a little Documentation or make 1 or two
working examples public?
I love Firebird, I use it with Delphi, Java and sometimes PHP But
there is less support!
--- In Firebird-Java@yahoogroups.com, "ebender1985"
<jan.losinski@g...> wrote:
> I have Fixed it, but I don't know why it is so:jdbc:firebirdsql:embedded:\projekte$\FIREBIRD\DATABASES\WINDBERG_MANA
> I have changed the URL from
>
> GER.GDBjdbc:firebirdsql:embedded:localhost:C:\\FIREBIRD\\DATABASES\\WINDBERG
> to
>
> _MANAGER.GDBjdbc:firebirdsql:embedded:C:/Firebird/Databases/WINDBERG_MANAGER.GDB
> and id runs.
> Why I must set localhost?
> The explanation from nagypapi was:
> > url to your database to the following
> > "jdbc:firebirdsql:embedded:drive:/path/to/database"
> > egsample: "jdbc:firebirdsql:embedded:c:/data/sexyboy.gdb"
>
> Thanks
>
> --- In Firebird-Java@yahoogroups.com, "ebender1985"
> <jan.losinski@g...> wrote:
> > In delpoymental reasons I cant Change the Databade-Dir. The
> > Application is running from an Net-Drive which is names projekte$
> > (projekte$\WindbergManager\).
> >
> > --- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
> > <rrokytskyy@a...> wrote:
> > > --- In Firebird-Java@yahoogroups.com, "ebender1985"
> > > <jan.losinski@g...> wrote:
> > > > Hello
> > > >
> > > > I have a Problem with my Embedded Server.
> > > > I get the following Exception:
> > > >
> > > > org.firebirdsql.jdbc.FBSQLException: Resource Exception. I/O
> > error
> > > > during "CreateFile (open)" operation for
> > > > file "\projekte$\FIREBIRD\DATABASES\WINDBERG_MANAGER.GDB"
> > > > Error while trying to open file
> > > > null
> > > > Reason: I/O error during "CreateFile (open)" operation for
> > > > file "\projekte$\FIREBIRD\DATABASES\WINDBERG_MANAGER.GDB"
> > > > Error while trying to open file
> > > > ....
> > > > General It seems as an simple File-Not-Found error or else,
> but
> > my
> > > > Firebird-URL is:
> > > >
> >
>
> > > > and NOTjdbc:firebirdsql:embedded:\projekte$\FIREBIRD\DATABASES\WINDBERG_MANA
> > > >
> >
>
> > > > GER.GDB
> > > >
> > > > what can the reason be?
> > >
> > > Can you try to put database in some other directory and change
> the
> > > URL, to see if projekte$ will not appear somewhere. I cannot
> > imagine
> > > how this can happen...
> > >
> > > Thanks!
> > > Roman