Can I use log4jdbc?

seunghee cho 1

spring.datasource.driverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy
I couldn't use this.

I am using azure mysql.
I tried to print a log using log4jdbc, but the database connection is not possible.
Can I use log4jdbc other than the functionality provided by azure?

If the function is not available, what function should I use to log?

Navtej Singh Saini 4,216 Reputation points Microsoft Employee

2020-08-27T01:33:51.047+00:00

@seunghee cho

For helping you regarding this, please convey what type of logs you are trying to print and brief overview of your Azure MySQL architecture(how you connecting etc.).

Also please check the document for available auditing options in Azure MySQL DB.

Thanks
Navtej S
seunghee cho 1 Reputation point

2020-08-27T06:24:59.137+00:00
@Navtej Singh Saini

Using this it works fine on azure server.
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://XXXXXXXXXX.mysql.database.azure.com:3306/XXXX?serverTimezone=UTC&useSSL=true&requireSSL=false

want to use this to print a log like the one below. It works fine on my local pc, but not on azure server.
spring.datasource.driverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy
spring.datasource.url=jdbc:log4jdbc:mysql://XXXXXXXXXX.mysql.database.azure.com:3306/XXXX?serverTimezone=UTC&useSSL=true&requireSSL=false

-log
2020-08-27 15:11:29 [] [DEBUG] [Slf4jSpyLogDelegator.java]sqlTimingOccurred(368) : com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
671. select count(t1.code) cnt from carpet_user t1
Navtej Singh Saini 4,216 Reputation points Microsoft Employee

2020-08-28T01:40:05.83+00:00

We are checking this and will get back to you.

Navtej S
seunghee cho 1 Reputation point

2020-08-28T03:01:54.62+00:00

thank you!
Navtej Singh Saini 4,216 Reputation points Microsoft Employee

2020-08-28T23:37:58.037+00:00

@seunghee cho

Our Product team has asked for some clarification here:

log4jdbc is used to spy on your DB calls which are made to a database. The same is done by the audit logs. What kind of log out you want ?

Please check and get back to us for further help.

Thanks
Navtej S
Navtej Singh Saini 4,216 Reputation points Microsoft Employee

2020-09-02T01:15:42.02+00:00

@seunghee cho

Please get back to us with the answers to the question above and we can take this forward.

Thanks
Navtej S