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
1
vote
2 answers

subquery or join?

I am using subquery and join to execute this statement: SHOW ALL THE JOB TITLES THAT EXIST IN FINANCE DEPARTMENT (DO NOT REPEAT ANY JOB TITLES) my Join works and I get right output, but subquery doesn't and I can't see an error output gives me this…
ANNA
  • 45
  • 5
1
vote
1 answer

Set up SQL Server connection in Dbvisualizer on Mac

I am trying to set up an SQL server connection in db visualiser on mac but i am getting the error "cannot connect to port 1433". I have tried to connect to the port through the terminal but i get the exact same message. Can anyone advise me on how…
Ryan Gadsdon
  • 2,272
  • 4
  • 31
  • 56
1
vote
2 answers

DB Visualizer on Ubuntu 16.04 - java.util.NoSuchElementException

I have installed DB Vizualizer using dpkg -i and when I launch DB Visualizer from the dashboard I get an error "java.util.NoSuchElementException". $ java -version Java(TM) SE Runtime Environment (build 1.8.0_131-b11) Java HotSpot(TM) 64-Bit Server…
jedi
  • 2,003
  • 5
  • 28
  • 66
1
vote
1 answer

Analysis of SQL Schema: what is the purpose of loop in ProductCategory of AdventureWorks?

I want to understand the purpose of the loop in the ProductCategory table. AdventureWorks is a sample database here provided by Microsoft. Why is there a loop in the ProductCategory table of AdventureWorks? Diagram from Microsoft SQL Server…
hhh
  • 50,788
  • 62
  • 179
  • 282
1
vote
1 answer

DBVisualizer background colour

I have DB Visualizer 9.5.7 on Windows 10 64-bit, using Java 1.8. I am not able to change the 'Normal' Background Color from the default White to another colour such as Grey (for example). I am using the Free version. Should this work? Thanks!
Acid Rider
  • 1,557
  • 3
  • 17
  • 25
1
vote
0 answers

Problems loading an obfuscated jar in DBVisualizer

I have a jar which I need to prevent others from decompiling. So I obfuscated it using ProGuard. But after obfuscation, I'm not able to load the jar file in DbVisualizer, because it throws ClassDefNotFound exception. The original class names are…
user1124236
  • 453
  • 2
  • 7
  • 17
1
vote
3 answers

in sybase ,after database password encryption ,not able to connect

Our sybase db password has been recently encrypted and post that i am not able to connect to db . i use Db Visualizer 7.1.4. I have tried changing the jars , then JCE_PROVIDER_CLASS setting but nothing seems to work .Please help. error :JZ0LA:…
munch
  • 31
  • 1
  • 2
  • 6
1
vote
1 answer

DBVisualizer and HIVE

I am using DBVisualizer 9.2 and Cloudera 5.4.1 I want to setup my db visualizer such that I can query hive database from the dbvisualizer tool. I downloaded the jdbc driver for HIVE from…
Knows Not Much
  • 30,395
  • 60
  • 197
  • 373
1
vote
1 answer

I was trying to concatenate 3 columns in SQL from dbvisualizer

I was trying to concatenate 3 columns in SQL, but I getting error message as 1) [Error Code: -440, SQL State: 42884] DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: CONCAT;FUNCTION. 2) [Error Code: -727, SQL State: 56098] DB2 SQL…
Satheesh Kumar
  • 23
  • 1
  • 5
1
vote
1 answer

DbVisualizer :Cannot connect to ORB

Please refer below error !!I am not able to add connections to database.I searched other answers but they aren't helpful. Product: DbVisualizer Free 6.5.4 Build: #1362 (2009/02/05 20:09) Java VM: Java HotSpot(TM) Client VM Java Version: …
SwapnilPopat
  • 517
  • 5
  • 26
1
vote
1 answer

SQL equals does not work for timestamps?

My table has a category 'timestamp' where the timestamps are formatted 2015-06-22 18:59:59 However, using DBVisualizer Free 9.2.8 and Vertica, when I try to pull up rows by timestamp with a SELECT * FROM table WHERE timestamp = '2015-06-22…
Mina Han
  • 671
  • 2
  • 10
  • 17
1
vote
1 answer

Create a temp table from a select query -- dbVisualizer vs SQL Developer

I've got a query: SELECT < column names > INTO <#temp_table> FROM < table > WHERE < stuff > It runs fine in dbVisualizer. However, running it in Oracle SQL Developer gives me the error "The executeQuery method must return a result set." What is…
NoSocks
  • 61
  • 1
  • 8
1
vote
2 answers

Applying dual conditions in case when in MYSQL

(question edited) My table has id,status,date,sequence Situation: Get ids which satisfies: date is max, not more than today's and status is A if more than 1 status' with same date then get id only if it has max sequence I am writing MYSQL in…
Anil Bhaskar
  • 3,718
  • 4
  • 33
  • 51
1
vote
2 answers

See actual code of function in DB2 for IBM i

Hello guy I create a function in DB2 UDB for AS/400 version 07.01.0000 V7R1m0 I use a windows with dbvisualizer to connect the server. My function is... CREATE FUNCTION JVAOBJ.BNOWPAPOL(POL VARCHAR(10)) RETURNS DECIMAL(7,7) LANGUAGE SQL NOT …
jasilva
  • 730
  • 3
  • 17
  • 45
1
vote
1 answer

Why does vsql can return all the records, while program using ODBC driver can't?

I do a simple test for Vertica: ha=> insert into test(Name, City) values( 'Nan', 'Nanjing'); OUTPUT -------- 1 (1 row) ha=> select node_name, wos_row_count, ros_row_count from projection_storage where anchor_table_name = 'test'; …
Nan Xiao
  • 16,671
  • 18
  • 103
  • 164
1 2 3
…
14 15