IdentityServer4 With Oracle database


I tried to connect Identity server with oracle database. Connection is success but, inside identity server give an error, identity server cannot execute below query but when I execute that query in the oracle SQL developer it successfully execute and give an output. all tables are existing with data.

I think this is occur when I use wrong NuGet package. Please help me to fix this issue.

SELECT c0.Origin FROM IdentityServer.Clients c
INNER JOIN IdentityServer.ClientCorsOrigins c0 ON c.Id = c0.ClientId

This query successfully runs in SQL Developer, but inside identity server I get an error

""SELECT "c0"."Origin" FROM "IdentityServer"."Clients" "c" INNER JOIN "IdentityServer"."ClientCorsOrigins" "c0" ON "c"."Id" = "c0"."ClientId"" 2021-02-03 17:56:45.891 +05:30 [Error] 2021-02-03 17:56:45.891228 ThreadID:4 (ERROR) OracleExecutionStrategy.ExecuteAsync() : Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist

asked on Stack Overflow Feb 3, 2021 by sampath pathirana • edited Apr 7, 2021 by marc_s

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0