Maven POM.xml

pom1

pom2

Text : 

<project xmlns=”http://maven.apache.org/POM/4.0.0&#8243; xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance&#8221; xsi:schemaLocation=”http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd”&gt; <modelVersion>4.0.0</modelVersion>
<groupId>TestConfig</groupId> <artifactId>TestConfig</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>jar</packaging>
<name>TestConfig</name> <url>http://maven.apache.org</url&gt;
<properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> </properties>

<build> <plugins> <!– Compiler plug-in –> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <configuration> <source>${jdk.level}</source> <target>${jdk.level}</target> </configuration> </plugin> <!– Below plug-in is used to execute tests –> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-surefire-plugin</artifactId> <version>2.18.1</version> <configuration> <suiteXmlFiles> <!– TestNG suite XML files –> <suiteXmlFile>testng.xml</suiteXmlFile> </suiteXmlFiles> </configuration> </plugin> </plugins> </build>

 

<dependencies> <dependency> <groupId>org.testng</groupId> <artifactId>testng</artifactId> <version>6.9.10</version> <scope>compile</scope> </dependency> </dependencies></project>

Configure Cucumber with Maven

What is Cucumber JUnit Runner?

It is important to recognize what Junit is, earlier than we start our discussion for Cucumber JUnit Runner. JUnit is an open source unit trying out framework for the Java programming language. JUnit has been crucial in the development of test-driven development, and is one of a family of unit testing frameworks, that is together referred to as xUnit that originated with SUnit.Read More »

Connect to ORACLE Database in Blueprism

The OLEDB object can be configured to support connections to Oracle databases. The OLEDB object uses the Jet OLE DB 4.0 connection capability, and so supports a number of OLEDB standard databases. By design the Provider String uses a generic format which is designed to cater for basic OLEDB connections. Oracle, however, requires slightly different parameters to the standard connection string.Read More »

Connection to a Microsoft Access database?

You can retrieve data using an SQL query connected to an MS Access database by using the Blue Prism Business Object called “Data – OLEDB” found within the Business Object called “BPA Object – Data – OLEDB.xml”. This is one of the processes that comes with the product, and can be imported from the VBO directory beneath the installation folder for Blue Prism (by default ‘C:\Program Files\Blue Prism Limited\Blue Prism Automate\VBO’).

OLEDB support and the JET 4.0 Provider

The OLEDB object uses the Jet 4.0 OLEDB interface to connect to MS Access by default. The OLEDB provider information can be modified to suit whichever provider you have installed and wish to use – it is not restricted to Microsoft Access. The Jet 4.0 provider string is provided by default, and this will support a large number of OLEDB connections, including Access databases up until Access 2007, when the Jet 4 provider was deprecated, and the ACE engine was used instead (.ACCDB files).

The existing connection string looks like this:-

“Provider=” & [Provider] & “; Data Source=” & [Database] & “;”  – no password required

“Provider=” & [Provider] & “; Data Source=” & [Database] & “; Jet OLEDB:Database Password=” & [Password] &”;”  – where a password is required

In the Calculation Stage where the password is required the JET 4.0 OLEDB provider has been coded in. You are free to change this.

Changing the Connection String

The Connection String can be modified to create whatever connection you need to an OLEDB compliant database. The Initialise page of the “Data – OLEDB” Business Object allows for the setting of  the most common Connection String parameters. You may add whichever ones you need to create your custom string.

The Set Connection page is the part of the process which uses the Connection parameters to form the connection string depending n whether a password is required or not. You are free to change these Calculation Stages to set whatever parameters you need.

For a list of the different Connection Strings used by most OLEDB compliant data structures please refer to the web site www.connectionstrings.com.

Functions:-

Set Connection

INPUTS

  • Database – supply the full file path to the Access .mdb database file
  • User – the name of an authorized Access user
  • Password – the password for the Access user account

Get Collection

INPUTS

  • SQL – a string containing the SQL query to retrieve data e.g. “SELECT * FROM myAccessTable”

OUTPUTS

  • Results – create a Collection Data Item in your process and use the collection in the ‘Store In’ parameter.

Troubleshooting

When the standard JET 4.0 OLEDB Provider has been used to try to access a database that was created using Microsoft Access 2007 or later, then the following error message may be seen:

“Internal: Could not execute code stage because exception thrown by code stage: Unrecognized database format ‘< path to database file>’.”

This can be resolved by changing the OLEDB provider used in the Connection String to be one that is suitable for the version oof Access that the database was created in.

Read More »