ObjectDB Database Search

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 it possible to make a backup from the explorer? jastorga Juan If the database is not in use you can use the File Open dialog and then copy and paste on the database file (right click a database file to see the copy command). But a safe online backup (while the database is in use) is not supported. support Support

ways to recover from DB curruption

Get database schema from objectDB file

Again about $temp from objectdb.conf

Fetch Set from DB only works on debug mode

Inconsistent return types from JDO query

Query to find object from element of a contained collection

How do I Remove an entity from the Database ?

Slow loading from db

Enhancement from gradle build file

2.5.7_03 missing from Maven repository

Removing an element from an @OneToMany doesn't work

Failure after ObjectDB 2.4.5_07 upgrade from 2.4.4_06

Catching exceptions from client-server mode online backup

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

represent specific SQL-like expressions: An expression that returns the first non-null value from a list

that have already signed (which are retrieved from the request's guestDao attribute that is set by

from Maven repositories. The Tutorial Steps This tutorial consists of the following steps:

) If  Maven is installed - extract the zip and run the application from the command line by

This tutorial demonstrates how to create reports based on data in an ObjectDB database using the popular open source Business Intelligence and Reporting Tools (BIRT). In order to keep things as simple as possible - we will use the basic  points.odb ObjectDB database file from the Getting

should represent Point objects in the database. Apart from the @Entity annotation and the id field