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 > > >
