Customer would like support for ADS to be able to read SQL files from One Drive folder. At this time the file has to be on the local machine.
There is no API available. Investigate for release.
16 KB
41 KB
12 KB
45 KB
300 KB
10 KB
22 KB
15 KB
51 KB
22 KB
Screen shots and logs attached.
"Hi, I am noticing strange ADS behavior, with the latest version of Microsoft OneDrive.
If I drag a query from OneDrive into ADS, the contents of the file do not show up in the Query Analyzer window.
Furthermore, after attempting to open up a query with that drag/drop method, anytime I try to toggle comments in a query using the right-click features, I get a Java application error.
The only way I can re-enable the comment toggle is by reinstalling the ADS files by running the ADS installer. After that, I can use the comment toggle, but still opening a query by drag/drop does not work...and then I loop back into the comment toggle issue.
Have you heard of this issue from other users?
Thanks,
Joe "
License Key: 4A9F083D49628999DE7C243CFF42BC6BB6A7405B71A3E317****************
Product: Aqua Data Studio
Version: 18.5.0-2
Build #: 55633
Build Date: 2017-Dec-06 03:06:36 PM
Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_102-b14
Memory: Max=954,728,448; Total=627,572,736; Free=342,078,424; CPUs=4
In-Window Graphics Capabilities
Graphics Vendor: Intel
OpenGL Renderer: Intel(R) Iris(TM) Plus Graphics 640
OpenGL Version: 4.5.0 - Build 22.20.16.4749
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 16
Hardware Acceleration: Enabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0
Initialization Time: 1939 ms
Offscreen Graphics Capabilities
Graphics Vendor: Brian Paul
OpenGL Renderer: Mesa OffScreen
OpenGL Version: 2.1 Mesa 7.8.2
Double-Buffering: Disabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Disabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16
Initialization Time: 63 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes
Offscreen Rendering: Enabled
Offscreen Buffer Size: 800x600
've been able to load and save my queries on a OneDrive folder for quite a long time until recently when ADS started to load a blank page instead of the query file content. It can't save a file neither. No errors are showing, but the query content isn't saved at all.
I assurme Microsoft must have made a change to the OneDrive platform that affect ADS because it stopped working suddenly without any update of ADS. I made sure to move to the latest ADS version 18.5 but no improvement.
I really like to use OneDrive since it keep my files safe seamlessly and dynamically.
Product: Aqua Data Studio
Version: 18.5.0-13
Build #: 55766
Build Date: 2018-Mar-27 02:15:00 PM
Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / fr / CA / Oracle Corporation 1.8.0_102-b14
Memory: Max=954 728 448; Total=565 706 752; Free=322 862 080; CPUs=4
In-Window Graphics Capabilities
Graphics Vendor: Intel
OpenGL Renderer: Intel(R) HD Graphics 520
OpenGL Version: 4.5.0 - Build 22.20.16.4836
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 16
Hardware Acceleration: Enabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0
Initialization Time: 1343 ms
Offscreen Graphics Capabilities
Graphics Vendor: Brian Paul
OpenGL Renderer: Mesa OffScreen
OpenGL Version: 2.1 Mesa 7.8.2
Double-Buffering: Disabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Disabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16
Initialization Time: 73 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes
Offscreen Rendering: Enabled
Offscreen Buffer Size: 800x600
've been able to load and save my queries on a OneDrive folder for quite a long time until recently when ADS started to load a blank page instead of the query file content. It can't save a file neither. No errors are showing, but the query content isn't saved at all.
I assurme Microsoft must have made a change to the OneDrive platform that affect ADS because it stopped working suddenly without any update of ADS. I made sure to move to the latest ADS version 18.5 but no improvement.
I really like to use OneDrive since it keep my files safe seamlessly and dynamically.
Product: Aqua Data Studio
Version: 18.5.0-13
Build #: 55766
Build Date: 2018-Mar-27 02:15:00 PM
Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / fr / CA / Oracle Corporation 1.8.0_102-b14
Memory: Max=954 728 448; Total=565 706 752; Free=322 862 080; CPUs=4
In-Window Graphics Capabilities
Graphics Vendor: Intel
OpenGL Renderer: Intel(R) HD Graphics 520
OpenGL Version: 4.5.0 - Build 22.20.16.4836
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 16
Hardware Acceleration: Enabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0
Initialization Time: 1343 ms
Offscreen Graphics Capabilities
Graphics Vendor: Brian Paul
OpenGL Renderer: Mesa OffScreen
OpenGL Version: 2.1 Mesa 7.8.2
Double-Buffering: Disabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Disabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16
Initialization Time: 73 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes
Offscreen Rendering: Enabled
Offscreen Buffer Size: 800x600
Not able to save or load files from One Drive. He had been able to do it until recently, the last week, and then couldn't.
User was on 18.0.1 but updated to 18.5.
Product: Aqua Data Studio
Version: 18.0.18
Build #: 55109
Build Date: 2017-Jul-12 02:09:22 PM
Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_102-b14
Memory: Max=2,863,661,056; Total=536,870,912; Free=281,527,912; CPUs=8
In-Window Graphics Capabilities
Graphics Vendor: Intel
OpenGL Renderer: Intel(R) HD Graphics 530
OpenGL Version: 4.4.0 - Build 21.20.16.4550
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 16
Hardware Acceleration: Enabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0
Initialization Time: 1705 ms
Offscreen Graphics Capabilities
Graphics Vendor: Brian Paul
OpenGL Renderer: Mesa OffScreen
OpenGL Version: 2.1 Mesa 7.8.2
Double-Buffering: Disabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Disabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16
Initialization Time: 51 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes
Offscreen Rendering: Enabled
Offscreen Buffer Size: 800x600
Scott Mallory
Senior Software Engineer I
Digital Science
Not able to save or load files from One Drive. He had been able to do it until recently, the last week, and then couldn't.
User was on 18.0.1 but updated to 18.5.
Product: Aqua Data Studio
Version: 18.0.18
Build #: 55109
Build Date: 2017-Jul-12 02:09:22 PM
Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_102-b14
Memory: Max=2,863,661,056; Total=536,870,912; Free=281,527,912; CPUs=8
In-Window Graphics Capabilities
Graphics Vendor: Intel
OpenGL Renderer: Intel(R) HD Graphics 530
OpenGL Version: 4.4.0 - Build 21.20.16.4550
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 16
Hardware Acceleration: Enabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0
Initialization Time: 1705 ms
Offscreen Graphics Capabilities
Graphics Vendor: Brian Paul
OpenGL Renderer: Mesa OffScreen
OpenGL Version: 2.1 Mesa 7.8.2
Double-Buffering: Disabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Disabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16
Initialization Time: 51 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes
Offscreen Rendering: Enabled
Offscreen Buffer Size: 800x600
Scott Mallory
Senior Software Engineer I
Digital Science
With ADS version 19.0, saving to a OneDrive Entreprise works but still not able to open a file.
With ADS version 19.0, saving to a OneDrive Entreprise works but still not able to open a file.
Hi Eric,
The OneDrive feature is on the roadmap for Aqua Data Studio version 20. It has not been added to version 19.
Thanks, Tom
Hi Eric,
The OneDrive feature is on the roadmap for Aqua Data Studio version 20. It has not been added to version 19.
Thanks, Tom
Issue #15510 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
1 issue link |
relates to #15509
Issue #15509Query Analyzer - Opening an SQL file in QA when the file is located in a OneDrive folder causes endless loop. |
Screen shots and logs attached.
"Hi, I am noticing strange ADS behavior, with the latest version of Microsoft OneDrive.
If I drag a query from OneDrive into ADS, the contents of the file do not show up in the Query Analyzer window.
Furthermore, after attempting to open up a query with that drag/drop method, anytime I try to toggle comments in a query using the right-click features, I get a Java application error.
The only way I can re-enable the comment toggle is by reinstalling the ADS files by running the ADS installer. After that, I can use the comment toggle, but still opening a query by drag/drop does not work...and then I loop back into the comment toggle issue.
Have you heard of this issue from other users?
Thanks,
Joe "
License Key: 4A9F083D49628999DE7C243CFF42BC6BB6A7405B71A3E317****************
Product: Aqua Data Studio
Version: 18.5.0-2
Build #: 55633
Build Date: 2017-Dec-06 03:06:36 PM
Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_102-b14
Memory: Max=954,728,448; Total=627,572,736; Free=342,078,424; CPUs=4
In-Window Graphics Capabilities
Graphics Vendor: Intel
OpenGL Renderer: Intel(R) Iris(TM) Plus Graphics 640
OpenGL Version: 4.5.0 - Build 22.20.16.4749
Double-Buffering: Enabled
Anti-Aliasing: Enabled
Anti-Aliasing Sample Count: 16
Hardware Acceleration: Enabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0
Initialization Time: 1939 ms
Offscreen Graphics Capabilities
Graphics Vendor: Brian Paul
OpenGL Renderer: Mesa OffScreen
OpenGL Version: 2.1 Mesa 7.8.2
Double-Buffering: Disabled
Anti-Aliasing: Disabled
Anti-Aliasing Sample Count: 0
Hardware Acceleration: Disabled
Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8
Depth Bits: 16
Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16
Initialization Time: 63 ms
Hardware PBuffer Available: No
Using PBuffer: No
Using Ram Buffer: Yes
Offscreen Rendering: Enabled
Offscreen Buffer Size: 800x600