Subject Re: Using FbStatisticsManager to getHeaderPage() will not timeout
Author jon.reckner
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:
>
> > 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
verify
> > the database is online before attempting to get its headerPage to
> > avoid asking for the header when teh database is offline.
> >
> > What is the best way to verify the database is online? I am
hoping I
> > dont need to make a full connection to determine this.
>
> At the moment there is no such possibility and I am not sure that
it
> exists at all. If you're able to connect to the database with your
user
> name and password, then all functions should be available,
otherwise you
> get the connection exception with error code
ISCConstants.isc_shutdown.
>
> I will check why the service manager from Jaybird hangs, while gsec
is
> able to tell this correctly...
>
> Roman
>