Keycloak x User Storage SPI

Hi,

I’m trying to run this example keycloak-quickstarts/user-storage-jpa at latest · keycloak/keycloak-quickstarts · GitHub with keycloak x (16.1.0) with 2 different databases. h2 and another like mssql. I’m experiencing issue to inject another EntityManager with a custom PersistentUnit. Is there anyone here who has tested this successfully?

I added a new datasource like this :

quarkus.datasource."mydatasource".db-kind=mssql
quarkus.datasource."mydatasource".jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
quarkus.datasource."mydatasource".jdbc.url=jdbc:sqlserver://xxxxxxx:xxxx;databaseName=xxxxx
quarkus.datasource."mydatasource".username=xxxxxx
quarkus.datasource."mydatasource".password=xxxxxx

quarkus.hibernate-orm."mydatasource".datasource=mydatasource
quarkus.hibernate-orm."mydatasource".dialect=org.hibernate.dialect.SQLServerDialect
quarkus.hibernate-orm."mydatasource".packages=com.mypackages

and try to add these annotations on my provider class :

@ApplicationScoped
public class MyUserStorageProvider implements UserStorageProvider, UserConsentFederatedStorage, UserLookupProvider, CredentialInputUpdater, UserQueryProvider, CredentialInputValidator, OnUserCache{

@Inject
@PersistentUnit("mydatasource")
EntityManager em;

......

is there something wrong ?