Hello, sorry, but I'm able to start a user trace session (=service attachment) without the trigger firing.
I'm using Thomas' FB TraceManager. This might be an intended feature. Is it? > On 02/27/12 18:19, Björn Reimer wrote: >> Hello, >> should a trigger like the following on fb 2.5.(2 snapshot) fire when >> attaching via service api? It does not in my tests. >> SET TERM ^ ; >> CREATE OR ALTER TRIGGER DB_BI0 >> ACTIVE ON CONNECT POSITION 0 >> AS >> begin >> if (upper(current_role) = 'NONE') then >> EXCEPTION PARAMINVALID 'Please use a role...'; >> end >> ^ >> SET TERM ; ^ >> Why? >> I can imagine that there might be problems because of the context (No >> transaction ...) but such tests like above should work, don't they? > Works for me: > fbs2 bin # ./gbak -z -se service_mgr -b employee e.bak > gbak:gbak version LI-V2.5.2.26422 Firebird 2.5 > gbak: ERROR:exception 8 > gbak: ERROR: PARAMINVALID > gbak: ERROR: Please use a role... > gbak: ERROR: At trigger 'DB_BI0' line: 5, col: 37 > gbak:Exiting before completion due to errors > fbs2 bin # > ------------------------------------------------------------------------------ > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Björn Reimer - RRZE ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel