Announcement Announcement Module
Collapse
No announcement yet.
oAuth-server: 'refresh_token_validity' is missing ... Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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)
    Last edited by OhadR; Oct 23rd, 2012, 10:41 AM.

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

    Comment


    • #3
      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:
      Code:
      Integer getRefreshTokenValiditySeconds();
      Map<String, Object> getAdditionalInformation();
      Last edited by OhadR; Oct 24th, 2012, 11:42 AM.

      Comment

      Working...
      X