ObjectDB Database Search

I have a " Table " that currently has  @Id private String userId; @Id private long range; private String someOtherField; I need to add a @Id to someOtherField.  But when I add that, and query the table all the PK fields are null or 0.  What can I do to modify primary keys?  

Hi we have found that applying indexes on an existing table erases the data. Are we doing something wrong. Thanks peric.emil Emil Perić Starting version 2.6.6 ObjectDB automatically activates new ... This was done few months ago and we just moved on. As far i remember the data records in the table

.summaryframework.database.SummaryStagingDatabase:75 It may be worth noting that the table that was being read ... work?  Again, notable - the table (with the old schema) being read by the client using the new

Hello, I have a very large business application that makes use of the Hibernate "Filters" feature and of the EclipseLink "Single Table Multitenancy with discriminator" feature in order to implement ... "Filters" or EclipseLink "Single Table Multitenancy with discriminator" to your very interesting

Hi, I have the following entity class: @Entity @ Table @Indices({ @Index(members={"relationshipType", "party"}), @Index(members={"relationshipType", "otherParty"}), @Index(members={"relationshipType ... the manual : In the [Parameters] table provide arguments for parameters (if any). An entity object

: ... *but* as you can see, the element and attribute names vary from table to table .. not so easy

. I'm using version 2.3.7. Test entities: @Entity @Inheritance(strategy=InheritanceType. TABLE _PER_CLASS ... ;   @Id     @GeneratedValue(strategy=GenerationType. TABLE , generator

I have a class that is persisting a Entity that holds remarks and a time. Then when I query for the latest remark I get a internal error when the remark is larger than 1966 chars. Here is a test class and entity that reproduces the problem on my system. @Entity @ Table (name = "TestEntity", schema

that this even occurrs on the same " Table " -- some saved Entitities of same type do still have a Long

: FAILS on @OneToMany with @TableGenerator/strategy = GenerationType. TABLE  (www.objectdb.com

Hi I would know if this type of query is supported By JPA: select sum(nb1), sum(nb2), sum(nb3) from table If yes I have this methode that return a list of Long: public List sommeClassesRep(Choix choix) { Query listClassRepHost = em.createQuery("SELECT SUM(h.nb1xx), SUM(h.nb2xx),SUM(h.nb3xx),SUM(h

Mortimer Cladwell To obtain an automatic id on persist before commit use sequence or table strategy . support Support

;and TABLE strategies generate automatic values as soon as new entity objects are persisted, i.e. before

Hi, I'm trying to persists objects defined as follows: @Entity @Inheritance(strategy = InheritanceType.SINGLE_ TABLE ) public abstract class AbstractContainer { ... @OneToMany(fetch = FetchType.LAZY, mappedBy="parent") private Set abstractContainers = com.google.common.collect.Sets

Why can the field "contracts" be "null"? ---------- @Entity @Inheritance(strategy = InheritanceType. TABLE _PER_CLASS ) public class Person implements Serializable,Subject {     @Id @GeneratedValue     private long id;     @ManyToMany(fetch = FetchType. EAGER , cascade

Will this code work on objectdb ? I was using it on mariadb , i need to inject GenericEntity to many tables to watch user activities. If this wont work , does objectdb has any other solution to this ? do i need to use jakarta objectdb or standard ? package com.manage.jpa; import lombok.Builder

a useless object to make the table exists, that is unnecessary in MySQL. I use ObjectDB exactly

of the last available $1 in the table ??? Alex quasado Alexander Adam The two queries look exactly

Hi , when i try to use this entity as shown below: package persistence.jpa.models; import javax.jdo.annotations.Indices; import javax.persistence.*; import java.io.Serializable; import java.sql.Date; import java.util.Objects; @Entity @ Table (name = "usrlist", schema = "posts") @NamedQueries

SELECT count(e) FROM Meta e, ImageNet i, Page p WHERE e.idImage=i.id AND e.idPage=p.id; So simple a command cause me half an hour and is running now! Each table has about 160K records. What formula can predict the time for such counting? TIA gzdillon Lai Yang Now, after 2 hours

a table order by a field use an ORDER BY query. Query execution will be faster in the field

. In our web application this behaviour gives aprox 10-13 s of refreshing a data table vs 2 second

of table Property (attached) and i please need your help, or i will die in front my keyboard

1. I got about 10K inserts / second, is it normal? I would expect more than that, like close to 100K/second. I can definitely do 80K inserts/seconds on Oracle with batch insert on table with one primary key. 2. Is batch update/insert operation supported? I attached the files. edy_at_ssn Edy Oey

used to scan my @Entity classes and create tables before the application even started

When I use @OrderBy and supply multiple order fields I get and error when ObjectDB Explorer expands a instance of the entity. Example code: @Entity @ Table (name="Defects", schema = "myDB") public class Defects implements Serializable {     ...     ...  

I've got this class... @Entity @ Table (name = "language") public class Language implements Serializable{ ... private List aliases; ... public boolean hasAlias(List alai) { return ... ; } ... } When I try to make this JPQL query: SELECT g from Language g where g.hasAlias("espanol", "italian

==== @Entity @EntityListeners({AuditLogAction.class}) @ Table (name = "IPT_AUDIT_LOG") public class

Hello, I have a problem with inserting of many entities. We use strings as primary key and indices. But if the db table of the entity type contains more and more data then the inserting of further entities needs also more and more ram memory, this leads to out of memory exceptions. But if use

the User table , just to make the explanation more easy). Now imagine the following where A and B

.newTotal  So are there rules for " table level/entity class level" operations

Binit Bhaskar This division by zero occurs in some hash table that happens to have a 0 size (but I

null. The package.jdo file is definitely being read, because when I put strategy=" TABLE " in

object from the bean editor and save its current state to the db table /row it was initially loaded

table - you can set an initial ID which is larger than any existing ID to avoid any conflict. support Support

Hi I no longer want to use an Entity .. (in SQL terms the whole Table ) ... How do I delete it ?   Thanks Paul Newman pnewman Paul Newman Currently classes cannot be removed but this only affects the list of classes in the Explorer. Removing of classes will be supported in the future. support Support

Hi, does anyone have experience with database with more than billion records (ie. more than 1000 million records) in one table . What is the limit of ObjectDB and is the database still fast. We are planing to do an application which handles document records and there metadata. peric.emil Emil

(with a subsequent fetch of a page of 20 results per table view on the UI) where a user belongs

I created a data model to test many-to-many relationship with a link table as following (full code in attachement) @Entity public class User {     @Id     private String code;     @OneToMany(mappedBy = "user") @MapKey     private Map

Hi, Is it possible to write a JPA query to select objects that contain a collection of elements? For example, suppose I have a table that maps a search terms to pages: @Entity public class SearchIndex { @Index SearchTerm term; @Index Page page; } Now suppose I have an array of SearchTerm objects

for the tables and trees look again, very old. A beautiful GUI boosts productivity! :)   Posting

entity objects to underlying tables and therefore does not handle columns. However, you can use use

data access on a large 2 dimansional table . Internally we used a list entities which hold a list of table rows which is a list of embeddable entities holding the final (String) value together with just

would have to switch to TABLE or SEQUENCE strategy instead of AUTO to get an ID ensured after just persist ... , but it seems that switching to SEQUENCE or TABLE  would provide better performance than flush after every persist . support Support

more, but you could check in the Action  table , typically we take an endDate that is 30 days from

After an error in a @PrePersist method in an Entity class, the database stopped working. Fortunately this was in development, but still worrying! The Entity class @Entity @ Table (uniqueConstraints = {     @UniqueConstraint(columnNames = "personalNumber")}) public class Customer

of my entity look now like this: @Entity @ Table (schema="ebene1") public class MyEntity { protected static

Hi, I'm trying to use objectdb in a producer/consumer scenario. Producer threads put message objects into a table while consumer threads remove the objects based on age, priority, etc. There are 2 main motivations for using objectdb for this purpose rather than a queue or similar data structure: 1

tables  ( issue #2600 ). Fixed a bug in using trailing '_' wildcard in LIKE queries ( issue

bug in opening tables for selected rows. Fixed a replication configuration error .