Activate MS SQL Server JDBC Trace

drosemeyer — Fri, 15 Nov 2024 22:57:00 GMT

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

Re: Activate MS SQL Server JDBC Trace

Anonymous — Tue, 17 May 2022 03:13:31 GMT

Hello,

Here is a KB article about:

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

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

Best regards

Sabrina

Re: Activate MS SQL Server JDBC Trace

Antonio69 — Fri, 16 Sep 2022 05:57:50 GMT

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

liteblue

topic Re: Activate MS SQL Server JDBC Trace in Talend Data Catalog

Activate MS SQL Server JDBC Trace

Re: Activate MS SQL Server JDBC Trace

Re: Activate MS SQL Server JDBC Trace