[Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Jesus Garcia
Hello all, i wrote time ago this item in the firebird-support list, but vlad suggest to write it in the devel list. The question is that doing some test, i use one udf function in one dll that raises an exception that the function did not catch. When that exception raised, the firebird engine

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Dimitry Sibiryakov
04.12.2011 10:28, Jesus Garcia wrote: why instead crush the engine when an exception is raised, the engine would catch it and write in the log the error? How??? How the engine catch an alien exception? Could you show the method working in MSVC and GCC? -- SY, SD.

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Jesus Garcia
How??? How the engine catch an alien exception? Could you show the method working in MSVC and GCC? I don,t know how and if is possible, There must be a point in firebird where a call to an udf in a dll is executed, and i don't know if is possible to catch an exception that is raised in

[Firebird-devel] CORE-3671 access violation in fbembed when connection isn't closed on exit

2011-12-04 Thread Mark Rotteveel
CORE-3671 describes a JVM access violation which occurs when a Java application using Firebird embedded exits when a connection hasn't been closed. The solution / workaround is of course to close() the connection from Java. I am however uncertain if this could be indicative of a problem in

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Jesus Garcia
The engine does what is possible and tries to catch the 'alien exception'. You must do your part and write a correct UDF, testing them before in non-production environment. Adriano I know it, and is not me, is firebird. I try To test everything, but nothing is perfect. One simple

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Adriano dos Santos Fernandes
On 04-12-2011 13:17, Jesus Garcia wrote: The engine does what is possible and tries to catch the 'alien exception'. You must do your part and write a correct UDF, testing them before in non-production environment. Adriano I know it, and is not me, is firebird. I try To test everything,

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Dimitry Sibiryakov
04.12.2011 17:26, Jesus Garcia wrote: an exception not catched in my app, would not restart my computer. But it will make OS to close your application harshly. Exactly as it is done with Firebird. -- SY, SD.

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Jesus Garcia
an exception not catched in my app, would not restart my computer. But it will make OS to close your application harshly. Exactly as it is done with Firebird. -- My example was not a good example, i knew it Just after pressing send button. But what i don't understand is that i

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Dimitry Sibiryakov
04.12.2011 17:51, Jesus Garcia wrote: but i Only have had responses like learn more, learn to write udf, etc Because every programmer know that exceptions can hardly pass boundaries of DLL. Now it is time for you to learn it too. -- SY, SD.

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Jesus Garcia
Because every programmer know that exceptions can hardly pass boundaries of DLL. Now it is time for you to learn it too. Thank you very much for the lesson, but you say can hardly not can't. Sorry for the post and for waste your valuable time with me. Jesus

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Dimitry Sibiryakov
04.12.2011 18:07, Jesus Garcia wrote: you say can hardly not can't. Right. But I'm not going to describe how many stars must have right positions to allow that. -- SY, SD. -- All the data continuously

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Jesus Garcia
Right. But I'm not going to describe how many stars must have right positions to allow that. Thank you again for the lesson, i did never link the positions of thr stars with programming, but i'll take it into account the next time. Jesus

Re: [Firebird-devel] Fb3: Window functions in recursive CTEs - endless recursion ?

2011-12-04 Thread Adriano dos Santos Fernandes
On 30-11-2011 23:36, Adriano dos Santos Fernandes wrote: On 16-11-2011 22:39, Frank Ingermann wrote: Hi all, i'm trying to combine the new Window functions in Fb3 with recursive CTEs to get a _defined_ ordering of the recursive child records in the result set. The recursive problem is

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-04 Thread Geoff Worboys
First off to say that I fully agree that a UDF must not let exceptions escape. I have no issue with that. Claudio says in the v2.1.4 release notes: Since UDFs have no formal mechanism to signal errors, the returned value would have to be used as an indicator. I was wondering if anyone had had