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

How do I view CLOB/BLOB data in DBVisulaizer?

I am trying to retrieve some CLOB/BLOB data from my database using the DBVisualizer. Could someone please tell me how I could do that? Any other tool/options outside DBVis would also be helpful. Thank you.
user526754
  • 3
  • 4
0
votes
1 answer

Oracle auto increment trigger issue

I am having an issue when creating the auto increment trigger in Oracle 11g. If someone can point out what I am doing wrong, I would really appreciate it. My script for the sequence is this : CREATE SEQUENCE SPSS_QUOTE_LINE_ITEMS_SEQ start with…
John
  • 5
  • 4
0
votes
1 answer

Database Profile for DBVisualizer & SnappyData?

We are using the DBVisualizer Generic profile and Wizard setup to access SnappyData Store, however, the tool randomly loses track of which Driver class to load and then, you need to re-create the connection each time. Product: DbVisualizer Pro 9.2…
Jason
  • 2,006
  • 3
  • 21
  • 36
0
votes
2 answers

SQL query sum and max one table, join to get corresponding value of another

I'm trying to query some data from SQL such that it sums some columns, gets the max of other columns and the corresponding value from another table. For example, |table1| |id| |shares| |date| 1 100 05/13/16 2 200 …
08351ty
  • 43
  • 6
0
votes
0 answers

DB visualizer tool, not able to show data while run sp

Issue in using dbvisualier tool: While sp can be executed, no result output showing up. This SP is tested ok to show data with others DBvisualizer. by simply testing sp_helptext, its not able to showing output with notification as : 17:37:15 …
ella
  • 153
  • 1
  • 12
0
votes
0 answers

ORA-01858 error-to_date() in sql

I'm using the query select to_date(DateString,'MM/dd/yy hh24:mi:ss') from tableName where to_date(DateString,'MM/dd/yy hh24:mi:ss') between to_date('2015-10-01','yyyy-MM-dd') and to_date('2015-10-31','yyyy-MM-dd'); the result is: ORA-01858:a…
radhik
  • 51
  • 1
  • 7
0
votes
1 answer

SQL Query-Multiple date ranges

I want to fetch some data from DB by giving multiple date ranges. Example,in February I want to get weekly report from a table in this order Feb 01 to 07, Feb 07 to 14, Feb 14 to 21, Feb 21 to 28 and Feb 28 to Mar 01. In DB the records are stored in…
radhik
  • 51
  • 1
  • 7
0
votes
1 answer

Is it possible to change a column without run raw sql in DbVisualizer + SQLite

Working on a SQLite database, seems DbVisualizer Pro does a lot of work very well, except one, Changing table schema. I often need to change column name, data type, etc, but don't want to do it through raw SQL statement. My workaround is opening…
Rm558
  • 4,621
  • 3
  • 38
  • 43
0
votes
0 answers

Dissimilar Data from the same database in different softwares

I'm using two softwares dbvisualizer and PGAdmin and connecting to the same database say db(Postgresql). The database db has a table timeRecord with a column which has a datatype as timestamp. I'm connecting both PGAdmin and dbvisualizer to db, and…
RakeshArk
  • 1
  • 4
0
votes
2 answers

Output multiple queries to same table/file?

I have a bunch of very simple SELECT statements. I would like to output them all to the same resultset (UI table or file). Here is the most recent thing I tried: @export on; @export set filename="c:\test.csv"; @export set…
user736893
0
votes
1 answer

Empty Object Explorer When Opening a H2 embedded database(.mv.db file) in DbVisualizer

EDIT: Please ignore the Database Type "MySQL". I have it set to H2 currently, I was just playing around with settings at the time of the screengrabs in an attempt to see if I could pinpoint what was going wrong. My friend came to me tonight with an…
SQL Taylor
  • 138
  • 11
0
votes
1 answer

Update one table from another within MySQL, via DBVIS SQL commander

I have adapted the solutions already posted on this question to my task but it is still generating the error: Unknown column testbr.Tel in 'field list' UPDATE `Test_file_base_record_subset` `testbr` INNER JOIN `UKTI_16sep15` `ukti` ON…
Lorna
  • 3
  • 2
0
votes
1 answer

Can AS/400 Database Tables Be Hidden?

I was trying to delete a record from a table in AS/400 database. I got an error message saying that there is a referential integrity to another table XYZ in the same Schema ABC. To my wonder, that table was not in the list of the tables shown by my…
Kushal Paudyal
  • 3,571
  • 4
  • 22
  • 30
0
votes
1 answer

hql select from final table

Here is my query: update JSNumber set runningNo=(select runningNo +1 from JSNumber where paymentDate= '2015-07-09 00:00:00.0' ) where paymentDate = '2015-07-09 00:00:00.0' This is working fine when I set it to a StringBuilder sb, and run as…
Panadol Chong
  • 1,793
  • 13
  • 54
  • 119
0
votes
2 answers

extremly disproportionate running time for query. Trying to understand RDBMS

I am working with a customers database (db2) where our company only has read access. Hence I don't have any control over indices, schema and the like. I want to emphasize this point, because there still might be indices I just don't know where. So I…
dingalapadum
  • 2,077
  • 2
  • 21
  • 31
1 2 3
…
14 15