topic Re: Oracle Connection in Talend Studio

Oracle Connection

Anonymous — Fri, 28 Dec 2012 02:44:00 GMT

Hi everyone,
Why my job can't retrieve the schema if I use an existing connection (Oracle) at tOracleInput. I throws an error something about driver. Schema can be retrieved only if I define the connection settings again.
FYI, I use context value from config file (external file), that's why I didn't use metadata.
Your help is very much appreciated!

Re: Oracle Connection

Anonymous — Fri, 28 Dec 2012 03:20:54 GMT

Hi,
When i met this issue, just choose the Repository and click the "...." option in Schema to find is there the related schema of your table. But for your situation,

FYI, I use context value from config file (external file), that's why I didn't use metadata.

i never use context value before.
Best regards
Sabrina

Re: Oracle Connection

Anonymous — Fri, 28 Dec 2012 06:49:52 GMT

Hi Sabrina,

When i met this issue, just choose the Repository and click the "...." option in Schema to find is there the related schema of your table.
Sabrina

So it must be from repository and cannot from built-in schema?
Thanks and regards,
Rozie

Re: Oracle Connection

Anonymous — Fri, 28 Dec 2012 07:01:12 GMT

Hi,
Yes, I often do this to solve such issue, why do you try it and let me know the result.
Best regards
Sabrina

Re: Oracle Connection

Anonymous — Fri, 28 Dec 2012 13:03:02 GMT

This problem is caused by a inconsistent library path for the generated java program. I had this problem also recently (with an other database) and solved this: delete <talend-studio-install-dir>/configuration/ComponentCache.javacache
Normally the tOracleConnection knows it libs and carry all necessary jars. As a developer you usually cannot do anything wrong here.
If you create an connection not by dragging it from repository it should also find the driver, because the repository fills only the host, schema, user, password etc. data and not the driver class name or help loading it.