Error Exception in component talendStats_DB

One Star

Error Exception in component talendStats_DB

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
Moderator

Re: Error Exception in component talendStats_DB

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Error Exception in component talendStats_DB

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
Moderator

Re: Error Exception in component talendStats_DB

Hi,
Would you mind sharing your current job screenshots with us? How did you set your implicit tContextLoad in job review?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Error Exception in component talendStats_DB

Below the images of the context set in the project
One Star

Re: Error Exception in component talendStats_DB

Below the images of the context set in the project
One Star

Re: Error Exception in component talendStats_DB

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

Re: Error Exception in component talendStats_DB

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:// )
Seventeen Stars

Re: Error Exception in component talendStats_DB

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
One Star

Re: Error Exception in component talendStats_DB

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
Seventeen Stars

Re: Error Exception in component talendStats_DB

a simple question : why not use OracleSID so ?
regards
One Star

Re: Error Exception in component talendStats_DB

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

Re: Error Exception in component talendStats_DB

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
Seventeen Stars

Re: Error Exception in component talendStats_DB

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 Smiley Happy
regards
One Star

Re: Error Exception in component talendStats_DB

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