Question
Asurion
US
Last activity: 17 Jul 2017 16:30 EDT
How to find the class in pr jar files
Hi All,
Is there a way to find the classes in pega jar files for example prpoi-3.6.jar , If I search the PR_EngineClasses table I can find these classes. I believe this jar contains the Apache POI api classes , but I'm not able to use the classes in POI api directly. does any one knows how to find the classes and methods in these pega jars , so that we can make use of it.
Thanks
***Updated by moderator: Marissa to close post***
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Yes doing a select against pr_engineclasses table for pzJar like ‘prpoi-3.6%' will show you the classes. The jar is a repackage of apache's prpoi library and is meant for Pega's internal use only. Having said that, don't believe the source code should be different from the one you can download from apache's website if you are curious about the APIs.
Asurion
US
Thanks Vipin , for the response . I want to know the pega equivalent class of POI class for example I cannot directly use org.apache.poi.hssf.usermodel.HSSFWorkbook Test= new org.apache.poi.hssf.usermodel.HSSFWorkbook(fileInputStream); in a java code it will throw error until I import apache's poi jar. I'm curious if I can use the classes in the prpoi ?
Does pzPackage column not tell you name of the package for the Class you are interested in?
Accepted Solution
Pegasystems Inc.
GB
A Vipin mentions the pzPackage column in PR_ENGINECLASSES should give you the information you are looking for.
Example:
SELECT pzpackage, pzclass, pzjar from pr_engineclasses
WHERE pzclass = 'HSSFWorkbook.class';
Result:
PZPACKAGE
com/pega/apache/poi/hssf/usermodel
PZCLASS
HSSFWorkbook.class
PZJAR
prpoi-3.6.jar
You can use the Advanced -> ETier Runtime Environment feature in SMA to perform a Java class lookup to verify the location of a particular class and help confirm you are using what you want / expect.
Example:
- Go to the Advanced -> ETier Runtime Environment menu in SMA
- Enter the fully qualified class (com.pega.apache.poi.hssf.usermodel.HSSFWorkbook in this case) in the "Java Class Name" input field.
- Press the "Lookup Java Class" button.
The result of the lookup will be displayed in the bottom half of the screen showing the location of the given class name:
| Java Class Lookup |
| Class Name | com.pega.apache.poi.hssf.usermodel.HSSFWorkbook |
| Location | pegajdbc://1589789075:0/prpoi-3.6.jar |
If the class cannot be found the Location will not be given as per the example below:
A Vipin mentions the pzPackage column in PR_ENGINECLASSES should give you the information you are looking for.
Example:
SELECT pzpackage, pzclass, pzjar from pr_engineclasses
WHERE pzclass = 'HSSFWorkbook.class';
Result:
PZPACKAGE
com/pega/apache/poi/hssf/usermodel
PZCLASS
HSSFWorkbook.class
PZJAR
prpoi-3.6.jar
You can use the Advanced -> ETier Runtime Environment feature in SMA to perform a Java class lookup to verify the location of a particular class and help confirm you are using what you want / expect.
Example:
- Go to the Advanced -> ETier Runtime Environment menu in SMA
- Enter the fully qualified class (com.pega.apache.poi.hssf.usermodel.HSSFWorkbook in this case) in the "Java Class Name" input field.
- Press the "Lookup Java Class" button.
The result of the lookup will be displayed in the bottom half of the screen showing the location of the given class name:
| Java Class Lookup |
| Class Name | com.pega.apache.poi.hssf.usermodel.HSSFWorkbook |
| Location | pegajdbc://1589789075:0/prpoi-3.6.jar |
If the class cannot be found the Location will not be given as per the example below:
| Location | class not found |
This can be a useful tool when investigating or reviewing class loading or class not found issues.
Asurion
US
Thanks Luke and Vipin