Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

SQLcl.exe giving Java error Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not loa

1002330Jan 30 2018 — edited Aug 17 2018

Hello Folks,

I am trying to connect sqlcl to our database but its giving me the error below -

Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path, Access is denied]

        at org.fusesource.hawtjni.runtime.Library.doLoad(Library.java:182)

        at org.fusesource.hawtjni.runtime.Library.load(Library.java:140)

        at org.fusesource.jansi.internal.CLibrary.<clinit>(CLibrary.java:37)

        at oracle.dbtools.raptor.console.clone.DbtoolsConsoleReader.<init>(DbtoolsConsoleReader.java:245)

        at oracle.dbtools.raptor.console.clone.DbtoolsConsoleReader.<init>(DbtoolsConsoleReader.java:238)

        at oracle.dbtools.raptor.console.SQLPlusConsoleReader.<init>(SQLPlusConsoleReader.java:35)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startConsole(SqlCli.java:235)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.<init>(SqlCli.java:216)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:427)

I have jre1.8.0_161 folder in the sqlcl folder. I have got the Java_Home link to sqlcl/jre1.8.0_161 and I in my path variable i have added %JAVA_HOME%\bin. I am lost at why its giving me this error. Any help is appreciated. Thank you!

Comments

User_E97G7

Hi All,

Any help will be appreciable

Roy Kidron

Hi,
It's disabled in the screenshot.
Try checking the "Enabled" box in action 21.
Best regards,
Roy.

Rohit Bhagat

Have you got the solution.Please share if yes.

User_E97G7

Yes, ofcorse, I already did that. I disabled during my multiple ways of testing to achieve the requirement

User_E97G7

Hi,
No, we still didn't achieved this
But, luckily, we somewhat educated users to save the changes(as a temporary solution)

braford_w_byron

I'm having the same issue. Built-In DO_KEY > COMMIT_FORM causes the form to lock up for about 15 minutes then it throws an error message

braford_w_byron

Update: DO_KEY > COMMIT_FORM works when called from a Menu option but not in WHEN-VALIDATE-RECORD

1 - 7

Post Details

Added on Jan 30 2018
12 comments
2,805 views