IdentityServer4 With Oracle database

0

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 quiery successfully run on sql developer but inside identity server it give an error

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

.net
oracle
.net-core
entity-framework-core
identityserver4

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0