In this post I’ll describe the way to manage database connections using Maximo’s connection management and user credentials.

For the database connection I use the psdi.mbo.DBShortcut class, this class is provided by Maximo. To create a database connection this library requires a psdi.security.ConnectionKey which can  can be obtained from the psdi.security.UserInfo class.

The UserInfo can be obtained either from an MboSet or the MXSession itself.

Here are 2 examples.

...
MXSession mxSession;
...
ConnectionKey connectionKey = mxSession.getUserInfo().getConnectionKey();
...

On the other hand one can generically get this object using the MXSession class.

...
MboSet mboSet;
...
ConnectionKey connectionKey = mboSet.getUserInfo().getConnectionKey();
...

Once with a connectionKey, a database connection is set using the psdi.mbo.DBShortcut class. It is created in the following manner.

<br> ...<br> DBShortcut dbShortcut = new DBShortcut();<br> dbShortcut.connect(connectionKey);<br> ...<br>

Executing DML statements can be done using 2 DBShortcut methods .executeQuery(String) or .execute(SqlFormat). I personally prefer the .execute(SqlFormat).

...
Date aDate;
...
String query = "select * from workorder statusdate > ?";
SqlFormat sqlF = new SqlFormat(query);
sqlF.setDate(1, aDate);
ResultSet resSet = dbShortcut.executeQuery(sqlF.format());
...

As a result the executeQuery returns a plain old java.sql.ResultSet which can managed as needed.

Very important is to close both the ResultSet as well as the DBShortcut whenever they’re not needed or you’ll be cursed by the infamous maximo error.

Related articles by Zemanta

• BMXAA6421E – The system could not connect to the JDBC source: (ibm.com)

BMXAA2714E: Each site must have 1 primary system.

After analysing the problem for a while I looked at the LOCSYSTEM database table and found out that more than one site didn’t have a primary system. Fisrt I had to find out which were missing:

select siteid from site
where
  not exists (
    select 1 from locsystem where siteid=site.siteid and primarysystem=1
  );

With this information I decided to add the primary systems to all these sites at a time, from the application. Unfortunately this didn’t do it, I kept on getting the same message.

Some time latter I came to the conclusion that Maximo was validating the data in the database, not taking into account the records that already existed in memory and were about to be saved to the database. This meant that I had to add these records directly to the database. I would have the database generate my own insert statements.

select 'INSERT INTO LOCSYSTEM (systemid,description,network,siteid,orgid,primarysystem,locsystemid,langcode,haslg) VALUES (''PRIMARY'',''Primary System'',0,'''+SITEID+''','''+ORGID+''',1,9999,''EN'',0)'
from site where not exists (select 1 from locsystem where siteid=site.siteid and primarysystem=1);

The resulting select gave me the insert statements, I only had to update the locsystemid with good values.

Posted from WordPress for Android

This document provides instructions for having Lock Out Tag Out info loaded on the Work Order Tracking application.

IBM Lock Out Tag Out info to be displayed on workorders – United States.

Related articles

• IBM Technote (FAQ): The Purpose of Classification in Create Service Request application (jacobdotcosta.wordpress.com)

We have the options of Select Value and Classification for the Asset field in the Create Service Request application, what is the advantage of using Classification over Select value?

Answer

The Select Value feature brings up a lookup dialog box that navigates to the Asset table as a whole, that lets end users associate an item to a Service Request.

More information on the IBM Site: IBM – The Purpose of Classification in Create Service Request application.

Related articles

• Import asset classification hierarchies and classification attributes with MIF (maximotimes.com)

via IBM Job Plans in Preventive Maintanance – United States.

Related articles

• IBM Maximo Calibration and IBM Maximo for Life Sciences Upgrade Issue in Version 7.5 (ibm.com)

From: http://bit.ly/ihm5vb