RoundFusion™

Simple Deployment from Sandbox to Production

2011-12-29T23:20:00.000-08:00

I just tried to deploy new custom tab, custom objects, application, pagelayout, visualforces, and a document from my Salesforce Developer sandbox to Salesforce production using Force.com IDE. Pretty simple. Here are the steps, assuming you make the changes directly in your sandbox and wish to deploy the changes to the production org:

Create a new Force.com project on your Force.com IDE from your Salesforce Developer sandbox. If you have created the project previously, make sure you "refresh" or "add meta-data" to the project to make sure that you have the latest changes downloaded into your project.
Deploy to Server (Force.com > Deploy to Server)
Login to your production org
Select the items to deploy
Test the deployment by clicking "Validate Deployment"
If succesful, click Next and Finish

Once it's deployed, you want to make sure that you login to the production org and provide necessary access to the components that are deployed. It's best if you have deployment runlist to make sure that these are documented properly.

HTML 5 - Flexing The Muscles!

2010-08-05T22:38:00.000-07:00

I had an awesome opportunity to attend HTML 5.0 crash course taught by Peter Lubbers, the co-author of the Pro HTML5 Programming book. I am very awed to learn that HTML 5 is designed to be very powerful. It definitely changes on how web app will be built. Here are some key points from the training:

Cleaner HTML Codes – It introduces some new HTML tags such as SECTION, HEADER, FOOTER, ARTICLE that will make HTML codes more readable (moving away from general DIVs to define page sections)
Improved Offline Experience – It allows programmer to define HTML files that should be stored in the desktop for offline browsing experience (instead of depending on the browser to decide for you).
Richer HTML Native Data Type – Some new rich data type such as email, calendar, URL will be available. It means we don't need to build masking, JavaScript validation code, etc to handle the user experience/data quality.
Better Graphic, Audio & Video Support – The Canvas object will provide drawable region in the HTML code. It allow programmer to embed SVG (Scalable Vector Graphics) in the document, embed audio & video file without plugging and allow JavaScript to control the audio/video properties.
Improve Browser Scalability with "Work Workers"– Heavy JavaScript execution sometimes caused browser to freeze. With Work Workers, the browser can spawn background workers running the script in parallel to the main page (similar to thread) to avoid the browser performance issue.
Better Storage Management – In addition to cookies, now JavaScript can manage store values with “local” or “session” storage. Value is stored and retrieved with Key (similar to map data structure).
Secure "Cross-Site Scripting" – JavaScript will be allowed to make cross-site scripting with supported server-side configuration to whitelist origins.
Full Duplex Communication with Web Socket – JavaScript codes can can be transmit & receive data concurrently in a single connection.

This is very exciting. I can't wait until the day where major browsers fully support HTML 5!

Installing Packages to Salesforce Sandbox Orgs

2010-05-19T19:04:00.000-07:00

Installing Package to Sandbox using the Package URL
From the package URL, replace the word “login” with “test” (see example below). Then complete the installation with your sandbox username/password

Replace:
https://login.salesforce.com/?startURL=%2Fpackaging%2FinstallPackage.apexp%3Fp0%3D0...

With:
https://test.salesforce.com/?startURL=%2Fpackaging%2FinstallPackage.apexp%3Fp0%3D...

Installing Package to Sandbox using the AppExchange Get It Now button
Click the Get It Now button from the AppExchange listing & make sure you select “Sandbox (text environments)” from the radio button. Then continue with the installation process.

jQuery... How Awesome!

2010-05-13T19:05:00.000-07:00

It's been a while that I've not updated myself with the latest and coolest JavaScript world, particularly with jQuery. I heard a lot about jQuery, but shame on me that I did not really play with it until two weeks ago. I feel that I am such a laggard!

I am definitely impressed with the 'SQL' or 'XPATH' like query that we can use to access DOM. I am impressed with the ready-to-use AJAX & other UI releated library.

I created a simple HTML page + jQuery codes. The story: user can highlight a paragraph depending on the paragraph user chooses from the drop-down menu. Try it yourself. To look at the source code, simply view the source code with your browser.

