Internal Website Search
51-100 of 200 resultsfind repeated records by JPQL in #1 contains GROUP BY / HAVING. The outer query in #1 contains the IN operator. The query in #3 ... get the point since in #3 there is no GROUP BY / HAVING. support Support ... (select id from TTT s group id having count(id)1) I dont know how to do this using JPQL, but I use | |
Problem with distinct select, order by and equivalent alias/attribute path, and will except the query above. However, in DISTINCT and GROUP BY queries it must follow these restrictions ... when ordering the results of some projection when the order by expression is different (though logically ... ; + "order by s_location.id asc";   | |
Help with JPA2 Criteria and conditional operator grouping; ))); System.out.println("Query: " + c); But I can can never get the grouping to occur ... persistence.xml shows the grouping happening. I've had to dumb down the domain model enough to convey ... . support Support That fixed the conditional grouping issue. Thanks. There is a new problem now however, I'll create a new post Willks William | |
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 | |
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 | |
Detached Entity Objects Detached entity objects are objects in a special state in which they are not managed by any ... ). Retrieval by navigation from detached objects is not supported, so only persistent fields ... EntityManager . In addition, in JPA 2 we can detach an entity object by using the detach method: em. detach | |
Shared (L2) Entity Cache an entity object that is already managed by the EntityManager returns the existing instance from ... objects, which is managed by the EntityManagerFactory and shared by all its EntityManager objects ... . The scope of these server side caches is wider, since they exist per database and are shared by | |
Database Connection using JPA A connection to a database is represented by an EntityManager instance, which also provides ... . An EntityManagerFactory is constructed for a specific database, and by managing resources efficiently (e.g ... the content of a database require active transactions. Transactions are managed by an EntityTransaction | |
JPA Lifecycle Events and are invoked automatically by JPA when these events occur. Internal Callback Methods Internal callback ... - after an entity has been retrieved from the database. @PreUpdate - when an entity is identified as modified by ... for the same event. However, the same method may be used for multiple callback events by marking | |
Working with JPA Entity Objects are provided in the Storing Entities section. Entity objects retrieved from the database by ... is detected by the owning EntityManager and the update is propagated to the database on transaction ... (except retrieval by refresh , which always requires accessing the database). The main role of the persistence | |
Blocked by find, Object obj)" method which is synchronized and attempts to load an object by id using the EntityManager ... : BLOCKED on rbccm.felix.objectdb.workflow.ObjectDbInstanceContainer@9c71a4 owned by : DEV1-WSAgent-1 ... @254e85f4 owned by : ODB-FileWriter Total blocked: 789 Total waited: 616 Stack trace: com.objectdb.o | |
SELECT clause (JPQL / Criteria API), the following query returns Country objects that become managed by the EntityManager em : TypedQuery query ... in the results directly, but their content can be added to the SELECT clause by using a bound JOIN ... that are retrieved directly by a result path expression are not associated with an EntityManager and changes | |
Literals in JPQL and Criteria Queries literals (e.g. 077 , 077L ), a feature that is not currently supported by all JPA implementations. String ... single quotes (e.g. 'Adam' , '' ) and a single quote character in a string is represented by ... can be used (e.g. "Adam\'s" , "abcd\n1234" ) but this is not supported by all the JPA implementations | |
ObjectDB Website - Terms and Conditions of Use 1. Terms By accessing and using this web site, you agree to be bound by these web site Terms ... from using or accessing this site. The materials contained in this web site are protected by ... of these restrictions and may be terminated by ObjectDB Software at any time. Upon terminating your viewing | |
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 ... authorized by this agreement. 3. The free edition of the Software includes restrictions on the number | |
JPA Exceptions JPA exceptions are represented by a hierarchy of unchecked exceptions: java.lang.Object java.lang ... are represented directly by the PersistenceException class. Some specific errors are represented by ... transaction is represented by : Database update failures that require transaction rollback are represented by | |
Database Transaction Replayer. Recording is enabled by default and can be disabled in the configuration . The ObjectDB Replayer tool ... is useful for two different purposes: It enables recovery from a database failure by replaying the recorded operations. It enables reproducing problems during debugging by repeating a failure. Backup | |
Setting and Tuning of JPA Queries in Query and TypedQuery support method chaining ( by returning the query object ... to be visible to the query. Flush policy in JPA is represented by the FlushModeType enum, which has two values ... the default is COMMIT (which is more efficient). The default mode can be changed by the application | |
JPA Metamodel API Metamodel API is Metamodel . It can be obtained either by the EntityManagerFactory 's getMetamodel method or by the EntityManager 's getMetamodel method (both methods are equivalent). For example, given an EntityManager , em , a Metamodel instance can be obtained by : Metamodel metamodel = em | |
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 | |
Database Server, if an ObjectDB database is accessed directly only by a web application, it should be embedded in ... configuration is loaded automatically as explained in chapter 6 . This can be overridden by specifying ... Configuration , but can be overridden by an explicit command line option: java com.objectdb.Server | |
javax.persistence.criteria.AbstractQuery a list of the grouping expressions. Returns empty list if no grouping expressions have been specified. Modifications to the list do not affect the query. Return: the list of grouping expressions ... (s) over the grouping items, or null if no restrictions have been specified. Return: having clause | |
javax.persistence.criteria.Subquery of the subquery Since: JPA 2.0 List getGroupList () Return a list of the grouping expressions. Returns empty list if no grouping expressions have been specified. Modifications to the list do not affect the query. Return: the list of grouping expressions Inherited from: AbstractQuery Since: JPA 2.0 | |
Database Doctor of a corrupted ObjectDB database file Repairs a corrupted ObjectDB database file by creating a new ... - if the recovery file is disabled. Using the database file simultaneously by two instances ... . Modifying the database file externally not through ObjectDB (e.g. by malicious software such as | |
Entity Management Settings are handled. ObjectDB can manage non enhanced classes by using reflection at the cost of performance ... entities are always held by strong references in the persistence context (until commit or flush ... that is managed by the EntityManagerFactory and shared by all its EntityManager instances. The level 2 cache | |
Online Backup 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 ... . Starting Online Backup The online backup can be started by executing a special query on an EntityManager | |
General Settings and Logging a limit size that is specified by the threshold attribute. The mb and kb suffixes represent megabytes ... has to be specified for ObjectDB to avoid using sockets that are expired by the firewall. The element ObjectDB manages a list of the recently accessed database URLs for use by the Explorer | |
Support for roles/groups in ObjectDB ObjectDB should incorporate roles/ group in ObjectDB config file? I see no support for this. I would like to place several users under a given group or role, but I see no way of doing this as ... , there could be a role/ group element which would categorise the user further. This would help in authentication. Thanks st.clair.clarke St Clair Clarke | |
Server Configuration is affected also by other elements in the configuration file, particularly the and the configuration elements ... . If another port is specified it also has to be specified by clients in the URL connection string ... specifies the maximum number of simultaneous connections that are accepted by the server. A request | |
Database Replication and Clustering ObjectDB server can manage different types of databases, including master databases, slave database ( by ... The configuration above demonstrates a situation in which the master database is managed by a server on localhost:6000 and the slave database is managed by a server on localhost:6001 . In this case | |
Logical Operators in JPQL and Criteria API || NOT ! JPQL follows the SQL notation, while Java uses its own notation (which is also in use by JDOQL ... expressions are represented in criteria queries by Expression and descendant interfaces. For example, a boolean path (a field or a property) is represented by Path : Path isInUN = country | |
Index Definition Querying without indexes requires iteration over entity objects in the database one by ... on more than one persistent field. It is defined by specifying multiple fields in the members attribute ... a collection, so multiple values will be maintained by the index for every entity. Multi part paths in | |
Numbers in JPQL and Criteria Queries The following arithmetic operators are supported by JPA: 2 unary operators: + (plus) and - (minus). 4 ... of the same type. The MOD Function The MOD function calculates the remainder of the division of one number by another, similar to the modulo operator ( % ) in Java (which is also supported by ObjectDB as | |
JPA Named Queries named queries instead of dynamic queries may improve code organization by separating the JPQL ... carefully to avoid collision (e.g. by using the unique entity name as a prefix). It makes sense to add ... at Runtime Named queries are represented at runtime by the same Query and TypedQuery interfaces | |
Step 3: Define an EJB Session Bean 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 ... getAllGuests() { TypedQuery query = em.createQuery( "SELECT g FROM Guest g ORDER BY g.id", Guest.class | |
Step 3: Define an EJB Session Bean 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 Java Class] dialog box by right clicking the guest package ... Guest g ORDER BY g.id", Guest.class); return query.getResultList(); } } The GuestDao session bean (EJB | |
Step 1: Install BIRT and ObjectDB Driver We start by installing the BIRT development environment and the ObjectDB data source driver ... IDE for Java EE Developers. Update your existing Eclipse IDE for Java EE Developers environment by ... an existing Eclipse IDE for Java EE Developers environment: Open the [Install] dialog box by | |
Step 3: Define a Spring DAO Component Operations on the database will be performed by an instance of a Data Access Object (DAO) that we will define in this step as a Spring MVC component: Open the [New Java Class] dialog box by right ... () { TypedQuery query = em.createQuery( "SELECT g FROM Guest g ORDER BY g.id", Guest.class); return | |
Step 3: Define a Spring DAO Component Operations on the database will be performed by an instance of a Data Access Object (DAO) that we will define in this step as a Spring MVC component: Open the [New Java Class] dialog box by right ... getAllGuests() { TypedQuery query = em.createQuery( "SELECT g FROM Guest g ORDER BY g.id", Guest.class); return | |
Step 3: Add a Context Listener Class The Guest entity objects will be stored in an ObjectDB database, which will be represented by ... created if not existing yet) when the web application starts, by instantiating an EntityManagerFactory . The database will be closed when the web application stops (or when the web server shuts down), by | |
javax.jdo.Query with a PersistenceManager . Multiple queries might be executed simultaneously by different threads, but the implementation ... , import statements, ordering and grouping specifications, result and result class, the range ... interface imported by method declareImports , or denote a class or interface from the same package as | |
javax.jdo.FetchGroup the default fetch group via the API does not affect the members defined by this category. Using this category ... JDO Interface FetchGroup FetchGroup represents a named fetch group for a specific class or interface. A fetch group instance identifies the name of the class or interface, the list of members | |
javax.jdo.PersistenceManagerFactory Methods void addFetchGroups (FetchGroup... groups ) Add the FetchGroup s to the set of active fetch groups . FetchGroup s are made unmodifiable before being added. FetchGroup s that match existing ... , getFetchGroups , and removeAllFetchGroups are internally serialized. Parameters: groups - an array | |
[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 | |
[ODB1] Chapter 1 - About ObjectDB Compliant ObjectDB is compliant with the JDO (Java Data Objects) standard, developed by Sun ... DB2 and Microsoft SQL Server. In addition, by using JDO you are backed up by a large community ... move your application to other platforms (Windows, Unix, Macintosh and almost any other platform), simply by taking | |
javax.jdo.FetchPlan JDO Interface FetchPlan Fetch groups are activated using methods on this interface. An instance ... Methods FetchPlan addGroup (String fetchGroupName) Add the fetch group to the set of active fetch groups . Return: the FetchPlan Since: JDO 2.0 FetchPlan clearGroups () Remove all active groups |