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