Lesson of the Day

"We learn something new everyday!" As a tribute to this saying...

We have this large million of records table. An audit table exists to record every single update or deletion of a row in this table. We were thinking of creating an index on this audit table where no indexes existed before. However, every update/deletion would require an update of this new index, therefore, slowing the performance of write operations on this table.

Lesson of the Day: Indexes, although improves the performance of read operations, leads to more overheard if this table is often updated.

I know i'm dumb..

Flex Error: ReferenceError: Error #1065

This error often refers to missing assets in the swf file that is expected to be there. For example, if you get the following error:

Variable ExampleView__embed_mxml__assets_png_example_picture_png_1012766830 is not defined.

It refers to a missing asset in an mxml file called ExampleView attempting to reference a png file as in the VBox below:

<mx:VBox backgroundImage="@Embed(source='/assets/png/example_picture.png')" width="100%"

In this instance, you must remember to include these assets into the compiled swf files.

Flash Global Security Settings: Windows vs. Macs

There seems to be a slight difference between how global security settings are set on Windows and Macs browsers. To note, when you set the global security settings, they are set "globally" for the machine and not for the particular browser where the security setting was set.

On Macs, you can just specify the swf file in the global security settings. The swf file will load successfully and any external interface registered functions can be successfully called.

On Windows, however, specifying the swf file in the global security settings will allow the swf file to load correctly. But, this does not allow registered external interface functions to be called. It will cause the following js error:

Error calling method on NPObject! [plugin exception: Error in Actionscript. Use a try/catch block to find error.].

In order for external interface functions to be called, you must also specify the folder/file where the swf file is located.

CVS Commands

Creating a New Tag from an Existing Tag
cvs -d :ext:{user}@{host}:/{cvs directory} -q rtag -r {existing tag} {new tag} {cvs directory}

java.lang.UnsatisfiedLinkError: create_stmt_c_copy

Googling this, this is a result of old oracle jars. Update your oracle jars to the latest or the right version. This should fix this error.

Mule Error: ObjectNotFoundException Object " null" not found in container

This error is not a very descriptive message. What is actually happening in the mule app is that the UMO is attempting to be created, however, it is throwing an error during its creation. The UMO is never then added to the container and therefore cannot be found in the container.

In the example that I encountered this error message, the creation of the com.bamnetworks.reporting.DataReporter fails to be created, because of a misconfiguration in the database and the reporting config.

SWFObject not working

Please ensure that the div in which the flash embed object will be written to is defined before the inclusion of the external javascript file that defines the SWFObject

Otherwise, it will not be able to write to a div tag that does not yet exist.

Example:

...

<div id="flash_videoplayer"><strong>You need to upgrade your
Flash Player</strong> This is replaced by the Flash content. Place your alternate
content here and users without the Flash plugin or with Javascript
turned off will see this. Content here allows you to leave out <code>noscript</code>
tags. Include a link to <a href="swfobject.html?detectflash=false">bypass the detection</a> if you wish.</div>

...

<script type="text/javascript" src="js/flvplayer_2.js">

==========
The above flvplayer_2.js file contains the code below:

var swfObject = new SWFObject("FlvPlayer2.swf", "flvPlayer2", flv_width, flv_height, "9");
swfObject.addParam("allowScriptAccess", "always");
swfObject.addParam("allowFullScreen", "true");
swfObject.addParam("salign", "tl");
swfObject.addParam("menu", "false");
swfObject.addParam("wmode", "transparent");
swfObject.write("flash_videoplayer");