Four Stars

Load records from a table of MySQL-Database to a new table of mysql

Hello,

Iam trying to load records from a MySQL-Database to a new table of the same database.

The error comes from the source "tMysqlInput" as you can see in the attached picture.

 

I use Talend Open Studio MDM.

 

Exception in component tMysqlInput_1 (load_mysql_to_mysql)

java.sql.SQLException: No database selected
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2832)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2781)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1569)
at local_project.load_mysql_to_mysql_0_1.load_mysql_to_mysql.tMysqlInput_1Process(load_mysql_to_mysql.java:862)
at local_project.load_mysql_to_mysql_0_1.load_mysql_to_mysql.runJobInTOS(load_mysql_to_mysql.java:1535)
at local_project.load_mysql_to_mysql_0_1.load_mysql_to_mysql.main(load_mysql_to_mysql.java:1384)

 

Thank you for any help

2 REPLIES
Employee

Re: Load records from a table of MySQL-Database to a new table of mysql

You should specify your database.  Check the settings of the components.  What is the config of the tMySQLInput component?

Four Stars

Re: Load records from a table of MySQL-Database to a new table of mysql

Thank you very much. The problem has been solved. The field from the database name in the settings for the tMySQLInput component was empty