[firebird-support] Re: server version

2013-02-03 Thread hugo.larson
Hello Paul, Thanks for your answer. What I want to do is to determine server version from pure JDBC. I probably posted this question in the wrong group. Should have posted it in Firebird-Java group. BR, Hugo --- In firebird-support@yahoogroups.com, Paul Vinkenoog wrote: > > Hello Hugo, > >

[firebird-support] Re: INSERT ... RETURNING and updatable view

2013-02-03 Thread Dmitry Yemanov
02.02.2013 16:51, ettotev wrote: > > Yes, that works, but I consider it a workaround :) > The same thing happens for calculated and DEFAULT fields as well. FWIW, you have to live with that. It's unlikely to change in the foreseeable future. Dmitry

[firebird-support] Re: server version

2013-02-03 Thread petr.jicin
> Is there a way to determine which version of Firebird is running before > connection to a Database? > > I'm looking in org.firebirdsql.management but cant find anything fitting. > Or using Python and fdb library (python binding): import fdb svc = fdb.services.connect(password='yourFirebirdS

Re: [firebird-support] Re: server version

2013-02-03 Thread Wolfgang Kluge
Good morning Paul I am using Try Qry.Close; Qry.SQL.Text := 'select rdb$get_context(''SYSTEM'', ''ENGINE_VERSION'') cVer from rdb$database'; // fails on engine version < 2 Qry.ExecQuery; cEngineVer := Qry.FieldByName( 'cVer' ).AsString; Qry.Close; Ex

Re: [firebird-support] Re: server version

2013-02-03 Thread Paul Vinkenoog
Hi Wolfgang, > I am using > > Try > >Qry.Close; >Qry.SQL.Text := 'select rdb$get_context(''SYSTEM'', > ''ENGINE_VERSION'') cVer from rdb$database'; // fails on engine version < 2 >Qry.ExecQuery; >cEngineVer := Qry.FieldByName( 'cVer' ).AsString; >Qry.Cl

[firebird-support] Firebird 2.04

2013-02-03 Thread katvis007
Hi everyone We are using Firebird 2.04 Classic server at a client which has 40 databases and about 50 users accessing them. Every once in a while we need to restart Firebird on the server as the connections become very slow, as soon as it is restarted all is fine. It is Win2008 server, 64bit,

[firebird-support] Re: Firebird 2.04

2013-02-03 Thread karolbieniaszewski
--- In firebird-support@yahoogroups.com, "katvis007" wrote: > > Hi everyone > > We are using Firebird 2.04 Classic server at a client which has 40 databases > and about 50 users accessing them. Every once in a while we need to restart > Firebird on the server as the connections become very s

RE: [firebird-support] Re: Firebird 2.04

2013-02-03 Thread Heinrich Havenga
Sorry, never got a mail for the first answer or saw it being posted. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of karolbieniaszewski Sent: 04 February 2013 08:11 AM To: firebird-support@yahoogroups.com Subject: [firebird-support] Re: Firebird 2.0

RE: [firebird-support] Firebird 2.04

2013-02-03 Thread Svein Erling Tysvær
>Hi everyone > >We are using Firebird 2.04 Classic server at a client which has 40 databases >and about 50 users >accessing them. Every once in a while we need to restart >Firebird on the server as the >connections become very slow, as soon as it is >restarted all is fine. It is Win2008 server

[firebird-support] Re: INSERT ... RETURNING and updatable view

2013-02-03 Thread ettotev
--- In firebird-support@yahoogroups.com, Dmitry Yemanov wrote: > > 02.02.2013 16:51, ettotev wrote: > > > > Yes, that works, but I consider it a workaround :) > > The same thing happens for calculated and DEFAULT fields as well. > > FWIW, you have to live with that. It's unlikely to change in t

[firebird-support] Firebird and RAID

2013-02-03 Thread garethm
Hi, What factors do we need to be aware of relating to Firebird and RAID controllers? We have a customer using a Firebird 2.0.6 Classic Server database on a single disk connected to an IBM ServeRAID M5015 SAS/SATA Controller. The disk is not part of any RAID array. The server is running Window

Re: [firebird-support] Firebird and RAID

2013-02-03 Thread Dmitry Kuzmenko
Hello, garethm! Monday, February 4, 2013, 11:07:53 AM, you wrote: g> We have a customer using a Firebird 2.0.6 Classic Server database g> on a single disk connected to an IBM ServeRAID M5015 SAS/SATA Controller. The disk is g> not part of any RAID array. The server is running Windows 2008 R2 64-