› › JDE/Oracle SQL error: Null Connection

JDE/Oracle SQL error: Null Connection


Scenario:

EBI server experiences periodic errors when connecting to Oracle database.

Issue:

Unable to perform SQL Select, SQL Insert via EXTOL Database Adapters/Bindings

EXTOL error message:


ERROR [com.extol.adapters.jdbc.JDBCInteraction] JDBC Resource Adapter encountered a Resource Exception: The connection to the database is null. Please verify that the Database Driver Settings for the Adapter are correct., ErrorCode=null

Exception detail:

javax.resource.ResourceException: The connection to the database is null. Please verify that the Database Driver Settings for the Adapter are correct.


ERROR [com.extol.processcontrol.adapter.JDBCAdapter] JDBC Resource Adapter received an Exception: JDBC Resource Adapter received a Standard Exception while attempting to SELECT: JDBC Resource Adapter received a Resource Exception: The connection to the database is null. Please verify that the Database Driver Settings for the Adapter are correct.

Exception detail:

com.extol.util.message.StandardException: JDBC Resource Adapter received a Standard Exception while attempting to SELECT: JDBC Resource Adapter received a Resource Exception: The connection to the database is null. Please verify that the Database Driver Settings for the Adapter are correct.



Resolution:

Recent hardware errors was causing intermittent issues when transacting with Oracle DB. The hardware issues originated with a Brocade switch and the EMC Service Processor. A switch was replaced along with a Service Processor.

Further troubleshooting occurred with VMWare.
By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.