Simple Search with SOQL

2010-04-05T22:27:00.000-07:00

I've added a simple search feature into my Force.com-powered guestbook app (see previous post). This search feature will take keyword(s) and search the comments with Force.com SOQL.

One very important catch that I discovered, we cannot use SOQL to filter long text area custom field type. I have to change the custom field type for my Comment__c from ‘long text area’ into ‘text area’ (255 char max). I still don’t know what would be the best way to filter long text area field. I might try searching using SOSL.

To try the search, please go to URL below and navigate to "Search Comments".
http://cewl-developer-edition.na7.force.com/listEntries

I enhanced the Apex Controller with several attributes and methods

// Apex Controller
public with sharing class gbEntryController {
  /** Class properties */
  ApexPages.StandardController controller;
  String searchKeyword;  // capture the search keyword
  gbEntry__c[] gbEntries;  // search result records holder
  Integer noSearchResults = 0;  // get the no. of search result
  /** Class Constructor */
  public gbEntryController(ApexPages.StandardController controller) {
    this.controller = controller;
 } 
  /** Getter & Setter methods */
  public void setSearchKeyword(String searchKeyword) {
    this.searchKeyword = searchKeyword;
  }
  public String getSearchKeyword() {
    return this.searchKeyword;
  }
  public gbEntry__c[] getGbEntries() {
    return this.gbEntries;
  }
  public Integer getNoSearchResults() {
    return this.noSearchResults;
  }
  /** Save method – save the comment and redirect user to list of comments */
  public PageReference save() {
    this.controller.save();
    PageReference pageRef = new PageReference('/apex/listEntries');
    return pageRef;
  }
  /** SearchEntries method – search comments based on the submitted keyword */
  public void searchEntries() {
    if (searchKeyword != null && !searchKeyword.trim().equals('')) {
      String likeStr = '%' + searchKeyword + '%';  
      this.gbEntries = [SELECT id, Name__c, Comment__c, CreatedDate 
                       FROM gbEntry__c WHERE Comment__c like :likeStr 
                       ORDER BY CreatedDate ASC  LIMIT 100];
      this.noSearchResults = (
      this.gbEntries == null) ? 0 : this.gbEntries.size();
    }   
  }
}

This is the new visualforce page. The "action" attribute is used to call the gbEntryController's searchEntries method. The result will be displayed with partial page refresh with AJAX provided by the Force.com Visualforce by using the "rerender" attribute & supplying an ID of an output panel.

// Visualforce code
<apex:page standardcontroller="gbEntry__c" 
  extensions="gbEntryController" showHeader="false">
  <div style="width:640px;margin:20px;padding:20px">
  <h1>Force.com Powered Guest Book</h1>
  <p><a href="listEntries">View Comments</a> | <a href="submitComment">Leave Comment</a> | Search Comments</p>
  <hr style="border:1px solid silver"/> 
  <apex:form >
    <table cellpadding="2" cellspacing="3">
      <tr>
        <td valign="top" colspan="2"><apex:pageMessages /></td>
      </tr><tr>   
        <td valign="top"><apex:inputText style="width:200px;" value="{!searchKeyword}"/></td>
 <td><apex:commandButton value="Search" action="{!SearchEntries}" rerender="searchResult"/></td>
      </tr> 
    </table>
  </apex:form>
  <hr style="border:1px solid silver"/>
  <apex:outputPanel id="searchResult"> 
    <apex:repeat value="{!GbEntries}" var="gbEntry" rendered="{!NOT(ISNULL(GbEntries))}">
      <div style="padding:10px;margin:10px;border:1px dotted silver; background-color:#F9B7FF">
        <span style="font-size: smaller">
   <apex:outputField style="font-family: Monospace;" value="{!gbEntry.Comment__c}"/>
   <br/><br/>
   Posted by&nbsp;<strong><apex:outputField value="{!gbEntry.Name__c}"/></strong> 
          at &nbsp;<apex:outputField value="{!gbEntry.createdDate}"/>
 </span>
      </div> 
    </apex:repeat>
    <strong>{!noSearchResults}</strong> records found.</apex:outputPanel> 
  </div> 
