Data Management

Connecting to an Actian X (Ingres) Database From PHP via JDBC

Actian Corporation

March 8, 2019

x with light behind it for actian x

We have documented the best way to connect from PHP to an Ingres database via ODBC in an Actian Knowledge Base article called Ingres ODBC with PHP and in a previous post, Connecting to Actian X (Ingres) with PHP and NGINX. Sometimes, however, due to limitations, users may need to use JDBC instead of ODBC to connect. This post shows how this can be done, although no native support exists to connect through JDBC using PHP.

In this situation a PHP-JDBC bridge is necessary. For this example, we are using the bridge available at PHP-JDBC Bridge.

Validate JDBC Connectivity

This assumes that a JDBC connection can be established. If you can run queries from a small test Java program using JDBC, then you can move to the next step.

Setup and Start the Bridge Service

Check the PHP_JDBC documentation (available at PHP-JDBC Bridge) on how to run install the necessary tools and run the service. An example of how this would run is:

java -cp “lib/pjbridge.jar:lib/commons-daemon-1.1.0.jar:$II_SYSTEM/ingres/lib/:$II_SYSTEM/ingres/lib/iijdbc.jar”
   Server com.ingres.jdbc.IngresDriver 4444 &

PHP Code Example

The following is an example of the PHP code to connect to the Ingres database:

<?php
   require "PJBridge.php"; 

   $dbHost = "localhost";
   $dbName = "testdb";
   $dbPort = "II7";
   $dbUser = "test_user";
   $dbPass = "test_password"; 

   $connStr = "jdbc:ingres://${dbHost}:${dbPort}/${dbName}"; 

   $db = new PJBridge();
   $result = $db->connect($connStr, $dbUser, $dbPass);
   if(!$result){
      die("Failed to connect");
   } 

   $cursor = $db->exec("SELECT * FROM test_table"); 

   while($row = $db->fetch_array($cursor)){
      print_r($row);
   } 

   $db->free_result($cursor);

For additional information or to arrange a demonstration please contact Professional Services at services@actian.com. You can learn more about Actian X here and visit our Actian X community forums here.

actian avatar logo

About Actian Corporation

Actian empowers enterprises to confidently manage and govern data at scale. Actian data intelligence solutions help streamline complex data environments and accelerate the delivery of AI-ready data. Designed to be flexible, Actian solutions integrate seamlessly and perform reliably across on-premises, cloud, and hybrid environments. Learn more about Actian, the data division of HCLSoftware, at actian.com.