blocks|key|4424304|text|原因:基本上，当应用程序启动时，它会将withClient()中的内容插入到oauth_client_details表中，所以请删除它，然后重新启动应用程序，它应该可以工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4424305|因为您已经运行了应用程序，所以它在oauth_client_details表中插入了行。|4424306|解决方案:只需将这一行作为您的方法。它将在该表中查找行。@Override+++++public+void+configure(ClientDetailsServiceConfigurer+clients)+throws+Exception++++++{+++++++++clients.jdbc(dataSource);+++++}假设您第一次使用上面的代码行启动应用程序，那么我猜您可以直接向该表中添加条目，也可以通过应用程序添加条目。|offset|length|style|CODE|4424307|我手动添加的目的是为了测试。|4424308|希望这对你有帮助。这对我很管用。|4424309|entityMap^0|0|0|S|3V|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@$F|S|G|T|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

Reason :
So Basically when application comes up, it inserts what's their in your withClient() into oauth_client_details table so please remove that and restart your application it should work.

As you have already ran your application, it inserted row in oauth_client_details table.

Solution :
Just have this line your method. It will find the row in that table.
<code>
 @Override
 public void configure(ClientDetailsServiceConfigurer clients) throws Exception 
 {
 clients.jdbc(dataSource);
 }
</code>
Suppose for the first time you start your application with above line then I guess you can directly add entry into that table or it can be added by application as well. 

I manually added for testing purpose.

Hope this helps to you. It worked for me.

blocks|key|641493|text|我解决了这个问题，首先显式删除客户端详细信息，然后重新添加它们，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|641494|//+Create+client+details
BaseClientDetails+clientDetails+=+new+BaseClientDetails();
clientDetails.setClientId("user");
clientDetails.setClientSecret("secret");
clientDetails.setScope(Arrays.asList("read",+"write"));
clientDetails.setAuthorizedGrantTypes(Arrays.asList("password","authorization_code",+"refresh_token"));

//+Remove+and+re-add+details
JdbcClientDetailsService+jdbcClientDetailsService+=+new+JdbcClientDetailsService(dataSource);
try+{
++++jdbcClientDetailsService.removeClientDetails(clientDetails.getClientId());
}+catch+(NoSuchClientException+ignored)+{
}
jdbcClientDetailsService.addClientDetails(clientDetails);

//+Configure+clients
clients.withClientDetails(jdbcClientDetailsService);|code-block|syntax|javascript|641495|您可以使用此代码完全替换原始问题中包含的方法体。|641496|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I solved this problem by first explicitly removing the client details and then re-adding them like so:

<pre><code>// Create client details
BaseClientDetails clientDetails = new BaseClientDetails();
clientDetails.setClientId("user");
clientDetails.setClientSecret("secret");
clientDetails.setScope(Arrays.asList("read", "write"));
clientDetails.setAuthorizedGrantTypes(Arrays.asList("password","authorization_code", "refresh_token"));

// Remove and re-add details
JdbcClientDetailsService jdbcClientDetailsService = new JdbcClientDetailsService(dataSource);
try {
 jdbcClientDetailsService.removeClientDetails(clientDetails.getClientId());
} catch (NoSuchClientException ignored) {
}
jdbcClientDetailsService.addClientDetails(clientDetails);

// Configure clients
clients.withClientDetails(jdbcClientDetailsService);
</code></pre>

You can use this code to fully replace the body of the method included in the original question.

blocks|key|4424362|text|请查找my+answer，它将在没有任何错误的情况下工作：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4424363|找到下面的代码|4424364|@Override
public+void+configure(ClientDetailsServiceConfigurer+configurer)+throws+Exception+{

++++JdbcClientDetailsService+jdbcClientDetailsService+=+new+JdbcClientDetailsService(dataSource);

++++if(!jdbcClientDetailsService.listClientDetails().isEmpty()+)+{++++++++++
++++jdbcClientDetailsService.removeClientDetails(CLIEN_ID);+++++
++++}

++++if(jdbcClientDetailsService.listClientDetails().isEmpty()+)+{
++++++++configurer.jdbc(dataSource).withClient(CLIEN_ID).secret(encoder.encode(CLIENT_SECRET))
++++++++.authorizedGrantTypes(GRANT_TYPE_PASSWORD,+AUTHORIZATION_CODE,+REFRESH_TOKEN,+IMPLICIT)
++++++++.scopes(SCOPE_READ,+SCOPE_WRITE,+TRUST).accessTokenValiditySeconds(ACCESS_TOKEN_VALIDITY_SECONDS)
++++++++.refreshTokenValiditySeconds(FREFRESH_TOKEN_VALIDITY_SECONDS).and().build();++++++++++++++++
++++}+++++++
++++configurer.jdbc(dataSource).build().loadClientByClientId(CLIEN_ID);+
}|code-block|syntax|javascript|4424365|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/57460575/9963016^0|3|9|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

please find <a href="https://stackoverflow.com/a/57460575/9963016">my answer</a> it will works without any errors :

find the below code 