</apex:page>

Force.com powered Guestbook

2010-03-28T18:30:00.001-07:00

Try it out:
http://cewl-developer-edition.na7.force.com/

Creating the custom object
Create the gbEntry custom object as the database table to store guestbook entries.

gbEntry
+Name (text)
+Comment(Long Text Area)

Creating the Apex Class (Custom Controller)
I could have used just gbEntry standard controller. However, I want to override the "save" method. By default, the "save" method redirect user to record detail. By overriding this method, I can redirect the user to the list of entries after submitting the guestbook entry.

public with sharing class gbEntryController {
  private ApexPages.StandardController controller;

  public gbEntryController(ApexPages.StandardController controller) {
    this.controller = controller;
  }

  public PageReference save() {
    this.controller.save();
    PageReference pageRef = new PageReference('/apex/listEntries');
    return pageRef;
  }
}

Creating the Visualforce pages
This visualforce page displays the list of guest book entries. I use apex:repeat tag to loop through the records.

// listEntries.page
<apex:page showheader="false" standardController="gbEntry__c" recordSetVar="gbEntries">
<div style="width:640px;margin:20px;padding:20px">
<h1>Force.com Powered Guest Book</h1>
<p><a href="submitComment">Leave your comment</a></p>

<p>
<apex:repeat value="{!gbEntries}" var="gbEntry" >
<div style="padding:10px;margin:10px;border:1px dotted silver; background-">
<span >
<apex:outputField style="font-family: Monospace;" value="{!gbEntry.Comment__c}"/>
<br/><br/>
Posted by <strong><apex:outputField value="{!gbEntry.Name__c}"/></strong> at
<apex:outputField value="{!gbEntry.createdDate}"/>
</span>
</div>
</apex:repeat>
</p>   
</div>
</apex:page>

This visualforce page displays the form that is used to submit a new guestbook entry. Please notice that I am closing the gbEntryController custom controller that extends the standard controller.

// listEntries.page
<apex:page standardcontroller="gbEntry__c" extensions="gbEntryController" showHeader="false">
<div style="width:640px;margin:20px;padding:20px">
<h1>Force.com Powered Guest Book</h1>
<p><a href="listEntries">View Comments</a></p>
<hr style="border:1px solid silver"/>
<apex:form >
<table cellpadding="2" cellspacing="3">
<tr>
<td valign="top" colspan="2"><apex:pageMessages /></td>
</tr><tr>
<td valign="top" >Name:</td>
<td><apex:inputText style="width:200px;" value="{!gbEntry__c.Name__c}"/></td>
</tr><tr>
<td valign="top" >Comment:</td>
<td><apex:inputTextArea style="width:300px;" value="{!gbEntry__c.Comment__c}"/></td>
</tr><tr>
<td valign="top" colspan="2"><apex:commandButton value="Save" action="{!Save}" /></td>
</tr>
</table>
</apex:form>
<hr style="border:1px solid silver"/>
</div>
</apex:page>

I also spent times to make sure Sites is enabled properly & that all permissions are put in place. The Salesforce's Help is pretty handy when setting up the Sites.

Hiding Salesforce Default UI Theme from Visualforce Page

2010-03-28T13:58:00.000-07:00

Simply set the following attributes in the apex:page element to false:

showHeader
standardStyleSheets

For example:

<apex:page showheader="false" standardstylesheets="false">
....
</apex:page>

Two chapters of Enlighment

2008-06-05T22:16:00.000-07:00

I have always been intrigued with business process automation. Having a software engineering background, I learn the power of business software that we can harnessed to reduce/eliminate business waste by automating and simplifying manual processes. With several emerging technologies spurred by the maturing internet adoption, managing and integrating business software have becoming more feasible and inexpensive to achieve. Adopting advance technology to support business operations now has become an affordable luxury nowadays; however, one has to adopt and use them carefully to avoid unnecessary technology overuse that could potentially hamper business activities.

