generic trigger Q&&A

Q3: explain the important term “trigger-event”, in relation to “trigger-action”

Q: can a trigger-event invoke both a before-action and an after-action?
A: yes

Q: can a trigger-action be defined with select-statements alone? Does it make sense?

Q: can a trigger-action call stored programs?
A: yes

Q8: Beside before-action and after-action, what other trigger-actions are supported?
A8: for-each-row-action is NOT a third type. Both mysql and oracle let you combine BEFORE and for-each-row

Q: what if a DML where-clause matches no record? Will a before-action run? How about an after-action?

A3: an insert on a table, a delete on a table, or an update OF one or more columns ON a table. In some databases(which?), a call to a stored procedure also qualifies as a trigger event

Advertisements

facade: loose coupling && fewer dependencies

One j4 facade — loose coupling and fewer “dependencies”.

Without a facade, a client object may need 5 instance variables to access 5 “services” either hosted in the same or hosted in a different JVM [2]
– logger “service”
– authentication service
– authorization service
– status-check service
– connection-pool or dataSource
– transaction manager
– sessionFactory’s static “services”
– StudentDAOFactory, ProfessorDAOFactory….

Basic OO principle lets each subject expert author (and maintain) her object, and require all client objects to get a reference [1] (a dependency) to her object.

[1] either static field or instance field
[2] perhaps through JNDI lookup

JVM mem leak detector basics + force GC

Some JVM profilers like JProbe can “force” GC daemon to wake up and run. We know that A regular java method can’t “force” GC daemon thread to wake up and run. But a JVM profiler is not written in java.

jconsole can invoke GC on the target JVM. It’s on the Memory tab, and also in Mbeans -> java.lang->Memory->operations

I think JProbe uses JVM Tool Interface (aka JVM Profiler Interface) to do that? Probably. See
http://java.sun.com/j2se/1.5.0/docs/guide/jvmti/jvmti.html#ForceGarbageCollection. The profiler runs in the same process as the JVM,
sharing the address space and have access to all the jvm variables, GC, threads..

Many memory leak detectors work by counting instances for each class and detect growth over time. The assumption — instance count for any class should rise and fall, not rise and rise. IMHO, This is the #1 fundamental assumption in memory leak detectors.

In general, if a system is supposed to generate increasing “live” objects then it will crash sooner or later. However, if under normal load the increase is slow enough relative to the lifespan between VM restarts, then it’s tolerable but still, such a design remains worrisome and questionable for a robust server-side engine.

load factor ]%%lang

When elements exceed 75%[3] of the “existing-buckets”[1] , the hashmap must grow [2]. System doesn’t care if any bucket is shared[4] by multiple elements

Q: What if load factor is too high like 0.99, and we *allow* the hash to become very very full?
A: somehow performance is likely to suffer

Q: what if load factor is set too low, like 0.52?
%%A: I think you get too frequent rehashing(?) and you always have 48% unused memory space(?)

Q: is a bucket similar to a chain in separate-chaining?

[1] current capacity
[2] How it grows is less important now. buzzwords: rehash, double,
[3] default load factor of a “new HashMap()”
[4]due to hash collision.

x++ vs ++x

echo ++$x means “increment first, then evaluate” => returns the modified value
echo $x++ means “evaluate, increment last” => returns the unmodified value

Applies to Java, PHP, Perl and any language.

Many (including experienced) programmers are fuzzy about the difference. It’s best to do

x++; if (x….) instead of if(++x …)

tiles — 4 types of resources

To quickly get a TR on any tiles application like http://www.javaworld.com/javaworld/jw-09-2002/jw-0913-designpatterns.html, at a glance you need to identify 4 types of “resources”

1) component-jsp files like header.jsp
2) template files
3) definitions contained in tiles-defs.xml
4) user-jsp files ie any jsp files using the trio.

So now you know tiles are not that simple — the simplest demo needs at least 4 types of files.

To better understand the need for the 4 files, use the concept of “referencing”, or more simply, “mention”.
a) A template alone can’t reference a component-jsp. Internalize the fundamental reasoning. See other posts.
b) Therefore a template can’t be a URL. A URL must reference all component-jsp directly or indirectly.
c) A URL has to be a user-jsp, referencing the defitions, which in turn references template and component-jsp files

tiles — 3 types of resources

For Tiles, there’s some valuable but less-than-comprehensible code example at http://www.javaworld.com/javaworld/jw-09-2002/jw-0913-designpatterns.html

Background: U have a template file, containing variables, each naming a component-jsp file. Each variable is a place-holder to be substituted by the corresponding jsp.

Q: If you don’t know tiles, how would u do the substitution in a servlet container? How do you assign a header.jsp to the first variable? If first variable names “header.jsp” right within template.jsp , then we can’t reuse template.jsp in another project. We need template.jsp to be free of hard-coding.

A: You need some kind of glue-file. Tiles implents it as a set of definitions spelt out in tiles-defs.xml

Closest starting point: smarty — also contains template, variables holding large content. Smarty uses assign() to put the content into the variables and glue the parts.

Observer pattern brief notes

event object? Ignore for now. First focus on the 2 basic players

Subject and Observer HAS-A pointer to each other. (tight coupling@@ NO. Thanks to interfaces)

– Subject HAS-A reference to each observer [1] in order to send them updates.
– Observer HAS-A rcontrol linked to his subject(s) in order to subscribe/unsubscribe. Usually a field in the observer.

It seems to me that they don’t normally receive these pointers by argument-passing like

– Subject doesn’t HAS-A such pointer but receives a list of observers in notifyObserver() method. However, this way, subscription has no meaning.
– Observer doesn’t HAS-A such pointer but receives it as argument when calling subscribe().

[1] Static collection or a collection as a field in the subject object.

[[ Head First Design Patterns ]] is good. Helps me internalize
– registration
– data passing during notification

–Usage@@ I think most (if not every) events, listeners, subscribers, publishers … take some hints from the Observer pattern.
* swing — /Intimate/ knowledge helps you chip away at swing. Events and listeners are fundamental to swing.
* java beans
* servlet — This pattern is also relevant for servlet listeners.
* threads — Observer pattern helps inter-thread communications and data sharing
* JMS, MDB @@ Confident. No need to verify

— keywords:
subject/observer
pub/sub — the observer subscribes to news published from the Subject object
listener aka observer
registration aka subscribing