Activate MS SQL Server JDBC Trace

[drosemeyer]

Hello,

I got a problem to connect to a MS SQL Server Database using a named Inctance.

Action "Test connection" fails in “Create Database Connection" GUI, but after storing the connection as Meta Data it can be used in a job successfully.

To get closer to the error I activated MS SQL Server jdbc trace following MS instructions on

https://docs.microsoft.com/de-de/sql/connect/jdbc/tracing-driver-operation?view=sql-server-ver15

I defined a logging.properties file and activated it using advanced settings in job properties.

• Use specific JVM arguments

• -Djava.util.logging.config.file=c:\tmp\mssqllog\logging.properties.

This works on running the job, the jdbc driver traces all commands as configured in  logging.properties

(com.microsoft.sqlserver.jdbc.level=ALL).

But I need to trace the “Create Database Connection” GUI.

Adding -Djava.util.logging.config.file=c:\tmp\mssqllog\logging.properties

to TOS_DI-winx86_61.ini

creates the log file defined in logging.properties, but doesn’t activate the jdbc trace.

How is it possible to activate the jdbc trace for the “Create Database Connection” GUI component?

Regards Dirk

[Anonymous]

Hello,

Here is a KB article about:

https://community.talend.com/s/article/How-to-generate-a-trace-for-the-HTTP-requests-executed-by-Stu...

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina

[Antonio69]

Awesome and interesting article. Great things you’ve always shared with us. Thanks. Just continue composing this kind of post.

liteblue