Recently I start reading Paul Hamon’s masterpiece, titled “Business Process Change – A Manager’s Guide to Improving, Redesigning, and Automating Processes”. Just by completing the first two chapters, Paul has successfully persuaded me to step back from my point of views in business process automation that are much polluted with fancy emerging technologies. Paul reintroduced me with Porters’ model of competition and perspectives that one can use to redefine business strategy. One of Porters’ perspectives that really hit me hard is the importance of achieving competitive advantage by balancing the company’s strategic positioning and operational effectiveness. Just like a coin that always have two sides, so far I have only been looking one side of the coin – the operational effectiveness. Porters explains that without clearly understanding its strategic positioning, a company will overdue its operational effectiveness. When competing companies in the same industry overdue the operational effectiveness to maintain its competitive advantage, it will cause condition that Porters called “hypercompetition”. When this situation occurs, competing companies are struggling to make profit and favor to relieve the condition through merger/acquisition. It amazes me how I can use this to analyze the current domestic aviation industry, for example. Porters’ perspective seems fit very well with the situation (eg. airlines claimed to lose money & merger between Delta & Northwest Airlines) . Please note, however, that I am not implying those executives do not understand Porters’ model, but it is definitely very challenging for them to define a compelling strategic position that differs from the competitors in this saturated market.

Though I am still far from completing the book, I have decided to give thumbs up for this book for successfully influencing me with its first first two chapters. I am going to march ahead with the rest of chapters and will write more review about this book in my later posts.

Web2Spreadsheet

2008-05-09T19:42:00.000-07:00

I like Google Spreadsheet the most out of the other Google Docs, primarily because of the web form feature. With Google Spreadsheet, you can create a web form that store data automatically in your spreadsheet in 6 simple steps (please see my slideshare).

Can you imagine how powerful it is? Even a flower lady can build an online survey for her little store. Yes, it's not a perfect web form. For example, there's no form validation and no page look-and-feel customization. But it's good enough for some simple scenarios.

Below you can find the instruction to create your own web form with step by step explanation. To try this sample web form, please click here. Please don't go crazy because data will be stored in my Google Spreadsheet account :-)

Google Docs is another example of Software as a Services (SaaS).

| View | Upload your own

Managing Information from Customer Facing Activities with CRM

2008-05-08T21:16:00.001-07:00

Many small and medium businesses currently still have not leveraged Customer Relationship Management (CRM) system to manage information collected from every customer facing activities. The slow adoption of the system can be attributed to unawareness about the benefits of the implementing the system or the perception that it’s difficult and expensive to implement CRM system. However, this article should help readers understand better about how comapanies can leverage CRM features to help manage prospects and customers’ information better. Finally, the article discusses SaaS – the latest trend in software industry.

Customer Facing Activities
From a high-level perspective, customer facing activities can be divided into three basic categories: marketing, sales, and service and support. In marketing category, marketers typically post advertisements or conduct events to promote products/services. In sales category, sales representatives try to sale products/services by contacting prospective buyers. In service & support category, company ensures customers are satisfied by providing the promised services or product supports.

Business Challanges
In a small size company, it’s not uncommon that one or two employees play a role in each category. Typically when business is operating on a low number of customers, these employees can manage information through spreadsheet and share them via email. The challenges appear when number of customers grows tremendously because the process is not scalable, and these can be identified through the several symptoms, such as lost of sale opportunities, decreasing customers’ satisfaction rate, and eventually loosing loyal customers to competitors. Internally, the employees are suffering fatigues from the difficulties to mange and share the growing customer information.

Customer Relationship Management (CRM)
Every company that sells products/services typically has a set of processes used to manage customer facing activities. These processes should be planned, designed, and executed carefully to entice prospective consumers and to maintain customers’ satisfaction level. Most importantly, these processes must be supported by a system that allow each stakeholders to scale while executing the process. With CRM software, a company can structure and centralize prospect and customer data, automate processes, and take proactive and reactive actions towards certain business conditions.

