ObjectDB Database Search

we have the critical problem that we receive a null or by zero (in the log a java.lang.ArithmeticException) error for this query: select o from ObjectNode o where o.currentLocation.nodePath = "/(MG)TOOLPOOL-DMC-125U4/(MP)IN" and o.classIdentifier = '(TP)' database can be download from

Dear Support, is there a way to compare two schemas or odb files? I try to compare two object graphs Thx wua Andreas Wurm This is currently not supported, but you may file a feature request  if you need this ability (describing what exactly you expect from this new feature, and how it should work). support Support

we get following exception when we open a database or open an entity manager   Exception in thread "ODB IndexActivation" [ObjectDB 2.6.6_06] Unexpected exception (Error 990) Generated by Java HotSpot(TM) 64-Bit Server VM 1.8.0_51 (on Windows 7 6.1). Please report this error on http://www

Hi Wanted to check with you on the exact level of support of JPA QL within the ObjectDB world. I have given a sample typed query below which fails to work with ObjectDB and it runs very well with the Hibernate/MySQL JPA. We are using Spring Data here. It looks like a problem with Sub query or

Is there a build-in way to encrypt object fields or entire "tables" with annotations?  If not, are there any recommended design patterns? Thanks mrbahr2003 Thomas Gregory Please see this feature request in the issue tracking. If you need selective encryption of types / fields - please describe your suggestion in that issue thread. support Support

Is there LIMIT or TOP functions in object db? If so can you provide some examples? vinodh vinodhkumar You can set query result range by using the setFirstResult and setMaxResults methods. You can find more details and an example in the manual . support Support Thanks. This solved my purpose. vinodh vinodhkumar

If I have a large number of objects to delete and then add to a PersistenceManager is it more efficient to do everything in one transaction or two? Currently my code looks like this: PersistenceManager pm = m_pmFactory.getPersistenceManager(); try { pm.currentTransaction().begin(); pm

To open source, or not to open source

Significant I/O costs during batch update or insert data.

Annotate a Map field with @ElementCollection or @Basic

A distinguished Name for server or explorer is good for maintaining!

ObjectDB as JDBC resource or custom realm

UserException or JDOUserException

interface is a thin wrapper around Expression , which adds order direction - either ascending (ASC) or ... an ascending or descending Order instance (respectively). See the ORDER BY in Criteria Queries section 

connection URL - either embedded (e.g. c:\points.odb ) or client-server (e.g.  objectdb ... ) and click Next . Entry a JPQL or a JDOQL query and click Finish . See the Report Generation

variable (with or without an explicit variable name) for iteration. Multiple variables and JOIN are not supported. The SET clause defines one or more field update expressions (using the range

An ObjectDB database can be backed up by simply copying or archiving the database file while the database is offline (i.e. when it is not open in an ObjectDB server and not in use by any application ...  ( em ) that represents the connection (local or remote) to the database:    

. One persistence.xml file can include definitions for one or more persistence units. The portable way ... explicitly by using class elements (for single class registration) or jar-file elements

the Configuration chapter. By default, managed entity objects that have not been modified or removed ... references or soft references instead of weak references . The contains method can check if a specified

I would like the capability to change helpdesk support ticket page titles. Or if there is a way to already do this please describe. [EDIT: sorry I don't know how to key this to your online helpdesk system as opposed to the objectdb software version] webel Dr Darren Kelly You should be able

Luc Have you tried 2.4.5 or 2.4.5_03? Because 2.4.5_03 fixes a GlassFish integration issue . support

. Running the Activator requires Java 6 or above.         dmoshal David Moshal Note

Compare two schemas or odb files

, MOD, NEW, NOT, NULL, NULLIF, OBJECT, OF, OR , ORDER, OUTER, POSITION, SELECT, SET, SIZE, SOME, SQRT

for building date and time expressions that represent the current date and/ or time: // Create

Collections may appear in JPQL queries: as parameters - when collections are assigned as arguments. as  path expressions - in navigation to persistent collection fields. IS [NOT] EMPTY The IS [NOT] EMPTY operator checks whether a specified collection is empty or not. For example: c.languages

relational database by using an ORM JPA provider such as Hibernate, EclipseLink or Open JPA

order to interact with a relational database such as Oracle, DB2, SQL Server or MySQL. The popular JPA

As explained in chapter 2 , entity objects can be deleted from the database by: Retrieving the entity objects into an EntityManager . Removing these objects from the EntityManager  within an active transaction, either explicitly by calling the  remove method or implicitly

); or by a special CriteriaBuilder 's method, nullLiteral , that returns a typed expression

or NetBeans . Forget relational databases, JDBC, drivers, tables, records, ORM tools and mapping

experience in database development, SQL or JPA, but such experience is definitely not a prerequisite.

, any field that is not declared as static or transient is a persistent field. For example

) and selecting  New Entity Class ... ( or   New Other... Persistence Entity Class and clicking ... a text editor (by right clicking and selecting Edit or by double click and then moving to the XML

The  Spring MVC JPA tutorial provides step by step instructions on how to build a simple Java/JPA Spring MVC database driven web application in  Eclipse or   NetBeans . Building a new ... and install ObjectDB or a Java web server - Maven will download the ObjectDB jar and the Jetty

a ServletContextListener to perform initialization and cleanup operations: The database will be opened ( or ... an EntityManagerFactory . The database will be closed when the web application stops ( or when the web server shuts

Project . Run the project: Select  Run Run Main Project... ( or   F6 ). Choose or define

node (in the [Project Explorer] window) and selecting New Folder ( or   New Other... General

This tutorial demonstrates how to create and run a full Java Spring MVC (Model View Controller) web application using Tomcat ( or GlassFish), JPA, ObjectDB and Maven. The demo web application manages a basic guestbook page. Every visitor can sign the guestbook by filling a simple form. All visitors

IDEA: Select the new run configuration at the toolbar and click the green run icon ( or   Shift

editor (by right clicking and selecting  Open With Text Editor or by double click

clicking and selecting Edit or by double click and then moving to the XML tab in the editor window

The  Java EE Web Application tutorial provides step by step instructions on how to build a simple Java/JPA database driven web application (for GlassFish 3/ JBoss 6) in  Eclipse or   NetBeans . Building a new application step by step is an effective way to learn - but 

, such as GlassFish 3.0.1 or JBoss AS 6. Another tutorial shows how to use JPA in a Spring MVC Framework

when the Maven project is imported into the IDE). Choose or define the server and click  Finish

Operations on the database will be performed by an instance of a session bean (EJB) class that we will define in this step: Open the [New Session Bean] dialog box by right clicking the guest package node (in the [Projects] window), selecting New Other... Java EE ( or Enterprise JavaBeans) Session

Start tutorial ). Specify an ObjectDB connection url - either embedded (e.g. c:\points.odb ) or client

project is imported into the IDE). Choose or define the server and click  Finish . Eclipse

For this tutorial you will need the following software: Java JDK (6.0 or above). Eclipse IDE for Java EE Developers

The Getting Started with JPA tutorial provides step by step instructions on how to build a simple JPA database driven application in Eclipse or NetBeans . Building a new application step by step is an effective way to learn - but if you prefer, you may download and run the result