ObjectDB Database Search

Hello, I would like to know if it's possible to copy the content of a table representing one class of object to another table whithout having to use java object (no object instantiation) ? In fact, I would like to execute a native query like "select * into T0 from T1" My purpose is to backup

objectsInCharge = new ArrayList (); on running a query like select count(a) from Action a JOIN ... = 1) and (a.objectsInCharge.objectNameUpper like '%CAM%')   Query Plan Description ... retaining only results that satisfy: like (v$1.objectNameUpper,'%CAM%'). Step 3: Apply selection

of arbitrary objects ( like key-value store)? CBE CBE Does ObjectDB access the datafile in page-sized IO ... ; Entire persisted entity objects?   Fields of arbitrary objects ( like key-value store ... persisted entity objects?   Fields of arbitrary objects ( like key-value store)? Pages as byte

)? 1.2. Is ObjectDB on the same level like Hibernate with only difference that Hibernate stores ... which looks like this: @Entity(name="RESULT") public class EBResult extends Pojo implements ... " which looks like this: public class Pojo { private transient boolean changed=false; public boolean

Swim Lessons  10-Pack I would like to know if it is possible to have a query return ... Program WHERE description LIKE " [something] " ...but, this doesn't seem like it will work

Hi, I want to access a object which contains some value like id,name,college and address ... some address of object not the data. Like This (nextpack.InsertionClass@5c7fa833 ... but my question is without using tostring method. like a independent object and database. Thank you. Bimal

working on a query that return all the last "PULabel" of every RO object. I have written someting like ... .persistenceId ASC But it's look like it's not a correct query, the compiler does not like the parentheses

of it and a few other things that would otherise cause serious issues. At the same time, it looks like adding ... for the exact stack traces in the log file? The stack trace at #16 above is likely to appear ... a lot of things but can't solve the issue. As a result, we would like to follow your other suggestion

. We are completely unclear if indexes or statistics are really used.  sometimes a query like this takes takes ... of all these problems hgzpincher Hans-Georg Zwicker Sure, but you wrote:  sometimes a query like this takes ... in another thread. We treat every reported issue very seriously and would like to solve this one as

Do you have any plan to integrate GIS to objectdb like PostgreSQL's PostGIS. Its not hard to implement with AI in these days... Like searching Point , Polygon , geojson etc...  kadirbasol Kadir BASOL Waow , if we can use objectdb like simple fast persistent hashmap we can use uber h3 java

") // the element itself is a map How about arrays like x.array[1] and x.array[1][2] ? Thanks & Best ... it to be done in JPA/JDO queries. How about arrays like x.array[1] and x.array[1][2] ? If such navigations

Hi, I realize this is kind of like an apples vs. oranges comparison, but I would be interested if you have any performance information vs. something like ehcache with a persistent store. I'm currently evaluating for a simple schema to persist only 1 or 2 types of entities

Hi, I get the following when ODB starts in embedded mode: Replaying recorded requests... then I get something like 500 lines of recordset information. Here is the relevant part of the config file ... directory has many files like this: mr.odb_nonclosed, mr_1.odb_nonclosed up to mr_10.odb_nonclosed 2

I have an entity that looks like this: class User {     @embedded private Profile profile;     ... } After running something like this:     User user = entityManager.createQuery("select......     entityManager.detach

Hi, I have a question about @SequenceGenerator . I have separate @SequenceGenerator in each of my model enitities, but it looks like id's are generated using only one, shared generator. Is there any ... just like in RDBM? lwalkowski Lukasz Walkowski You can use different generators for different entity

EclipseLink this query works fine. select distinct c from CI c, CIstring s where c.name like :SSTR or (c.id = s.ci.id AND s.text like :SSTR) The class CI (Confiugration Item): private String name

Hello dear ObjectDB Community ! First of all let me tell You: I am glad that I have revisited ObjectDB just recently; because with its newly added JPA compliance and affordability, it seems like ... like ObjectDB, for instance. Immediately the following question pops up: Which Web Framework supports

" is consist with variables street,city,zip etc.  2.How should look like get and set method ... database forum is like asking for advice about meat recipes in a forum of vegetarian people

/IP option but I would like both DB's accessible in-program without the need for TCP/IP as ... .byteBuffer ryan.gustafson Ryan Gustafson Yes, it is very likely that this will be implemented in

' you should see something like the following (after the compile has completed): [INFO] --- exec-maven ... ). Any idea what is the problem?   support Support For some reason, the example doesn't like

?! like i said, this is properbly not the best way to test it, it's more like an integration test. i try

objects. i adapted my query and it works like expected. thanks for the hint chris Christoph Ernst ... like to know more about this. It looks very useful. 1. Are there any restrictions on the depth

that, for every transaction, I need to handle the optimistic lock by manually refreshing each object? if so, it seems like ... , so that doesn't help me. Pessimistic locks might not help either, given #3 above, ie: it seems like

was detached through serialization this would not be possible. .. If you would like TopLink Essentials ... adequately explore aspects like accessing lazy relationships when combined with Glassfish. From http

. But when it starts with language specific character like 'Č', these records are placed after records ... Normalizer.normalize(u.name, Normalizer.Form.NFD) How should the correct query look like ? Michael  

Lukasz Walkowski So, I did few tries with getPersistenceManager() method and it looks like ... for difference in object fields? It should be something like creating entire new EntityManager that has access

something that identifies that that is the issue, say something like "MissingSchemaException", ie ... something like  javax.persistence.EntityNotFoundException? Either that, or is there some way to query

($1.name) LIKE :p1) AND (($1.conditionOne=:p2))) Got: 1 results - correct   testFindByLikeLowerWildcardWithBranchWithOr: SELECT $1 FROM Company $1 WHERE ((LOWER($1.name) LIKE :p1) AND ((($1

Hello -   I think ObjectDB might be just the solution for our current project but I 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

Hello! I'm a student from Politechnika Rzeszowska University of Technology. I'm doing a project and i have a problem with  polish characters. When i'm coding .jsp file like this: i have polish ... that you have stored. Therefore, it is very likely that the polish encoding problem is related

, It is better if there was an elegant way like "alter table ...". gzdillon Lai Yang Add the index definition ... , I restore the Meta to independent. But I get error like : Exception in thread "main" [ObjectDB 2.2.9

2 different PUs. This works fine with one JPA Provider like Eclipselink, but with ObjectDb as ... class names ). The error goes away when I use qualified names, but Eclipselink does not like qualified

. support Support You can try configuration like this (it's my day to day dev environment): - create ... configuration - Arguments - VM arguments) Of course you can change this on Windows to something like "d

something like MVCC, so it can see the data at the time the backup was started (to have consistent ... it implement something like MVCC, so it can see the data at the time the backup was started

? I'd like to implement a many-to-many relationship so that User and Project can be directly access ... and Underlying object (but not through theirs keys). I'd like to work with typed object in the code

Hi there! Trying to add a simple type expression with the criteria api like in your sample: cb.equal(e.type(), cb.literal(Country.class)); results in the error: Caused by: com.objectdb.o ... ) when trying to get a result list. leaving it out removes the error, other filters like string equals

do something like SELECT FROM Test ORDER BY hint.name It orders ASC like this (assuming I've got

Hi! I've got a situation I do not understand. Assume code like this: @Embedable public class EmbeddedThing {     private String name;     public String ... by calling something like getFirstEmbeddedThing().setName("Yeah"). However, after comitting

looks like this: SELECT DISTINCT $1 FROM Organisation $1 JOIN $1.attributeList $2 LEFT JOIN $1.parentOrg ... is supposed to work like that? I'm running 2.3.4_05 version. Kind Regards, Natalia. natmaclin Natalia

hi! I am having loads and loads of occurrences of something like ((com.test.MyEntity) $1.map.get('com.test.MyEntity')).someProperty ... ((com.test.MyEntity) $1.map.get('com.test.MyEntity ... variable look like ? And how to create it using criteria api? We do have heavy usage of maps so I'd

Hi, I have a search using wildcards: SELECT $1 FROM CDI $1 WHERE $1.loginId LIKE '%*_last%2' ESCAPE '*' This works perfectly when loginId has NO annotations. Now if I add to loginId the following ... demonstrates that ESCAPE in LIKE was ignored when using an index. Build 2.3.7_11 fixes this bug. Thank you for your report. support Support

with something like booking.external_booking_ref = "TEST SdsfdfgdfgdfgdgdfTR "; and it still blows up. My entity looks like this .. @Entity public class av_booking implements Serializable { @Id

, run for like 10min and then I have to repair again. There seems to be a bug which corrupts ... Support Hello, yes. I repaired the database using the Doctor. Then running the application for like 5 ... ObjectDB 2.7.0_03. Recovery is enabled like stated above but the database gets corrupted

because it appears to be either database integrity corruption, or it just looks like ... like it). Please attend to this very serious problem as soon as possible so that I can resume

more felixobjectdb Richard Szurgot On further investigation it looks like this may be related ... this is more likely to happen frequently). It is unclear if the other exception is related. support Support Ok

Hi! We have an two entities, the first one is something like : @Embeddable class TestEmbed {...} and the second one: @Entity class TestEntity { private TestEmbed myEmbed = null; public TestEmbed ... only with an embeddable entity embedded within another embeddable entity like :   @Embeddable class Embed

like some of the "WorkflowInstance" objects have failed to persist (explorer lists an exception ... ) and is help as a string. The size is certainly larger than 2k and is likely to be in MB. The second

, what is the desired, JPA-Conform way of NOT having a result with doubled $1 and stilll use something like our code ... it looks like I am too dumb!? Using this query on attached DB: SELECT DISTINCT $1, UPPER($2.lastName

Hi, I am doing something simple like final Root from = criteria.from(T.class) final Path path = from.get("someStringProperty") final Expression upperPath = builder.upper((Expression ) path ... would have expected the alias to be used in the ORDER BY clause, something like SELECT $1, UPPER($1

Let's say I no longer need some entity in my project and after deleting all the objects of this type in database I want to remove this type from schema. How can I do this? Is there something like ... . Is it correct? support Support Yes. lwalkowski Lukasz Walkowski Any update on this? I also like to remove