Structured and Centralized Data
CRM typically comes with a set of standardized business objects (similar to database tables) that relates to the marketing, sales, and service & support business data. For example, Account, Contact and Opportunity object are used to manage sales related information. Campaign and Lead objects are commonly used to manage marketing related information. Product, Case, Solution are used to manage service & support information. These standardized objects structure data universally across the organization. The more employees start utilizing the system, the more data continuously stored into the system, creating a centralized repository for the the company. Structured and centralized data enabled company to mine the data and to create better reports to analyze the state of business and make better decisions. Compared with the spreadsheet documents & emails, this has definitely provided a significant improvement for the company.

Automated Processes
In addition to the standardized business objects, CRM usually comes with built-in automated processes. These built-in automated processes promote universal understanding about the process in the company. For example, when a lead meets its qualification, it can be converted into account, contact, and opportunity objects. Built-in automated processes also serve as the one of key primary differentiator between CRM and databases system.

Proactive and reactive actions towards business condition
CRM may come with feature for users to create and manage dashboards, reports and workflows. Reports are suitable to trigger reactive actions, while dashboards and worfklows can be used to initiate proactive actions. For example, a marketer can create an ROI report of multiple campaigns. After reviewing the report, she can decide to eliminate several under-performing campaigns. A support dashboard can inform the supervisor about his team performance by observing number of open cases. When the dashboard indicate high number of open cases, he can contact his team, investigate the causes and solve them preventing the situation to become a source of crisis. A workflow can send an email to the key executive when a new high value opportunity is created alerting him that there's important deal and he may to take further actions to secure this deal.

SaaS - Software as a Service
The ‘Software as a Service (SaaS)’ term does not really provide new meaning to software industry. But it’s a new term that represent the ‘Application Services Provider (ASP)’ and later commonly known as ‘OnDemand’ concept. This concept promotes an easy software consumption while avoiding common on-premise software installation and configurations pitfalls. SaaS application typically allows fast and easy software provisioning through the internet and web browser, as fast and easy as renting movie online. SaaS application vendor also use a subscription pricing model that allows company to consume the software in affordable subscription price. This model allows small and medium companies to enjoy the benefits of using "elite" enterprise software that previously was only affordable for larger companies.

Small and medium businesses should definitely consider moving away from the non scalable practices and should not shy away from adopting CRM. It will help companies to manage the full cycle of customer facing activities from marketing, sales, and service & support. It stores the activity data in structured, centralized allowing for easy reporting. Dashboards, reports, and worklows allows companies to be more responsive to prospects and customers. And with SaaS model, even a small company can enjoy the luxury of running its business activities as professional as enterprise companies.

| View | Upload your own

Contextual Design and User Interface Design/Testing

2006-11-03T22:22:00.000-08:00

I recently completed two projects required by the Master degree that I am pursuing. These two projects thought me valuable lessons in how to design a good interface by conducting a contextual design and eliciting the usability problems in the user interface design.

Contextual Design
When building a system’s user interface, we want to ensure that we build it to accommodate the existing work processes. Performing a Contextual Design (CD) helped our team collect data and model the existing work processes. The data collection process is called the Contextual Inquire (CI). When performing CI, our team visited the actual work place and observed the daily working processes. We later created a transcript of the activities that is used as the base information for the modeling for the CD. There are three models that our team generated:

Sequence model – captures the motivation of a user to complete a task (goal/intent), a sequence of actions to accomplish the task, and the trigger that causes the sequence of actions to start.
Flow model – captures the communication and coordination occurs between individuals or between system and individual in the work place.
Cultural model – captures the cultural influences (policies, tone, and organization influence) that affect the individual while completing the task.

In the sequence and flow models, we can also identify problems that slow down/jeopardize the task completion) by noting them as breakdowns into the models.

After having these three models ready, we were able to learn and observe more about the work processes in the organization and the culture of the organization. With these in mind, we were ready to build a user interface prototype that suites or improve the existing work processes.

