Internal Website Search
51-100 of 200 resultsGROUP BY and HAVING clauses The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns properties of generated groups instead of individual objects and fields. The position of a GROUP BY ... clause. When a GROUP BY clause exists in a JPQL query, database objects (or tuples of database objects | |
ORDER BY clause (JPQL / Criteria API) The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not include an ORDER BY clause produces results in an undefined and non-deterministic order. ORDER BY ... is at least one million people, ordered by the country name: SELECT c.name FROM Country c WHERE c.population 1000000 | |
Privacy Policy the Service. By using the Service, You agree to the collection and use of information in accordance ... files that are placed on Your computer, mobile device or any other device by a website, containing ... individuals employed by the Company to facilitate the Service, to provide the Service on behalf | |
Step 3: Add a Main Class In this step we will add a main class to the project to store and retrieve Point objects from the database: Right click the tutorial package in the [Package Explorer] window and select New Class . The package name should be tutorial . Enter Main as the class name (case sensitive). Click Finish | |
Step 3: Add a Main Class In this step we will add code to the Main class (that was generated with the project) in order to store Point objects in the database and then retrieve them from the database. Use copy and paste to replace the content of the Main class with the following content: package tutorial; import javax | |
BIRT/ODA ObjectDB Driver language. For step by step instructions on using BIRT with ObjectDB see the Report Generation ... Developers extension. To install it: Open the [Install] dialog box by selecting Help Install New Software ... and press ENTER. Select the ObjectDB Birt/ODA feature. Complete the installation by clicking Next twice | |
Chapter 1 - Quick Tour Getting Started with JPA and NetBeans Tutorial These tutorials provide step by step instructions ... This chapter demonstrates basic ObjectDB and JPA concepts by introducing a simple example program ... that contains points in the plane. Each point is represented by an object with two int fields, x and y | |
ObjectDB License Agreement [ver. 2.0.4] Please read carefully this software license agreement. By downloading, installing or using ... of this agreement will be binding, unless in writing and signed by an authorized representative of each party ... steps to protect the Software from any use, reproduction, or distribution except specifically | |
Obtaining a JPA Database Connection In JPA a database connection is represented by the EntityManager interface. Therefore, in order ... an EntityManager instance consists of two steps . First we need to obtain an instance ... by ObjectDB to be a database URL rather than a persistence unit name. The $objectdb variable | |
What are the steps of creating small web app?What are the steps of creating small web app? | |
Pre-detach loading: retrieval by navigation not working in if statement that can be referenced by ID, and meets a uniform and powerful IElement interface. - The BooleanValue is doing a heap ... to do it this way; but the wrapped boolean value is not the whole story. webel Dr Darren Kelly By JVM ... -Djava.compiler=NONE webel Dr Darren Kelly OK. It could still be an optimization that is used by the JVM | |
query hint: Query plan 1/128 description ============================ Step 1: Process ObjectNode (o) instances ---------------------------------------- [ Step 1a] Scan index com.agile.hummingbird.ObjectNode ... )'). [ Step 1b] Retrieve fields in ObjectNode (o) instances. Step 2: Process ObjectProperty (v$2 | |
JPA Web App Tutorial - Maven Project The JPA Web Application tutorial provides step by step instructions on how to build a simple ... . Building a new application step by step is an effective way to learn - but if you prefer ... ) If Maven is installed - extract the zip and run the application from the command line by | |
Getting Started with JPA - Maven Project 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 ... ) If Maven is installed - extract the zip and run the application from the command line by : mvn test | |
Java EE JPA Tutorial - Maven Project 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  | |
Spring MVC JPA Tutorial - Maven Project 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 application step by step is an effective way to learn - but if you prefer | |
Eclipse/JPA Spring MVC Web Tutorial a basic guestbook page. Every visitor can sign the guestbook by filling a simple form. The visitors that have already signed are listed below the form: Persistence is managed by JPA. Every visitor that has signed the guestbook is represented by a Guest JPA entity object and all the Guest | |
NetBeans/JPA Web Application Tutorial application manages a basic guestbook page. Every visitor can sign the guestbook by filling a simple form. The visitors that have already signed are listed below the form: Persistence is managed by JPA. Every visitor that has signed the guestbook is represented by a Guest entity object | |
NetBeans/JPA Spring MVC Web Tutorial manages a basic guestbook page. Every visitor can sign the guestbook by filling a simple form. The visitors that have already signed are listed below the form: Persistence is managed by JPA. Every visitor that has signed the guestbook is represented by a Guest JPA entity object and all the Guest | |
Eclipse/JPA Java EE Tutorial can sign the guestbook by filling a simple form. The visitors that have already signed are listed below the form: Persistence is managed by JPA. Every visitor that has signed the guestbook is represented by a Guest entity object and all the Guest entity objects are stored in an ObjectDB database | |
Eclipse/JPA Web Application Tutorial. The demo web application manages a basic guestbook page. Every visitor can sign the guestbook by ... is managed by JPA. Every visitor that has signed the guestbook is represented by a Guest entity object ... but the code would be the same). The Tutorial Steps This tutorial consists of the following steps : | |
NetBeans/JPA Java EE Tutorial. Every visitor can sign the guestbook by filling a simple form. The visitors that have already signed are listed below the form: Persistence is managed by JPA. Every visitor that has signed the guestbook is represented by a Guest entity object and all the Guest entity objects are stored in | |
JPA Tutorials 3 web application: Spring MVC and JPA Maven Projects for Download The tutorials provide step by step instructions on how to create the sample applications. In addition, the sample applications | |
combined index not used --------------------- Group the results of step 5 by : a.endDate,v$1.nodePath,v$3.doubleValue. Step 7: Apply ... .properties.name = 'scheduledSlot') GROUP BY a.endDate, a.objectsInCharge.nodePath, a.objectsInCharge ... we can see that this index is not used: Query Plan Description ====================== Step 1: Process | |
[ODB1] Chapter 6 - Persistent Objects Explicitly When a new object is constructed by the new operator, it always starts as a transient ... demonstrated by the following code: pm.currentTransaction().begin(); Person person = new Person("George ... transient object. Then it becomes persistent by an explicit call to the makePersistent( ... ) method | |
[ODB1] Chapter 2 - A Quick Tour, step by step . Both sample programs are contained in ObjectDB's samples directory. 2.1   ... ArrayList list; 18 try { 19 // Retrieve the list from the database by its name: 20 list = (ArrayList ... the database by its name "Hello World" using the getObjectById( ... ) method (line 20 | |
Different behavior for two equal queries Description ====================== Step 1: Process IndividualContact ($1) instances ------------------------------------------------ [ Step 1a] Scan type com.quasado.foundation.communication.api.model.contact.individual.IndividualContact locating all the IndividualContact ($1) instances. [ Step 1b | |
Database Explorer directory a path to it has to be specified. Alternatively, you can run the Explorer by double clicking explorer.jar or by running explorer.exe (on Windows) or explorer.sh (on Unix/Linux, after editing ... . By default, when the Explorer starts it tries to open a connection to the most recently used | |
queries under 2.7.6_4 significantly slower than under 2.7.6.classIdentifier='(TC)')). [ Step 1b] Order the results of step 1a by : v$1. [ Step 1c] Scan index com.agile ... )')). [ Step 1d] Order the results of step 1c by : v$1. [ Step 1e] Merge the results of steps 1b ... results --------------------- Group the results of step 4 by : o. [ Step 6] Remove duplicates | |
Retrieving JPA Entity Objects of entity classes and to keep them as simple as possible. Retrieval by Class and Primary Key Every entity object can be uniquely identified and retrieved by the combination of its class and its primary key ... method except that if the entity object is not already managed by the EntityManager a hollow object | |
[ODB1] Chapter 9 - ObjectDB Explorer.jar my.odb Some JVM arguments can be useful. For instance, by default Java does not use ... . Otherwise, the required executable jar would not be found by explorer.exe. By default, running explorer.exe ... " menu command. By default, when the Explorer starts its opens the last used local database file | |
Database Management Settings the size by which to extend the database file when additional space is needed. Small initial size and resize values save space. Larger values can improve performance by reducing file fragmentation (many ... When enabled, a recovery file is created by ObjectDB when a database is opened and deleted by ObjectDB | |
Apache License, Version 2.0, January 2004 the terms and conditions for use, reproduction, and distribution as defined by Sections 1 through 9 of this document. "Licensor" shall mean the copyright owner or entity authorized by the copyright ... and all other entities that control, are controlled by , or are under common control with that entity | |
JPA Entity Fields (Mapped By ) fields Primary key (ID) fields Version field The first three groups (transient ... -final entity field is persistent by default unless explicitly specified otherwise (e.g. by using ... . Only the persistent state of the entity object, as reflected by its persistent fields (including | |
Locking in JPA update collisions resulting from simultaneous updates to the same data by two concurrent users. Locking ... by another transaction. When using ObjectDB, optimistic locking is enabled by default and fully ... is automatically increased by one. Version numbers are managed internally but can be exposed by defining | |
JPA Persistable Types are represented in queries by entity names . By default, the entity name is the unqualified name ... can be set explicitly by using the name attribute of the Entity annotation: @Entity ( name ="MyName ... superclasses are treated by ObjectDB as ordinary entity classes. Mapped superclasses are really | |
JPA Class Enhancer ObjectDB Enhancer is a post compilation tool that improves performance by modifying the byte code ... (and actually required by JPA but not enforced by ObjectDB) to avoid accessing persistent fields ... should be used (e.g. by using the get and set methods). If you follow this practice only user defined | |
Eclipse Public License - v 1.0 additions to the Program originate from and are distributed by that particular Contributor. A Contribution 'originates' from a Contributor if it was added to the Program by such Contributor itself or ... entity that distributes the Program. "Licensed Patents" mean patent claims licensable by | |
Report Generation with BIRT and JPA), (12, 12), ..., (20, 20) The data will be presented in the BIRT report using a chart and a table: The tutorial consists of the following steps : | |
Getting Started with JPA and Eclipse well (dialog boxes and menus might look slightly different but the code would be the same). This tutorial consists of the following steps : | |
Getting Started with JPA and NetBeans well (dialog boxes and menus might look slightly different but the code would be the same). This tutorial consists of the following steps : | |
JPA Primary Key the database is uniquely identified (and can be retrieved from the database) by the combination of its type ... and do not have their own separate identity. Automatic Primary Key By default, the primary key is a sequential 64 bit number ( long ) that is set automatically by ObjectDB for every new entity object | |
Storing JPA Entity Objects New entity objects can be stored in the database either explicitly by invoking the persist method ... is committed. An IllegalArgumentException is thrown by persist if the argument is not an instance of an entity ... is thrown. The exception is thrown either by persist (if that existing entity object is currently | |
Query Parameters in JPA) The following method retrieves a Country object from the database by its name: public Country ... method supports method chaining ( by returning the same TypedQuery instance on which it was invoked ... identified in a query string by their special form, which is a colon (:) followed by a valid JPQL | |
Paths and Types in JPQL and Criteria API classes) are represented in JPQL by the following types of expressions: Variables - FROM ... and functions (e.g. for strings and for numbers ), they can be compared by all six comparison operators ... with an instance of a user defined class (represented by a variable, parameter or prefix path | |
[ODB1] Chapter 4 - JDO Metadata file. The metadata is used first by the JDO Enhancer, and later by the JDO ... ) By default, JDO manages an extent for every persistent class. An extent enables iteration ... in terms of time and storage space. When extent management is not needed, it can be omitted by | |
[ODB1] Chapter 7 - JDOQL Queries result = (Collection)query.execute(); Queries are represented by the javax.jdo.Query interface. A Query instance is constructed by one of the PersistenceManager 's newQuery( ... ) methods. For example, in ... . If the query compilation succeeds, the Extent of Person instances in the database is iterated object by | |
[ODB1] Chapter 5 - JDO Connections that every connection consumes. Database connections are managed in JDO by the javax.jdo ... management is transparent. The functionality of PersistenceManager instances returned by ... a file, as demonstrated by the following properties file: javax.jdo.PersistenceManagerFactoryClass | |
[ODB1] Chapter 8 - ObjectDB Server An ObjectDB server can manage one or more databases. Databases that are managed by a server can be accessed by multiple processes simultaneously. In addition, the server supports accessing these databases from remote machines by TCP/IP. More details about client server mode vs. embedded database | |
[ODB1] Chapter 3 - Persistent Classes store methods and code. Only the state of the object as reflected by its persistent fields is stored. Persistent fields, by default, are all the fields that are not defined as static , final or ... types above are defined as optional by JDO (arrays and most of the collection classes), but ObjectDB |