topic Re: Error Exception in component talendStats_DB in Talend Studio

Error Exception in component talendStats_DB

_AnonymousUser — Mon, 24 Nov 2014 16:41:59 GMT

Hi, I have a problem with version 5.2 of Talend:
Exception in component connectionStatsLogs
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:323)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:268)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:191)
at routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:62)
at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)
at ecce_etl.tw_complete_0_1.TW_COMPLETE.connectionStatsLogsProcess(TW_COMPLETE.java:2727)
at ecce_etl.tw_complete_0_1.TW_COMPLETE.preStaLogConProcess(TW_COMPLETE.java:752)
at ecce_etl.tw_complete_0_1.TW_COMPLETE.runJobInTOS(TW_COMPLETE.java:5130)
at ecce_etl.tw_complete_0_1.TW_COMPLETE.main(TW_COMPLETE.java:4934)
Exception in component talendStats_DB
java.lang.NullPointerException
at ecce_etl.tw_complete_0_1.TW_COMPLETE.talendStats_STATSProcess(TW_COMPLETE.java:3857)
at ecce_etl.tw_complete_0_1.TW_COMPLETE.runJobInTOS(TW_COMPLETE.java:5142)
at ecce_etl.tw_complete_0_1.TW_COMPLETE.main(TW_COMPLETE.java:4934)
Exception in component tJDBCInput_1
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:323)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:268)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:191)
at ecce_etl.tw_complete_0_1.TW_COMPLETE.tJDBCInput_1Process(TW_COMPLETE.java:1707)
at ecce_etl.tw_complete_0_1.TW_COMPLETE.runJobInTOS(TW_COMPLETE.java:5151)
at ecce_etl.tw_complete_0_1.TW_COMPLETE.main(TW_COMPLETE.java:4934)
Exception in component talendStats_DB
Has anyone had a similar problem?
thanks

Re: Error Exception in component talendStats_DB

Anonymous — Tue, 25 Nov 2014 08:10:51 GMT

Hi,
What's your JDK? And did you set the CLASSPATH for java/bin? Does this issue repro on other build version(Talend 5.6)?

Have you already checked document: TalendHelpCenter:How to install external modules in the Talend products?

Best regards
Sabrina

Re: Error Exception in component talendStats_DB

_AnonymousUser — Tue, 25 Nov 2014 08:43:22 GMT

Hello, I use the
java version "1.6.0_33"
OpenJDK 64-Bit Server VM (build 23:25-b01, mixed mode)
I state that use the Implicit tContextLoad from File
and the problem occurs when I value the context during export.
As soon as I start the .sh returns the above error because Talend can not see the connection Db Connections "General JDBC".
How do I make him see the connections from file?

Best regards
Anna

Re: Error Exception in component talendStats_DB

Anonymous — Tue, 25 Nov 2014 08:53:55 GMT

Hi,
Would you mind sharing your current job screenshots with us? How did you set your implicit tContextLoad in job review?
Best regards
Sabrina

Re: Error Exception in component talendStats_DB

_AnonymousUser — Tue, 25 Nov 2014 10:06:09 GMT

Below the images of the context set in the project

Re: Error Exception in component talendStats_DB

_AnonymousUser — Tue, 25 Nov 2014 10:08:38 GMT

Below the images of the context set in the project

Re: Error Exception in component talendStats_DB

_AnonymousUser — Tue, 25 Nov 2014 10:35:47 GMT

I can not upload the pictures ... it the url of the images

Re: Error Exception in component talendStats_DB

_AnonymousUser — Tue, 25 Nov 2014 14:48:59 GMT

Hi,
I configured the connection General JDB and exported has context:
https:// imagizer.imageshack.us/v2/517x437q90/r/633/IYjG4g.jpg
and I removed all parameters from the context:
http:// imagizer.imageshack.us/v2/784x490q90/r/674/TjVdvw.jpg
Then I set the project properties:
http:// imagizer.imageshack.us/v2/473x437q90/r/901/bEAIoQ.png
http:// imagizer.imageshack.us/v2/784x467q90/r/674/IVMIjE.png

and it returns the error already attached previously.
The error occurred when I used a set connection with Oracle DB:
http:// imagizer.imageshack.us/v2/451x437q90/r/673/1NxN7E.jpg
and I removed all parameters from the context:
http:// imagizer.imageshack.us/v2/784x491q90/r/912/wBFJzf.jpg

(I have problems with the link, remove the blank space after http:// )

Re: Error Exception in component talendStats_DB

Anonymous — Tue, 25 Nov 2014 15:05:27 GMT

hi,
are you that values from context file (you connection.properties) are loaded ?
did you try to see the result by printing the load of your context (check box in implicit load definition)?
the location of your driver is in a context variable ? it it in your file properties ?
regards
laurent

Re: Error Exception in component talendStats_DB

_AnonymousUser — Tue, 25 Nov 2014 15:52:24 GMT

Hi,
office file correctly connection.properties (with free OracleSID works while with GeneralJDBC not work).
DriverJar the file exists and is on the path EC_DATA_TRG_DriverJar = / opt / ETL / Talend / lib / ojdbc5.jar

regards
Anna

Re: Error Exception in component talendStats_DB

Anonymous — Tue, 25 Nov 2014 15:56:14 GMT

a simple question : why not use OracleSID so ?
regards

Re: Error Exception in component talendStats_DB

_AnonymousUser — Tue, 25 Nov 2014 16:08:39 GMT

Why I did a test with OracleSID but we use different DB and so we need JDBC General

regards
Anna

Re: Error Exception in component talendStats_DB

_AnonymousUser — Wed, 26 Nov 2014 11:20:57 GMT

hello, having received no response I made various tentivi and I found a solution valuing only the field and the field context.EC_DATA_SRC_DriverJar and context.EC_STAGE_SRC_DriverJar with a nonexistent path /opt/Talend/lib/ojdbc5.jar and I worked reading values right to file CONNECTIONS.properties
As this is not an ideal solution rest waiting for another solution.
regards
Anna

Re: Error Exception in component talendStats_DB

Anonymous — Wed, 26 Nov 2014 13:17:44 GMT

hi Anna,
Do you got a default value for your driver path in your context or values are only in file properties ?
I guess that when you build job Talend find driver path as it 's in that file.
When you build job, is there the driver .jar in lib repository ?

I guess no, because Talend seems to not find the driver jar as it's in a context value.
perhaps try to configure CLASSPATH variable system in your .bashrc


export CLASSPATH=$CLASSPATH;/path/to/your/lib/ojdbc6.jar

or try to copy driver jar directly in th lib package
hope I've been clear enought .. not sure
regards

Re: Error Exception in component talendStats_DB

_AnonymousUser — Wed, 26 Nov 2014 16:03:52 GMT

hello,
in the properties file have the correct value.
While in the context I put a default value otherwise I would go wrong.
The .jar is present in lib repository.

There is no way not to exploit the context and not make it go wrong?
regards
Anna