- We have come across an issue with JBEDS with doing merge join between two datasets, where the join column is stored as a string in one database and an integer in another. The problem is that the federated query requires the sources to order the datasets before sending to JBEDS, and that one database will order alphabetically and the other will order numerically. Thus alphabetically 2 is greater than 100.
- Is this a bug in JBEDS? What is the recommended solution?
- JBoss Enterprise Data Services (JBEDS) 5.2.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.