ObjectDB Database Search

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

Jakarta Persistence (JPA) provides annotations to define static, reusable queries at the class level, separating query logic from business code. Query definitions Declare named queries using ... . Retrieve it by result type from EntityManagerFactory.getNamedQueries , and use it to get a TypedQuery instance via EntityManager.createQuery .

to protect the Software from any use, reproduction, or distribution except specifically authorized ... all copies of the Software. This agreement will terminate immediately without notice from ObjectDB

JPA defines special JPQL expressions that return the date and time from the database server ... , MONTH , DAY , HOUR , MINUTE , and SECOND parts from a date or time value. For example: YEAR({d '2011

Jakarta Persistence criteria queries use the following interfaces and enums to extract temporal components like year, month, or hour from date and time values. TemporalField # Base interface ... to DateTime/Timestamp values (e.g., java.time.LocalDateTime , java.sql.Timestamp ), combining options from the two component type list above.

cache using these utility types: A utility interface obtained from Persistence . Use it to check ... obtained from EntityManagerFactory . It provides methods to inspect identifiers and version

and retrieve Point objects from the database: package com.objectdb.tutorial; import jakarta ... and automatic sequential value generation . This powerful feature of ObjectDB is absent from other object-oriented databases.

database file : Creates a new database file and copies all recoverable data from the corrupted file ... Doctor tool is included in the objectdb.jar file. You can run the tool from the command line: $ java -cp

annotation for defining multiple @MapKeyJoinColumn entries. Overrides Override mappings inherited from mapped ... a relationship mapping (e.g., a @JoinColumn ) inherited from a mapped superclass or within an embeddable

( from another EntityManager instance) currently holds a PESSIMISTIC_WRITE lock on that database object ... for locking entities when they are retrieved from the database. In addition to improving efficiency

from using or accessing this site. The materials contained in this web site are protected by ... notations from the materials; or transfer the materials to another person or "mirror" the materials

query from the first query. Returns: a new criteria query which returns the result of subtracting the results of the second query from the results of the first query. Since: Jakarta Persistence (JPA) 3.2 ... ) subtraction of the second query from the first query, without elimination of duplicate results

cannot be changed or reassigned. Returns the same selection item. Inherited from Selection Parameters ... : may result in a runtime failure. Inherited from Expression Parameters: type - intended type of the expression ... . Inherited from Expression Parameters: type - a basic type Returns: a scalar expression of the given basic

or compound attribute path from a bound type or collection, and is a "primitive" expression ... . Inherited from Selection Parameters: name - alias Returns: selection item. Since: Jakarta Persistence ... is not changed. Warning: may result in a runtime failure. Inherited from Expression Parameters: type

. Once assigned, an alias cannot be changed or reassigned. Returns the same selection item. Inherited from ... . Warning: may result in a runtime failure. Inherited from Expression Parameters: type - intended type ... required. Inherited from Expression Parameters: type - a basic type Returns: a scalar expression

statement. Inherited from Query Returns: the number of entities updated or deleted. Throws ... effect during query execution. Inherited from Query Since: Jakarta Persistence (JPA) 3.2 CacheStoreMode ... . Inherited from Query Since: Jakarta Persistence (JPA) 3.2 int getFirstResult () The position of the first

must be eliminated from the query result or whether they must be retained Returns: the modified query.. Since: Jakarta Persistence (JPA) 1.0 Root from ( Class entityClass ) Create and add a query root ... from AbstractQuery Parameters: entityClass - the entity class Returns: query root corresponding

must be obtained from an EntityManagerFactory , and is only able to manage persistence of entities belonging ... , that is scheduled for removal from the database upon transaction commit. The EntityManager API is used ... their primary key, and execute queries which range over entity types. An entity may be disassociated from

selection item. Inherited from Selection Parameters: name - alias Returns: selection item. Since: Jakarta ... : the runtime type is not changed. Warning: may result in a runtime failure. Inherited from Expression ... between other basic types is not required. Inherited from Expression Parameters: type - a basic type

reassigned. Returns the same selection item. Inherited from Selection Parameters: name - alias Returns ... . Inherited from Expression Parameters: type - intended type of the expression Returns: new expression ... . Support for typecasts between other basic types is not required. Inherited from Expression

. Returns the same selection item. Inherited from Selection Parameters: name - alias Returns ... . Inherited from Expression Parameters: type - intended type of the expression Returns: new expression ... . Support for typecasts between other basic types is not required. Inherited from Expression Parameters

reassigned. Returns the same selection item. Inherited from Selection Parameters: name - alias Returns ... . Inherited from Expression Parameters: type - intended type of the expression Returns: new ... , and Double . Support for typecasts between other basic types is not required. Inherited from Expression

) 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

Explorer] window and selecting  New Data Source . Select ObjectDB Data Source from the list ... the database connection url: Download and save the points.odb  database file ( from the Quick

In this final step we will add a simple table to the report: Open the [Insert Table] dialog box by dragging a Table  from the [Palette] window and dropping it on the report design (.rptdesign ... ) in the third field and click OK . Fill the table with data by dragging the x and y columns from