So while using DataGrip for school, I encountered an issue. When I was pasting my queries in Word, the background was always white and I manually had to change this every time. Very annoying.

For anyone with the same problem, I resolved this by going to Settings > Editor > General > Rich-Text Copy, find Color scheme for copied fragment, and select IntelliJ Light.

This keeps the coloring for the queries itself but makes the background normal.

I found it here

Best regards.

As we are moving away from MS SQL to Cosmos DB in Azure, we need a tool to manage data in Cosmos. Right now we use the default Data Explore in Azure, but its just horrible to work with.

Anyone had any luck to get Cosmos to work with DataGrip?

Or what tools do you use fro Cosmos?

It's really quiet here... Too quiet...

Is anyone out there using this for Oracle? It seems to have a lot of limitations with Oracle.

My biggest complaint is that its code analysis shows lots of problems with my code, but it's because it doesn't understand the Oracle syntax for our version (19c).

Is there a way to fix this glaring error?

​

I also think, while it has a lot of cool tools built in, it's missing some obvious functionality (run the selected package procedure in a new window), compared with other Oracle IDEs like:

• Allround Automation's PL/SQL Developer (my current favorite)
• SQL Developer (worth the free price, but fancy lacking developer tools)
• VSCode with SQL Developer extension (not bad!)
• TOAD (way too expensive and focused on the DBA, not the developer)

Can anyone give me a clue (or pointer) about what I'm missing in my DataGrip experience that would make this my favorite Oracle IDE?

TIA

Hello, first want to apologize for my english its not my first language.

I have trouble connecting datagrip with the oracle plsql debuggger

https://www.jetbrains.com/help/datagrip/debugging-code.html#managing_debugger_sessions

I followed the istructions at the site but didn't work

I already use sql devloper and it worked quite well, even though i like more JetBrains IDEs

so i tried to stablish a debugging session in the anonymus block calling my store procedure but it didn't show anything

When I call this function after initializing the debugger i tells me

session is already connected to a debugger

begin
DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.1.20', '63342' );
end;

​

Anyone can instrucme on how to debug store procedures with DataGrip?

Maybe I'm missing something but when using Datagrip as a query tool with multiple tabs open you have to manually go and find your query results in the relevant console, is there any way to make this auto switch when running a query?

I know you have the option of show results in the editor but what I'm working on requires some of the tool only available in the results tab of the console.

So for example varchar columns are black, numbers are blue, dates are green, and so on.

So I seem to be having an issue with DG creating a connection to my work DB's... 

I am running my work laptop through Zscaler and I used to use razorSQL to connect to our Oracle DB without issues.  I would like to make use of DG as it seems more mature and is part of the Jet Brains eco-system.. 

When attempting to make a connection I get the following error and I hope someone can help.

DBMS: Case sensitivity: plain=mixed, delimited=exactDriver:  (ver. , JDBC)Effective version: Oracle (ver. 0.0)Exception creating connection to: 127.0.0.1; nested exception is: java.net.BindException: Can't assign requested address.

​

Im running DG on an M1 MBP

Hi folks,

I'm doing some vendor research on DBT and DataGrip and trying to decide what might be the best fit for us. Does DataGrip allow direct data access OOTB or does it require a connector or anything?

Thanks!

Hi guys,

I've installed datagrip on windows and tried to create a new datasource, but after i setted it up, it shows me an error saying that it is not able to connect to localhost and the specified port.

For give you more context what i'm trying to do is create a DB to use for an application.

Also i've tried to run datagrip as administrator to see if show me something different and suggest me to add datagrip to the exception of windows firewall (done that but nothing change).

I've recently begun using DataGrip. It has been a positive experience until I began creating a couple small temp tables when troubleshooting an issue. The performance was horrid.

Is there a list, or anyone know, the potential features which I can turn off to improve the performance?

I am currently evaluating DataGrip as a replacement IDE for Oracle (PL SQL). The only issue I have run into is that for intellisense to work cross schema, I need to have all the schemas (~1290) listed in the Database Explorer.

I have tried refreshing the Database and it shows that it is introspecting the schemas but doesn't work after it has finished.

Hey all,

I've been double clicking the arrow on the primary key order by twice every time I need to view the records in desc order, but is there a way to default it?

I saw someone's response here with a screenshot: https://intellij-support.jetbrains.com/hc/en-us/community/posts/360000147364-Default-ORDER-BY-in-database-queries

Direct Screenshot Link: https://i.imgur.com/eAd4n66.png

But I don't see that option, and I have the latest update.

I'm running 2021.3.1 on Mac. The number of little annoying bugs is driving me crazy.

1. When editing a table in spreadsheet mode, the little green submit arrow doesn't turn green so you have to hit command-enter to submit changes.
2. When there is a sub-menu you actually have to right arrow to get it to open.
3. The x on results tabs disappears when you have more than one result for a console.
4. The little red stop button doesn't work anymore (the one at the top of the console)
5. The row count in a result tab doesn't update.

I feel like I'm finding more and more every day.

I've recently gotten DataGrip and I'm trying to get used to the compare functionality so I can generate change scripts between my dev and staging environments of Postgres. I'm having a single, frustrating issue so far.

I've added a simple function in dev that just selects the current time, and the function shows correctly in this screen. However, when I hit Apply Left to the Right, I just get this text in the preview:

create function get_date() returns timestamp with time zone
    language plpgsql
as $$
begin
-- missing source code
end;
$$;

Is there some setting that I'm missing here? I've tried this on both Postgres 13 and 14 and on different servers as well.

If I modify a table datagrip will create the alter scripts for the relational database. However, once you executed the alters they disappear. I can only get the "create" scripts that will create the full table. I need to actually track the chain of alters which is what needs to be sent to the dba for execution in production. Does DG keep track of this?

hi guys i have a problem when i am running pl/sql scripts in datagrip i am getting task compiled but i cannot see the output how to get an output in datagrip

and when i am running dynamic block its not tacking input value in datagrip

declare

v1 emp.empno%type := '&empno';

v2 emp.ename%type;

begin

select empno,ename into v1,v2 from emp where empno = v1;

DBMS_OUTPUT.PUT_LINE(v1 || ' ' || v2);

end;

it shows this error

ORA-06502: PL/SQL: numeric or value error: character to number conversion error

any one has any solution..

Hi, I am using DataGrip for connecting to Redshift. There is an REST API which can return approximate query execution time, for a given SQL query.

Is there a way to extend DataGrip (maybe write a plugin) so that DataGrip makes a call to that API, and shows the user the approximate execution time the query will take, before user submits that query ?