Start a new topic

DbVisualizer 5.1.1.7 now available

[This topic is migrated from our old forums. The original author name has been removed]

Hello, DbVisualizer 5.1.1.7 is now available in the early access web: http://www.minq.se/products/dbvis/eap Best Regards Roger

[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available
With version 5.1.1, I'm used to add the following line to %DBVIS-HOME%/resources/dbvis-custom.prefs file in order to make DB Visualizer portable on my USB hard disk :
user.home=./
That way, the .dbvis directory used by DB Visualizer is located in %DBVIS-HOME% instead of %USER-HOME% (?:\Documents and settings\%user%\).

Unfortunately this trick doesn't work anymore with version 5.1.1.7. I see in DB Visualizer System Properties that a new property has been introduced : dbvis.prefs.home. But I can't find any way to force or modifiy its value set to default ?:\Documents and settings\%user%\.dbvis to another value.

Note that I don't want to use the command line option -up to do so. The original trick was perfect because I only have to launch dbvis.exe to start the application.

Is there any way to change the value of dbvis.prefs.home properties ?
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available
Hi, Try set [b]dbvis.prefsdir[/b]. Post a follow-up with the result independent if it's successful or not. Regards Roger
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available
I forgot to mention that the path should *not* include [b].dbvis[/b]. Example: dbvis.prefsdir=C:\Documents and Settings\joe Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available
Thanks for your quick reply ;-)

I've tried the following lines in %DBVIS-HOME%/resources/dbvis-custom.prefs files :
dbvis.prefsdir=./
dbvis.prefsdir=F:\Development\db\dbvisualizer-5.1.1.7

Unfortunately both settings have the same result... DB Visualizer still uses ?:\Documents and Settings\%USER%\.dbvis :-(
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available
Ok, I'll check it. Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available
I've found the solution !!!

I've had the following lines to %DBVIS-HOME%\reources\dbvis-custom.prefs file:
user.home=./
dbvis.prefs.home=.dbvis

Now everything works like a charm!

Thanks for this great software.

Bertrand
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available
Bertrand, Great you found a workaround. I'll take a look anyway just to find out how it works :-) Roger
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available
Bertrand, In the next version you may use [b]dbvis.prefsdir[/b] to set an alternative location for the .dbvis directory. Setting it to "." will store property files in the same directory as DbVisualizer is installed in. $DBVIS-HOME/.dbvis Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available

roger wrote:
In the next version you may use
dbvis.prefsdir
to set an alternative location for the .dbvis directory. Setting it to"." will store property files in the same directory as DbVisualizer isinstalled in.

$DBVIS-HOME/.dbvis

Roger,

I just want to let you know I tested successfully this trick with version 5.1.1.8 and it works like a charm.

Thanks,

Bertrand
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available - charset trouble
Hi Roger,

today I met a nice little database with 'other' characters in the table and column names. Like é, ü, ë etc. When I hit show ddl from the object tree, those characters where displayed as they should. In the result grid they were not. Can you take a look at that ?

thanks,
Ronald.
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available - charset trouble
Ronald, Do you have a font set in grids that is capable displaying these characters? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available - charset trouble
Hi Roger,

that's quick ... as usual :-D
I never look at those things so it's all default. Does the default font show those ? (I hope they do)

regards,
R.
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available - charset trouble
BTW: the font is :Dialog-plain-14

I restarted dbvis and now got:
    "(ERNAM) GECREËERD DOOR" VARCHAR2(12),
in the result grid, which is good.
After a while the behaviour of dbvis changes. When dbvis runs for a while the quote character suddenly needs an extra hit on the spacebar before it appears. Here too: a restart solves this. The character issue costed me quite a while to correct ... It really caused me a problem (not one that could not be solved but also not one that made me happy ...)

R.


[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.7 now available - charset trouble
Ronald, Sorry for the late response on the font issue problem. It seem weird that the appearance of some chars change in the same DbVisualizer session. I did some Googling but unfortunately there's not much. If someone else have similar experiences then please let us know. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.7 now available - horizontal slider in resultgrid
Roger,
the horizontal slider bar in the result grid is not working ok when a long column is involved.
try with:
SELECT DBMS_METADATA.GET_DDL('TABLE', u.table_name, u.owner)
     FROM dba_tables u;
the slider can only be positioned by dragging, not by clicking next to it or on the arrows on the sides.

R.