Hello Luis, Juan Pablo, I think I'm having the same issue with ExecuteSQL to connect with Azure serverless SQL endpoint using Active Directory. I have downloaded the official microsoft jdbc driver and all dependent jars, and my results seem the same as Luis reported. I am not sure what was done here to resolve the issue, when you said to add the column alias name. Can someone help clarify what was done to fix this?
Thanks, Scott On Fri, May 8, 2020 at 11:46 AM Luis Carmona <[email protected]> wrote: > > > 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 <[email protected]> > > 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 be it is cause the SWL server is too > > > old. > > > > > > And with jTDS I got the coneection, and was able to execute > > > Database > > > list Tables. But the processor ExecuteSQL is not working. > > > > > > Regards, > > > > > > LC > > > > > > > > > > > > > > > On Fri, 2020-05-08 at 02:27 -0300, Juan Pablo Gardella wrote: > > > > Did you try using mssql official jdbc driver? > > > > > > > > On Fri, 8 May 2020 at 01:34, Luis Carmona < > > > [email protected]> > > > > wrote: > > > > > Hi everyone, > > > > > > > > > > I am trying to execute a query to an MS SQL Server, through > > > jTDS > > > > > driver, but can't figure why is it giving me error all the > > > time. > > > > > > > > > > If I let the processor as it is, setting the controller service > > > > > obviously, throws the error of image saying "empty name". > > > > > > > > > > If I set the processor with Normaliza Table/Columns and Use > > > Avro > > > > > Types > > > > > to TRUE, then throws the error of the image saying "Index out > > > of > > > > > range" > > > > > > > > > > Th query is as simple as this: > > > > > > > > > > SELECT MAX(ORDEN) > > > > > FROM demo_planta2.dbo.ORDEN_VENTA_CAB > > > > > WHERE > > > > > CODEMPRESA=2 > > > > > AND > > > > > CODTEMPO=1; > > > > > > > > > > Please some tip about what could be wrong in my settings. > > > > > > > > > > Regards, > > > > > > > > > > LC > > > > > > > > > > > > > > >
