[teiid-issues] [JBoss JIRA] (TEIID-4427) Migration to Teiid 9.0.0 - Materialized views error: Expected integer, but was bigdecimal
Mark Tawk (JIRA)
issues at jboss.org
Wed Sep 14 09:42:01 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13293291#comment-13293291 ]
Mark Tawk edited comment on TEIID-4427 at 9/14/16 9:41 AM:
-----------------------------------------------------------
i'm counting on ResultSetMetaDataImpl to create the view and stage tables columns data types; in the case of Aggregate function COUNT, the meta is returning Integer.
Here is the code used in this concern:
....
IntegerStatementImpl stmt = (StatementImpl) conn.createStatement();
ResultSetMetaDataImpl meta = (ResultSetMetaDataImpl) stmt.getResultSet().getMetaData();
for (int j = 1; j <= meta.getColumnCount(); j++) {
int colType = meta.getColumnType(j);
String className = JDBCSQLTypeInfo.getJavaClassName(colType);
......
}
was (Author: mtawk):
i'm counting on ResultSetMetaDataImpl to create the view and stage tables columns data types; in the case of Aggregate function COUNT, the meta is returning Integer.
Here is the code used in this concern:
....
IntegerStatementImpl stmt = (StatementImpl) conn.createStatement();
ResultSetMetaDataImpl meta = (ResultSetMetaDataImpl) stmt.getResultSet().getMetaData();
for (int j = 1; j <= meta.getColumnCount(); j++) {
int colType = meta.getColumnType(j);
String className = JDBCSQLTypeInfo.getJavaClassName(typeCode);
......
}
> Migration to Teiid 9.0.0 - Materialized views error: Expected integer, but was bigdecimal
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-4427
> URL: https://issues.jboss.org/browse/TEIID-4427
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 9.0
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 9.1, 9.0.5
>
>
> After migrating to Teiid 9.0.0, we are facing issues with existing views materialized on Oracle server.
> when fetching an Oracle materialized view that contains a column using date function like : "Month" or "Year" or "TIMESTAMPDIFF", we are getting the error : Expected integer, but was bigdecimal.
> If we go back to Teiid 8.11.3, the same materialized views fetch without any problem.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list