(WID/WPS) How to Connect to BPEDB in WPS

During the development of the real time projects ( For which runtime is WPS), we may need some mechanism through which we can customize the default BPC functionality.

To achieve this we should have connection details for BPEDB. We can either query from the tables of this DB or can export the results in a report (through Java)

In one of my project we needed a daily report of all the process instances which got failed during its life cycle.

Initially we did it manually using BPC explorer (Search by stop status) & generated a report out of it manually.

Later we came up with a reusable automated tool which queries from BPEDB and generates a report of required information automatically.

The following diagram illustrates the details required : 

Connection Details to connect to BPEDB

Note : Database URL could be anywhere; it should be C:/XX/XX.../databases/BPEDB.


Using Java :
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
Connection db2Conn = DriverManager.getConnection(<<DB_URL>>,<<DB_USERNAME>>,<<DB_PWD>>);