Oracle is not supported very well
Answered
I'm using https://github.com/gvenzl/oci-oracle-xe#initialization-scripts with:
docker run --rm --name oracle -p 1521:1521 -e ORACLE_PASSWORD=letmein -v $pwd/sample-data:/container-entrypoint-initdb.d gvenzl/oracle-xe:full
sample-data contains 1_create_user.sql 2_create_data_model.sh as described in the Github repo.
First problem I had was connecting to DB via Datagrip. I had use Service Name XEPDB1 as the default SID connection type didn't work.
jdbc:oracle:thin:@//localhost:1521/XEPDB1
Once connecting with test/test (as setup by init script) using jdbc Oracle 21 driver it doesn't show the table in the sidebar. Is that to be expected?
Please sign in to leave a comment.
Hello,
> First problem I had was connecting to DB via Datagrip. I had use Service Name XEPDB1 as the default SID connection type didn't work.
By default Oracle uses XE SID. If it's changed then it should be changed in connection settings.
> Once connecting with test/test (as setup by init script) using jdbc Oracle 21 driver it doesn't show the table in the sidebar
Was this table created in TEST database? Am I got it right that table name is highlighted red, but query works fine?
Yes queries work, but the tables do not show. I noticed the exact same behaviour in dbeaver Version 22.3.3.202302041916
You can see how I create the database here btw: https://github.com/kaihendry/oracle-sql
Does the completion work in query? Could you please try to type "Select * from TEST." and check what completion suggests?