About WRITE

forum_thread

Sorting problem

Hi, I was rewriting our DAO to support pagging in large dataset and I think I have found a problem with sorting. I send you a test case - sorry for using the same project as previous, but it was faster to write this test case. As usual, you can load data with DataLoader and then check problem with QueryData. There is a simple query with "order by" sentence: ... using the same project as previous, but it was faster to write this test case. As usual, you can load data with DataLoader and then ...

 
forum_thread

Data portability

Hi,   I've never used an OODB, I'm looking for a starting point but a recurrent concern is the Data Portability one. More clear: what options / strategies do I have to export / move my data to another  tool, if there is a need to? #1 2010-12-01 18:29 Hi, I've never used an OODB, I'm looking for a starting point but a recurrent concern is the Data Portabi ...

 
forum_thread

Managing software release cycles.

How do you manage software release cycles with objectDB? For example we might have different installation of a given web application, and we might need to introduce new fields with default values or to change something in the database "structure".  How can we apply the update script without downloading the entire DB file? Are there any command line tools like sqlPlus to connect to a DB and execute queries / scripts? ... by configuration. In some cases you may have to write code. You can use the PostLoad event to adjust old objects to new ...

 
manual

Database Replication and Clustering

Replication enables maintaining up to date version of an ObjectDB database on multiple nodes.... manages the main (master) database, which supports Read / Write operations. The other (slave) nodes in the cluster manage identical ...

 
forum_thread

java.sql.Time field off by 30 minutes

Hihi, I'm wondering if this is a bug. I have a simple entity with java.sql.Time field. On writing and readback, the field is found to be 30 minutes off. It is observed on objectdb explorer as well. Timestamp works perfectly fine. Ps. dont think its a UTC issue. My system is set at far off UTC+30min time.   #1 2012-03-07 01:28 Hihi, I'm wondering if this is a bug. I have a simple entity with java.sql.Time field. On wri ...

 
forum_thread

Vacuum - Reclaiming Unused Space In Odb

I was curious if you could assist me with a challenge we are having with our objectdb database.  Our odb files are about 50Gb in size and are written to about a million times a day with both adds and updates.  This is creating a lot of unused space in the database that we are wanting to reclaim.  Other database vendors provide a vacuum process to allow dumping a database to a flat file (basically a sql dump) and reload.  Is there a capability in ObjectDb to provide a vacuum?  The online backup feature appears to copy the dead space as well so isn't performing... other than manually implementing code to read, delete, and write to a new odb, is there an algorithim that you could provide that plays to ...

 
forum_thread

Data migration from SQLServer to ObjectDB

Hi, could someone recommend a good tool to use for data migration from SQLServer to ObjectDB. ... a JPA ORM library (e.g. Hibernate or EclipseLink) you can write your own conversion program that retrieves data from the SQLServer ...

 
page

ObjectDB - Object Database for Java (JPA/JDO)

Fast Object Database for Java with JPA 2 and JDO 2 support. Reduce development time and improve productivity ObjectDB is the most productive software for developing Java database applications using the Java Persistence API (JPA). It is the first persistence solution ...

 
forum_thread

How to package orm.xml when using EJB in WAR?

Hi, I have database utility classes in one project, the id's use sequences declared in an orm.xml file for example: ... with @Startup can access the database OK for both read and write, suggesting that the orm.xml is found OK and that the sequences are ...

 
forum_thread

UPDATE query to set a new field after schema change

I've added a new property/field to one of my objects and want to set the value of this (boolean) property to false for all existing entities in the DB. I tried to execute an update statement with the Explorer tool. The statement ends and tells me that 1000 entities have been updated. I then save the changes to the DB via file->save. But when I execute a select on the DB I see that the field is still "null" for all instances. How do I initialize the field? ... be fixed in future versions. The workaround is to write some code (even in a simple console application) that update the objects ...