topic Re: SQLBuilder Dialog doesn't start in Talend Studio

SQLBuilder Dialog doesn't start

ettore1 — Sat, 16 Nov 2024 02:45:56 GMT

Hi all, I have designed a job including a tOracleInput component. When I click on the three-dots button right the Query panel in the Component view, a progress dialog appears for a while, then it vanish and the expected SQLBuilder Dialog doesn't appear.

I have the same issue in a fresh reinstallation.

No relevant messages in <workspace>/.metadata/.log file.

My version is:

Talend Open Studio for ESB

Version: 7.3.1.20200219_1233

JDK: java version "1.8.0_201"

Any idea for a solution?

Tks in advance!

Re: SQLBuilder Dialog doesn't start

Anonymous — Wed, 08 Apr 2020 03:15:18 GMT

Hi eapolloni

Which operating system? We need to test and check if it is a bug.

Regards
Shong

Re: SQLBuilder Dialog doesn't start

ettore1 — Wed, 08 Apr 2020 16:42:14 GMT

Windows 10 - vers. 1909 (build SO 18363.720)

Tks

Re: SQLBuilder Dialog doesn't start

UseThat — Tue, 14 Apr 2020 11:47:55 GMT

Hi,

We have same problem with sqlBuilder. It doens't want to open from component.

Our version: TOS_ESB-20200219_1130-V7.3.1

Windows Server 2012 R2 Standard

java 1.8.0_161

Regards,

Mateusz

Re: SQLBuilder Dialog doesn't start

ygao1 — Wed, 15 Apr 2020 08:51:37 GMT

i try this on windows 10 and windows 2012R2 use build TOS_ESB-20200219_1130-V7.3.1, and it works well on my side

Re: SQLBuilder Dialog doesn't start

UseThat — Wed, 15 Apr 2020 10:15:37 GMT

What version of java do you have? Is our version is correct? We have java 1.8.0_161

Re: SQLBuilder Dialog doesn't start

Anonymous — Thu, 16 Apr 2020 03:13:23 GMT

@UseThat, Talend studio requires Java version minimum 1.8.0_161, if you have multiple java version installations on your machine, open <workspace>/.metadata/.log and check if it uses the right java version to launch studio. If you can't still open the SQL Builder, have a try to upgrade java version and try it again.

Regards
Shong

Re: SQLBuilder Dialog doesn't start

ettore1 — Thu, 16 Apr 2020 13:36:11 GMT

It seems that @UseThat has exactly the java mininum version, as far as I understand.
However, as stated at the begininning of this thread I have an upgraded version (JDK: java version "1.8.0_201"), but SQLBuilder doesn't start yet, and in <workspace>/.metadata/.log there is no error logged

Re: SQLBuilder Dialog doesn't start

UseThat — Tue, 21 Apr 2020 09:25:43 GMT

@shong @ygao

I found the problem. To repet this you have to create tDBConnection set to Microsoft SQL Server:

Then I created tDBInput and try to run sql builder with component set like this:

And now after clicking to open sql builder it doesn't open.

Also I found solution to fix this problem by my site i have to uncheck Use an existing connection and get all data from Preprty Type like this:

And now i can open builder:

And now after back to use existing connection on compnent it start works.

Regards,

Mateusz

Re: SQLBuilder Dialog doesn't start

ettore1 — Thu, 23 Apr 2020 11:30:54 GMT

Hi @UseThat , thanks a lot for your suggestion. I have an Oracle DB and unfortunately the SQL Builder windows still doesn't open. But now I have a clue to investigate in further detail ...! As soon as I have SQL Server Database I'll try your suggestion with it as well.