ObjectDB Database Search

Delete object from collection versus delete from JPQL

Hello, we have a Question to the dependency from enhanced classes (required for license ... of post #1 In the example (Eclipse OSGi Example #2) I have the ObjectDB removed from the bundle "com.btc.ep.base.bl.impl". Now we get the error message from post #1. java.lang.NoClassDefFoundError: com

to evaluate your tool I would like to know if your product has the ability to failover from ... down the application will still be able to read from the slaves but writes will not be allowed ... Currently automatic switching from a failed master database to a replicated database is indeed limited by

would like some feedback from the community to see if I'm thinking about it right.   We have a finance data mart that is appended to daily via an SSIS package. I would like to pull the data from SQL, add ... this make sense? Is there a way to map the structure of the table directly into ObjectDB from SQL Server

to an existing database , but it could be also some issue with the conversion from 1.x to 2.x. To activate ... it and let you know. I will use the following command after i convert from 1.x to 2.x String ... step 4 from post #9 above. You may need to run the Doctor to build the index. support Support hmmm

Besides the em.remove() one by one, is there a function of "drop table" or "delete from table ... FROM MyEntity e").executeUpdate(); This is implemented since version 2.2.4 but the manual has not ... . I can not find "drop table" in this site BTW. gzdillon Lai Yang The code “createQuery("DELETE FROM

attention when using Entities previously geared towards JPA / Hibernate migrating data from existing ... objects from Hibernate, detaches them and then persists them using ObjectDB. A tool ... answers! retrieves entity objects from Hibernate, detaches them and then persists them using ObjectDB

mysql data into objectdb? gzdillon Lai Yang Currently to import data from other databases ... data from MySQL using JPA as entity objects, detach the retrieved entity objects and then persist ... its priority. See also the  migration path from JPA / Hibernate forum thread. support Support

Hi from Spain! We're evaluating ObjectDB and we have some questions: - How can we create ... need initial structure like tables, but how can we populate some "tables" with initial data from ... as jdbc driver for ETL software like Kettle? How about migrating data from another database

Hi, I want to drop one column from my database table suppose i have 3 column (id, name, address ... Just remove the field from the entity class. See Automatic Schema Evolution . Space in the database ... is physically removed only when an object is stored again, after removing the field from the entity

ClassCastExceptions on my "entity" classes when I try to read data from the DB. In a very old (2011?) forum ... ; TypedQuery typedQuery = entityManager.createQuery("SELECT FROM Person p WHERE p.id = 1", Person.class ... indicates that the Person class is available from two different class loaders: A Person  class

Hello, i am trying to set up the SSL for connections to objectDB server. I cannot connect the Client, when SSL is enabled. I can connect from Explorer, when "Use SSL" is checked, isn't there some ... .objectdb.o.CST.o(CST.java:150) thamal Tomas Hamal I can connect from Explorer, when "Use SSL" is checked

Hi, Where do i download the explorer from ? I dont see any link. Please guide. Ravi ravionweb Ravi It is included in the zip file that can be downloaded from the download page  (with the entire ObjectDB distribution) in the bin directory. support Support

Please I have being working on an application, and I am experiencing some challenges populating my javaFx table from ObjectDB, Please I don't know if I can get a sample code for populating javaFx table from ObjectDB that could aid my Project. Jerry Onoja Jerry You may check the following links

Hi,   AFter the upgrade from 2.2.8_02 (not sure if it was build 03/04 as I skipped 03) - my LIKE queries have stopped working during a regression test. As an example output: Query: SELECT $1 FROM Company $1 WHERE ((($1.companyId LIKE :p1) AND ($1.conditionOne=true)) AND ((($1.conditionTwo

Hi, could someone recommend a good tool to use for data migration from SQLServer to ObjectDB. irene05 irene lan Unfortunately there is currently no such automatic tool. Using a JPA ORM library (e.g. Hibernate or EclipseLink) you can write your own conversion program that retrieves data from

Hibernate
When getting this entity from PostgreSQL with the key EntityManager.find(id), we receive ... , it is an exception from ObjectDB, although the entity itself is not related to ObjectDB any more. com

Hi, I realised that I have a mistake ( from application logic point of view) in one of my JDO metadata files:                       ... also from version 2.7.2_09 and it made no difference. jakab Gergely Jakab Looks like

Hi, Is there a way to "Rebuild Class Indexes" from the command line? I have just added a new index and want to make sure the DBs with previously persisted entities have a BTree with all entities ... an index currently requires running the ObjectDB Doctor , which is run from the command line. ObjectDB 1

I would like to draw the attention of those assessing migration from EclipseLink ORM to ObjectDB to a significant difference in the initialization of persistent lists, namely that EclipseLink ... is clearly different from EclipseLink, and so has an impact on migration. I have previously examined

Client Server mode. kindly provide information how to switch from client server mode to embedded ... of the database file ( from the client-server session) on your computer (under objectdb/db ), you can also use

, it must be read from the configuration file. b) ) Is it possible to place the configuration file in

I've determined that the database is correctly initialized, looking at it from the Object Explorer, I can run the code that loads the database in a Junit test and it's initializing the children objects correctly, but in the application running in Jetty with Spring, fetching is not cascading

Hi, I have Problems to initialize objectdb in a jee envoirment. I used the Guestbook from the tutorial and try to deploy on Tomcat but i get this error. Caused by: org.apache.tomee.catalina.TomEERuntimeException: org.apache.openejb.OpenEJBException: Creating application failed: /objectdb-2.6.2

can some one help me how exactly i need to use this to delete the records from Conclusion

Getting following error when executing bellow query.   [2022-03-25 14:42:19 #1 query] Error during query execution: Select rt From RtDelete rt Where rt.EntityClass =: encls And rt.DeletedAt : lastcheck({encls-RtCall,lastcheck-Fri Mar 25 14:42:14 IST 2022}) [2022-03-25 14:42:19 #2 *] [ObjectDB

although there was an Exception in it. I attached a screenshot from the debugger.   jakab

Activated DB does not work from one to another day. How can this be? com.objectdb.o.UserException: Too many persistable types (10) - exceeds evaluation limit at com.objectdb.o.MSG.a(MSG.java:64) at com.objectdb.o.MST.YW(MST.java:1168) at com.objectdb.o.WRA.YW(WRA.java:215) at com.objectdb.o.TYS.f

ObjectDB in embedded mode? Apparently undeploying a web application from GlassFish doesn't close

Hi ObjectDB, Is there a way to extract the schema from an existing Database? i.e. without using my class files Thanks EKK EKK Emmanuel Keskes The schema is available for viewing in the Explorer. You may use the JPA Metamodel API to extract it using your own code. support Support

Is there a way to show what queries are actually being executed from within a Java class? I'm getting the exception: Exception in thread "main" [ObjectDB 2.5.4_05] javax.persistence.NonUniqueResultException However, I'm unable to debug it because I don't know what the query's actually searching

Hi, is there a way to put an Index on the values from an Map? For example, if I have a Map like this: private Map mmsContainer and I want to access it fast in following way: Collection values = mmsContainer.values();   Thanks for you help   wua Andreas Wurm Indexes are used only in

; May I suggest you also link from there to the tutorial example:  https://www.objectdb.com

Support Thanks. I have got this working, by a combination of moving the sequence from ORM to JDO file

Hi! I was looking for ways to delete a class (entity/embedded) from a database through Explorer, but I couldn't find any. Is there any way for doing that? If not, why? The only way I see right now is to delete the whole db and make a new one, but that's not a good scenario

Greetings, this NPE happened in our app first time today while reading objects from DB. Could u please check what could be the issue ? Inner message: Cannot invoke "com.objectdb.o.ORS.YD()" because " " is null -------------------- com.objectdb.o.TYR. (TYR.java:113) com.objectdb.o.ENT

Is there a preferred way to run a client-server database so that updates from one application are immediately visible to another? The way I managed this was to run PersistenceManagerFactory.getDataStoreCache().evictAll(true,MyClass.class) to ensure that a query on MyClass would contain updated

) is: Retrieval by navigation from detached objects is not supported, so only persistent fields ... : on accessing lazy loaded relationships outside a transaction, after a query, from Glassfish forum thread ... a similar extension in ObjectDB would ease emigration of web applications from EclipseLink to ObjectDB

Hi. It would be very useful to be able to delete an entire entity class from ObjectDB, but especially from Explorer. This is very useful for everyone, but also for clients that don't own a license ... the Schema / Managed Types list and then deleted by using [Edit Delete] from the menu bar or right click (context menu) and Delete. support Support

Hi, We are preparing to upgrade our database servers and application dependencies from 2.6.9_04 ... that includes these dependencies and the problems disappeared.  From my latest round of testing ... Dev   From my latest round of testing it looks like code that has a 2.6.9 ObjectDb.jar

from ObjectDB queue at rbccm.felix.objectdb.messaging.ObjectDbMessagePipe.take(Unknown Source ... .RuntimeException: Error getting message from data at rbccm.felix.objectdb.messaging.ObjectDbMessagePipe ... whose schema is not stored in the database, i.e. there are broken references from entity object field values

Hi, The problem occured since an update from my old-version (2.4.7_08) to the new version(2.4.7_18): 1) my recent db-file, created with the old-version, has been copied to the local db-folder ... -file programatically ( from within my code) without any errors 4) the db doctor ends without error

we have since today exceptions on executing some queries like this: Failed to read from file 'F:\Hummingbird\Objectdb\db\coreSystemDb.odb' we are using objectdb 2.7.2_05 in the objectdb log ... )   hgzwicker Hans-Georg Zwicker Please post the full stack trace from the ObjectDB log file. support Support

Hello, we have found several these exceptions in our log [ObjectDB 2.5.0_06] javax.persistence.PersistenceException Failed to read from file 'C:\SafeQORS\server\cache\MainORSCache.odb' (error 117 ... : Failed to read from file 'C:\SafeQORS\server\cache\MainORSCache.odb' at com.objectdb.o.MSG.d(MSG.java

named list) INFO: RequestBean []: involveBlockListInParsel: : list name(blocks) from blockId(65 ... []: involveValueOfEntityClassWithinListelInParsel: : valuePropertyName(floatQuantity) from entityClass(class com.greensoft.entity.test

reading from table gives Unexpected exception [ObjectDB 2.6.3] Unexpected exception (Error 990)   Generated by Java HotSpot(TM) 64-Bit Server VM 1.8.0_131 (on Windows 10 10.0). Please report this error on http://www.objectdb.com/database/issue/new com.objectdb.o.InternalException: null com

. Thanks, Joel jleblanc Joel Leblanc You are right, of course. JDO files should be removed from

Hello! When the JPA entities are not enhanced the removal of an entry from a @OneToMany collection is not possible. The following java code demonstrates the problem. The statement parentEntity.getChildEntityContainer().remove("01"); does not work correctly with not enhanced JPA entities. package

.createQuery(ReportDownloadObject.class);     Root r = q. from (ReportDownloadObject.class

ObjectDB for Java/JDO is a powerful Object Database Management System (ODBMS) written entirely in Java. It can efficiently handle a wide range of database sizes, from a few KBs to hundreds of GBs ... . Moving from one mode to the other can be done simply by changing a single string (the connection