Breaking News: Grepper is joining You.com. Read the official announcement!

spring show sql

Add Answer

YOU.com answered on April 2, 2023 Popularity 6/10 Helpfulness 1/10

answer spring show sql

related show sql in spring boot

related show sql spring

spring show sql

Comment

import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import javax.sql.DataSource;

@Configuration
public class AppConfig {

    // Configure the primary data source
    @Primary
    @Bean
    public DataSource dataSource(DataSourceProperties properties) {
        DataSourceBuilder<?> dataSourceBuilder = DataSourceBuilder.create()
                .driverClassName(properties.getDriverClassName())
                .url(properties.getUrl())
                .username(properties.getUsername())
                .password(properties.getPassword());

        // Enable SQL logging
        dataSourceBuilder
                .type(org.apache.tomcat.jdbc.pool.DataSource.class)
                .build()
                .setLogValidationErrors(true)
                .setLogAbandoned(true)
                .setRemoveAbandoned(true)
                .setRemoveAbandonedTimeout(60)
                .setJdbcInterceptors("org.apache.tomcat.jdbc.pool.interceptor.LoggingInterceptor");

        return dataSourceBuilder.build();
    }
}

Popularity 6/10 Helpfulness 1/10 Language java

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

Closely Related Answers

show sql in spring boot

Comment

spring.jpa.show-sql=true

Popularity 9/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: sql spring-boot spring-b

Link to this answer
Share Copy Link

Contributed on Apr 02 2023

Wide-eyed Wryneck

0 Answers Avg Quality 2/10

show sql spring

Comment

import org.springframework.jdbc.core.JdbcTemplate;

public class MyDAO {
    private JdbcTemplate jdbcTemplate;

    public MyDAO(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public void executeSqlQuery() {
        String sql = "SELECT * FROM my_table";
        List<MyObject> result = jdbcTemplate.query(sql, (rs, rowNum) -> {
            MyObject obj = new MyObject();
            // map the result set to your object
            obj.setId(rs.getInt("id"));
            obj.setName(rs.getString("name"));
            // ... map other fields
            return obj;
        });
        
        // process the result
        for (MyObject obj : result) {
            System.out.println(obj.toString());
        }
    }
}

Popularity 6/10 Helpfulness 1/10 Language

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 11 2023

YOU.com

0 Answers Avg Quality 2/10

spring show sql

Contents

More Related Answers

spring show sql

Closely Related Answers

show sql in spring boot

show sql spring

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.