Exception in component tDBInput_1 java.sql.SQLException: No database selected

[Anonymous]

I am new to talend and I am trying to build a job to retrieve data from one table to another using tDBInput(MySQL). When i run the job, below error shows up. I even tried setting up the "useSSL=false" parameter for the component. 

Exception in component tDBInput_1 (SampleJob)
java.sql.SQLException: No database selected
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218)
at local_project.samplejob_0_1.SampleJob.tDBInput_1Process(SampleJob.java:1009)
at local_project.samplejob_0_1.SampleJob.runJobInTOS(SampleJob.java:1758)
at local_project.samplejob_0_1.SampleJob.main(SampleJob.java:1607)
[statistics] disconnected

Job SampleJob ended at 22:26 09/04/2019. [exit code=1]

Can someone please help me out?

[Anonymous]

Hi,

   Could you please share a screen shot of your problematic component for review? The error says you have not correctly selected the database. Please also check whether you have inserted all the parameters correctly. One last item to check is whether any firewall is preventing Talend to connect to DB (you will have to ping the DB with right port number).

    Based on your update, we will proceed further.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[joearun4u]

Hi @Appy1234 ,

This issue will be raised when your DB credentials are not supplied properly to the input component. Kindly provide screenshot to get more insight.

Also, go to the code view in talend and check where are you getting the error. take a screenshot of the error and post it to suggest easily.

Thanks,

Joe

Dont forget to give kudos or solution accepted when you found this reply is useful