# Using DBEAVER `(DB Client GUI)` to interact with different DBs

## Pull dbeaver

docker pull dbeaver/cloudbeaver

### edit dbeaver Dockerfile

FROM dbeaver/cloudbeaver

EXPOSE 8978

### edit Docker-compose.yaml
and you can add other DB server to this docker-compose
or you can add the target db server after docker container running that you can enter the browser ;

version: '3.7'

services:
    ...
    dbeaver:
        build: ./dbeaver/.
        restart: unless-stopped
        ports:
            - 8080:8978

You can also use `dbeaver/cloudbeaver` image after you pull that image.
And if you want to keep the settings, you can add the volumes to bind to your host machine.
Here's the `docker-compose.yml` content

version: '3.7'

services:
    ...
    dbeaver:
        image: dbeaver/cloudbeaver
        # build: ./dbeaver/.
        # container_name: CloudBeaver
        restart: unless-stopped
        volumes:
            - dbeaver-data:/opt/cloudbeaver/workspace
        ports:
            - 8080:8978
volumes:
  dbeaver-data:

### Run docker-compose

docker-compose up --build --force-recreate

## Oracle

### Connection String
dbaver is use jdbc driver, so the connection string is like this below.

jdbc:oracle:thin:@{ip}:{port}/{dbname}

### Settings
if you face the issue shows

`Error connecting to database:
Connection failed:
ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found`

please change the property to `false`

oracle.jdbc.timezoneAsRegion = false

### Result

Source

https://github.com/dbeaver/cloudbeaver

https://www.codeproject.com/Tips/5336563/Run-Database-and-GUI-Clients-in-Docker