Skellywag

Wednesday, April 26, 2006

Don't call us, we'll call you

Useful info on DB change notification over at Oracle. A bunch of .NET classes wraps it all up nicely, so that you just implement an event handler and pull the details out of the event args. The DB itself (Oracle Database 10g Release 2) determines when to notify the client based on the SQL statement used at registration time: cunning.

Am not sure their example .NET code is so hot though; it's peppered with

  cmd.Dispose();
  con.Dispose();
calls, which are usually unnecessary if the class is well-implemented. I'd prefer to see explicit calls to resource-releasing methods, and the whole thing wrapped in try..finally. </rant>


0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home