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
1 answer

DBVisualizer doesn't connect to SQL Server using jTDS

I tried to connect my database using the default Sql Server driver and it doesn't work, but from my computer with the same configuration I can connect to the Management Studio. The error is time out, it can't find the database, but the …
Roger Oliveira
  • 1,589
  • 1
  • 27
  • 55
0
votes
1 answer

MERGE INTO DbVisualizer not worknig

Heelo everyone, I'm trying to use Merge INTO to update my table from another table like that example here: MERGE INTO locations l USING new_locations n ON (l.customer_id = n.customer_id AND l.location_x = n.location_x AND …
user2320492
  • 151
  • 1
  • 14
0
votes
1 answer

SQL Query display results with wind but it skips certain lines

I've got a table with 11 columns for track and field and I've created an SQL query that sorts the table by a specific event, age group and gender, takes out all the duplicates and keeps the one with the best result. For some events it also…
NJC
  • 5
  • 2
0
votes
2 answers

SQL Query sorting rows by duplicate name keeping lowest in result

I've got a table with 11 columns and I want to create a query that removes the rows with duplicate names in the Full Name's column but keeps the row with the lowest value in the Result's column. Currently I have this. SELECT …
NJC
  • 5
  • 2
0
votes
1 answer

Query remote hive metastore to get list of tables

Hi Gurus, I want to access remote hive metastore on mapr : Below are the conf parameters: driver :"org.apache.hive.jdbc.HiveDriver" database url : jdbc:hive2://Company.com:port number/ I am using hiveserver2 and dbvisualizer is the tool from where…
elyon
  • 181
  • 2
  • 6
  • 16
0
votes
1 answer

DBvisualizer 9.1.12 errors on semicolon in comments

I recently upgraded my DBvisualizer from several versions back, to the most recent version (9.1.12), and I am getting errors on my code with reference to comment lines and semicolons in comments. For instance, against a mysql DB: select * from…
user1984308
  • 41
  • 3
0
votes
1 answer

SQLite and DbVisualizer: Using 'ATTACH'

I have a few SQLite databases and I'm using DB Visualizer Free to view the tables. I would like to create selects statements with joins between the sqlite databases. From the SQLite documentation I can see that the DB can be linked using the ATTACH…
WongSifu
  • 547
  • 1
  • 5
  • 11
0
votes
2 answers

db2 z/os transform simple query in dynamic query

I want to transform a simple query in a dynamic query, passing some variables directly. The query could be something like this: SELECT * FROM mySchema.THETABLE a WHERE a.THECOLUMN = 'someVariable'; So, I tried something like this: DECLARE v_schema…
Francesco
  • 55
  • 7
0
votes
1 answer

Is DECIMAL_DIGITS an Oracle field, and if not, how do I get that info?

I've been using dbVisualizer as a quick-and-dirty database viewer, since I'm unfamiliar with Oracle and don't have sqlplus/gqlplus available. I assumed that its "columns" view was showing me the same metadata for a table that Oracle would. The…
Jenn D.
  • 1,045
  • 4
  • 13
  • 22
0
votes
0 answers

Query different schemas

I'm working in a database with multiple databases, I'm not really sure what to call it since I am new to this kind of database layout, but basically there is a variable in the database URL that the user inputs for example: …
Sewder
  • 754
  • 3
  • 11
  • 37
0
votes
2 answers

Using a hard coded value and sub query in an IN clause

I have this query: SELECT * FROM Parent.Table WHERE Ref_Num IN ('4205' or (SELECT Ref_Num FROM Child.Table WHERE Ref_Num ='234')) AND Asset_Type IN ('PUMPS','COLL') This query doesn't work. The subquery returns 53 rows, instead of typing out all…
Sewder
  • 754
  • 3
  • 11
  • 37
0
votes
1 answer

Customize color of reference graph in DbVisualizer

Is it somehow possible to create differenet colored groups in the reference graph of DbVisualizer Free 9.1? For Example: I have table user and roles, category and pictures and each picture is related to an user, but user and roles "boxes" in the…
user2822941
  • 5
  • 3
0
votes
1 answer

query to clone table gives error

I am using the dbVisualizer to handle tables in my database, I want to clone a table. This is what I am using: CREATE TABLE TIMEREPORT.MANAGER_CONFIRMATION_CRITERIA AS (SELECT * FROM TIMEREPORT.MANAGER_CRITERIA); But it gives me an…
David Karlsson
  • 9,396
  • 9
  • 58
  • 103
0
votes
1 answer

I am extracting two columns using a case statement and selecting them into one single column

I have two columns named pno and rno both are varchar which has a order number and now my requirement is if rno is not null it should print Actual Generated, If its not then its Forecast Generated. if pno is not null then it should print …
Mahesh Sambu
  • 349
  • 2
  • 15
0
votes
1 answer

Is there any tool to access the Non Relational Database like IMS other than Mainframe?

I am looking for a tool to connect to Non relational Database IMS. Is there any tool available? Similar to DBVisualizer for Relational Database.
Priyanka
  • 11
  • 3
1 2 3
…
14 15