Hi, I ran into the same issue. The situation is: The Connection to the MS SQL Server is defined in metadata. For this Database I have to use the MS SQL Driver. The JTDS is (for whatever reason) not working. When I'm using this connection I'm perfectly able to fetch the rows as long as I define the schema manually. As soon as I'm creating a tMSSQLInput and I try to guess the schema, Talend Studio is using the jtds driver desprite of what is configured. This results in in a ClassNotFoundException: org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaProcess$1: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at org.talend.designer.core.ui.editor.properties.controllers.GuessSchemaController$1.widgetSelected(GuessSchemaController.java:197) For me the expected behaviour would be that Talend Studio is using the driver which has been selected in the connection to guess the schema.
... View more
Hi, Im in the unfortunate situation to migrate a bunch of views from a big MS SQL Server 2005 database to a new hive cluster. The process must be developed in Talend. I now experienced a couple of problems: 1. It seems that Talend Studio is not able to guess the view schema correctly, which means that I have to create the internal schema on my own. Unfortunately the views I have to migrate have 200+ Columns. Anyone else experienced such problems or has some hints for me? Or is it just due to the fact that I have to deal with this **bleep**ty old database? 2. For work I'm using a Mac-Pro (2016) running on Sierra. I already adjusted the Xms (2GB) and Xmx (4GB) settings for Talend Studio but It's still slow as hell. Too many times the Studio is freezing. Closing the Studio in a normal way is not possible (kill -9 will do the job though) and in general it slows down the whole system performance. Anyone experienced the same behaviour with Talend Studio (6.4.1) and has some tips to improve the overall performance? Best Arne
... View more