3
$\begingroup$

I work with MMA 12.0. When I want to make a connection with met Oracle Database, I do:

Needs["DatabaseLink`"]
Needs["JLink`"]
$connection = 
 OpenSQLConnection[JDBC["Oracle", "localhost:1521/xxxx"], 
  "Username" -> "xxxxxx", "Password" -> "xxxxxx"]

After this I can query my Oracle dbase like

SQLExecute[$connection, "select * from tablename"];

Everythin works fine. Now I installed MMA 12.2. When I use the same script on the same computer I get a error like:

KeyExistsQ::invrl: The argument Association[Flatten[JDBCDrivers[]/. JDBCDriver[Name->DatabaseLinkSQLPrivatename_,Driver->DatabaseLinkSQLPrivatedriver_,Protocol->DatabaseLinkSQLPrivateprotocol_,_,_,_]:>{DatabaseLinkSQLPrivatename->Association[Rule[<<2>>],Rule[<<2>>]]}]] is not a valid Association or a list of rules.

JDBC::classnotfound: Oracle

Is there a easy way to fix this issue without 'disturbing'the settings of MMA 12.0

Improve this question
$\endgroup$
2

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.