Stack Overflow
Stack Overflow

Questions tagged [dbvisualizer]

DBVisualizer is a popular database tool by DbVis Software AB. Written in Java, it runs on Windows, Mac OS X, and Unix/Linux, and will connect to any JDBC enabled database server.

DBVisualizer is a popular database tool by DBVis Software AB. Written in Java, it runs on Windows, Mac OSX, and Unix/Linux, and will connect to any database server.

214 questions
0
votes
2 answers

Can't access all adventure works tables on MacOS

I have adventure works on local docker container and also on a sql-server. When i try to access adventure works i have only 3 tables. On windows it works. I used DBeaver and DBvisualizer for connection. Screen-shot SOLVED: in new version of DBeaver…
ChR1sMC
  • 33
  • 1
  • 7
0
votes
1 answer

DBVisualizer query snytax to add a range of values

I need to be able to do something like this in DBVisualizer: WHERE Column = {12, 23, 55, 33, 22} Instead, I am doing this WHERE Column = 12 OR Column = 23 OR Column = 55 OR Column = 33 OR Column = 22 Is there some sort of syntax reserved for…
user246392
  • 2,661
  • 11
  • 54
  • 96
0
votes
1 answer

Sqlalchemy and DBvisualizer failing with port fowarding

To connect to our database, we need to use port forward to connect to the remote instance. ssh -i [ssh Key] -f -N -L [local port]:[host]:[remote port] [user]@[remote ip] Afterwards, I can then use this command to access the remote database. mysql…
user2820906
  • 195
  • 1
  • 15
0
votes
1 answer

Combining separate queries from the same table as separate columns

I have a query that I am trying to combine but with different columns. The specifics of this are: Same table Different Where clause Oracle DB Ran in DBVisualizer This is what I was trying to do: it runs but it does not join the two columns. they…
JJCADIZ
  • 143
  • 2
  • 14
0
votes
1 answer

DBVisualizer Hive SSH Tunnel Ignoring Server Information

I'm attempting to setup a connection to our Hadoop cluster via DBVisualizer. In order to connect I need to SSH into a server on the domain and then I need to run the command to a remote server (I've not ssh'd onto the Hadoop cluster directly) I have…
Aaron Whiteway
  • 1
  • 2
0
votes
1 answer

Keeping only date in a timestamp while joinng to date in another table

I am working with some tricky data, and am trying to join a timestamp to a date while getting rid of the timestamp all together and just keeping the date. I have tried a few different methods, but this is the most recent: convert(row_add_ts,…
burnsa9
  • 131
  • 2
  • 3
  • 10
0
votes
1 answer

DB2 declared temporary table varchar returns error -443

I'm trying to query a DB2 and I declare a temporary table like this declare global temporary table session.results (code_statement varchar, count_statement integer) with replace on commit preserve rows not logged; delete from…
jjimenezg93
  • 162
  • 4
  • 16
0
votes
0 answers

DBvisualizer character as question mark

I am using DBvisualizer and Im struggling with one thing. I have this simple statement: update table_name set column_name = replace(column_name,'š','s'); The thing is, that in DBvisualizer when i run this, it is processed as: update analysis set…
ondrikh23
  • 13
  • 2
0
votes
1 answer

How to open DbVisualizer connection (GUI) from commandline?

I wonder if it's possible to start the DbVisualizer GUI and open a db connection per command? Anyone knows if this is possible?
MKorsch
  • 3,822
  • 3
  • 16
  • 21
0
votes
1 answer

DB visualizer query running for a long time without producing any output

Hi i connected Hive using DB visualizer and fired a simple join query to fetch two columns according to the filter applied. But the query was running for more than an hour with the status "Executing". I fired the same query in Hive logging through…
Satheesh Raju Parayil
  • 1
  • 1
0
votes
0 answers

Correct driver to connect to Cloudera VM 5.10(CDH 5.10) hue hive interface sample database from client interface

I am trying to make a connection to Cloudera VM 5.10(CDH 5.10) hue hive interface sample database to test the right driver using dbVisualizer tool (https://www.dbvis.com/download) I checked CDH 5.10 has hive version 1.1, I got this information from…
Shweta Parihar
  • 1
0
votes
1 answer

Db Vis: how to visualise the data in Data Monitor with graphs?

I have the AdventureWorks db in DbVis Free edition (OSX) and I want to visualise the data in Data monitor with graphs like below. I am not sure whether this charts feature is working only in Pro. How can I visualise the data with graphs like the…
hhh
  • 50,788
  • 62
  • 179
  • 282
0
votes
1 answer

DBVisualizer Unicode Bug

I am facing a problem while inserting two characters (É (0xC389) and П (0xD0BF)) in database table that has Charset UTF-8.and Collation UTF-8 as well. These both characters come in range U+0800 - U+FFFF. So, I understand that these two characters…
SSC
  • 2,956
  • 3
  • 27
  • 43
0
votes
0 answers

unable to find or download sql server jdbc 2000 driver jar

I tried to add sqlserver 2000 jar file in DBVisualizer tool. I am facing below issue. This driver requires a JDBC driver class named:     com.microsoft.jdbc.sqlserver.SQLServerDriver. The problem is however that this driver class could not be found…
Murali
  • 1
  • 1
0
votes
0 answers

Cannot Connect to Port 3306 MySql Server on Centos from Windows

I am trying to play around with MySql on a CentOs7 Server, mostly by ssh on a Windows machine. I cannot seem to connect on to port 3306 from DBVisualizer which I am running on the Windows side. I receive the following error in the DBVisualizer…
Jack Frye
  • 583
  • 1
  • 7
  • 28
1 2 3
…
14 15