About Doctor

forum_thread

Shrinking Database Files

These are questions asked in the context of the proposed architecture described in the forum thread titled, "Sample JDO Architecture for Follow Up Questions".   I thought I read something on the ObjectDB website (forum? 1.x manual?), which I cannot find now, that stated that the datastore file never shrinks when large number of objects are deleted and the only way to reclaim that space would be with Database Doctor. Is there a way to reclaim database file space? ... the only way to reclaim that space would be with Database Doctor. Is there a way to reclaim database file space? Is it ... to make the database file smaller is to run the ObjectDB doctor in repair mode (i.e. building a new database file from an existing ...

 
forum_thread

errors on repair

we are using version 2.6.7. On running the doctor we have message like free page list broken ... unexpected total page count ... what could be the reason for this ?   ... we are using version 2.6.7. On running the doctor we have message like free page list broken ... ... broken at page #0' occurs every time when we run the doctor after ending our application - we do not do any copy or move of ...

 
forum_thread

index - data rewrite

Hi we have found that applying indexes on an existing table erases the data. Are we doing something wrong. Thanks ... had no effect until the database was rebuilt using the Doctor. What ObjectDB version are you using? Because automatic ... new index? Have you checked the database using the Doctor? Are there any errors? ObjectDB Support ...

 
forum_thread

Low performance when getting grove roots

Hi, I have a grove-like structure of objects, every objects referencing its parent. Root objects have null as the value of this parent reference. To find the roots I execute a query. If the number of objects in the tree is significant, this query takes almost forever, it seems ObjectDB loads all objects on the DB to test their parent field value. Id there a way to force ObjectDB to create an index for this field? Regards, Vladimir ... database requires fixing the database using the ObjectDB Doctor . If you post a test case that demonstrates the problem it ...

 
release

2.4.0

... ( $objectdb ) in NetBeans RCP . Fixed a Doctor and Replication regression (Type session exceeds timeout). ... . Added option for running the Doctor without activating disabled indexes. Fixed a ...

 
forum_thread

Is there an administration tool with which I could create extra indexes?

Hello, I have composite index, and it was working fine, but now I need to add more features to the software and I need to throw more indexes in there. I wanted to know what's the best way to do this. 1. Have some admin tool CREATE INDEX..... ON a.b or 2. add more @Index to the object entities. in case of #2, would ObjectDB auto-reindex all existing data? ... order to update the schema. Run the ObjectDB Doctor (in repair mode) to build the new index. Step 2 may be skipped if you run the Doctor (step 3) with your up to date classes in the classpath. ...

 
forum_thread

How to create a Unique constraint?

Hi, I'm trying to create a unique constraint. Here is a simple example: @Entity public class Account { @Id @GeneratedValue private long id; @Index(unique="true") private String name; } The code runs and my Account objects are persisted. But no exception is thrown if name is the same. What do I need to do to have a Unique constraint? Thanks, Carl   ... the only way to activate the index is to use ObjectDB Doctor to rebuild the entire database. Future versions of ObjectDB ...

 
issue

Error on commit

I get the following on commit:  (v2.3.7_15) Let me know if you need more info. ... Please use the ObjectDB Doctor to check the database and post the report. ... at com.objectdb.o.DMR.B(DMR.java:163) at com.objectdb.Doctor.main(Doctor.java:22) [2012-04-20 13:29:50 #104 type.loader] ...

 
forum_thread

Error using query with MAX() function

I have a class that is persisting a Entity that holds remarks and a time. Then when I query for the latest remark I get a internal error when the remark is larger than 1966 chars. Here is a test class and entity that reproduces the problem on my system. ... entities yet. After the failure the database fails Doctor check ObjectDB Doctor [ version 2.2.3_03 ] Copyright ( c ) 2011, ...

 
forum_thread

@Unique added afterward is not taken into account

Hello, ... data requires rebuilding the database by using the Doctor in repair mode (a better support for adding a new index is expected to ...