arnaldop / enhanced-pet-clinic Goto Github PK

HI!
I have forked the enhanced-pet-clinic project. Then I imported the project in STS environment based on Eclipse Neon. STS in throwing the following error:

log cannot be resolved on every line where the log object is used like so :

log.info("(beforeExceptionHandler) Before executing '" + jp.getSignature().toLongString() + "'");

At the state of the last commit (934b259) on March 31, 2016 the project is using project lombok version 1.16.8.

When I build enhanced-pet-clinic with the newest version of Spring Boot, I get an error after clicking create user on the form. There is an error about the attribute map being empty. Any ideas?

Getting traceback with this message:
PreparedStatementCallback; bad SQL grammar [select username,authority from authorities where username = ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'username' in 'field list'

Is this a known problem?

I should mention that I tried to change the project to use a mysql database instead of in-memory db.
trying changing mysql table definition.

Adding username to authorities table fixed issue.

Upon using that spring config, running the unmodified sql files that came with the project I get the below error.

Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select username,authority from authorities where username = ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'username' in 'field list'

Here is the current schema for table authorities:
id bigint(20) NO PRI NULL auto_increment
authority varchar(255) NO NULL

I could create a 'username' field, but that seems wrong here.
Honestly I dont know where this is coming from and therefore not sure where to check to fix it.