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

Anonymous — Thu, 28 Sep 2017 02:17:19 GMT

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

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

Anonymous — Thu, 28 Sep 2017 02:31:30 GMT

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

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

Anonymous — Thu, 28 Sep 2017 02:46:54 GMT

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

topic Load records from a table of MySQL-Database to a new table of mysql in Talend Studio

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

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

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