Hi everyone,

  • My name is Andrew 
  • I am living in Thailand 
  • I am a Senior Software Engineer, and sometimes work as an Integration Architect 
  • I work on and support a huge implementation of IRIS as an Enterprise Service Bus. Actually, I think it is one of the biggest IRIS instances that is used exactly as a Service Bus (maybe the biggest). We do not have a very intensive inbound data flow, this is around 300 RPS, but my Productions contains thousands of Business Hosts, dozens of combined systems, and an amount of transmitted data of around 2 TB per week. So, my specialization is Interoperability. Feel free to ask me about app integration. BTW, I'm looking for an additional job for now.
  • My hobby is sports. Here in Thailand, all men must learn Muay Thai. It's a joke, of course, but Thailand and Thai boxing it is like Dagestan and wrestling. Maybe one day I'll change all these boring globals to the fighter's way 😁 (subscribe to my fighter Instagram: https://www.instagram.com/andrey.sklyaroff )
  • And my Link: https://www.linkedin.com/in/andrey-sklyaroff

I'm sure the problem is in a selected field. The warehouse has a varchar type on the database side and %String on the IRIS side. It's just a warehouse ID. I need to select a big JSON string as one field, one record.

I could go with this problem to the database team, but in external SQL console with the same driver (I used SQuirreL SQL) all works fine.

My main hypothesis is that there is some error on the Java Gateway level. But I don't understand what the Long type value means here. Long, it's a number, right? Selected field have type text.