[Mondrian] Mondrian 4 Failing on <Query>

William Back wback at pentaho.com
Fri Nov 2 20:26:21 EDT 2012


I'm encountering an exception when attempting to use the <Query> element.  

I get the following exception:

mondrian.rolap.RolapSchema$MondrianSchemaException: Unknown data type VARCHAR (-1) for column CountryRegionCode of view; mondrian is probably not familiar with this database's type system (in Query) (at line 38, column 4)
	at mondrian.rolap.RolapSchemaLoaderHandlerImpl.warning(RolapSchemaLoaderHandlerImpl.java:69)
	at mondrian.rolap.RolapSchemaLoaderHandlerImpl.warning(RolapSchemaLoaderHandlerImpl.java:59)
	at mondrian.rolap.RolapSchema$PhysSchema.describe(RolapSchema.java:1040)
	at mondrian.rolap.RolapSchema$PhysView.populateColumns(RolapSchema.java:1598)
	at mondrian.rolap.RolapSchema$PhysRelationImpl.ensurePopulated(RolapSchema.java:1502)

This is occurring because the return from metaData.getColumnType(i + 1) is -1.  However, the ResultSetMetadata has the following values:

	com.mysql.jdbc.Field at 489de27c[catalog=adventure_works_dw,tableName=c,originalTableName=dim_customer,columnName=CustomerKey,originalColumnName=CustomerKey,mysqlType=3(FIELD_TYPE_LONG),flags= PRIMARY_KEY, charsetIndex=63, charsetName=US-ASCII]
	com.mysql.jdbc.Field at 75806022[catalog=adventure_works_dw,tableName=g,originalTableName=dim_geography,columnName=CountryRegionCode,originalColumnName=CountryRegionCode,mysqlType=253(FIELD_TYPE_VAR_STRING),flags= BLOB, charsetIndex=8, charsetName=Cp1252]
	com.mysql.jdbc.Field at 3f279472[catalog=adventure_works_dw,tableName=g,originalTableName=dim_geography,columnName=StateProvinceName,originalColumnName=StateProvinceName,mysqlType=253(FIELD_TYPE_VAR_STRING),flags= BLOB, charsetIndex=8, charsetName=Cp1252]
	com.mysql.jdbc.Field at 3f82e8c2[catalog=adventure_works_dw,tableName=g,originalTableName=dim_geography,columnName=City,originalColumnName=City,mysqlType=253(FIELD_TYPE_VAR_STRING),flags= BLOB, charsetIndex=8, charsetName=Cp1252]

I would expect the call to return Types.VARCHAR rather than -1. 

Any ideas?  

Bill.




More information about the Mondrian mailing list