Skip to Main Content

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!

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

Albert B.Nov 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

Copyright (c) 1982, 2024, Oracle. All rights reserved.

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>

Comments
Post Details
Added on Nov 22 2024
2 comments
461 views