Thursday, December 10, 2015

Installing dbeaver application Debian 8



Dbeaver is Free multi-platform database tool.It supports  most of the popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MongoDB,

We will first Download debian package dbeaver-ce_3.5.5_amd64.deb from


After completing download open with package installer complete the installation.Launch dbeaver create a new connection, for oracle.oracle jdbc driver you need to download first manually then need to add it to library.

  Now you will be able to create oracle connection object but testing connection if give timezone region not found error then as we have done for SQL Developer we have to pass certain driver properties.Can be seen in connection setting of current connection.

To pass this timezone to application we have to pass parameter at the time of running it so from bash shell we can run it as

dbeaver -vmargs -Duser.timezone=GMT+IST

Now if we saw connection succeeds but each time we have to run app with this additional parameter here parameter value  is specific to India should be replaced by relevant to your installation.

To  run this app with required parameter we will create a shell script as follows

Script

#!/bin/bash
/usr/share/dbeaver/dbeaver -vmargs -Duser.timezone=5.30 &>/dev/null &


saving this in mydbeaver.sh copy to /usr/local/bin

Now we will give this script suitable file permission

chmod u+x /usr/local/bin/mydbever.sh

issue mydbever.sh from command line, your application will able to connect to oracle without hassles of passing parameters each time.

In bash file instead of IST, GMT+5.30 is added as postgres connection somehow can't work with IST paramter value.

Dbeaver is nice application that has capability to connect to multiple databases. we are able to connect ORACLE,MySQL & Postgres simultenously in Dbeaver.

References:
http://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge

http://dbeaver.jkiss.org/forum/viewtopic.php?f=2&t=596

4 comments:

  1. You also may solve the problem by adding a "User propertie" named oracle.jdbc.timezoneAsRegion with the value false.
    To do this i created the connexion without testing (test gives error)
    After the connection is created : right click>Edit connection>Connection String>Driver properties>right click in User properties>Add new property

    Reference:
    http://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found

    ReplyDelete
    Replies
    1. Thank you Emmanuel Duviviers - creating the user property solves the issue.

      Delete