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

[Anonymous]

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,

AK

[Anonymous]

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

[Anonymous]

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!

AK

[hosman]

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!

[Anonymous]

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?