I have a grails app where I integrated with Spring Social and it was working fine. It started throwing error once I introduced a default schema in DataSource.groovy.
When I looked at the code which was working before, I found that UserConnection table was getting created under public schema. Now since I had specified default_schema it got created in 'my_schema'.
cache.use_second_level_cache = true
cache.use_query_cache = false
cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory'
default_schema = "my_schema"
generate_statistics = true
But, the sql getting generated to fetch the user connection is not adapting and it throws up an error.
Any suggestions on how to solve this?
Table "USERCONNECTION" not found; SQL statement: select userId from UserConnection where providerId = ? and providerUserId = ? [42102-164]