Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

Four Stars

Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

Hello,

 

when I try to use "Guess schema" within a tRedshiftInput compenent I get an error.2019-04-29 08_52_34-Warnung!.png

 

I delete all depend jars and get this:

2019-04-29 08_29_21-Current operation requires the following third party modules.png

 

So, which jar file I have to choose that is works properly?

 

Thanks in advance

Employee

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

Hi,

 

    The jar name is already specified in the warning message. Could you please try that?

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

Four Stars

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

I choose this file:

2019-04-29 09_19_37-Öffnen.png

 

But I still get the missing jar error

Moderator

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

Hello,

Did you follow up this online documentation about:TalendHelpCenter:Installing external modules manually using the Modules view?

Have you tried to restart your studio to see if it works?

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.
Employee

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

Sorry. I do not have much idea in this scenario as the jars are already present.

 

@xdshi Could you please advise what could be the next step in this scenario?

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

Seven Stars

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

hHi @aebben  ,

 

After installed the Jar, restart the studio to make it reflect the repository. It will work.

 

Thanks,

Joe

 

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Four Stars

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

Thanks for the fast reply's.

Now I'm getting this error when click on guess schema:

2019-04-29 13_52_38-Connection warning.png

 

Logfile:

!ENTRY org.talend.platform.logging 1 0 2019-04-30 08:02:08.606
!MESSAGE 2019-04-30 08:02:08,604 INFO org.talend.designer.core.runprocess.Processor - Command line: C:/Program Files/Java/jre1.8.0_201/bin/java.exe -Xms256M -Xmx1024M -Dfile.encoding=UTF-8 -cp C:/Aktuell/TOS_DI-20181026_1147-V7.1.1/workspace/.Java/target/classpath.jar; tool_stock_analysis.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema --context=Default %*


!ENTRY org.talend.platform.logging 4 0 2019-04-30 08:02:09.524
!MESSAGE 2019-04-30 08:02:09,521 ERROR org.talend.commons.exception.CommonExceptionHandler - Syntax error, insert ")" to complete MethodInvocation


!STACK 0
org.talend.designer.core.ui.editor.properties.controllers.AbstractGuessSchemaProcess$1: Syntax error, insert ")" to complete MethodInvocation

 

Seven Stars

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

Hi @aebben ,

 

This is syntax error.  Try to execute your query outside of Talend  to check the syntax. 

Please give more details about your query to assist further.

 

Thanks,

joe

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Moderator

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

Hello,

We usually open the code tab in your job and check if there will be your compile error highlighted in red line.

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.
Four Stars

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

I see I didn't express myself properly.

My Job works fine, only the guess schema won't work.

Within the code window I can't execute guess schema, right?

 

I also try an minimal query like "SELECT 'Hello World' "  --> job fine, guess schema fails

Four Stars

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

I think I found the issue.

The DB password contains a double quote "

The guess schema build a temp Mock_job_for_Guess_schema.java

which contains the stored password in the line:

java.sql.Connection conn = java.sql.DriverManager.getConnection(url, "user", "password");

and if there is a double quote in the password it can't compile.

 

Is there a workaround for passwords with double quote?

Moderator

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

Hello,

Have you tried to escape double quotations with \ to see if it works?

eg:

\''password\"123

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.
Four Stars

Re: Guess schema issue Missing jars:redshiftJDBC42-no-awssdk-1.2.16.1027

Then I get this password error when click on guess schema

2019-05-06 12_57_00-Error Message.png

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads