Posts Tagged ‘WCM’

No doubt, WebCenter Sites has provided a great tool called CSExplorer in JSK for exploring the Database contents. But this tool has limitations. This works only on the Windows environments. But in reality, developers work on different environments aswell like MAC, Linux, etc.

I really felt bad when I couldn’t find someway to explore the database contents. while working on MAC. Fortunately, I have gone through some other website, and came to know how to explore the HSQLDB using eclipse.

I want to explain now how to explore the underlying tables of WCS using Eclipse, more elaborately.

Step  1 :

Open your server.xml file. It can be found under the below location:

[WCS installation Dir ]/apache-tomcat-7.0.42/Sites/conf/server.xml

Get the below values:

  • Username
  • Password
  • URL

See below screen shot.


Step  2:    

Have your eclipse installed. You can get it from

Step  3:     

Download the Data tools platform from eclipse marketplace. To do this, go to the Eclipse market place window, and search for ECLIPSE DTP (DATA TOOLS PLATFORM) 1.11.1 KEPLER, and install the plugin.


 Step 4:     

Now open the Perspective ” Database Development“.

You can do this by going to the Eclipse -> Window -> Open Perspective -> Other – > Database Development

Step 5: 

In the left hand, you will see a new tree opened called DATA SOURCE EXPLORER.

Right click on DATA CONNECTIONS, and click on NEW.


 Step 6:    

You will now get the following CONNECTION PROFILE window. Select HSQLDB from the available list of options, and click on NEXT button:


 Step 7:    

Enter the DB connection details in the below window:

Enter the following values from the inputs taken in step 1.

  • Database Location  : [WCS Installation Dir ] /App_Server/apache-tomcat-7.0.42/Sites/default/data/hypersonic/csDB
  • UserName  :   sa
  • Password    : blank

Then click on the TEST CONNECTION button. It shows a PING SUCCESSFUL dialog box. Now click on FINISH button.

DB Info Screen

NOTE:  You need to add the hsqldb.jar in the above window, by clicking on the + button available against the DRIVER  drop down.

Step  8:  

That’s it. In the Data source explorer tree of left hand side, you can see a new DB connection created to your local JSK. You can explore the tables as shown in the below screenshot.




That’s it for now.





Though I have started blogging on Documentum and Fatwire, I just thought of even blogging on Alfresco, so that I will cover Document Management (Documentum), Web Experience Management (Fatwire), Web Content  Management (Alfresco).

Exactly what is ALFRESCO?

Alfresco is the leading Open Source alternative for traditional Enterprise Content Management (ECM) softwares such as Documentum, Filenet, Sharepoint, etc. It covers almost all the branches of ECM, viz Document Management, Collaboration, Records Management, Knowledge Management, Web Content Management, and Imaging.

It is available free of cost to download and implement. The installers are of two types: Community Edition and Enterprise Edition. The Community edition is also called as Labs Edition, and it is for internal use in the organization, like development activities, etc. Where as the Enterprise edition needs subscription from Alfresco vendors, to implement it in production.

The Alfresco Community Edition is designed for use by developers and technical enthusiasts in noncritical environments.

The Alfresco Enterprise Edition is a production-ready, stress-tested certified build that is supported by Alfresco Software Inc. It is a fully-supported Alfresco Product.

Alfresco is completely built on the following open standards:

  • Java
  • Java Content Repository API
  • Java Portlet Integration
  • Spring Framework
  • Hibernate ORM Persistence
  • Lucene Text Search Engine
  • WebDAV
  • Open Office

The latest version of Alfresco Community Edition can be downloaded from here.

Alfresco provides the following Clients for the ease of access to the users:

  • Alfresco Explorer
  • Alfresco Share

Alfresco Explorer is the main client which is used to implement Document Management, and implementation Web Content Management.

Alfresco Share is the client which is used for easy share of documents (Like a Portal), hence the heavy consumption of bandwidth for transferring the documents can be avoided, and thus helps in Collaboration. Apart from the share of documents, it also provides wiki, sites, etc.