One Star

Script Giving "No database selected" error when run

I have successfully built one script using Talend which pulls data from an Excel file into a MySQL DB. I am looking to perform the same task, but with a new XLS and MySQL table. I have followed the same steps and have retrieved schema for both object types, but when I run the script, I am getting a "No database selected" error. The run calculates 600+ lines, but they do not insert into the DB. Any help is greatly appreciated.
7 REPLIES
One Star

Re: Script Giving "No database selected" error when run

Hi
Because you forgot to type a database name in tMysqlOutput.
Regards,
Pedro
One Star

Re: Script Giving "No database selected" error when run

Hello Mam/Sir,
                     I am Trying to Connect My Access Data to MySql. But Receiving the Error as "No DataBase Selected" inspite of i have choosen proper DataBase also.Please If u Know Help Me Regarding with this.Thank You. 
Five Stars

Re: Script Giving "No database selected" error when run

are you able to connect Ms Access db using metadata? try to create Metadata first then use same object in job. 
One Star

Re: Script Giving "No database selected" error when run

Ya i tried.Finally I got Result.Thank u.
One Star

Re: Script Giving "No database selected" error when run

Hi I have a data Base as Follows.
Employee    |      Employee ID       |      Email                    |      Position   |
__________________________________________________________
Steve         |   CS42                    |  steve12@gmail.com     | Manager      |
Steve         |   CS42                    |  steve12@gmail.com     | System Analyst      |
John           |   CS43                    | john42@gmail.com        |  Project Coordinator |
John           |   CS43                    | john42@gmail.com        |  Project Coordinator |
Steve         |   CS42                    |  steve12@gmail.com     | Manager      |
I want to Eliminate Duplicate Values and as well for the "Steve" both positions to be displayed in my database.It would be very helpful if anybody guide me.Thank You..
One Star

Re: Script Giving "No database selected" error when run

Hi,
I Have Huge Number Records Of MS Access Data Base.And I want Only 10000 records to be Displayed.In That Records we Have 2 Column Named "First Name" And "Last Name".And i Want To apply the condition that only 10000 records of "First Name" and "Full Name" to be displayed in Upper Case.Please Can Any One Help Me Regarding with this.How Shall we Apply Query in Ms Access Query Box.Thank You. 
One Star

Re: Script Giving "No database selected" error when run

I am also getting same error, but the scenario is different. I have multiple schemas, when use one schema with tMySqlConnection, and uses its one table as input, the job design could not recognize the schema as database. This error appears at input component properties, when I click at getSchema it shows No Database selected. 
Note: I have set the same schema in Component List option. So this is not the case that the database is not selected.