Menu
How Can I "set server output" on in Jetbrains DataGrip IDE? I am able to do this in SQL Developer and run the SQL script successfully. The same script I try to run in DataGrip and it gives error. I know its the "set server output on" that is not working because I had to configure SQL Developer for it to work. Any advice would be appreciated. Thanks.
204
View query logOn the Output tab in the Services tool window, you can see a log of user and internal queries. Open a console for a data source F4 . Run a query for a data source. In the Services tool window, select a corresponding session for your console and click the Output tab.
If you run DataGrip on Windows in the same domain as the Microsoft SQL Server database, you can use the Single-Sign On (SSO). Navigate to File | Data Sources or press Ctrl+Alt+Shift+S . ) and select Microsoft SQL Server. Click the Driver link and select Microsoft SQL Server (jTds).
Click a data source and select File | New | Query Console. Right-click a data source and select New | Query Console. Click a data source, press Alt+Insert , and select Query Console. Click a data source, press Ctrl+Shift+F10 , and select New Query Console.
DataGrip is a database management environment for developers. It is designed to query, create, and manage databases. Databases can work locally, on a server, or in the cloud. Supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and more.
According to the documentation:
For Oracle, you can enable or disable showing the contents of the DBMS_OUTPUT buffer in the output pane. To do that, use
on the toolbar of the Database Console tool window (Ctrl+F8).
They also show an image of the window with the button enabled;
Update: 2019
The icon to enable the output looks like:
On MacOS it can be enabled with Command+F8.
185
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
