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

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 "recursiv

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] 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 generate

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 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
> > >> 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

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
> So UDFs should not raise exceptions. Period. The bug is in it, not in > Firebird. May be i don't explain well, i know the bug is in the UDF, but an exception not catched in my app, would not restart my computer. > > If your UDF instead write some bytes in random memory places, it will be > e

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 tes

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

2011-12-04 Thread Dimitry Sibiryakov
04.12.2011 16:17, Jesus Garcia wrote: > If you think that one simple thing like this must take down one database > engine, i do not agree What makes you think that "this thing" is a simple one? Have you ever learned how exceptions work "inside"? It's time to start to. PS: Can we make UDF to

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 09:53, Jesus Garcia wrote: > >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

[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 em

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

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.

[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 cru