All geek questions in one place

Debugging SQL Queries Using Spring JDBC

I am working with Spring Framework and I am following test-based development. I get an exception, but I'm not quite sure why I would like to know what jdbc actually works. The request attempt is as follows:

public OrderEntity addOrderEntity(OrderEntity orderEntity) {
    String query = "INSERT INTO ORDERS(ID,REVISION,CONTRACT_ID,PROJECT_ID,WORKSITE_ID,DROPZONE_ID,DESCRIPTION_ID,MANAGER_ID,DELIVERY_DATE,VOLUME) VALUES(?,?,?,?,?,?,?,?,?,?)";
    String id = (orderEntity.get_id() != null) ? orderEntity.get_id() : UUID.randomUUID().toString();
    jdbcTemplate.update(id,1,orderEntity.getContractNo(),orderEntity.getProjectID(),orderEntity.getWorksiteID(),orderEntity.getDropzoneID(),orderEntity.getDescriptionID(),orderEntity.getManagerID(),orderEntity.getDeliveryDate(),orderEntity.getVolume());

    return getOrderEntityById(id);
}

So what is the best way to see if a JDBC query is working or to get useful information? He is currently throwing org/springframework/dao/QueryTimeoutException(which I find infinitely useless), so I don’t know what might be wrong.

EDIT: added log4j but have not yet received a useful request. The property file is below:

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[%-5t] %-5p %c - %m%n
log4j.rootLogger=trace, stdout

log4j.logger.org.springframework.jdbc.core=DEBUG
log4j.logger.org.springframework.jdbc.core.StatementCreatorUtils=DEBUG
+4
source share
1 answer

You can enable query tracing using:

log4j.logger.org.springframework.jdbc.core = TRACE

Special

log4j.logger.org.springframework.jdbc.core.StatementCreatorUtils=TRACE

:

 TRACE StatementCreatorUtils:206 - Setting SQL statement parameter value: column index 4, parameter value [TheValueWillBeHere]
+6

Source: https://habr.com/ru/post/1531149/

More articles:


All Articles