Forum Stats

  • 3,750,519 Users
  • 2,250,187 Discussions
  • 7,866,997 Comments

Discussions

SQLCl Command line issue

Aasubram-Oracle
Aasubram-Oracle Member Posts: 143
edited Oct 25, 2017 9:27AM in SQLcl

Hi,

Can someone help me with this?

The issue is with SQLDeveloper version 17.2.0.188 Build 188.1159

“trying to run sqldeveloper report from command line .

it errors with:

  1. java.lang.IllegalArgumentException: null connection not allowed

it works fine from the gui and I saved password in the connection.

When I check the environment variable APPDATA is set to C:\users\myusername\AppData\Roaming

I see the connections.xml file under there under the sql developer folder

Is there another environment variable I need to set so it can find the connections.xml file?”

The command used is

sdcli64.exe reports generate -report "Invalid Objects" -db "TEST" -file "C:\TEMP\output.html"

Executed at the OS cmd window as the same OS user through which he runs the SQLDeveloper GUI as well. It does not work.

Customer has the following questions

what file is it looking in for the connections?
connections.xml?
tnsnames.ora?
Please let me know and I can check the files.
Also what path paths does it look in?

Kindly let me know if I am missing something on this.

Thanks,

Anand

Answers