I haev a tMySqlInput object that is pointed at a view. host, port, and username are filled out. Database is blank - if I put anything in there the database refuses to connect. How do I get around this error? thanks ---- Exception in component tMysqlInput_1 java.sql.SQLException: No database selected at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2562) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2512) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476) at topcoolapps.iosappstoredata_0_1.iOSAppStoreData.tMysqlInput_1Process(iOSAppStoreData.java:540) at topcoolapps.iosappstoredata_0_1.iOSAppStoreData.runJobInTOS(iOSAppStoreData.java:1488) at topcoolapps.iosappstoredata_0_1.iOSAppStoreData.main(iOSAppStoreData.java:1353)
host, port, and username are filled out. Database is blank - if I put anything in there the database refuses to connect.
Do you mean you cannot put anything in database item? What version do you used? I have tested your issue on Talend open studio for Data Integration (5.2.1r95165), everything is ok. Would you mind giving us more info about your issue? Screenshots will be appreciated.
Best regards
Sabrina
