Marcus W Posted July 3, 2018 Share Posted July 3, 2018 hiwhen I read database fields within the Dataset_and_Query_Dialog the numeric fields have got the BigDecimal data type. But I want them to be Double. Where can I change that? I use the ojdbc8-12 driver for Oracle 11/12. I use Jasperstudio 6.0 and Eclipse Luna.greetzMarcussee also: https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v611/working-database-jdbc-connections Link to comment Share on other sites More sharing options...
hozawa Posted July 4, 2018 Share Posted July 4, 2018 Have you tried creating a new Variable of type Double and setting the Expression to be $F{BigDecimalField}.doubleValue() Link to comment Share on other sites More sharing options...
Marcus W Posted July 4, 2018 Author Share Posted July 4, 2018 Of course I know this possibility. But that's not the right answer to my question. :-)I want the "Read fields" button (Dataset and Query Dialog) to produce the data type "Double". Now it produces "BigDecimal". There must be a conversion table somewhere. Or is it hard-coded in the Oracle driver? Link to comment Share on other sites More sharing options...
hozawa Posted July 4, 2018 Share Posted July 4, 2018 If you open the "Dataset and Query Dialog," a list of field names should show. You'll be able to change the "Class Type" from there. Link to comment Share on other sites More sharing options...
Marcus W Posted July 5, 2018 Author Share Posted July 5, 2018 But that's too much work if you have many numeric fields. The fields should be Double without any interaction by human. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now