Subject | Re: Using FbStatisticsManager to getHeaderPage() will not timeout |
---|---|
Author | jon.reckner |
Post date | 2008-07-31T14:28:06Z |
Yes this is a windows environment. :(
I am using Spring and jdbcTemplate to manage my Firebird connections
anyway so for now I am going to try and query a known system table
for the current time or something and catch the DataAccessException
if this is not available, from that I will assume the database is at
least online before trying to query the headerpage. Its not perfect
by any means but should give me another layer of protection until we
know why it hangs.
--- In Firebird-Java@yahoogroups.com, Roman Rokytskyy <roman@...>
wrote:
I am using Spring and jdbcTemplate to manage my Firebird connections
anyway so for now I am going to try and query a known system table
for the current time or something and catch the DataAccessException
if this is not available, from that I will assume the database is at
least online before trying to query the headerpage. Its not perfect
by any means but should give me another layer of protection until we
know why it hangs.
--- In Firebird-Java@yahoogroups.com, Roman Rokytskyy <roman@...>
wrote:
>verify
> > gsec version WI-V2.0.3.12981 Firebird 2.0
> > Cannot attach to services manager
> > unable to open database
>
> Is it non-Windows platform? What is the command line?
>
> > I suppose I could change my design here a bit and attempt to
> > the database is online before attempting to get its headerPage tohoping I
> > avoid asking for the header when teh database is offline.
> >
> > What is the best way to verify the database is online? I am
> > dont need to make a full connection to determine this.it
>
> At the moment there is no such possibility and I am not sure that
> exists at all. If you're able to connect to the database with youruser
> name and password, then all functions should be available,otherwise you
> get the connection exception with error codeISCConstants.isc_shutdown.
>is
> I will check why the service manager from Jaybird hangs, while gsec
> able to tell this correctly...
>
> Roman
>