JetBrains PhpStorm / DataGrip introspecting Oracle database error
On PhpStorm version 2017.1.3 but I think that this error is present on any JetBrains IDE with database support.
When I choose to synchronize an Oracle schema, some objects like triggers are not shown on database and I found an error on the log.
I could not find any reason and it was working on older PhpStorm / DataGrip version (before 2016.1)
In the options tab I've added an object filter. Without it there are 5000+ tables. Even removing the regular expression on the object filter I still have the same error.
Capture of Options and Advance Options. The oracle client used is Thin.
Solution
On your connection properties check if you are using Thin Driver and change it to OCI.
- can not access to database in moodle
- How to create a filter in power BI to filter rows from a table if the particular column contains certain text?
- Make database column value dependant on another column
- How to Autocomplete several Tables with DBEdit
- Why is my LiveData not getting retrieved from the Room Database and update automatically?
- MySQL - Kill all sleeping connections
- What is the difference between these 2 queries?
- MongoDB run loop to add incremental index value in array
- SQLite as a production database for a low-traffic site
- When i run npm run dev command show error
- Most Efficient Way to... Unique Random String
- Why is my PHP code not correctly updating my CRUD application?
- How to fix the issue: "Values of types "BINARY(255)" and "CHARACTER VARYING(255)" are not comparable" while autopopulating data into H2 database?
- How to map OO inheritence to a relational database scheme?
- Why don't DBMS's support ASSERTION
- Thunderl Cient- Error: User validation failed: accountStatus: `SUSPEND` is not a valid enum value for path `accountStatus`., roles.0:
- Which column type for storing the year field in a table with rows of yearly data
- Access a MongoDB Collection Using String in PyMongo
- What is Database Normalisation/Normalization?
- Check for changes to a SQL Server database?
- Import some database entries through PHPMyAdmin with overwrite
- Is the primary key automatically indexed in MySQL?
- Add new field based on the value of the existing field - MongoDB Aggregate
- Modify and delete tables and apply to DBContext
- Composite Primary Keys : Good or Bad?
- Query that returns the size of a table in a SQLite database
- Declare local variables in PostgreSQL?
- How to migrate data from MongoDB to SQL-Server?
- Custom sorting a dataframe based on multiple columns
- How add unique key to existing table (with non uniques rows)