Fusion Middleware

In this example below we show how to create a multi threaded insert client to insert 100,000 records into SQLFire table. In this example below the table is partitioned with synchronous persistence turned on.The distributed system includes one locator and 5 data members.

1. Create Table as shown below

  
drop diskstore store1;

CREATE DISKSTORE STORE1;

drop table person;

create table person 
(id int primary key,
 name varchar(40))
PARTITION BY COLUMN (id)
REDUNDANCY 1
PERSISTENT 'STORE1' SYNCHRONOUS;

2. Multi Threaded Insert client Code.

  
package pivotal.au.fe.sqlfire.insert;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.concurrent.Callable;
import java.util.concurrent.ExecutionException;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;
import java.util.concurrent.Future;
import java.util.concurrent.TimeUnit;
import java.util.logging.Level;
import java.util.logging.Logger;

public class MultiThreadInsert 
{
 private String url = "jdbc:sqlfire://127.0.0.1:1527/";
 private final int RECORDS = 100000;
 private final int COMMIT_POINT = 10000;
 private static final int nThreads = 4;
 
 public MultiThreadInsert() 
 {
 }
 
 private Connection getConnection() throws SQLException
 {
  Connection conn = null;
  conn = DriverManager.getConnection(url);
  return conn; 
 }
 
 @SuppressWarnings("unchecked")
 public void start() throws InterruptedException, SQLException 
 {
  Connection conn = getConnection();
  
        final ExecutorService executorService = Executors.newFixedThreadPool(nThreads);

        ArrayList list = new ArrayList();
        for (int i = 0; i < nThreads; i++) {
            list.add(new RunData(conn, i+1));
        }
        long start = System.currentTimeMillis();
        
        List<Future<?>> tasks = executorService.invokeAll(list, 5, TimeUnit.MINUTES);
        
        for(Future<?> f : tasks){
         try {
    f.get();
   } catch (ExecutionException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
        }
        
     long end = System.currentTimeMillis() - start;
     
     float elapsedTimeSec = end/1000F;

        System.out.println(String.format("Elapsed time in seconds %f", elapsedTimeSec));
        
        conn.close();
     executorService.shutdown();
        System.exit(0);
 }
 
 private class RunData implements Callable 
 {
     int counter = 0;
        int increment;
        Connection conn;
        
        private RunData(Connection conn, int increment) 
        {
            this.increment = increment;
            this.conn = conn;
        }

        public void run() 
        {
      PreparedStatement stmt = null;
      String sql = "insert into person values (?, ?)";
      int counter = 0;

            int dataSize = RECORDS / nThreads;
            System.out.printf("Start: %d  End: %d \n",(dataSize * (increment - 1)), (dataSize * increment));
      try 
      {
       stmt = conn.prepareStatement(sql);
       
       for (int i = (dataSize * (increment - 1)); i < (dataSize * increment); i++)
       {
        counter = counter + 1;
        stmt.setInt(1, i);
        stmt.setString(2, "Person" + i);
        stmt.addBatch();
        
        if (counter % COMMIT_POINT == 0)
        {
         stmt.executeBatch();
         conn.commit();
        }
       }
       
       /* there might be more records so call stmt.executeBatch() prior to commit here */
       stmt.executeBatch();
       conn.commit();
       System.out.printf("Number of records submitted %d.\n", counter);
       
                 
      } 
   catch (SQLException e) 
   {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   finally
   {
    if (stmt != null)
    {
     try 
     {
      stmt.close();
     } 
     catch (SQLException e) 
     {
      // TODO Auto-generated catch block
      e.printStackTrace();
     }
    }
   }      
        }
        
        public Object call() throws Exception 
        {
            run();
            return counter;
        }
  
 }

 /**
  * @param args
  * @throws InterruptedException 
  * @throws SQLException 
  */
 public static void main(String[] args) throws InterruptedException, SQLException 
 {
  // TODO Auto-generated method stub
  MultiThreadInsert test = new MultiThreadInsert();
  test.start();
 }
}

3. Output when run as follows.

Note: This was run on my MAC laptop which had 5 cache servers running on it. This would perform much better if I had 5 physical machines for each of the SQLFire cache server members.

Start: 0  End: 25000
Start: 75000  End: 100000
Start: 50000  End: 75000
Start: 25000  End: 50000
Number of records submitted 25000.
Number of records submitted 25000.
Number of records submitted 25000.
Number of records submitted 25000.
Elapsed time in seconds 4.409000


http://feeds.feedburner.com/TheBlasFromPas

Missed the Fishbowl Webinar on FishbowlToGo Mobile Phone Application? Get inside the Fishbowl and watch our video recap with Mobile Project Manager, Kim Negaard and Marketing Team Lead, Jason Lamon.

The post Get inside the Fishbowl: See our latest video recap from our FishbowlToGo Mobile Application appeared first on C4 Blog by Fishbowl Solutions.

With the OSB Report Action we can add some tracing and logging to an OSB Proxy, this works OK especially when you add some Report keys for single Proxy projects but when you have projects with many Proxies who are invoking other JMS or Local Proxies than the default reporting tables (WLI_QS_REPORT_DATA, WLI_QS_REPORT_ATTRIBUTE ) in the SOA Suite soainfra schema is not so handy. I want to

Fishbowl Solutions recently held a webinar about our newest application for iPhone and Android – FishbowlToGo.  FishbowlToGo lets you easily access information on the go by putting Oracle WebCenter Content at your fingertips.

Unfortunately, we didn’t have enough time to get to all the questions that were posed during the Webinar.

Here are the answers to your questions:

Is there a list showing the differences between the free and paid versions?

Yes, the following table shows the differences between the free and premium versions of FishbowlToGo.

Free

Premium

Content Search

X

X

Favorites

X

X

Basic Document Info

X

X

Open-In Other Apps

X

X

Email Files

X

X

Workflow Queue List

X

X

Mobile-Optimized Full Document Info

X

Photo & Video Check-In

X

Check-In from Other Apps (Open-In)

X

Mobile-Optimized Search

X

Workflow Info & Comments

X

Workflow Approve & Reject

X

Native File Access

X

 

Who are the primary users for this app?

This application is designed for anyone who uses Oracle WebCenter Content and spends a lot of time away from their desk. This includes executives or directors running between meetings who need to approve contracts and get at important company information as well as sales reps who are on the road a lot or field services workers who need to check in images or access project plans from a worksite.

How can I access Oracle WebCenter behind a company firewall?

If you’re looking to access Oracle WebCenter behind the firewall in order to use FishbowlToGo, you can use a VPN client on your mobile phone to do so. This can be set up using either the built-in VPN client or a third-party VPN app such as SonicWall. The VPN connection should be configured in accordance with the settings provided by your organization’s IT department. Once connected, you will be able to access Oracle WebCenter and use FishbowlToGo inside the firewall.

Does the app work with eSignatures for use with WebCenter Content Workflow?

No, currently FishbowlToGo does not support the use of eSignatures within a workflow.

Is there the ability to prompt for comments when approving or rejecting workflows?

Yes, FishbowlToGo allows users to provide comments when rejecting workflow items. Currently Oracle WebCenter Content does not allow users to provide approval comments out-of-the-box however Fishbowl has added this capability with our Workflow Solution Set product. For more information on using these two products together please contact us.

Does the application support logging in with external AD accounts?

You can log in to the application with AD accounts when using a User Provider configured within Oracle WebCenter Content. The application does support Windows NTLM authentication.

Are you planning to include a custom branding with the paid license?

The paid version does not include custom branding out-of-the-box. Fishbowl has implemented custom branding for other customer projects and can discuss this with customers as needed. Please contact us to learn more.

How do I get pricing for an enterprise license?

Contact sales@fishbowlsolutions.com or call 952-465-3400.

Where can I get the app?

The free version is available on iTunes or Google Play. To start using it simply download the app and enter the server address you normally use to get to WebCenter. For premium features like workflow and check-in contact Fishbowl Solutions directly by emailing sales@fishbowlsolutions.com.

Still didn’t answer your question?  Feel free to email us at info@fishbowlsolutions.com.

 

 

The post Fishbowl Answers Your Questions About Our Newest App – FishbowlToGo appeared first on C4 Blog by Fishbowl Solutions.

Oracle came out with a clever new online course on Developing Applications with ADF Mobile. I really like the format: it's kind of like a presentation, but with with video of the key points and code samples. There's also an easy-to-navigate table of contents on the side so you can jump to the topic of interest.

I like it... I hope the ADF team continues in this format. Its a lot better than a jumble of YouTube videos ;-)

read more

FishbowlToGo is a mobile phone application for iPhone and Android that provides fingertip access to Oracle WebCenter Content. With simple swipe and touch gestures, the application empowers users to:

• Search for items using metadata or full-text
• Access and view items
• Check in photos, email attachments and other documents
• View, approve or reject workflow items

To learn more about FishbowlToGo including a demonstration of FishbowlToGo Premium features, please join us for a webinar on Thursday, June 6th. You can also check out the free version of the application by searching “FishbowlToGo” from the Apple App Store or Google Play.

We hope you will be able to join us!

 

Date: Thursday, June 6th Time: 1:00 – 2:00 PM EST, 12:00 – 1:00 PM CST Register Now! 

 

The post Fishbowl Webinar: Get Oracle WebCenter Content on your iPhone or Android with FishbowlToGo appeared first on C4 Blog by Fishbowl Solutions.

Searching for a specific document out of millions can be a daunting task, particularly if you don’t know what you’re searching for. Often the title is on the tip of your tongue, and you would know it if you saw it. Wouldn’t it be nice if search tools accommodated for vague criteria just as easily as pinpoint queries? What if users could take a heap of guesses and whittle it down into a small set of relevant results?

We set about to solve this problem for WebCenter Content by leveraging a tool designed to handle massive amounts of data. Microsoft’s PivotViewer feeds off data sources and molds them into views for the end user to consume. The most popular example of this technology in action is the Netflix catalog at http://netflixpivot.cloudapp.net, where 1000 movies from Netflix Instant are pulled down and organized by year, cast, rating, and more. The applications for such powerful control over this data are clear for anyone who can’t remember the name of the movie that starred so-and-so and was released at the turn of the century. We immediately recognized the value of this within the domain of Digital Asset Management, and so we brought it to WebCenter.

PivotViewer is a control for Microsoft Silverlight, which is installed as a browser plugin much like Flash. Once it receives a collection of data that it can understand, PivotViewer organizes the data by common attributes called facets, allowing documents to be sorted and filtered on any metadata field. The thumbnail rendition is pulled in to represent the document in the canvas. Silverlight operates asynchronously, meaning that it doesn’t need to wait for every image to download before it can be used.

PivotViewer grid view

This control is made accessible on the main search result page. In practice, users can perform a quick search for latest documents or use existing search methods to gather a large set of documents, and drill down from those results using PivotViewer. All that it needs is a QueryText parameter in the URL.

For example, say I was looking for a Powerpoint presentation that held an important piece of information, but I could only reliably identify it by its red background. I would first use the full-text search for fragments of content, narrowing candidates down to 200 or so results. These would be piped into PivotViewer to show two-dozen red-colored documents. Using the metadata filters, I would select the Presentation document type and the date range of its release, yielding 2 documents. This process allows quick retrieval in spite of the vague search criteria, and is much more precise than wading through 10 pages of possibilities.

Zoom-in details with quick links to the content info page and web viewable

Selecting a document brings up a short list of content information; these fields can be customized for each distribution of the component. Each of these fields is a hyperlink that can quickly create a filter on its value. Say that a collection of documents was checked in together: by finding one document and filtering on its Release Date and Document Type, the entire collection is immediately available to me. I can also create a filter across all fields with a keyword search.

Pivoting with PivotViewer

Complementing the default grid layout is a bar chart representation of results along any metadata field. This view is helpful for identifying patterns within data, allowing me to actively pivot on fields and drill down on interesting pockets of documents. Every action is recorded in a breadcrumb trail at the top of the control, so if I ever get lost, a few clicks will undo the filters I’ve added and get me back to where I was.

All of these features are packed into a content server component and ready to be installed in a few clicks. Contact our sales team at sales@fishbowlsolutions.com to discuss your search needs and schedule a demo.

 

The post Responsive Search with PivotViewer appeared first on C4 Blog by Fishbowl Solutions.

Senior Software Consultant, AJ LaVenture recaps the new Multi-Upload and Batch Metadata Editor just released from Fishbowl Solutions!
This software component  allows you to upload and tag lots of content at once, saving time and frustration.

Hear about all the benefits now: http://bit.ly/17UG1rU 

The post Video Recap: WebCenter Content (Oracle UCM) Multi-Upload and Batch Metadata Editor appeared first on C4 Blog by Fishbowl Solutions.

Coming back from the EMC World conference in Las Vegas I was looking at the people playing on the slots and making ridiculous bets at Craps and wondering 'don't these people know anything about statistics?'.  Lets be clear I get the idea of it being fun, but when you sit next to someone on a blackjack table who twists when the dealer is showing a six and they've got 15 is just depressing. There

I find it useful to give a member a meaningful  name. In SQLFire you could simply give each member a name by adding a property "name" as follows to the sqlfire.properties file for the member.

sqlfire.properties

# sqlfire.properties for data store or accessor member
license-serial-number=XXXXXXXXXXX
name=server1

Note: The same can be done with GemFire as well.

Then when the system is up the ID for each system member includes the given name as shown below.

  
sqlf> select substr(id, 1 , 35) as "Member" from sys.members;
Member                             
-----------------------------------
172.16.62.1(server2:38971)<v2>:4265
172.16.62.1(server1:38970)<v1>:1660
127.0.0.1(38744):29535             

3 rows selected

http://feeds.feedburner.com/TheBlasFromPas

Fishbowl Solutions was recently featured on Oracle’s Blog during WebCenter Partners Week, showcasing our mobile application for iPhone/Android – FishbowlToGo. Mobility product manager, Kim Negaard authored a post detailing how our newest mobility venture helps WebCenter customers get the most from their investment.

Access Oracle WebCenter Content on your iPhone or Android with FishbowlToGo 

Fishbowl Solutions has been working with Oracle WebCenter customers since 2010 to extend WebCenter Content to mobile devices. We started working with mobile sales force enablement and have since extended our offerings to meet expanding customer needs. We are excited to announce the release of our newest mobile app, FishbowlToGo.

Read the whole blog post here: http://bit.ly/ZHLDxX

 

 

The post Fishbowl Solutions featured on Oracle Blog for WebCenter Partners Week appeared first on C4 Blog by Fishbowl Solutions.

Today I would like to share something Fishbowl Solutions has been working on internally for a little while now and started to implement at customer sites – Fishbowl Multi-Upload and Batch Metadata Editor.

This component was initially developed as part of Fishbowl’s Innovation Event. The combination of the first place and second place idea meshed very well together in delivering a seamless method for bulk contributing and editing metadata. This is now within production at a customer site with several modifications made to satisfy their requirements.

The main use case for this component is the mass uploading of content to get it into the system for categorization now, or at a later time.  Providing a staging ground for content to get it in the system and off the user’s desktop is crucial for an enterprise solution. In addition, the mass tagging and editing of metadata all at once is a feature that has been missing within content server from its inception.  As many of you know, Bex Huff of Bezzotech has a Microsoft Excel Spreadsheet (Remote Metadata Updater) that uses SOAP calls to communicate with content server to perform edits to content’s metadata after a search query is performed.  My goal was extend this functionality within Oracle WebCenter Content using modern-day advancements in JavaScript and browser capabilities.

This was done using a combination of several API’s, PlupLoad (Oracle uses an older version of this for their Drag & Drop upload feature within WebCenter Spaces Document Explorer Taskflow), Handsontable, JQuery, (in addition to extensively utilizing my WebCenter Content and Jquery Framework for calling WebCenter Content services) and Fishbowl’s overall knowledge of WebCenter and web development techniques.

The most compelling feature that was added for this deployment is “Profile Awareness”.  By this I mean all aspects of the profile and rules set up within content server are taken into consideration.  This includes, but is not limited to:

• Metadata field state (hidden, edit, info only, required, excluded)
• Custom field labels
• Standard list and profile restricted lists for drop down lists
• Date selection
• Default values for profiles
• Metadata field ordering if rule is set as a group

Here are several screenshots of the features and use case it provides (click on any of them to see actual sizes):

• A user had several images to upload and know they will go within a certain profile.  Navigate to the upload page and drag and drop the files into the drop area:

• All of the items are now checked into the content server into a private workspace for that user.  Within the workspace you can filter by keywords uploaded and categorize content by profile. (Note: You can also tag content without profiles as well).

• As there are bound to be erroneous uploads of duplicates, or extra files, supporting a delete function was crucial.

• The user is now ready to check the boxes for the items they want to categories and tag with final metadata.  Here we present the user with a spreadsheet within the browser.  This is built using the Handsontable JQuery plugin which supports common Excel like features; copy / paste, undo, and cell dragging.  UCM is integrated to provide a high level of context while editing this data; Dropdowns, date fields, required fields, and info only fields aid in user tagging.

• With column support for dropdowns and dates.

• Once the user is done editing, they can execute an update.  The table will provide feedback in real time as each item is updated.  The result of the update will be relayed to the user via row highlighting and an error / exception table informing them of the failure.

This expands upon the use case of updating content already in the system with the spreadsheet (Note: That use case is still supported, however, locked down to administrators only).

I hope you find this post compelling about the power that Fishbowl can provide by combining ideas from an innovation event with the years of experience Fishbowl has within the WebCenter Content (UCM) world to provide ease of contribution and bulk editing of content. For more information, feel free to reach out to us at 952-465-3400 or info@fishbowlsolutions.com.

Thanks,

AJ LaVenture
Senior Software Consultant

 

The post WebCenter Content (Oracle UCM) Multi-Upload and Batch Metadata Editor appeared first on C4 Blog by Fishbowl Solutions.

There is something that is beginning to irritate me, ok something else.  Its mobile applications that don't cache.  I'm fed up of travelling on a train or being on a plane and the end result being that my iPad or iPhone app doesn't work because I'm in an area that doesn't have reasonable network coverage.  I was using the App earlier when it had WiFi and it was all fine but the app requires me

Collaborate brought Fishbowl Solutions to Denver, Colorado this year. Overall, it was another well-coordinated and well-attended event. Special kudos go to Al Hoof and Dave Chaffee of the WebCenter SIG for IOUG (Independent Oracle Users Group). They spend a lot of time scheduling the WebCenter sessions, scanning the attendees who go to those sessions, and providing a friendly face each morning. Thanks again guys.

Here are some themes and hot topics that I picked up on this year. Some of these were discussed last year as well, but based on session attendance and booth traffic this year, these topics seemed to stand out even more and attendees dug deeper into benefits and ROI.

User Experience – Portals and Intranets

Some customers that deployed the initial versions of WebCenter Portal 11g struggled to roll it out on a large scale. Additionally, user feedback was pretty negative. Overall performance was poor and usability was marginal. Since those initial versions or patch sets, specifically PS2 and PS3, WebCenter Portal has become much more stable and usable. Customers have seen this as well, and they are now looking to evolve their initial deployments and create that next-generation intranet or portal.

One of the key considerations moving forward though is user experience. They want their portals and intranets to provide the flash or sizzle that make them inviting, but they also want the navigation to be intuitive and the contribution capabilities to be open yet governed. They are also looking for the overall user experience to be personalized, so that users have similar yet different experiences that help them to keep coming back. Lastly, they want their portals and intranets to be that true, one-stop shot that has always been the goal but has been hard to achieve. This means that they want to integrate data from other business applications, such as customer purchase history from PeopleSoft or JDEdwards, or employee expenses from E-Business Suite. The customers we talked to really stressed not only getting internal or external users to visit the intranet or portal, but also stay to consume or share information, and keep coming back. Again, the goal that customers are trying to achieve is to provide one view into the business processes or information that users need daily from one site – instead of having to jump between or open multiple applications to complete tasks or connect with others.

It was good timing for Fishbowl Solutions to be able to talk about portal and intranet use cases, and how those use cases could be further enabled or extended using our Intranet In A Box solution. WebCenter Customers are no different than other enterprise application customers – they all would like a starting point and “accelerator” to begin using the system. Fishbowl’s Intranet In A Box, as detailed in American Axle’s Collaborate presentation and white paper, helps them do just that. It also incorporates and enables user experience capabilities and application integrations, providing that portal or intranet jumpstart to build an enterprise system.

Mobile Content Management

No surprise that, once again, mobility and mobile content management were popular topics at Collaborate. In fact, they have been popular topics for many years now. I remember back to Collaborate 2010, which took place around the same time that the Apple iPad was released. Fishbowl Solutions announced its mobile strategy – extending WebCenter Content to smartphones – at this event as well, and it seems the excitement for mobile ECM has been building ever since.

2013 finds Oracle, and more specifically WebCenter, customers thinking about or planning their mobile strategy as it applies to content management. This seems to be the next evolutionary step for most organizations, which is being driven in party by the rise of the tablet and other mobile devices in the workplace. See our recent Mobile Tablet Application webinar for more details on tablet usage in the workplace. What used to be more of a pull from employees – I have a tablet, where are my business-enabled mobile applications and content? – is turning into a push from the business with governance and use case policies being put into place for mobile technologies. The reality is the mobile-enabled employee is the more productive employee, so organizations are providing this enablement but doing so with proper control and oversight.

This applies to extending high-value sales and marketing collateral, stored in Oracle WebCenter Content, to mobile devices as well. Customers that we talked to at Collaborate were aware of Oracle’s Application Developer Framework (ADF) Mobile, which Oracle announced in October of last year. We received questions on what the differences are between that solution and our Mobile ECM offerings, including our tablet and phone apps. The easy answer is that while Oracle ADF Mobile can be used to create feature-rich, powerful mobile applications, if WebCenter customers want to consume, share and interact with WebCenter assets from their mobile devices, they would have to build such an application themselves – pretty much fro scratch. Fishbowl offers packaged mobile offerings for iOS and Android, and we have customers in production with Applie iPads and Android tablets – including Banner Engineering (Collaborate preso and white paper).

Document Imaging – ROI

The last topic I would like to mention is document imaging. I’m not sure how many document imaging sessions there were at Collaborate, but I know the two I attended were packed. Document imaging and capture technologies continue to represent sure-fire ways to reduce business process costs. The most popular process where these technologies have been applied is invoice processing. Fishbowl Solutions was fortunate to partner with Land O’ Lakes for a presentation – here is their white paper as well – on their document imaging use case, and what really resonated in their presentation was the amount of manual invoice steps they were able to eliminate with document capture and imaging.

What stood out to me most from conversations at Collaborate was how hungry WebCenter customers were to realize ROI. Having made significant investments in the WebCenter stack over the years, they were looking for projects that would produce hard-dollar, measurable ROI. That isn’t to discredit how WebCenter is being used for websites, portals, or records management, but many times these use cases represent overhead that are much harder to measure. Document Imaging, and specifically Oracle’s end-to-end invoice processing system, helps organizations reduce invoice processing costs by reducing labor costs and late fees, while also making it possible for organizations to realize early pay discounts. For these reasons, I expect to see more WebCenter customers ramp up imaging projects over the next few years.

Collaborate returns to Las Vegas next year and will be held at the Venetian. Until then, good luck with your WebCenter projects, and feel free to contact Fishbowl if you need any assistance.

The post Collaborate 2013 Summary: UX, Mobile ECM, ROI appeared first on C4 Blog by Fishbowl Solutions.

In all of my career to date in IT there really has been three clear worlds in IT, the software development guys who are the bespoke tailors, the package guys who deliver off the shelf and the BI guys. I'm going to admit a prejudice here.  Until a couple of years ago my impression of BI guys was folks who were one step up from Excel guys.  It was dead-data and done in batches, sure it had to be

With the release of vFabric SQLFire 11 we can now start a JMX manager with the locator itself. To do that we add the following to the sqlfire.properties file of the locator itself.

jmx-manager=true
jmx-manager-start=true
jmx-manager-ssl=false
jmx-manager-http-port=8083

Then with the locator started we can verify we have it running on the default port of 1099 as shown below.

[Thu May 02 09:45:49 papicella@:~/sqlfire/vFabric_SQLFire_11_b40332/pasdemos/agent-test/locator ] $ netstat -an | grep 1099
tcp4       0      0  127.0.0.1.1099         127.0.0.1.64803        ESTABLISHED
tcp4       0      0  127.0.0.1.1099         127.0.0.1.64801        ESTABLISHED
tcp4       0      0  127.0.0.1.64801        127.0.0.1.1099         ESTABLISHED
tcp4       0      0  127.0.0.1.64803        127.0.0.1.1099         ESTABLISHED
tcp4       0      0  127.0.0.1.1099         127.0.0.1.64799        ESTABLISHED
tcp4       0      0  127.0.0.1.64799        127.0.0.1.1099         ESTABLISHED
tcp46      0      0  *.1099                 *.*                    LISTEN    

Finally start jconsole and connect using a service URL as follows

Format:

service:jmx:rmi://{hotname}/jndi/rmi://{hostname}:1099/jmxrmi

Example:

service:jmx:rmi://Pas-Apicellas-MacBook-Pro.local/jndi/rmi://Pas-Apicellas-MacBook-Pro.local:1099/jmxrmi

Once connected you can browse the MBean as shown in the image below.



More Information

http://pubs.vmware.com/vfabric53/index.jsp?topic=/com.vmware.vfabric.sqlfire.1.1/manage_guide/jmx/jmx_intro.htmlhttp://feeds.feedburner.com/TheBlasFromPas

Another talk I gave at Collaborate 2013 is this one on ADF Mobile and WebCenter. It builds off my talk from last year about general techniques, and gets into specific about the new ADF Mobile technology, and how to integrate it with WebCenter content and WebCenter Portal.

Integrating ADF Mobile with WebCenter from Brian Huff

read more

At Collaborate 2013 this year, Tony Field and I put together a talk about a topic that has been been floating around the WebCenter community as of late...How do I integrate WebCenter Sites (Fatwire) with WebCenter Content or Site Studio? We put together a handful of integration techniques, but the main focus was on upcoming features in the next version of WebCenter... specifically the official Sites/Content connector, and support for External Repositories. Cool by themselves, but when combined with Site Studio for External Applications, it's a compelling set of integration options:

Seamless Integrations between WebCenter Content, Site Studio, and WebCenter Sites from Brian Huff

read more

With the recently released vFabric SQLFire 11 version the query execution plan is much easier to read then previously. An example below.

  
[Wed May 01 11:32:11 papicella@:~/sqlfire/vFabric_SQLFire_11_b40332/pasdemos/sqlfire ] $ sqlf
sqlf version 10.4
sqlf> connect peer 'bind-address=localhost;mcast-port=12333;host-data=false' as peerClient;
sqlf> explain select * from emp where deptno = 20;
MEMBER_PLAN                                                                                                                     
--------------------------------------------------------------------------------------------------------------------------------
ORIGINATOR 192.168.14.167(73118)<v6>:61492 BEGIN TIME 2013-05-01 11:32:39.735 END TIME 2013-05-01 11:32:39.777
DISTRIBUTION to &
Slowest Member Plan:
member 192.168.14.167(72048)<v1>:42223 begin_execution 2013-05-01 11:32:39.74 end_execution 2013-05-01 11:&
Fastest Member Plan:
member 192.168.14.167(72048)<v1>:42223 begin_execution 2013-05-01 11:32:39.74 end_execution 2013-05-01 11:&

3 rows selected
sqlf> select STMT_ID, STMT_TEXT from SYS.STATEMENTPLANS;
STMT_ID                             |STMT_TEXT                                                                                                                       
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
00000001-ffff-ffff-ffff-000400000016| select * from emp where deptno = <?>                                                                                           

1 row selected
sqlf> explain '00000001-ffff-ffff-ffff-000400000016';
stmt_id 00000001-ffff-ffff-ffff-000400000016 SQL_stmt select * from emp where deptno = <?> begin_execution 2013-05-01 11:32:39.735 end_execution 2013-05-01 11:32:39.777
QUERY-SCATTER  execute_time 0.0 ms
  QUERY-SEND 
    RESULT-RECEIVE 
      SEQUENTIAL-ITERATION (0.38%) execute_time 0.136 ms returned_rows 5 no_opens 1
        RESULT-HOLDER  returned_rows 5 no_opens 1
          DISTRIBUTION-END (99.61%) execute_time 35.073 ms returned_rows 5
member 192.168.14.167(72048)<v1>:42223 begin_execution 2013-05-01 11:32:39.74 end_execution 2013-05-01 11:32:39.774
QUERY-RECEIVE 
  RESULT-SEND 
    RESULT-HOLDER  returned_rows 5 no_opens 1
      ROWIDSCAN (1.71%) execute_time 0.148 ms returned_rows 5 no_opens 1 node_details EMP : 
        CONSTRAINTSCAN (98.28%) execute_time 8.482 ms returned_rows 5 no_opens 1 scan_qualifiers None scanned_object APP.6__EMP__DEPTNO:base-table:APP.EMP scan_type  node_details WHERE : ((DEPTNO = CONSTANT:20) and true) 

http://feeds.feedburner.com/TheBlasFromPas

2 years ago I already did the same with ANT and now I migrated these scripts to Maven. These Maven poms can still do the same like my ANT scripts. Build and deploy an OSB OEPE workplace Build one OSB project. Export OSB projects from an OSB server and generate a customization plan. Here you can find my code https://github.com/biemond/soa_tools/tree/master/maven_osb_ps5 or the PS6 version https: