SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

what is proper way to enable ojdbc extensions in sqlcl and sqldeveloper ?

AlbertBNov 22 2024

What is proper way to enable Oracle JDBC extensions for use by sqlcl or sqldeveloper ?

The extensions are https://github.com/oracle/ojdbc-extensions

I am trying to connect sqlcl v24.3 to database with AzureAD token directly retrieved by JDBC thin driver.

and getting this error:

C:\Users\X271176\work\Software\sqlcl\sqlcl-24.3.1.311.1631\sqlcl\bin>sql /nolog

SQLcl: Release 24.3 Production on Fri Nov 22 12:07:25 2024

SQL>
SQL>
SQL> conn /@orcl_23500_token_direct
Connection failed
USER =
URL = jdbc:oracle:thin:@(description= (address=(protocol=tcps)(port=11522)(host=127.0.0.1)) (connect_data=(server=dedicated)(service_name=FREEPDB1)) (security=(ssl_server_cert_dn="CN=docker_orcl_23500") (CLIENT_ID="CCCCCCCC-CCCC-CCCC-CCCC-CCCCCCCCCCCC") (TENANT_ID="TTTTTTTT-TTTT-TTTT-TTTT-TTTTTTTTTT") (TOKEN_AUTH=AZURE_INTERACTIVE) (AZURE_DB_APP_ID_URI="https://ZZZZZZZZZZZZZZ/XXXXXXXX-XXXX-XXXX-XXXXXXXXXXXX") ) )
Error Message = ORA-18726: Failed to get a value from an OracleResourceProvider: No implementation of oracle.jdbc.spi.AccessTokenProvider with name: "ojdbc-provider-azure-token" can be located. Implementations of oracle.jdbc.spi.AccessTokenProvider that can be located have the following names : []
https://docs.oracle.com/error-help/db/ora-18726/

SQL>

Added on Nov 22 2024

#azure, #token

2 comments

66 views

2 mentions