Connecting to an Actian X (Ingres) Database from PHP via JDBC
Actian Corporation
March 8, 2019
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.
Subscribe to the Actian Blog
Subscribe to Actian’s blog to get data insights delivered right to you.
- Stay in the know – Get the latest in data analytics pushed directly to your inbox
- Never miss a post – You’ll receive automatic email updates to let you know when new posts are live
- It’s all up to you – Change your delivery preferences to suit your needs