ObjectDB Database Search

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

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

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

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

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

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

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

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

ObjectDB as JDBC resource or custom realm

To open source, or not to open source

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

UserException or JDOUserException

Annotate a Map field with @ElementCollection or @Basic

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:    

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

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

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

The configuration element specifies Secure Sockets Layer (SSL) settings for secure communication in client-server mode, for both the client side and the server side. The default configuration file contains the following element: The enabled attribute of the ssl element (whose value is "true" or

by fields that are marked with CascadeType . PERSIST or CascadeType . ALL are also persisted

of a composite primary key - an instance of the ID class or the embeddable class is returned. Using

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

To access relational databases using the Java Persistence API (JPA) you will need an Object Relational Mapping (ORM) tool, such as Hibernate, TopLink, EclipseLink, Open JPA or DataNucleus. The DataNucleus ORM implementation supports also the Java Data Objects (JDO) API. ObjectDB is a full featured

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

which objectdb.jar is located, with one exception - if the name of that directory is bin , lib or build

should be used mainly when the query result type is unknown or when a query returns polymorphic

, when a required entity object is not found: or during query execution: The lock exceptions

A prior knowledge of database programming (SQL, JDBC, ORM or JPA) is not required in order to follow

Persistence fields can either be accessed by JPA directly (as fields) or indirectly (as properties and get/set methods). JPA 2 provides an annotation and an enum for setting the access mode: More details are provided in chapter 2 of the ObjectDB manual.

coordinate is greater or equal to 100 are deleted. All the other Point objects are updated. Chapter 3

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

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

- the executeUpdate method returns the number of objects that have been updated or deleted by the query

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

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

) 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

(session beans) it requires a full Java EE 6 application server, such as GlassFish 3.0.1 or JBoss AS 6. If you need a web application that can run on a simple servlet container (such as Tomcat or Jetty

Eclipse - using ObjectDB, JPA, Tomcat ( or GlassFish) and Maven. The demo web application manages ... the following software: Java JDK 6.0 ( or above). Eclipse IDE for Java EE Developers. m2eclipse

and click  Open Project . Run the project: Select  Run Run Main Project... ( or   F6 ). Choose or define the server and click  OK . If  a browser is not opened - open it at http://localhost:8080/Guestbook/.

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

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

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

The  JPA Web Application tutorial provides step by step instructions on how to build a simple Java/JPA database driven web application (for Tomcat / Jetty) in  Eclipse or   NetBeans ... and install ObjectDB or a Java web server - Maven will download the ObjectDB jar and the Jetty

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

-  x and  y . For this tutorial, besides the Java JDK (8 or above) and the NetBeans IDE

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

We start by creating a new Java EE 6 Web Application project in NetBeans: Open the [New Project] dialog box, e.g. by using File New Project... Select Java Web Web Application and click Next . Choose a Project Name (e.g. Guestbook ) and click Next . Select GlassFish Server 3 ( or above)