I'm also having a little problem with the petclinic app.
I got Spring and petclinic installed after a little difficulty along the lines of previous posts.
I'm running hsql. I had several errors in the petclinic.script file. It didn't like the 'public' schema. It's also missing a semicolon somewhere.
Anyway, I worked through all that. When I run the petclinic app from the SpringSource Tool Suite I get the following:
Code:
Data access failure: PreparedStatementCallback;
bad SQL grammar [SELECT id, first_name, last_name, address, city, telephone FROM owners WHERE last_name like ?];
nested exception is java.sql.SQLException:
Table not found in statement
[SELECT id, first_name, last_name, address, city, telephone FROM owners WHERE last_name like ?]
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
bad SQL grammar [SELECT id, first_name, last_name, address, city, telephone FROM owners WHERE last_name like ?];
nested exception is java.sql.SQLException:
Table not found in statement [SELECT id, first_name, last_name, address, city, telephone FROM owners WHERE last_name like ?] at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276) at
(snip)
At this point I'm getting stuck - I'm running the hsql manager - I can see the owner table and it is populated. So I'd surmise the petclinic application is using the wrong schema. I don't know how to tell it to use 'public'. How can I determine if the 'sa' user uses the 'public' schema?