ObjectDB ObjectDB

Internal Website Search

111-120 of 200 resultsRefresh
15

@OneToOne query issue with OR and IS NULL

through a relationship is implemented using JOIN (i.e. INNER JOIN), and only the A instance that has another passes the FROM clause, which precedes the WHERE clause. Try LEFT OUTER JOIN: SELECT ... another.counter = 0 is a short form of the this equivalent query: SELECT a FROM A a JOIN a.another b
13

OR not working with isNull

is probably converted to something such as: SELECT e FROM MyEntity e JOIN e.owner o WHERE o IS NULL OR o.id = :userId Notice that the navigation root.get("owner").get("id") is implemented as INNER JOIN. This is a requirement of the JPA specification, which is known to cause some confusion
12

Database size is much larger than expected (x2)

store only the special features when @Inheritance(strategy=InheritanceType.JOINED)? gzdillon Lai Yang ... with entity classes defined as inner static classes. support Support ??? What IDE you use? .persist ... .JOINED) @DiscriminatorColumn(discriminatorType=DiscriminatorType.INTEGER,name="type
2

MapKeyJoinColumn.table

that contains the foreign key column. If the join is for a map key for an element collection, the foreign key column is in the collection table for the map value. If the join is for a map key for a ManyToMany entity relationship or for a OneToMany entity relationship using a join table, the foreign
2

correlate(parentJoin)

Method javax.persistence.criteria.Subquery Join<X,Y> correlate( Join<X,Y> parentJoin ) Create a subquery join object correlated to a join object of the enclosing query. Parameters: parentJoin - join object of the containing query Returns: subquery join Since: JPA 2.0
2

MapKeyJoinColumn.name

of the foreign key column for the map key. The table in which it is found depends upon the context. If the join ... for the map value. If the join is for a map key for a ManyToMany entity relationship or for a OneToMany entity relationship using a join table, the foreign key column is in a join table. If the join
2

JoinColumn.table

of the applicable entity. Default: If the join is for a OneToOne or ManyToOne mapping using a foreign key mapping strategy, the name of the table of the source entity or embeddable. If the join ... of the target entity. If the join is for a ManyToMany mapping or for a OneToOne or bidirectional
2

JPQL support for Maps (JPA 2.0)

. It seems to me they are not supported. Query : "SELECT s FROM Session s JOIN s.data d WHERE VALUE(d) = :value" Object ... )     @Column(name = "DATA_VALUE")     @MapKeyColumn(name = "DATA_KEY")     @JoinFetch(INNER ... yet. Try: SELECT s FROM Session s JOIN s.data d WHERE d = :value support Support That works. Please let
2

javax.persistence.PessimisticLockScope

that are contained in join tables will be locked if the javax.persistence.lock.scope property is specified ... , element collections and relationships owned by the entity that are contained in join tables ... only the rows in the join table or collection table for that relationship or collection. This means
2

fetch(attribute, jt)

Method javax.persistence.criteria.FetchParent Fetch<X,Y> fetch( PluralAttribute<?,?,Y> attribute, JoinType jt ) Create a fetch join to the specified collection-valued attribute using the given join type. Parameters: attribute - target of the join jt - join type Returns: the resulting join Since: JPA 2.0

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