Re: SQLcl Connection

That's curious. We do nothing but sling it over to the db then return when the db is connected of failed with a message back.

2 options if you have time...
1- when it's hung, run jstack - p <pid> and float it over to me 2- sqlnet tracking to see what the db is doing.

-kris

On Mon, Aug 23, 2021 at 10:37 AM Charlotte Hammond < dmarc-noreply_at_freelists.org> wrote:

> Hello,
>
> I have only just started playing with SQLcl (version 19.1 on Linux) and
> have hit an oddity - just want to check if this is expected?
>
> sql charlotte/mypassword_at_myhost/MYSID <-- connects fine
> sql charlotte/wrongpassword_at_myhost/MYSID <-- hangs
>
> Is it meant to hang if I get my password wrong? It looks like a bug (or
> at least a misconfiguration) but since I'm new I want to make sure I'm not
> overlooking something obvious.
>
> Verbose mode shows nothing after:
> INFO: Attempting to connect using URL= "jdbc:oracle:oci8:_at_myhost:MYSID"
>
> The hang also happens if I get the username or service wrong (it errors if
> the host is wrong). And it's the same if I use nolog and then the connect
> command.
>
> Thank you!
> Charlotte
>

--
http://www.freelists.org/webpage/oracle-l