topic Re: Exception in component tJDBCInput_1 in Talend Studio

Exception in component tJDBCInput_1

_AnonymousUser — Wed, 16 Sep 2015 15:09:35 GMT

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]

Re: Exception in component tJDBCInput_1

Anonymous — Thu, 17 Sep 2015 03:25:37 GMT

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

Re: Exception in component tJDBCInput_1

_AnonymousUser — Thu, 17 Sep 2015 08:41:18 GMT

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

Re: Exception in component tJDBCInput_1

_AnonymousUser — Mon, 28 Sep 2015 17:07:09 GMT

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

Re: Exception in component tJDBCInput_1

Anonymous — Fri, 23 Oct 2015 09:19:10 GMT

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