topic Re: Guess Schema Error in tSQL component in Talend Studio

Guess Schema Error in tSQL component

brama — Wed, 24 May 2017 12:08:02 GMT

Above error happens when we click Guess Schema. But it works fine when we hit Guess Query. Any suggestions to fix this, please?

Re: Guess Schema Error in tSQL component

Anonymous — Thu, 25 May 2017 08:47:58 GMT

Hi,

There is a "Class not found " exception. All jar files installed?

Is your DB connection Ok with you? What's talend build version you are using?

Best regads

Sabrina

Re: Guess Schema Error in tSQL component

Anonymous — Thu, 19 Oct 2017 06:12:27 GMT

Helo I'm having this isue... only when guessing schema, the full job can be run but I have to make a schema manually

Re: Guess Schema Error in tSQL component

brama — Thu, 19 Oct 2017 13:32:51 GMT

Hi,

Please ensure all the Jar files were installed and jar files are located within the Talend Folder where Talend exes are present.

Thanks,

Ram

Re: Guess Schema Error in tSQL component

Anonymous — Fri, 20 Oct 2017 03:14:04 GMT

Hi Ram,

Thank you for the answer. May I know what directory should I put the jar file into? Because when I download my TOS_DI, it can run without any installation.

This is my TOS_DI directory: I've no idea where to put my jtds file...

Re: Guess Schema Error in tSQL component

Anonymous — Tue, 24 Oct 2017 10:38:20 GMT

Hello,

Is there any jtds jar file under <TalendStudioInstallationPath>\plugins\org.talend.libraries.jdbc.jtds.jars_6.xxx.xx.xx\lib folder? Do you want to update your jtds jar file?

Best regards

Sabrina

Re: Guess Schema Error in tSQL component

Anonymous — Tue, 24 Oct 2017 10:42:37 GMT

Hi Sabrina,

Yes, it is exist: <InstallationPath>\plugins\org.talend.libraries.jdbc.jtds_6.4.1.20170623_1246

But I think, I Installed the driver from microsoft site, so that the error message when I clicked the Guess Schema button is: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver

How can I fixed this?

Thank you

Re: Guess Schema Error in tSQL component

Anonymous — Tue, 24 Oct 2017 10:44:34 GMT

Correction, There is not \lib\ directory inside <InstallationPath>\plugins\org.talend.libraries.jdbc.jtds_6.4.1.20170623_1246