Jim Gust

Follow New posts New posts and comments

Created March 23, 2023 14:14

Cbd Thank you for that update!  I tried to install DG by uninstalling the previous version and installing the new one after a reboot.  That didn't go well because I couldn't connect to my Oracle db...

1. Community
2. DataGrip
3. Export to JSON unavailable

• 0 votes

Created March 22, 2023 19:06

Below find the contents of the JSON-Groovy.json.groovy extractor that I have. Filename:  JSON-Groovy.json.groovyLocation: C:\Users\<user>\AppData\Roaming\JetBrains\DataGrip2022.3\extensions\com.int...

1. Community
2. DataGrip
3. Export to JSON unavailable

• 0 votes

Created December 07, 2022 19:11

William Stam's comment in https://youtrack.jetbrains.com/issue/DBE-3017 demonstrated the removal of the filter.

1. Community
2. DataGrip
3. On the new UI 2022.3

• 0 votes

Edited October 10, 2022 14:20

Most of my efforts in the db are spent creating procedures whose sole purpose is to provide data to a report which means the procedure returns an SYS_REFCURSOR. In DG when you select to run a proce...

1. Community
2. DataGrip
3. Print the ref cursor results in a grid when running oracle stored procedures

• 0 votes

Edited July 22, 2022 16:43

I was using the thin client with 19.8.00 drivers. I just switched to OCI and am able to connect

1. Community
2. DataGrip
3. Cannot connect using Oracle and Kerberos after 2022.2 update

• 2 votes

Edited June 22, 2022 13:50

I agree, that is what is happening.  In other IDE's I don't have to issue new tickets but only this one I do. I've modified my ticket for 1 day lifetime and renew lifetime to 3 days.  Hopefully, th...

1. Community
2. DataGrip
3. Help with Oracle and Kerberos

• 0 votes

Created June 16, 2022 13:20

I spoke too soon.  Again the next day without making any connection changes I am getting the Principal Name error.   Making no changes other than running "KINIT JGUST" I was able to log in using m...

1. Community
2. DataGrip
3. Help with Oracle and Kerberos

• 0 votes

Created June 15, 2022 20:53

Thanks for pointing me to the advanced properties. I updated the oracle.net.kerberos5_mutual_authentication to true and added the following entry to the VM Options: -Djava.security.krb5.conf=C:\Ora...

1. Community
2. DataGrip
3. Help with Oracle and Kerberos

• 1 vote

Created January 24, 2022 19:10

Eric, Thank you for the update.  Based on what you did I expanded the Oracle date logic to cover all of the date data types.  Below is my SQL-Insert-Statements.sql.groovy /** Available context bind...

1. Community
2. DataGrip
3. What objects/functions are available for custom data extractors?

• 0 votes

Created August 11, 2021 12:15

You can expand the column list by going behind the * and activating your context actions (Alt+Enter).

1. Community
2. DataGrip
3. Extract Columns for renaming

• 1 vote