Bug 131465 Fetching date from MySQL returns bogus values
1) In MySQL I have a table with a column of type integer (Year int(11). 2) I run the following SQL statement SELECT date_format(makedate(year, 1), "%Y") FROM census c 3) Which returns the following 1980 1990 2000 4) When I run the same query inside a data set I get the following: 31 39 38 30 31 39 39 30 32 30 30 30 This looks like hex code that is not being translated back to character format.
data/org.eclipse.birt.report.data.oda.jdbc/src/org/eclipse/birt/report/data/oda/jdbc/ResultSetMetaData.java
return rsMetadata.getScale( index );
		}
		catch ( SQLException e )
		{
			throw new JDBCException( ResourceConstants.RESULTSET_MEATADATA_SCALE_CANNOT_GET,
					e );
		}
	}
	/*
	 * @see org.eclipse.datatools.connectivity.IResultSetMetaData#isNullable(int)
	 */
	public int isNullable( int index ) throws OdaException
	{
		logger.logp( java.util.logging.Level.FINE,
				ResultSetMetaData.class.getName( ),
				"isNullable",
				"ResultSetMetaData.isNullable( )" );
		assertNotNull( rsMetadata );
		try
		{
			
			return rsMetadata.isNullable( index );
		}
		catch ( SQLException e )
		{
			throw new JDBCException( ResourceConstants.RESULTSET_NULLABILITY_CANNOT_DETERMINE,
					e );
		}
	}
}