User Interface Design and Testing
The second project is to continue where we left off from the Contextual Design task. Based on the previous models and the system requirements, we built a web user interface prototype for the organization that we observed.

When building the user interface prototype, we built three artifacts (sitemap, flow diagram, and storyboard) that helped us categorize the information and visualize the layout of the user interface components.

Most importantly, after the prototype was completed, we conducted feedback session by performing usability heuristic evaluation and user test.

Heuristic evaluation is a method to find usability problems in user interface design. This evaluation process involves a set of evaluators to examine the interface and judge its compliance with recognized usability principle (Jakob Nielsen’s Ten Usability Heuristics).

User Testing, on the other hand, is a process where an evaluator (a person that conducts the test) interprets observer’s (a person who takes the test) actions and relates these actions into usability issues in the design of user interface.

After conducting these different feedback sessions, we received a set of difference feedbacks from the heuristic evaluation and user test. We noticed that feedbacks from the heuristic evaluation consist of finer grain information about mistakes we made from the prototype (incorrect color, hard to understand labels, inconsistencies, etc). The user test feedbacks gave us coarse grain information that relates more with the ease of use of the prototype.

Summary
From the first project, I learned a great deal of capturing user’s work processes and translate them into guidelines in building a user-centered user interface design. A design that is built on-top of the contextual design activity will fit better for the user by increasing the usability of the system. From the second project, I learned that the results of heuristic evaluation and user test compliment each others. These methods will definitely be great tools that I can use on my future professional endeavor.

Flaw in IE's getElementsByName() Method Implementation

2006-08-11T15:02:00.000-07:00

I recently discovered a JavaScript implementation flaw in Microsoft IE while trying to build dynamic form. I realize that Microsoft IE v 6.0.29 does not implement the getElementsByName(param) properly according to the W3C standard.

As a web delovoper, my intuition expects the getElementsByName(param) to return a list of elements that fulfill the following criteria: 1) it needs to have the "name" attribute as its element; 2) the name attribute must have a value that is equal with value of the param passed by the method caller.

To illustrate the issue better, let's use the following example:


01 <html>
02 <script>
03 function validateFormFields(aForm) {
04  var elems = document.getElementsByName("field1");
05   alert("There are " + elems.length + " elements");
06   return false;
07 }
08 </script>
09 <body>
10 <form name="myForm" action="addData.do" method="post"
11    onsubmit="return validateFormFields(this)">
12    <div id="field1">
13       <input name="field1" type="text" value="cool"/>
14    </div>
15    <input type="submit" value="Submit"/>
16 </form>
17
18 </body>
19 </html>
20

From the codes sample above, I expect the browser to render the page by displaying an input field and a submit button. When submit button is clicked, it will invoke the validateFormFields() function, and this function is responsible to alert the number of elements that is returned by the document.getElementByName(“field1”).

The codes sample only has 1 element that has a “name” attribute where its value is equal to “field1” (line 12). Therefore, I expected the method to alert me only 1 element is found when the submit button is clicked. When tested with Firefox v 1.5.04, the browser met my expectation. However when running the same codes with IE v6.0.29, the alert informed me that there are 2 elements are found.

"Retrieves a collection of objects based on the value of the NAME attribute"

Ok, it is something that I want. But then when I read further, I also found the following sentences:

"When you use the getElementsByName method, all elements in the document that have the specified NAME or ID attribute value are returned."

There the main issue is documented. Not only that IE returned elements that have a "name" attribute that matches the value of the param, but it aslo retuned elements that have an "id" attribute that matches the value of the param. That's why the browser returned 2 elements where the first element comes from line 12 and the second element is from line 13.

I found the following explanation of the method from the W3C website:

"With [HTML 4.01] documents, this method returns the (possibly empty) collection of elements whose name value is given by elementName. In [XHTML 1.0] documents, this methods only return the (possibly empty) collection of form controls with matching name. This method is case sensitive"

