Oracle 10g SQL Access Error; Unsupported SQL column type -15

Oracle 10g SQL Access Error; Unsupported SQL column type -15

Scenario:

When trying to query to JDEdwards/Oracle 10g table we are receving an unexpected error Unsupported SQL column type: -15 in column 1

Issue:

During the set-up of the EBI 2.6 DataSource, the incorrect JDBC driver was chosen. The JDBC driver that was applied was designated for Oracle 12c.

EXTOL error message:


Message ID: 273
Primary: SQL Access error: SelectAllFromF5547: Unsupported SQL column type: -15 in column 1
Secondary:
Category: General
Type: Hard_Error
Process ID: actionLauncher
Issued by: class com.extol.transformationrules.SQLAction
Msg file: messages.emf
Issued on: Wednesday September 10, 2014 7:39:22.844 AM EDT

Message ID: 37
Primary: Unsupported SQL column type: -15 in column 1
Secondary: java.lang.IllegalArgumentException: Unsupported SQL column type: -15 in column 1
at com.extol.adapters.jdbc.JDBCTypeMap.getColumnValue(JDBCTypeMap.java:238)
at com.extol.transformationrules.ExecutableSQLAction$SQLActionPerformer.a(ExecutableSQLAction.java:132)
at com.extol.transformationrules.ExecutableSQLAction$PreparedSQLAction.d(ExecutableSQLAction.java:4)
at com.extol.transformationrules.ExecutableSQLAction$SQLActionPerformer.performAction(ExecutableSQLAction.java:68)
at com.extol.transformationrules.ExecutableSQLAction.execute(ExecutableSQLAction.java:8)
at com.extol.userinterface.ActionLauncher.actionPerformed(ActionLauncher.java:235)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

Resolution:

Update the DataSource to use the correct JDBC Driver. Once the JDBC driver is updated the errors went away.



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.