BigDecimal Null Pointer Exception
When trying to view data from a column with a data type of Decimal in designer, I get the following error:
See com.borland.dx.dataset.DataSetException error code: BASE+87
com.borland.dx.dataset.DataSetException: Execution of provider failed.
....
....
Chained exception:
java.lang.NullPointerException
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getBigDecimal(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.a(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.c(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideMoreData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.provideMoreData(Unknown Source)
at com.borland.dx.dataset.DataSet.getDisplayVariant(Unknown Source)
at com.borland.dx.dataset.DataSet.getDisplayVariant(Unknown Source)
at com.borland.dbswing.JdbTable.prepareRenderer(JdbTable.java:1932)
at javax.swing.plaf.basic.BasicTableUI.paintCell(Unknown Source)
at javax.swing.plaf.basic.BasicTableUI.paintCells(Unknown Source)
at javax.swing.plaf.basic.BasicTableUI.paint(Unknown Source)
at javax.swing.plaf.ComponentUI.update(Unknown Source)
....
....
This error only occurs when trying to view a decimal column. I am able to view data in all my other columns.
I have found information that points to being an issue with the Borland component, but I can't find anything about upgrading the component to a version that does not call the deprecated method getBigDecimal.
I am about to try changing the datatype to something other than decimal, but this is not the ideal solution, as it would mean manually changing every column that has a decimal data type.
Has anyone run into this issue, or have any ideas as to a workaround?