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
0 answers

neo4j 2.1.2 dbvisualizer connection

Im trying to connect neo 2.1.2 with DBvisualizer 9.1.5 and I'm getting the following error: Database connection could not be established for:    neotest1 An error occurred while establishing the connection: Long Message: Unsupported Neo4j…
Nektarios Kyriakou
  • 45
  • 1
  • 1
  • 8
1
vote
2 answers

DbVisualizer 8.0.12 performs two updates instead of expected one update

I am using DbVisualizer 8.0.12 as the client tool towards MS SQL Server 2012 database. I want to perform simple update: update table1 set field1=0 where filed2='something'; I expect exactly one row to be updated, since field2 is primary key of…
mismas
  • 1,236
  • 5
  • 27
  • 55
1
vote
1 answer

NoClassDefFoundError when establishing a connection on DBVisualizer

I've installed my driver on DBVisualizer but when I try to connect to a database using that driver I get the NoClassDefFoundError below. I suspect it's the Apache Logging classes that it can't find, but I couldn't find how I can edit the classpath…
Henrique Ordine
  • 3,337
  • 4
  • 44
  • 70
1
vote
2 answers

Oracle Bulk Import

Bulk Import in Oracle I have created the table emp and I need to import bulk data from a file into emp For Ex CREATE TABLE emp ( c1 NUMBER, c2 VARCHAR2(30) ) File path : 'C:\Documents and Settings\TestUser\My…
Jai
  • 11
  • 1
  • 1
  • 2
1
vote
0 answers

DBVisualizer Fails to Connect

I am trying to Connect to Sybase Database (on VM Server) using Sybase SQL Anywhere (JConnect) Driver but everytime it fails with following error: Product: DbVisualizer Free 9.1.2 Build: #2072 (2013/10/28 18:25) Java VM: Java HotSpot(TM) 64-Bit…
Manan
  • 140
  • 2
  • 14
1
vote
2 answers

MySQL connection with DBVisualizer

I've created a user (1caap) in mysql root account and given read only privileges for this user to one of my database. Now my client(1caapuser) is unable to access this database. I've established the connection using Workbench. He's getting the…
Shiva
  • 11
  • 1
  • 3
1
vote
1 answer

Merge data from columns into one column

I have three different tables and i need same column from the three tables and i need to put all of the values into one output column without missing any record. below is the existing query suggest me some modifications SELECT …
Mahesh Sambu
  • 349
  • 2
  • 15
1
vote
1 answer

how to connect to hsqldb which is instantiated through spring

I'm using Embedded database for running my test cases while maven test phase. I assume Spring must be starting the HSQLDB server. Is my assumption correct ?
Pankaj
  • 3,512
  • 16
  • 49
  • 83
1
vote
1 answer

How to solve a ruby on rails version discrepancy (backward/forward compatability)

I'm new to Ruby/Ruby on Rails and I'm working with project fedena which runs on Rails 2.3.5. I looked around for a rails schema visualizer.. but I found that there are only some gems that support rails 1.x and others that support rails 3.x. Is it…
abbood
  • 23,101
  • 16
  • 132
  • 246
1
vote
1 answer

Not able to query after Alter table in DB2

We have a table someone created in DB2. I have no idea how they created it. But when I edit the table, It edits just fine. But after edit I can not query the table at all THE COLUMN CANNOT BE ADDED TO THE TABLE BECAUSE THE TABLE HAS AN EDIT…
Broken Link
  • 2,396
  • 10
  • 30
  • 47
1
vote
2 answers

PSQLException when connecting to Postgres server via JDBC in same LAN (PGAdmin works)

I have some severe problems with connecting from DBVisualizer (8.0.9) to a PostgreSQL server which is running in the same LAN. DBVis is Java-based thus uses JDBC for connection. Connecting from PGAdmin works like a charm - only DBVis connection via…
Bionicman303
  • 1,293
  • 3
  • 12
  • 15
0
votes
2 answers

CRUD processing with access controls to SQL Server database

We have built a large database model (SQL Server) for our client and an automated way to load the data into something like 100 database tables. Unfortunately due to time constraints (isn't this always the case?) we need to have some capability to…
Arthur Frankel
  • 4,695
  • 6
  • 35
  • 56
0
votes
2 answers

How to extract a portion of a URL in PostgreSQL

I'm trying to extract only a certain portion of a string URL field in my query. I am doing this in Amazon Redshift. The query is very simple, essentially SELECT email_id, url FROM emailsends WHERE date > '01-01-2023' Pretty simple overall. In the…
user14452102
  • 1
  • 1
0
votes
1 answer

Is there a way to import database connections and settings from DBVis to DataGrip?

I've been using DBVis for years, but some of my coworkers prefer DataGrip. I have about 100 database connections set up in DBVis (I'm a QA tester and this is how I check the data in all our test environments). Is there any way to import these into…
aospovat
  • 29
  • 3
0
votes
0 answers

DBVisualizer: Is there a way to adjust how the auto resize feature works on column widths?

I'm a QA tester and the software I work with involves a lot of database tables, so I'm in the habit of writing SQL queries to join the fields I'm interested in from various tables and quickly look at them. I'm using DBVisualizer Pro 11.0.5 (usually…
aospovat
  • 29
  • 3
1 2 3
…
14 15