It does not mention anything about returning an element that has an "id" attribute with matching value. Therefore, I think the proper implementation has been executed by Firefox browser, where as IE method implementation does not follow the W3C DOM specification, and as a web developer, I found it to be confusing and annoying.

Doodling around with Spring Framework and Hibernate ORM

2006-06-16T12:29:00.000-07:00

I am implementing a small project with Spring Framework and Hibernate ORM. During the environment set up, I encountered several major problems which took several days to investigate and resolve. Here is the list of servers and frameworks that I am using:

Apache Tomcat {5.5.17}
SpringFramework {1.2.8}
Hibernate ORM {3.0}
MySQL {5.0}

First Issue
When integrating the Spring Framework and the Hibernate ORM, my Tomcat server complained during start up that it could no find the Hibernate hbm.xml files. I attempted to use Spring's HibernateTemplate for the integration. When registering the LocalSessionFactoryBean into the Spring XML configuration files, I listed the Hibernate hbm.xml files as the "mappingResources" parameter, along with other parameters. Here is the error message that is spit out by the Tomcat server:


Caused by:
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/jnfintl-data.xml]:
Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError
Caused by:
java.lang.NoClassDefFoundError
at org.hibernate.tuple.EntityMetamodel.class$(EntityMetamodel.java:41)
at org.hibernate.tuple.EntityMetamodel.(EntityMetamodel.java:122)
....

As some suggested, this error may occurr because the container cannot find the hbm.xml files in its classpath, and therefore they suggest to add "classpath:/package.java.class" into the Spring XML configuration file. I tried this approach, but it did not solve my problem. After further investigation, I realized that there I miss one jar file on my web application that caused this issue, the cglib-2.1.3.jar. After putting back the jar file into the application lib folder, I did not see the error message anymore when I started up my Tomcat server, and the web application works just fine now.

Second Issue
When using Spring WebMVC to map a URL request that contains a directory structure, the framework failed to map the relevant physical directory, causing the browser to displays HTTP 404 error msg reporting that the requested resource is not available. I attempted to use a combination of UrlFileNameViewController and SimpleUrlHandlerMapping in my Spring XML configuration file to map a URL request with its corresponding JSP file. However, the UrlFilenameViewController failed to find and display the JSP files that are organized within a directory structure. For example:


...
<bean id="urlFilenameViewController" class="org.springframework.web.servlet.mvc.UrlFilenameViewController"/>

<bean id="simpleUrlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
<property name="mappings">
<props>
 <prop key="/test/testDbConnectionPool.html">
   urlFilenameViewController
 </prop>
</props>
</property>
</bean>
...

When the browser requested http://localhost:8080/somewebapp/test/testDbConnectionPool.html, the server complained that it could not find the requested resources.

This turned out to be a bug (or an enhancement?) within the version of Spring Framework that I was using. After updating the Spring Framework jar files with the version 2.0 M5 development release, the isssue is solved.

Third Issue
I kept encountering the Lazy Initialization error when trying to access an associated/joined objects from another object that is returned by the hibernateTemplate's load method. I think this was due to my lack of understanding of Hibernate lazy initialization concept. It is a new concept that is introduced in Hibernate 3.0.

I found Mr. Baum's blog that discussed the problem and provided alternative solutions to my problem. Please visit Mr. Baum's discussion about the ORM Lazy Initialization With DAO to read more about it. It's very well written and easy to understand. I tried Mr. Baum suggestion, and it worked very well with my case. The only catch that I encountered was caused by a Spring Framework's hibernate template version difference. The sample codes provided by Mr. Baum is using the older version of the Spring Framework. If you are using the newer framework, make sure that you are using the hibernate3 template.

While investigating on my problems on the Internet, I also stumbled into a good article about Spring Controller, written by Mr. Mike Raible. You can find this article at Mr. Raible's Wiki: SpringControllers.

WSDL2Java & TCPMON Tutorial

2006-03-02T09:52:00.000-08:00

