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
No comments:
Post a Comment