<pre><code>@Override
public void configure(ClientDetailsServiceConfigurer configurer) throws Exception {

 JdbcClientDetailsService jdbcClientDetailsService = new JdbcClientDetailsService(dataSource);

 if(!jdbcClientDetailsService.listClientDetails().isEmpty() ) { 
 jdbcClientDetailsService.removeClientDetails(CLIEN_ID); 
 }

 if(jdbcClientDetailsService.listClientDetails().isEmpty() ) {
 configurer.jdbc(dataSource).withClient(CLIEN_ID).secret(encoder.encode(CLIENT_SECRET))
 .authorizedGrantTypes(GRANT_TYPE_PASSWORD, AUTHORIZATION_CODE, REFRESH_TOKEN, IMPLICIT)
 .scopes(SCOPE_READ, SCOPE_WRITE, TRUST).accessTokenValiditySeconds(ACCESS_TOKEN_VALIDITY_SECONDS)
 .refreshTokenValiditySeconds(FREFRESH_TOKEN_VALIDITY_SECONDS).and().build(); 
 } 
 configurer.jdbc(dataSource).build().loadClientByClientId(CLIEN_ID); 
}
</code></pre>

blocks|key|915341|text|请找到我的答案，它将工作，没有任何错误：https://stackoverflow.com/a/57460575/9963016|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|915342|找到下面的代码|915343|@Override+public+void+configure(ClientDetailsServiceConfigurer+configurer)引发异常{|915344|++++JdbcClientDetailsService+jdbcClientDetailsService+=+new+JdbcClientDetailsService(dataSource);

++++if(!jdbcClientDetailsService.listClientDetails().isEmpty()+)+{++++++++++
++++jdbcClientDetailsService.removeClientDetails(CLIEN_ID);+++++
++++}

++++if(jdbcClientDetailsService.listClientDetails().isEmpty()+)+{
++++++++configurer.jdbc(dataSource).withClient(CLIEN_ID).secret(encoder.encode(CLIENT_SECRET))
++++++++.authorizedGrantTypes(GRANT_TYPE_PASSWORD,+AUTHORIZATION_CODE,+REFRESH_TOKEN,+IMPLICIT)
++++++++.scopes(SCOPE_READ,+SCOPE_WRITE,+TRUST).accessTokenValiditySeconds(ACCESS_TOKEN_VALIDITY_SECONDS)
++++++++.refreshTokenValiditySeconds(FREFRESH_TOKEN_VALIDITY_SECONDS).and().build();++++++++++++++++
++++}+++++++
++++configurer.jdbc(dataSource).build().loadClientByClientId(CLIEN_ID);+
}|code-block|syntax|javascript|915345|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/57460575/9963016^0|K|18|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@]|C|$K|L]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

please find my answer it will works without any errors : <a href="https://stackoverflow.com/a/57460575/9963016">https://stackoverflow.com/a/57460575/9963016</a>

find the below code 

@Override
 public void configure(ClientDetailsServiceConfigurer configurer) throws Exception {

<pre><code> JdbcClientDetailsService jdbcClientDetailsService = new JdbcClientDetailsService(dataSource);

 if(!jdbcClientDetailsService.listClientDetails().isEmpty() ) { 
 jdbcClientDetailsService.removeClientDetails(CLIEN_ID); 
 }

 if(jdbcClientDetailsService.listClientDetails().isEmpty() ) {
 configurer.jdbc(dataSource).withClient(CLIEN_ID).secret(encoder.encode(CLIENT_SECRET))
 .authorizedGrantTypes(GRANT_TYPE_PASSWORD, AUTHORIZATION_CODE, REFRESH_TOKEN, IMPLICIT)
 .scopes(SCOPE_READ, SCOPE_WRITE, TRUST).accessTokenValiditySeconds(ACCESS_TOKEN_VALIDITY_SECONDS)
 .refreshTokenValiditySeconds(FREFRESH_TOKEN_VALIDITY_SECONDS).and().build(); 
 } 
 configurer.jdbc(dataSource).build().loadClientByClientId(CLIEN_ID); 
}
</code></pre>

I am configuring an OAuth2 authorization server in a Spring project. Here is configuration. 

<pre><code> @Override
public void configure(ClientDetailsServiceConfigurer clients) 
 throws Exception {
 clients.jdbc(dataSource)
 .withClient("user")
 .secret("secret")
 .scopes("read", "write")
 .autoApprove(true)
 .authorizedGrantTypes(
 "password","authorization_code", "refresh_token")
 }
</code></pre>

The problem is that each time I restart application, it tries to add those clients in database, which I don't want. I am getting the unique constraint violation exception. How can I configure it to only add the clients only if they not already exists?

Thanks.

Spring Oauth2 JDBC Client configuration add same client multiple times

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在一个Spring项目中配置一个OAuth2授权服务器。以下是配置。 @Overridepublic void configure(ClientDetailsServiceConfigurer clients)   throws Exception {    clients.jdbc(dataSource)    ...

问Spring Oauth2 JDBC客户端配置多次添加同一客户端
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Spring Oauth2 JDBC客户端配置多次添加同一客户端EN