ObjectDB ObjectDB

Check for index existence ?

#1

Hello,

Is there a simple way to check if indexes specified in entities are well taken into account by ObjectDb ?

Regards,

Xirt

edit
delete
#2

You can see query execution details, including usage of indexes:

  1. When you execute a query in the Explorer in the log pane.
  2. In the log file if you enable query logging in objectdb.conf (on the server side):
    <logger name="query" level="trace" />
    or
    <logger name="query" level="debug" />

 

ObjectDB Support
edit
delete
#3

Hello,

sorry but name="query" give me nothing in output ( debug or trace ).

name="*" give me some informations about enhanced classes but still nothing about query :(

Regards

edit
delete
#4

Are you using client-server mode? If you do, set the server configuration and check the server logs (queries are executed on the server, enhancement messages are client side).

ObjectDB Support
edit
delete
#5

I am using the embedded mode. 

My objectdb.conf


<log path="/var/lib/tomcat7/logs/objectdb" max="8mb" stdout="true" stderr="true" />
<log-archive path="/var/lib/tomcat7/objectdb/archive/" retain="330" />

Any error ? 

edit
delete
#6

It should be:

    <log path="/var/lib/tomcat7/logs/objectdb" max="8mb" stdout="true" stderr="true" />
    <log-archive path="/var/lib/tomcat7/objectdb/archive/" retain="330" />
    <logger name="query" level="debug" />
ObjectDB Support
edit
delete
#7

Full general conf :

<general>

                <temp path="$temp" threshold="64mb" />
                <network inactivity-timeout="0" />
                <url-history size="50" user="true" password="true" />
                <log path="/var/lib/tomcat7/logs/objectdb" max="8mb" stdout="true" stderr="true" />
                <log-archive path="/var/lib/tomcat7/objectdb/archive/" retain="330" />
                <logger name="query" level="trace" />
                <!--<logger name="*" level="error" /> -->
                <!--<logger name="query.manager" level="debug" />-->
</general>

I've got nothing in "/var/lib/tomcat7/logs/objectdb" directory.

I've got a file in archive ( containing infos about enhanced classes ) when i replace query by "*"

edit
delete
#8

Maybe ObjectDB doesn't use that specific configuration file. Check the location of the objectdb.conf file, the location of the objectdb.jar file (that your application is using) and the information on this manual page.

ObjectDB Support
edit
delete
#9

I've added the args to my tomcat server but i'm sure that's was OK because name="*" output enhanced classes.

I'm using objectdb 2.6.2, may the conf has changed ...

I don't want to update my version because of potential regression or differents behaviours ( already experimented this ).

Well, i still don't understand my issue

edit
delete
#10

Oh well i got it after few minutes.

Seems write in log is not immediate.

Well, how can i check index existence so ?

edit
delete
#11

The log should show the selected query execution plan (and also other plans in debug level logging).

You may post it here for help with what it means.

ObjectDB Support
edit
delete

Reply

To post on this website please sign in.