Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

fail to run test in maven #92

Closed
MikeZheng opened this issue Aug 16, 2015 · 1 comment
Closed

fail to run test in maven #92

MikeZheng opened this issue Aug 16, 2015 · 1 comment
Assignees
@arey
Labels
bug

Comments

@MikeZheng
Copy link

I encountered an issue that description is "org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT id as visit_id, visit_date, description FROM visits WHERE pet_id=?]; SQL state [S0022]; error code [0]; Column 'visits.id' not found.; nested exception is java.sql.SQLException: Column 'visits.id' not found." when running test in maven.

I use MySQL as database.
petclinic-issue

I think the root cause is that the sql in method "findByPetId" of class JdbcVisitRepositoryImpl are not mapped with the method "mapRow" of class JdbcVisitRowMapper.
arey added a commit that referenced this issue Aug 19, 2015
@arey
#92 Fix column 'visits.id' not found on MySql
91d19d1
@arey
Copy link
Contributor

arey commented Aug 19, 2015

Hi MikeZheng, could you please pull the last commit and execute your test again?

arey added a commit that referenced this issue Aug 20, 2015
@arey
#92 Use column alias
06be7eb
@arey arey self-assigned this Oct 2, 2015
@arey arey added the bug label Oct 13, 2015
arey added a commit that referenced this issue Oct 13, 2015
@arey
#92 add some comments to switch from HSQLDB to MySQL
cb0504e
@arey arey closed this as completed Oct 13, 2015
attil-io added a commit to attil-io/spring-petclinic that referenced this issue Jun 17, 2016
@attil-io
spring-projects#92 Fix column 'visits.id' not found on MySql
a52572b
attil-io added a commit to attil-io/spring-petclinic that referenced this issue Jun 17, 2016
@attil-io
spring-projects#92 Use column alias
af3bb23
attil-io added a commit to attil-io/spring-petclinic that referenced this issue Jun 17, 2016
@attil-io
spring-projects#92 add some comments to switch from HSQLDB to MySQL
7e547f3
mariusoe pushed a commit to JonasKunz/spring-petclinic that referenced this issue May 11, 2021
@arey
Merge pull request spring-projects#92 from arey/bugfix/failOnNoGitDir…
e9cb2e8 
…ectory

spring-projects#14 Do not fail maven build of the .git directory is missing
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@arey arey

Labels
bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@arey @MikeZheng