topic Re: tMSSqlInput, tNeo4jOutput and the MONEY data type in Talend Studio

tMSSqlInput, tNeo4jOutput and the MONEY data type

Anonymous — Sat, 16 Nov 2024 11:49:30 GMT

I have a tMSSqlInput component connected to a tNeo4jOutput component.
The query in the tMSSqlInput component produces a column of DB Type MONEY. On the designer surface I am seeing a warning, "the schema's dbType not correct for this component" and the MONEY DB Type in the Schema dialogue is highlighted. If the type in the DB is money, what should the DB type in the Schema dialogue be set to? Or can this warning be ignored.
Furthermore, I am having trouble mapping it to a java type. Ideally I wish to pass the db value through to Neo4j as is, however, if I set a type of BigDecimal I receive an error:
java.lang.IllegalArgumentException: Unknown property type on: 126928.0000, class java.math.BigDecimal
If I use Long I lose my decimal places (obviously) or I have to convert to pennies (UK currency!) which is not ideal (but possible).
Am I trying to achieve the impossible?

Re: tMSSqlInput, tNeo4jOutput and the MONEY data type

Anonymous — Tue, 26 Nov 2013 02:45:35 GMT

Hi,
For the warning "the schema's dbType not correct for this component"
Please refer to related https://community.talend.com/t5/Design-and-Development/Warning-quot-the-schema-s-dbType-not-correct-for-this-component/td-p/71347.
For your data type, please upload your current DB schema sett screenshot into forum so that we can see if it is possible to convert it by tMap or tConverttype.
Best regards
Sabrina

Re: tMSSqlInput, tNeo4jOutput and the MONEY data type

Anonymous — Tue, 26 Nov 2013 09:41:05 GMT

Thanks Sabrina.
I have attached a screenshot of my schema settings. The first is for the tMSSqlInput component. The second is the tNeo4jOutput component connected to the tMSSqlInput.
With regards the warning I have been ignoring it and the job has been running fine. I just wondered why it should be so. I believe I have set all of the DB Types as should be clear in my screenshot?
All the best,
Chris