topic Re: SQL statement working in Query builder but not in component view - table not found in Talend Studio

SQL statement working in Query builder but not in component view - table not found

Anonymous — Thu, 14 Nov 2019 17:33:48 GMT

Hello community,

i created a job to query data from a sybase DB. I added a connection in the meta data section which I the use in tDBConnection. To query data i use tDBrow wich i configured with the mentioned tDBConnection.

When i add my query in query builder and execute it, I get a adaquate result set also shown in the section of the query builder.

When I then use that configured query for my tDBrow component and start the job i get the following error:

[SAP][JDBC Driver][SQL Anywhere]table 'cc_statistik' not found

I am using jconn4.jar & sajdbc4.jar in my config.

What am I doing wrong? Why does the query work in the query builder but not in the component view?

Thanks in advance & best regards,

Re: SQL statement working in Query builder but not in component view - table not found

Anonymous — Fri, 15 Nov 2019 09:03:28 GMT

Hi
If the table already exists in database, retrieve the table schema under DB metadata, then drag and drop the table schema from Repository to a job, select tDBInput(Sybase) to query data from a Sybase DB. It will fill in the right syntax in the Query.

Regards
Shong

Re: SQL statement working in Query builder but not in component view - table not found

Anonymous — Thu, 21 Nov 2019 12:15:31 GMT

Hello Shong,

I did have the chance to try your proposal because I changed the DB-driver type to JDBC. That did the trick for me.

May be I check your way later.

Thanks for helping out!

Re: SQL statement working in Query builder but not in component view - table not found

hosman — Wed, 10 Jun 2020 14:52:56 GMT

Hi Arko,

how were you able to change the Db driver to jdbc?

I suspect that I'm facing the same problem.

Thanks for your reply in advance!

Best Regards!

Re: SQL statement working in Query builder but not in component view - table not found

Anonymous — Thu, 18 Jun 2020 12:23:59 GMT

Hi,

I created a connection in the meta data section and used context mode. In the context I am delegation to the specific drivers:

Hope that helps?