All Forums Teradata Applications
Claudia 4 posts Joined 09/09
22 Oct 2009
JMS Adapter.

Does anyone use JMS Adapter?

I have some issues with this tool:
1) When the queue has too many rows JMS Adapter try to insert into teradata with some value mixed. For example, into the field date it puts a number. And the row goes to the error table in Teradata.
2) When exists some NULL value JMS Adapter can not insert into Teradata.

Please, I need some help with this issues.
Thanks.

geonil 1 post Joined 12/09
14 Dec 2009

It seems you are using JMS Adapter - Loader which is taking jms messages from the jms queue into the teradata.
JMS Adapter should insert the date value into the teradata when jms message contains proper date field value.
Also, null value should be accepted when the teradata table's column is defined as Nullable.

Could you give me more detailed information about your environment, requirement or what are you going to do?

Thanks.

You must sign in to leave a comment.