[RADIATOR] Session database sql statement query

[Alex Sharaz]

Hi,
Thanks for replying
Solved the problem by have a session database statement and a
postprocessinghook perl subroutine.

long term I'm going to set up a stored procedure to do my session database
processing .. if i can find some reasonable examples :-) I'm doing that sort
of thing for all my java stuff at the moment anyway.
Alex


-----Original Message-----
From: Claudio Lapidus [mailto:clapidus at gmail.com] 
Sent: 22 August 2008 14:04
To: Hugh Irvine
Cc: Alex Sharaz; radiator at open.com.au
Subject: Re: [RADIATOR] Session database sql statement query

Hello Alex

>> When I receive a stop record I want to
>> a). Delete the record in my online table
>> b). Insert the final set of accounting details as found in the accounting
>> stop record into another database table.
>>
>
> To do this you should probably use one or more AuthBy SQL clauses with one
> or more AcctSQLStatements.

Another possibility (depending on your DB capabilities) would be to
have a trigger in your online table that intercepts DELETEs and copies
the record's content into the new table. This way you don't need to
modify your Radiator config and you secure your data inside a single
DB transaction, eliminating the possibility of data getting lost "in
transit" (i.e. if the delete succeeds but the subsequent insert
fails).

hth,
cl.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5438 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20080822/926a990d/attachment.bin>