Generating Java Proxies from the WSDL
Sometimes when working with web services integration, it's easier for Java developers to utilize Java proxies and use them to interact with the service provider because learning the Java API might be faster and easier than learning about the structure of SOAP Envelope through WSDL. Creating the proxies is very easy with WSDL2Java tool. Once you finish creating the proxies, you can start writing a simple client to interact with the service provider, and you can use the TCPMON tool to intercept the SOAP messages that are exchanged between the service provider and consumer.

To create the Java proxies, there's a WSDL2Java plugin for Eclipse endorsed by SalesForce.com (com.myspotter.wsdl2java_1.2.0.zip). Once you unzip the file into your eclipse/plugins directory, restart your Eclipse. To generate the stubs, all you have to do is to locate the WSDL file with Eclipse package explorer, right click, and choose "Generate". This will generate the Java proxies on your project root folder. You can move these proxies to your Java source folder.

Setting up TPCMON
To intercept the messages, you can use the TCPMON (tcpmon.jar). Double click on the JAR file, you will see the Swing console to appear on your screen. To set up this TCPMON will be a little bit tricky but not too difficult. You will see the following input fields:

Local Port: Use any unused local port number (such as 8181).
Server Name: Put the IP address of the services provider (the url/IP address of the service endpoint. For example, Salesforce's service endpoint is "na1-api.salesforce.com")
Server Port: Usually just use "80" as default service endpoint unless they specify something else.

Writing Simple Web Services Client
Having the proxies generated from WSDL to Java and the TCPMON set up, you are ready to write simple web services client in Java. The following is a simple tutorial of how to write Java web services client code using the generated proxies to connect to SalesForce CRM OnDemand. You need to have an active account (free to register for developer account at SalesForce website).

You can also download the wsdl2java_tcpmon.zip that contains:

com.myspotter.wsdl2java_1.2.0.zip (Eclipse plugin for WSDL2Java)
tcpmon.jar (TCPMON to intercept SOAP Message)
createPriceBook.jsp (Simple example to create PriceBook at SalesForce.com)
jaxrpc_client.ppt (Slides I used to use for my past lecture).

Let's start writing the codes

// don't forget to import the generated proxies
// Get the instantiate the ServiceLocator object
SforceService service = new SforceServiceLocator();

To intercept the SOAP message using the TCPMON, we need to modify the service endpoint by using method available from SoapBindingStub.

// get SoapBindingStub
SoapBindingStub binding = (SoapBindingStub) service.getSoap();

With the binding object, now we can change the service endpoint to point to our TCPMON. Previously, the stub is trying to send the SOAP message directly to SalesForce with the following URL:

https://na1-api.salesforce.com/services/Soap/c/6.0

Replace the service endpoint above with our TCPMON by using the following URL (assuming you pick port 8181 for the TCPMON local port):

http://localhost:8181/services/Soap/c/6.0

Now, using the local service endpoint, you can set it to the binding object.

//To set the local endpoint to the binding object
binding._setProperty(SoapBindingStub.ENDPOINT_ADDRESS_PROPERTY,
"http://localhost:8181/services/Soap/c/6.0");

Now, before we start calling the web services API, we need to login first. To login:

// Login
LoginResult loginResult =
binding.login("username@company.com", "password");

We need to get the session ID from the loginResult object and set it into the SOAP Header.

// Instantiate a SessionHeader object
SessionHeader sh = new SessionHeader();

// set the session id into the SessionHeader object
sh.setSessionId(loginResult.getSessionId());

// set the SessionHeader object into the binding object
binding.setHeader(
new SforceServiceLocator().getServiceName().getNamespaceURI(),
"SessionHeader", sh);

Now, the rest will be easy. For example, to store a new record at SalesForce, we just need to use the SalesForce object (such as Pricebook2 or Product2).


// Instantiate Pricebook2 object and give a name.
Pricebook2 pb = new Pricebook2();
pb.setName("The Price Book - " + System.currentTimeMillis());

// call the Create API from the binding object
SaveResult[] saveResults = binding.create(new SObject[] { pb });

The steps above will let you create a new price book, and you can see how the SOAP Request and Response are being structured on the TCPMON tool.