Query Manager Log

Note: please leave bug reports and feature requests on

Query Manager Log

Postby Quatchy » Wed Aug 21, 2013 11:32 am

Hello guys,

looking for a free DBVisualizer alternative i stumbled upon DBeaver. Well, i did stumple upon SQuirreL first but lets leave that fact out. I love the look and feel and the feature set of DBeaver. Even better i might be able to explain and get my colleagues to use it.

The thing I cant seem to get to work is a seesion-wide persistent Query-Manager. So either there is some error in the program, I'm doing something wrong or its not yet implemented.

I cant find any errors in the error log. The log path is not write protected or anything and I did run DBeaver as Administrator priviliges just to rule it out.

I kinda need that feature... my colleagues won't like the idea of saving SQL scripts.

Thanks for the help!
Quatchy
 
Posts: 3
Joined: Wed Aug 21, 2013 11:24 am

Re: Query Manager Log

Postby Serge » Wed Aug 21, 2013 1:57 pm

Hello,

DBeaver has Query Manager log which is session-wide and can be configured to store logs in files. So I actually didn't understand the nature of your problem. Is it about query log viewing or about persistence?
I'll attach two screenshots with a sample query log and query manager configuration.

Thanks
Attachments
query_manager.png
query_manager.png (77.56 KiB) Viewed 40365 times
Query_manager_Config.png
Query_manager_Config.png (55.03 KiB) Viewed 40365 times
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Query Manager Log

Postby Quatchy » Wed Aug 21, 2013 2:20 pm

The problem is the persistence. The Query-Manager is working and logs all statements within the session. As soon as i close and reopen the program everything is gone. As you can see from the attachment i also turned on the logging for "metadata read". So the first entries are brought up every time i open DBEaver. I've played around quite a bit with the options just to ensure im not doing something wrong.

Hope you can help. As i explained before there is no error shown in the error log.

Whatever the problem is i think im gonna stick with your program. I just love it.
Attachments
querymanager.jpg
querymanager.jpg (76.49 KiB) Viewed 40365 times
Quatchy
 
Posts: 3
Joined: Wed Aug 21, 2013 11:24 am

Re: Query Manager Log

Postby Serge » Thu Aug 22, 2013 8:27 am

There is nothing in error log because it is not a bug, it is lack of functionality.
Query manager writes log on disk but never reads it (due to performance/memory consumption issue - query log can be really huge).
You can open this log manually using Error Log view (there is "Import Log" function).

Actually we had plans to persist logs in lightweight embedded database - additionally it will allow to search in log. But as it is not very urgent task it is still not implemented.
Hopefully we'll return to it this autumn.

Kind regards,
Serge
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Query Manager Log

Postby Quatchy » Thu Aug 22, 2013 9:12 am

Thanks a lot. I found the function to import the log. Seeing the functionality in other tools i probably jumped to the wrong conclusion on how the log should be read.

It would be great to see the log implemented in an embedded DB. I already made use of the search function within SQuirreL and i think it is a great feature but the lack of that one function won't let me stop using DBeaver.

Thanks for the great support!

Kind regards
Quatchy
 
Posts: 3
Joined: Wed Aug 21, 2013 11:24 am

Re: Query Manager Log

Postby joselitux » Thu Sep 17, 2015 9:40 am

+1000 for this feature.
joselitux
 
Posts: 43
Joined: Thu Oct 25, 2012 12:11 pm

Re: Query Manager Log

Postby sehager » Thu Nov 05, 2015 5:46 pm

+1000 for this feature.
sehager
 
Posts: 1
Joined: Thu Nov 05, 2015 5:45 pm


Return to Support



Who is online

Users browsing this forum: No registered users and 31 guests