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
A free web counter provided by GoStats.