spring-guides / gs-relational-data-access Goto Github PK

Using IntelliJ, the Autowired annotation for the jdbcTemplate variable is labeled as an issue.

...
public static void main(String[] args) {
	SpringApplication.run(SpringjdbcApplication.class, args);
}

@Autowired //Field injection is not recommended
JdbcTemplate jdbcTemplate;

@Override
public void run(String... args) throws Exception {
        log.info("Creating tables");
...

It says that "Field injection is not recommended". How to solve this?

"jdbc:h2:mem" doesn't work with Spring Boot 1.2.0.RC2.

"jdbc:h2:mem" works fine with "com.h2database:h2:1.3.176",

but it doesn't work with "com.h2database:h2:1.4.182".

Spring Boot 1.2.0.RC2 uses "com.h2database:h2:1.4.182".

So I guess "jdbc:h2:mem" needs to be changed to something like "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1".

I'm new to Java and Spring framework. I tried to build using gradle, but got this error during compilation process.

/home/user/Projects/Java/src/main/java/hello/Application.java:41: error: cannot find symbol
List results = jdbcTemplate.query(
^
symbol: class Customer
location: class Application

I know i'm making some basic mistakes. Please help me fix it.

hello, I am confused that would the H2 database disappear after this app finish? Could I store these data in my own computer?

thanks for help!!

Update the guide to use the most recent Spring Boot version.

Files that require changes are:

initial/build.gradle
initial/pom.xml
complete/build.gradle
complete/pom.xml

？？

Line:45

why don‘t need to configure the h2 username and password?

The guide is on Spring Boot 3.2

Hi,

Description:
For the page "Accessing Relational Data using JDBC with Spring", the method RelationalDataAccessApplication#run call to a deprecated function: jdbcTemplate.query(....

Details:
Deprecated function "query" in JdbcTemplate:

@Deprecated
@Override
public <T> List<T> query(String sql, @Nullable Object[] args, RowMapper<T> rowMapper) throws DataAccessException {
	return result(query(sql, args, new RowMapperResultSetExtractor<>(rowMapper)));
}

The function to call

@Override
public <T> List<T> query(String sql, RowMapper<T> rowMapper, @Nullable Object... args) throws DataAccessException {
	return result(query(sql, args, new RowMapperResultSetExtractor<>(rowMapper)));
}

Fix:
To fix it, we should simply invert the two last param (args and rowmapper).

Regards,
Gilles

Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE customers if exists ]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if exists' at line 1

please change Sql spell to "jdbcTemplate.execute("DROP TABLE IF EXISTS customers");"

Hello!
I was reading the guides on spring.io and I notice that the files included in ASCII Doctors are throwing an error and I can't see the code snippet unless I access the file directly here in the repo.

Follow the evidence below: