Home » Support » Forum » Check for index existence ?

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

#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
ObjectDB - Fast Object Database for Java (JPA/JDO)
#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

#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
ObjectDB - Fast Object Database for Java (JPA/JDO)
#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 ? 

#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
ObjectDB - Fast Object Database for Java (JPA/JDO)
#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 "*"

#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
ObjectDB - Fast Object Database for Java (JPA/JDO)
#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

#10

Oh well i got it after few minutes.

Seems write in log is not immediate.

Well, how can i check index existence so ?

#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
ObjectDB - Fast Object Database for Java (JPA/JDO)

Post Reply

To post a reply and/or subscribe to update notifications - please login