oAuth-server: 'refresh_token_validity' is missing ...

[OhadR]

After upgrading to RC2a, I got this exception in the oAuth provider; to what table should I add the 'refresh_token_validity'? (I assume to my client-details table...)
I did not get this error in M6. Plus, I do not ask for a refresh token... so how come?

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown column 'refresh_token_validity' in 'field list'
sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:39)
sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:27)
....
....com.mchange.v2.c3p0.impl.NewProxyPreparedState ment.executeQuery(NewProxyPreparedStatement.java:7 6)
org.springframework.jdbc.core.JdbcTemplate$1.doInP reparedStatement(JdbcTemplate.java:644)
org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:587)
org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:637)
org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:666)
org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:674)
org.springframework.jdbc.core.JdbcTemplate.queryFo rObject(JdbcTemplate.java:734) org.springframework.security.oauth2.provider.JdbcC lientDetailsService.loadClientByClientId(JdbcClien tDetailsService.java:112) org.springframework.security.oauth2.provider.Defau ltAuthorizationRequestFactory.createAuthorizationR equest(DefaultAuthorizationRequestFactory.java:43)
org.springframework.security.oauth2.provider.endpo int.AuthorizationEndpoint.authorize(AuthorizationE ndpoint.java:130)

[Dave Syer]

Since the error comes from JdbcClientDetailsService I suggest you look there for the table name.

[OhadR]

Well, I guess that it happens because JdbcClientDetailsService now has a different query, that consists of "refresh_token_validity" (did not appear in M6)



it relates the fact that ClientDetails now has 2 more methods:

Integer getRefreshTokenValiditySeconds();
Map<String, Object> getAdditionalInformation();