#15488: Aqua Data Studio closes connection when executing "Set noexec on" on Sybase ASE

hmakitta reported 2017-11-17T19:12:30Z · last modified 2017-11-27T15:34:43Z

Aqua Data Studio closes connection when executing "Set noexec on" on Sybase ASE

Dev
QA

Priority	Minor
Complexity	Unknown

Component	App - AquaProjects
Version	18.0

"set noexec on" on is used after "set showplan on" on Sybase ASE to show the query optimizer plan, but to avoid running the query itself (as it may need too much time).

This did work in former versions of Aqua Data Studio, but now executing "set noexec on" simply closes the connection, which of course prevents from actually executing the query to see the query optimizer plan returned by Sybase ASE.

Trying to execute it simply gives the following error message:

No operations allowed after connection closed. You can enable auto-reconnect in "File->Options->General->Query Windows->Auto-reconnect on execution if connection is closed"

Auto-reconnect of course is useless here, as re-opening the connection will reset the noexec-option.

ADS version: 18.0.7

Sybase ASE version: 15.7

Server Properteis in ADS: "Sybase ASE 11/12/15/16"

1 attachment

Sybase.png

2017-11-22T17:46:43Z

86 KB

All Comments (5) Change History

tomconrad 2017-11-21T16:04:25Z

Hi Horst,

Can you execute the showplan and noexec on the same line like:

set showplan, noexec on

select * from "dbo"."another"

set showplan, noexec off

Please give that a try.

Thanks,

Tom

hmakitta 2017-11-21T18:34:25Z

Hi Tom,

I tried that, but the connection was closed after "set showplan, noexec on".

tomconrad 2017-11-22T22:35:35Z · (edited)

Hi Horst,

Try highlighting and executing all of the statements at once as the attached screenshot shows.

set showplan, noexec on

select * from "dbo"."another" <----- Add your query here

set showplan, noexec off

We upgraded the Sybase JConnect JDBC driver for Aqua Data Studio version 18. Unfortunately, the way that the new JConnrect JDBC driver tests for a closed connection has changed. We depend on the JDBC isClosed() method to tell us if the connection is closed. If it is, we will display the connection closed message. In the past, the driver did not detect a closed connection after the set noexec on was executed. Now it does.

Please give that a try.

Thank you,

Tom

hmakitta 2017-11-24T19:56:40Z

Hello Tom,

I can confirm this solves the problem (for me).

Might still be irritating for other users if you don't know this trick.

Thanks!

Regards,
Horst

tomconrad 2017-11-27T15:34:43Z

Hi Horst,

I will mark this issue as resolved.

Thanks for getting back to me,

Tom

Search Tips

Aqua Data Studio / nhilam

Aqua Data Studio closes connection when executing "Set noexec on" on Sybase ASE

1 attachment

Issue #15488

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Aqua Data Studio closes connection when executing "Set noexec on" on Sybase ASE

1 attachment

Issue #15488

Completion