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
3
votes
2 answers

How to figure out Oracle Connection String from PL SQL Developer's connection?

I PL/SQL Developer installed (pre-loaded by my company) on my laptop, when I want to connect to an ORACLE database, all I give it is Database Name, User Name and Password and it connects successfully. I also have DBVisualizer installed on my…
Karthik Balasubramanian
  • 1,127
  • 4
  • 13
  • 36
3
votes
3 answers

Replacing "(null)" with blank cell in SQL query result

I believe what I'm asking here is possible, but I haven't find a way yet : Some cells in the result of my SQL SELECT-FROM-WHERE query are blank, and in DbVisualizer, (null) is written inside. I'd like to display a blank cell instead. I've already…
AdrienW
  • 3,092
  • 6
  • 29
  • 59
3
votes
3 answers

ORA-12514 error on **DBVisualizer**

Please help with this error on DBVisualizer. No oracle or Sql is installed i just simply use DBVisualizer. I have read lot of answers here on stackoverflow but not able to find a suitable answer. Note : I used Oracle Thin Driver for connection.I…
SwapnilPopat
  • 517
  • 5
  • 26
3
votes
7 answers

Loading data into a table

I'm new to Hive and using DBVisualizer for hive I have a text file in the path *D:\data files\datafiles*. I want to load data from one of the files to a table created in hive. while i'm trying the following, load data inpath "D:\data…
RAVITEJA SATYAVADA
  • 2,503
  • 23
  • 56
  • 88
2
votes
1 answer

How to Bulk Import data from file into Netezza DB?

I want to bulk import data from a file present on my local into the Netezza Database using NZSQL language. I tried with below query but, I am not able to do it. create external table ext_tab ( login_email VARCHAR(10),identifier int,first_name…
sujay777
  • 41
  • 5
2
votes
0 answers

DBVisualizer Error : Long Message: SSL error: Connection reset, Details: Type: java.sql.SQLException SQL State: 08006

I am getting below error while trying to connect to a Redshift database thru DB visualizer. It was working fine but then computer restarted and it stopped working. Now giving below error while connecting to Redshift - An error occurred while…
Codegator
  • 459
  • 7
  • 28
2
votes
3 answers

MySQL - Trouble with creating user defined function (UDF)

I'm trying to create this function: CREATE FUNCTION remove_non_alphanum (prm_strInput varchar(3000)) RETURNS VARCHAR(3000) DETERMINISTIC BEGIN DECLARE i INT DEFAULT 1; DECLARE v_char VARCHAR(1); DECLARE v_parseStr VARCHAR(3000) DEFAULT ''; …
Greg
  • 45,306
  • 89
  • 231
  • 297
2
votes
1 answer

What does the hash(#) operator do in Postgresql

I'm trying to replicate a function that a former employee built within Postgres in another language and having trouble working out what the # operator does. I've run a few numbers through it and there doesn't seem to be any consistency in the…
Rossy
  • 65
  • 1
  • 6
2
votes
1 answer

How to connect sql server using docker on mac?

I am trying to connect to sql server using docker. I have successfully enabled the container using this command sudo docker run -d --name aakash -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Maximus6hero@" -p 1434:1434 microsoft/mssql-server-linux docker…
Nishant Kumar
  • 31
  • 4
2
votes
1 answer

SQL Month YTD and prior YTD data

I am trying to write a query to return Month-To-Date data for the Current Year, and also the Previous Year. Meaning I need data from 2017-07-01 to 2017-07-26 and also 2016-07-01 to 2016-07-26. However, my query currently returns data from 2017-07-01…
George
  • 23
  • 3
2
votes
2 answers

How to visualize embedded derby database?

I am using the embedded derby database in a small Java project. Are there any possible ways to visualize the database? I hope to see the tables and data in the database. I have tried DbVisualizer. Since embedded derby database could only accessed by…
Angie.W
  • 21
  • 1
2
votes
2 answers

Which DB driver to use DbVisualiser with Azure SQL?

I have earlier used Microsoft SQL Server Management Studio here with Azure SQL here but I want to try DbVis (a platform independent alternative). I am trying DbVis in OSX. I could find JDBC driver for SQL Server here but not sure whether this…
hhh
  • 50,788
  • 62
  • 179
  • 282
2
votes
1 answer

DbVisualizer cannot connect to PostgreSQL database without authentication

I have a local PostgreSQL database that does not require authentication, but I cannot connect it through DbVisualizer when I leave 'Authentication' fields (Database Userid, Database Password) empty. It shows the following error in Connection…
Talha Awan
  • 4,573
  • 4
  • 25
  • 40
2
votes
1 answer

How to connect Neo4j JDBC driver with DbVisualizer

I am running Neo4j 2.1.6, tried Neo4j 2.20 as well. I can not connect it with DbVisualizer 9.1.13 And I can not find ANY step by step clear explanation on how to do it. First I've got binary JDBC Neo4j-2.0.1-SNAPSHOT here I can run my just installed…
master-lame-master
  • 3,101
  • 2
  • 30
  • 47
2
votes
1 answer

how to configure web sphere portal 8 derby database in visualizer?

I want to view the data inside the portal Derby DB, what data it is storing, how it is retrieving, i want to visualize the derby databases of IBM WebSphere portal 8 Derby data bases in DBVisualizer. can any one tell be steps to configure in DB…
Koti Reddy
  • 79
  • 1
  • 1
  • 9
1
2
3
…
14 15