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!

This still does not appear to work in Windows...

user12248089Jun 24 2020 — edited Jul 10 2020

Y:\Oracle\sqlcl-19.4.0.354.0937\sqlcl>echo %JAVA_HOME%                                                                       

Y:\Oracle\Java\Java8\64-bit\jre                                                                                              

Y:\Oracle\sqlcl-19.4.0.354.0937\sqlcl>path                                                                                   

PATH=Y:\Oracle\Java\Java8\64-bit\jre\bin;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\     

Y:\Oracle\sqlcl-19.4.0.354.0937\sqlcl>java -version                                                                          

java version "1.8.0_221"                                                                                                     

Java(TM) SE Runtime Environment (build 1.8.0_221-b11)                                                                        

Java HotSpot(TM) 64-Bit Server VM (build 25.221-b11, mixed mode)                                                                                                                           

                                                                                                                             

Y:\Oracle\sqlcl-19.4.0.354.0937\sqlcl>cd bin                                                                                 

Y:\Oracle\sqlcl-19.4.0.354.0937\sqlcl\bin>sql.exe                                                                            

This application requires a Java Runtime Environment 1.8.0_150                                                               

I have an older version of Java 8 'installed' to support some legacy applications but why can't this product just work out the box using the shell environment - it must be reading the Windows Registry? This is Windows 10.

Comments
Post Details
Added on Jun 24 2020
8 comments
696 views