One Star

[resolved] SQL Builder cannot take over Query Textarea in component tab

Hi, guys.
Simply I followed tutrial of DB connection ( www.talendforge.org/tutorials/tutorial.php?language=english&idTuto=16),
however, got an incident.
How to take over the SQL shown into Component properties textarea to SQL Builder

I connected to MySQL DB successfully and created the Metadata for DB connection wich its schema.
Then I drug-'n-dropped the above Metadata to my design field.
It showed correct component properties including Query Textarea with correct SQL.
However, when I clicked the next button of SQL textarea, SQL Bilder did not take over the SQL shown in the above textarea.
The tutorial shows it should be taken over. Do I need any configurations to take over the SQL?
Thank you for your reply.
Atsushi
4 REPLIES
Moderator

Re: [resolved] SQL Builder cannot take over Query Textarea in component tab

Hi,
Is it OK with you when you change DB type as "Built-In"?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] SQL Builder cannot take over Query Textarea in component tab

Thank you for your suggestion, Sabrina.
Unfortunately, your idea could not solve my case. Thanks anyway.
Anyway, I found that the same thing has not been happened in v5.5.1.
So, this incident seems a degraded bug of v5.6.0.
I'll close this ticket soon.
# I'm not a developer, so I could not try development version.
# I hope anyone can open the ticket in Bug Tracking System.
Moderator

Re: [resolved] SQL Builder cannot take over Query Textarea in component tab

Hi ash-naughty,
We will make a testing on 5.6 to see if this issue repro then coming back to you.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] SQL Builder cannot take over Query Textarea in component tab

Thank you, Sabrina!
I close this ticket now.