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!
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.