PowerBuilder Tips, Tricks, and Techniques

Berndt Hamboeck

Subscribe to Berndt Hamboeck: eMailAlertsEmail Alerts
Get Berndt Hamboeck: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Related Topics: Java EE Journal, Apache Web Server Journal, ERP Journal on Ulitzer

J2EE Journal: Article

Working with the Enterprise Portal

An Overview Part 1

TIP: In a production environment change the password to protect your enterprise portal from unwanted access and misconfiguration by other users.

To stop the portal, do the following:

  • Close the window containing Tomcat.
  • Click on the ASA icon in the taskbar and click on Shutdown.
To log in again in future sessions, simply start the database (startdb.bat) and Tomcat (starttomcat.bat) and launch the portal by using the URL http://demo.sybase.com: 4040/onepage/index.jsp. Use the username and password you used for your own user. Or, if you want to log into the Portal Studio, use the URL http://demo.sybase.com: 4040/onepage/index.html with the username opsuper and the password 0psuper.

Installing Sybase EP Full Version
Sybase Enterprise Portal 5.0 comes with six CDs. As you have seen, the Sybase EP evaluation version is easy to install. This is not really true of the "big" version, but Sybase doesn't expect you to figure it out yourself. It provides an "Installation Guide for Sybase Enterprise Portal Version 5.0" as a printed book in the box. As a general tip, you should read it before you start with the installation. This section gives you an overview on what's installed and explains some things that might not be clear after reading the Sybase documentation.

What's in the Box?
After opening the box, you will find a set of six CDs:

  • EP Adaptive Server Enterprise version 12.5 CD - The database server where the security database and portal database will be stored
  • EAServer Version 4.1.2 CD - The only component transaction server out there supporting J2EE and PowerBuilder components
  • Enterprise Security Version 2.5.2 CD - Adds single sign-on capabilities to your portal
  • EP Portal Interface and Search CD - Adds portlet and search capabilities to your portal
  • PowerJ Version 4.1.0 CD - A Java IDE you might use for developing components
  • PowerDesigner version 9.5 CD - A database-development tool
PowerJ and PowerDesigner aren't really needed to operate the portal, but I recommend installing PowerDesigner if you don't know the product. It's a great database-development and documentation tool (because version 9.0 enhanced the functionality for PowerBuilder and Java developers and application designers).

This doesn't sound like much, but a lot more comes with some of the products. For example, you will have a running SQL Anywhere Server database after installing the first CD.

What Will Be Installed?
The more complex the software becomes with every new version, the more is installed. If you installed the complete PowerBuilder 9 package, or if you already own a version of EAStudio, you know what I'm talking about. As a standard user, you might not really care about what's installed on your machine, but as a Sybase Enterprise Portal developer, you should know what's on your machine. As I mentioned, feel free to install PowerJ and PowerDesigner; all other CDs should be installed completely. Let's take a closer look at what will be installed and what it's good for.

The CIM Repository
The systems management architecture uses a common information model (CIM) database called the CIM Repository. The CIM Repository maintains a record of what managed components are installed and how to connect to them for monitoring and management. The CIM Repository is populated when you install EAServer or Enterprise Portal components. You could use the Web console that comes with your EAServer to read and display CIM information from the CIM Repository, such as installation location, error log location, statistical information, and so on.

Where to Find It
You can find the CIM repository in the folder Sybase\CIMRepository-3_0_0 on your hard drive.

To start the CIM Repository, run repository.bat in the bin directory; to stop the CIM Repository, run stoprepository.bat. If you open Windows Task Manager, you will see that there is a Sybase SQL Anywhere server database service either started or stopped, respectively.

Sybase has published a small Java application called CIMListVersions on its Web site (www.sybase.com/detail/1,6904,1020343,00.html) to read and display information from the CIM Repository to the user. This is the same information, for example, that the Sybase installer uses to verify already installed products. You simply execute it by typing this line: java -jar CIMListVersions.jar >versions.out.

The output is a text file where all your installed Sybase products are listed.

More Stories By Berndt Hamboeck

Berndt Hamboeck is a senior consultant for BHITCON (www.bhitcon.net). He's a CSI, SCAPC8, EASAC, SCJP2, and started his Sybase development using PB5. You can reach him under [email protected]

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.