How to catch exceptions from Firebird database?

  • Thread starter Thread starter Jarkki
  • Start date Start date
J

Jarkki

Hi!

I use Visual studio 2005 beta 2, and the latest Firebird database with
the latest .NET 2.0 drivers for the Firebird.

In my development setup, I have a remote server(localhost) that I
connect to with a test client(through remoting). This server acts like
an application server. For example, it retrieves data from database and
returns objects to the client.
I have two executables in my solution, the server and the test client.
I start both simultaneously, the client starts with no debugging and
waits 3 seconds before calling the server. When the remote call from
the client arrives to the server, I can debug the server with no
problems.

The problem:
I can open the connection to the database, and execute query
succesfully, but when using more complicated query(I think there is
something wrong in the query), the command.ExecuteReader() just hangs,
the debugger doesn't jump to the catch part and Visual Studio Hangs
until I close the command-line windows.

Could someone tell me how can I debug the events in the Firebird
database and catch the exceptions?


Thanks in advance, Jarkki
 
Uzytkownik "Jarkki said:
Hi!

I use Visual studio 2005 beta 2, and the latest Firebird database with
the latest .NET 2.0 drivers for the Firebird.
Click to expand...

The question would be better addressed onto the firebird .NET provider
group:
----
Firebird-net-provider mailing list
(e-mail address removed)
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
----

However I might be able to point you in the right direction here.
The problem:
I can open the connection to the database, and execute query
succesfully, but when using more complicated query(I think there is
something wrong in the query), the command.ExecuteReader() just hangs,
Click to expand...
Post the query, that goes succesfully and the 'complicated' one that hangs
the debugger doesn't jump to the catch part and Visual Studio Hangs
until I close the command-line windows.

Could someone tell me how can I debug the events in the Firebird
database and catch the exceptions?
Click to expand...
There are two cases here:
Either you mean Firebird Exceptions (those would fire the catch part in VS),
and to debug them you need some kind of database ide (IBExpert for example)
Or you mean the events posted by firbierd engine - there you need to setup
event catching mechanism, examples are here:
http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=examples#3

But as you say most probably it is the query problem, in that case most
insight could be gained here:
http://groups.yahoo.com/group/firebird-support/
Thanks in advance, Jarkki
Click to expand...
HTH,
CUIN Kaczy
 
Back
Top