ARIS Community - We Love BPM

How To - Establish a Database Connection (JDBC) in MashZone 2.0

chrneu's picture
by Christian Neu in MashZone posted on 2010-09-09

A new feature from MashZone 2.0 allows the use of new data sources. The JAVA Database Connectivity (JDBC) plays an important role here. It allows users to establish connections to different database models. However it should be noted, that the JDBC isn't included in delivery with MashZone. Where you can get it and how you install it, will be described later.
In this post I will show you how to establish a connection with the help of an Oracle Database and output the data records of  demo tables.

First you must decide which database to use. As mentioned above, I decided to use an Oracle Database in the Express Edition, because it’s popular and has a demo data record. To use it, you must configure certain allocations. This How To assumes that the database user “HR” is unlocked and otherwise the JDBC Driver of Oracle is copied in the MashZone folder. This can be done in the following manner:

Open the Adminstration interface of Oracle http://127.0.0.1:8080/apex/ and log in with “system” and the password you specified in the setup. Afterwards, switch to the user administration, unlock “HR” and change the password.

Alter User

Change Password

Now you need the JDBC Driver so that MashZone can establish a connection to the database. This is the default setup folder, which was automatically selected during setup:
C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib
Copy  the file “ojdbc24.jar” and paste it accordingly in the subfolder “jdbcdrivers” of MashZone 2.0.

 

Now, to set up the database, reboot the MashZone server, switch to the "Administration" tab and select the new item "Database Connection". Once there click on "Create" and enter the following values:

Add Connection

Driver: oracle.jdbc.driver.OracleDriver
Database URL: jdbc:oracle:thin:@localhost:1521:XE

When your input is saved, click the button "Test database connection" to test the settings you entered. Now you are asked to specify the user data for the test connection.

Connection Test

If your login was successful the following message appears: "Connection test with database ‚Oracle Database‘ successful."

Now switch to the Feed editor, create a new data feed and select "Database" as the data source. The following shows a window that displays the database you just created.

Database Source

Select Database Connection

 

Now select this database and confirm it with „OK“. As user enter the user “HR” which was already tested above. For this post, I invented a connection between the employees and their departments as an SQL statement. Due to this, the IDs between “Employees” and “Departments” were compared: „SELECT First_Name, Last_Name, Department_Name FROM Employees, Departments WHERE Employees.Department_ID = Departments.Department_ID“

Database Query

If you want to experiment with your own instructions, there are several programs that can help you:
SQuirrel
- Eclipse- DBVisualizer

 

A detail of the results can be seen in the following table:

Result Demo Database

 

Congratulations on your first database connection in MashZone 2.0!

Note: See this post for a list of other articles about MashZone 2.0. You might be also interested to join the ARIS MashZone group at ARIS Community.

25812 Views
0 Likes
9 Comments
Sorry there are no tags
There are no attachments
Michael Bevilacqua posted on 2010-10-21

Comment pending review.

Mojtaba Hedayatinia posted on 2010-12-21

Dear Christian,

Thank you very much for this post. very useful.

Markus L. posted on 2011-05-27

Dear Christian,

do you have a comparable tutorial to connect ARIS MashZone to MS SQL Server? That would be helpful :-)

Stephan Freudl posted on 2011-05-30

Hi Markus,

no we have not but it is already part of your database vendo's documentation. All you need is its JDBC driver and its JDBC URL connection string.

Regards
Stephan

Parth Magu posted on 2017-05-29

Stephan ,

I have a query I am new to Aris .

Below is the query .

eeed your help 

Hi All ,

 

I need Help .

I am using Aris mashzone 2.3.1.0.1656 Version .

I am using mysql-connector-java-5.1.5.jar 

FIle installled in jdbcdriver folder in Linux .

I am able to connect to database with jar file .

 

However When I am running query in mashzone it throws me an error message .

"

Incomplete operator parameterization. The following fields or properties are not initialized:

Configure columns 

Can you please let me know where I am going wrong .

SQL queries executes fine in My SQL Yog .

Regards

Parth 

Kees Hoogenboezem posted on 2013-01-10

Dear Christian,

UPDATE: !@#$%^&*()_ it is working.

After writing this message I tried it again. I deleted the connection, made a new one with the same driver and it's working (no restart MashZone).
It looks like it is necessary to create a new connection when you change the driver.

We are trying to use  ARIS Mashzone 2.3 but we cannot connect to the Oracle database.
I have tried several drivers but all of them give an error:

The following error occurred when connecting to database "ARIS test": No suitable driver found for jbc:oracle:thin:@oyama.hhs.nl:1521:aristest

 

We are also using Business Publisher with jdbc and is working fine. I tried this driver and downloaded several drivers from Oracle. But all of them are giving the same error (after restarting Mashzone).

Do you have any suggestions?

 

Kees Hoogenboezem

 

 
Kushal Bangabash posted on 2013-02-07
Hi All,

I am new to ARIS MashZone and am facing an issue. I am connecting to Oracle database and am fetching some records for my data feed to be later used in a mashApp.

The connection is successfully tested but after every 4-5 runs to fetch the data from the data feed, i receive an error stating all database connections are in use and the connection fails.

I tried to increase the connection pool but it is somehow not helping the cause. I have also noted that if i test the connection after i receive this error, the connection test works fine and is successfull.

This is hard for me to work out and would need assistance from you all.

Thanking in advance,

Kushal Bangabash

vijay kumar posted on 2013-02-13

Hi Kushal,

please check the no of connection you provided from the aris mashzone under admin page.

also check the cache time u have set to have the data fetch from the datafeed to fetch the data.

I assume u are connecting to the data base and the cache time set is default 5 sec. which is too low and also the no of connections available are less in number so there is no connnections left after few hrs.

 

Please share screenshots of the above if that doesnot work.

 

Also tell how frequently u are assessing the Database through the aris mash app .

 

Thanks,

Vijay.

 

Parth Magu posted on 2017-05-29

Hi All ,

 

I need Help .

I am using Aris mashzone 2.3.1.0.1656 Version .

I am using mysql-connector-java-5.1.5.jar 

FIle installled in jdbcdriver folder in Linux .

I am able to connect to database with jar file .

 

However When I am running query in mashzone it throws me an error message .

"

Incomplete operator parameterization. The following fields or properties are not initialized:

Configure columns 

Can you please let me know where I am going wrong .

SQL queries executes fine in My SQL Yog .

Regards

Parth Magu

 

"