Instead of SELECT MAX(ORDEN) FROM demo_planta2.dbo.ORDEN_VENTA_CAB
Use an alias in the projection column: SELECT MAX(ORDEN) foo FROM demo_planta2.dbo.ORDEN_VENTA_CAB Juan On Fri, May 12, 2023 at 8:46 PM scott <tcots8...@gmail.com> wrote: > 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 <lcarm...@openpartner.cl> > 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 <lcarm...@openpartner.cl> >> > 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 < >> > > lcarm...@openpartner.cl> >> > > > 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 >> > > > > >> > > > > >> > > >> >>
