Re: ExecuteSQL not working

2020-05-08 Thread Luis Carmona
Thanks Juan Pablo. It did work !! Thanks. LC On Fri, 2020-05-08 at 13:54 -0300, Juan Pablo Gardella wrote: > Try again by adding a column alias name tonthe results. > > On Fri, May 8, 2020, 12:21 PM Luis Carmona > wrote: > > Hi juan Pablo, > > > > I did, but jTDS was the only way

Re: MergeRecord performance

2020-05-08 Thread Robert R. Bruno
Sorry for the delayed answer, but was doing some testing this week and found a few more things out. First to answer some of your questions. I would say with no actual raw numbers, it was worse than a 10% degradation. I say this since the flow was badly backing up, and a 10% decrease in

Re: ExecuteSQL not working

2020-05-08 Thread Luis Carmona
Hi juan Pablo, I did, but jTDS was the only way achive the connection. With the offical jdbc driver always issued error about TSL protocol problems. After some reading, seems to be it is cause the SWL server is too old. And with jTDS I got the coneection, and was able to execute Database list

Re: ExecuteSQL not working

2020-05-08 Thread Juan Pablo Gardella
Try again by adding a column alias name tonthe results. On Fri, May 8, 2020, 12:21 PM Luis Carmona wrote: > Hi juan Pablo, > > I did, but jTDS was the only way achive the connection. With the > offical jdbc driver always issued error about TSL protocol problems. > > After some reading, seems to