ObjectDB ObjectDB

Internal Website Search

91-100 of 200 resultsRefresh

"Problem" with cross join

=InheritanceType.JOINED) ... @ManyToOne private CI ci; subclass CIstring private String text; I ... primary key fields in JOIN queries). Please try the new build (2.0.4_01) that should fix the bug

joining of tables

Hi In objectdb site i found :Note: This ORM/SQL annotation is silently ignored by ObjectDB so i want join tow table and generate a third table. Ex: table 1: employee table 2: address and the generate table will be table 3: emp_add employee: e_id, e_name address: add_id, city, house

Index Definition

JOIN queries: SELECT d FROM Document d JOIN d.words w WHERE w = 'JPA' The Document entity class ... can also be used for executing the following query: SELECT d FROM Document d JOIN d.words w

Mapped by fields are not initialized by JOIN FETCH in queries

As demonstrated in this forum thread, a mapped by collection field with lazy fetch mode is not initialized in results of a query that uses JOIN FETCH on that collection field (when enhancement is used). support Support Build 2.4.1_06 fixes this issue (fields are now initialized and the test in

Different behavior for two equal queries

components. Navigation should be compiled as LEFT OUTER JOIN to avoid losing results in such cases, but maybe an ordinary JOIN was used in this query. Could you isolate the OR component that causes this query

ObjectDB 2.4.0

(by catching unexpected exception). Fixed LEFT [OUTER] JOIN issues (including on mapped by ... . Fixed handling null values in JOIN and path expressions in queries. Fixed a possibly very slow query

ObjectDB 2.3.6

in the default fetch policy. Fixed a new bug in retrieving byte[] (issue #624). Fixed a bug in LEFT OUTER JOIN. Fixed GROUP BY DATE(...) - merging AM and PM into the same date.

ObjectDB 2.2.8

Fixed a critical bug in extensive removal operations of large objects. Improved the performance of navigation through an inverse (mapped by) field if the owner field is indexed. Fixed a LEFT OUTER JOIN bug. Fixed a bug in parsing queries with parenthesis followed by NOT. Fixed a bug in running

New issues with queries using build 2.7.8

Hello, we found another query bug: SELECT a FROM ArtifactImpl a LEFT OUTER JOIN a.tcSignal s WHERE a.startStep.stepNumber <= 2 AND a.endStep.stepNumber >= 0 AND (s.name IN ('In1') OR a.tcSignal IS NULL) With 2.7.6_b6 we get the expected three result objects. But with 2.8.0 we get only two result

addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters)

a Query and subsequently attached to a different query (the outer query) by calling this method ... of the outer query. Only some of the query parts are copied for use as the subquery. The parts copied ... the outer query that represents the candidates over which the subquery is evaluated. If the trimmed

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support