Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Exception in component tJDBCInput_1

Hello i try to lookup Data with tJDBCInput Adapter.
Following Error appears:
Starte Job AirPlusLookup am 15:55 16/09/2015.

[statistics] connecting to socket on port 3443
[statistics] connected
Exception in component tJDBCInput_1
java.lang.ClassNotFoundException:
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at airplus.airpluslookup_0_1.AirPlusLookup.tJDBCInput_1Process(AirPlusLookup.java:3943)
    at airplus.airpluslookup_0_1.AirPlusLookup.tFileInputDelimited_1Process(AirPlusLookup.java:2043)
    at airplus.airpluslookup_0_1.AirPlusLookup.runJobInTOS(AirPlusLookup.java:4416)
    at airplus.airpluslookup_0_1.AirPlusLookup.main(AirPlusLookup.java:4273)
[statistics] disconnected
Job AirPlusLookup endet am 15:55 16/09/2015. [exit code=1]

Labels (2)
4 Replies
Anonymous
Not applicable

Hi,
It seems that something wrong with your Java environment variable.
 Did you follow up document TalendHelpCenter:Installation requirements to set your Java Environment variable?
Best regards
Sabrina
_AnonymousUser
Specialist III
Specialist III
Author

Hey i follow the up the document and set up the Java Environment variable and reinstall Talend

But noithing chaned the Problem ist the same:

[statistics] connecting to socket on port 3387
[statistics] connected
Exception in component tJDBCInput_1
java.lang.ClassNotFoundException:
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:191)
    at airpluslookup.airpluslookup_0_1.AirPlusLookup.tJDBCInput_1Process(AirPlusLookup.java:3951)
    at airpluslookup.airpluslookup_0_1.AirPlusLookup.tFileInputDelimited_1Process(AirPlusLookup.java:2049)
    at airpluslookup.airpluslookup_0_1.AirPlusLookup.runJobInTOS(AirPlusLookup.java:4424)
    at airpluslookup.airpluslookup_0_1.AirPlusLookup.main(AirPlusLookup.java:4281)

javac works and java -version reports:
java version "1.7.0_79"
Java(TM) SE Runtime Environment (build 1.7.0_79-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

which Driver jar needed tJDBCInput Adapter?
and which class is to be defined?

best regards
_AnonymousUser
Specialist III
Specialist III
Author

Hi,

I reinstall all  new.
The correct Java ist new installed and the Path is set bevor the installation.
Installed Talend and get it to a lot of Jar updates.

But Still get the thame error message

Starte Job AirPlusLookup am 18:03 28/09/2015.

[statistics] connecting to socket on port 3480
[statistics] connected
Exception in component tJDBCInput_1
java.lang.ClassNotFoundException:
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at airplus_lookup.airpluslookup_0_1.AirPlusLookup.tJDBCInput_1Process(AirPlusLookup.java:3951)
    at airplus_lookup.airpluslookup_0_1.AirPlusLookup.tFileInputDelimited_1Process(AirPlusLookup.java:2049)
    at airplus_lookup.airpluslookup_0_1.AirPlusLookup.runJobInTOS(AirPlusLookup.java:4424)
    at airplus_lookup.airpluslookup_0_1.AirPlusLookup.main(AirPlusLookup.java:4281)
[statistics] disconnected
Job AirPlusLookup endet am 18:03 28/09/2015. [exit code=1]

Need Help
Anonymous
Not applicable

Hi schmidpve2,
How did you set tJDBCInput component? Could you please upload the component setting screenshot into forum?
What's the DB do you want to connect?

Best regards
Sabrina