ObjectDB Database Search

I have a family of related types, like this: @Entity class Base { String val1; String val2 ... string within any of their String-typed fields.  The query I'm using looks somewhat like this: SELECT b FROM Base b WHERE b.val1 LIKE :search OR b.val2 LIKE :search OR TYPE(b) = Derived1

. It's a 'type' field. When I try to build a query that looks for example like this: select new ResultData(p ... name? Or do I have to change this field name and remember no to use words like from, group ... .jar:na] at java.lang.Thread.run(Thread.java:619) ~[na:1.6.0_23] when using query like

objects. I would like to update my query below to include a similar ' like ' pattern match for each ... .class); //pseudo code(i think i need something like this here) Predicate myPred = for all records (any record.FIELD LIKE searchString) Path status = root.get("status"); criteriaQuery.where( builder.or

: Ideally I'd like to capture all objects that were changed after a commit, i.e: after the transaction ... really like to know after a commit what objects changed in the prior commit. in other words a 'post ... a graph of objects, I'd like to know all the objects that changed and commited, so that I can generate

. I am supposing, that it is because of some mistake, so I would like from you to help me diagnose ... behave like this also for You. For me it's sufficient to just start the server and leave it running ... like sockets. Our app is also using SSL connections and I never saw there unused sockets like

application configs. Like ; tablename : enumeration table rows: key       ... ? Like this: @Entity @Table(name="enumerations") public class Enumerations { //Field binding possible like below ? @Column(field="servername") private String serverName; @Column(field="username

is more like a session cache? andrewmcveigh Andrew McVeigh The L1 cache is per EntityManager ... can imagine that after flush method it could be problematic so i did sth like this   ... is the same like before evictAll() mth and i in the result i get OutOfMemory How I can check size od

and have it affect employeeDB - so I'm likely doing it wrong. I'll try to construct a single class file ... may try pursuing that further if absolutely necessary, but I'd like to inquire further on your statement ... and still read those changes? If UPDATE queries don't seem like a valid solution then I'm still likely

Hi, is it possible to access one odb file from different applications? What we would like ... would like to use our APP but he asks how the data from the DB can be used to fill its DWH ... Web Services within the APP but he would like to do some integration directly) Does anybody

instance of embeddable class in entity. And what happens if I do operation like : entA.setBList(new ... have another question though. I have entity EntityA like that @Entity public class EntityA implements Serializable ... another simple entity.   My problem is - when i remove EntityA instance I would like

field. I would like to enter SHA1.hash("mypassword");  You might use beanshell for the expression ... the maximum number of records 'N' (default to some small number like 10) to display ... , but they may contain collections (explicit or derived) with a large number of elements. Again, most likely I'm

them with paging. The problem is, that running code that looks like this: TypedQuery icQuery = em.em.createQuery ... pl.hplxtool.dao.impl.ProductDAOImpl - Returning data Query manager builds plan like this: [2011-11 ... at a time. The funny thing is that in log from query manager fetchSize is like all objects in

hi, How can I realize multi selection with the criteria api concerning distinct? I.e. doing something like SELECT DISTINCT $1, $2 wouldn't work because I do only have something like criteria.multiselect(...) and nothing like builder.distinct(selection) so that I could do something like criteria

Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINCT $1 FROM CDI $1, Organisation $2, Organisation $3 WHERE ((UPPER($1.cdiId) LIKE 'THREAD14%') AND ((($1 ... ObjectDB. Is there any other way to specify execution order of query components for a complex query like

.com/tbIsj.png (old link) and then when I try to start it anyways I get things like thaat: 2. https ... ok, it works but I still have the error from picture 1. It works, on server like it should but in eclipse I still have a error like this:   Description Resource Path Location Type Plugin

for identical members. Something like : SELECT o FROM Object o WHERE o.someCollection CONTAINS MEMBER OF :someCollection Is something like this possible in the JPA spec? bensteele Ben Steele A possible ... Support Sounds like you are suggesting a solution to matching the entire contents of a collection

have Relation tables    TransportationEvent  and Conclusion  , relations like @Entity ... = new ArrayList (); .... } here in database i have got another two table like Conclusion ... to delete conclusion table records like bellow: removeConclusions(conclusion.getId()); public void

value doesn't match any results in the database. Our code looks like this: CriteriaBuilder builder ... of the created predicate yields in something like : $1.eintritt=2013-11-01 whereas as seen in my manual query string i do something like : $1.eintritt = {d '2013-11-01'} Any ideas why this might be the case? Note

is the producer from DB (based on a query) and I would like to speed it up. I have tried using several entity managers (same DB instance) to benefit from the parallelisation - but it looks like I don't get much benefit from doing that.  I profiled the application - and it looks like there are some benefits

might stand for something like "Page Access Group element". So, I eventually derive at the conclusion ... like the following.) private static final StoreLifecycleListener storeLifecycleListener = new ... ; Looks like the uploaded attachment actually succeeded though.  "UploadFailure.png

= JPA.em().createQuery("SELECT m FROM MyClass m WHERE m.myDate LIKE :query OR m.myText LIKE :query ... ().createQuery("SELECT m FROM MyClass m WHERE m.myText LIKE :query OR m.myDate LIKE :query"); q.setParameter

Hi I have not seen, cursory search was not informative, if odb can be embedded like derby.  ... to examine the schema?  tia lamininid Laminin if odb can be embedded like derby. Yes. ObjectDB has a client-server mode ( like MySQL), but also an embedded mode ( like Derby). See this page .  

How to store and compare date up to sec? By default it stores the dates like "23 May, 2020 10 ... May, 2020 10:25:23 AM") like MySql and other db. They stores the date up to sec. Manoj Manoj ... . You can reset date part as you like , before the object is stored in the database. e.g. https://stackoverflow

we would like } ) ; // Wait until the backup is completed. try {     backupThread ... 'a', like u can see on the attached screen. So my suggestion is that You could either make this field ... would be nice solution for us. jakab Gergely Jakab Please check build 2.8.9_02 with something like :  

performance ? Q2: Do LIKE operations have significant degradation on queries ... of read only entity managers automatically. Even though ObjectDB implements LIKE very efficiently ... could help. LIKE against patterns that start with fixed characters rather than wildcards is expected

to the JVM like this -dSource=someValue I dont know what app server you are using   ... , it seemed more like a general question. Let me know if you need more clarification on what I am talking about I ... to the database - aka a managed pool. In Glassfish, setting up this pool is like this (domain.xml):  

to be being pretty useless.. thanks, Alex quasado Alexander Adam I am getting closer.. looks like ... Alexander Adam Looks like calling merge() *before* modifying the underlying list property does the job ... is this: - Create a class with a simple list in it like in my first post - Open up connection to server to any

. Each entity has it's own field that holds java.lang.Date. There is no function like YEAR(), MONTH() or DAY() in ODB. So, how to build queries similar to something like this: SELECT COUNT(id) FROM stats ... something like this: SELECT COUNT(id) FROM stats WHERE YEAR(record_date) = 2009 GROUP BY DATE_FORMAT(record_date

Hi, I have an issue with the EntityManager. My persistance XML looks like : com.objectdb.jpa ... .4_03). I had to load them manually in the transaction due to lack of time but would like ... the second junit test, you will see heaps of calls like : AttributeName EQUALS method called

Hi there! Actually, what I have is something like : @Embedable class Address {     ... with a concatenated value of street + streetNo (if not null). So I want something like this: SELECT c, a FROM Customer ... itself... Alex quasado Alexander Adam Maybe something like : SELECT c, a FROM Customer LEFT JOIN c.addresses

.1.0 - FAIL. Does not support "lower(FIELD_NAME) LIKE lower('value')". According to the exception message only "lower(FIELD_NAME) LIKE 'value'" is supported:      org.apache.openjpa ... ; but, of course, I would like to know: - When will the ObjectDB JPA 2.0 implementation fully support

need initial structure like tables, but how can we populate some "tables" with initial data from a script ? In SQL world we have scripts like "insert into..." - Can we use main objectdb.jar library as jdbc driver for ETL software like Kettle? How about migrating data from another database

) LIKE LOWER( :doi ) The error is: Unexpected query token 'metadata' This query works on Hibernate ... FETCH metadata.coverages LEFT JOIN FETCH metadata.rights WHERE LOWER( doi.doi ) LIKE LOWER( :doi ... WHERE LOWER( doi.doi ) LIKE LOWER( "10.000/test" ) ...I get the error: Invalid fetch path: .titles

-15%. If you are referring to something else, I'd like to understand better what you mean. Our tomcat ... seconds wait on writing to disk. If you are referring to something else, I'd like to understand better ... threads (e.g. database pages) is much more extensive so lock competition is more likely

version by RedHat which is based on 7.1, has been released recently. I would really like to use ... this version of JBoss? I would also like to ask when but I know timeframes are not really known in advance ... product that runs rings around the competition and I would like to use your product. Thank

Hi, I would like to retrieve all the primKeys (user defined) by doing something like : TypedQuery query = em.createQuery("SELECT mif.primkey FROM MyClass mif", MyClassPrimKey.class); The only alternative I can think of - would be to store the primkey on the object - but sounds like it is double

I have a application that initializes with spring, now I'd like to change my data access tier ... ) look like this org.hibernate.dialect.HSQLDialect thread 10 true false false create-drop I need ... something like this... @Configuration @PropertySources( value = { @PropertySource("classpath:properties

like a classpath issue. Maybe objectdb.jar is available only in compilation and not at runtime ... somehow. I came up with a workaround and it's now working! Thanks :) Flying Banana Jiacong Xu It seems like ... an external Jar to my Project. Eclipse does not show any errors and it looks like it finds all classes

; I've wrote a test on this, and seems that my Converters methods are not executed at all ( like ... object whenever it is instantiated... Like concrete example is @Entity Currency, there are 100s ... me know.  This will actually help me avoid lot of useless code in the future, so I'd like

, I had configured my persistence unit like below.      com.objectdb.jpa.Provider ... . That means our app is not connected to db server even if I had configured our client app like ... - when objectdb on localhost The objectdb.conf server data url configured like : Thoughts?  

" interfaces like this, so that I am not spending a long time (I'm slow) programming what I'll ... the database, and I like this a lot so far. However, in writing the Contact class, I realized I ... developer/ enterprise multi tiered philosophy--nevertheless--I decided that I would like

Dear Objectdb-Team We're really pleased with objectdb. Nevertheless we would like to ask ... . We would like to make a self-test before every start of the database (i.e. the server). In case of fails or errors we would like to repair the database and/or inform the customer. So it would be very helpful

where a.objectsInCharge.nodePath like "/(PR)W4455NS01%" and a.objectsInCharge.nodePath like "%MARAS%" or Update Action Set transferred = 0 here objectsInCharge.nodePath like "/(PR)W4455NS01%" and objectsInCharge.nodePath like "%MARAS%" both result in: Query Execution Error ===================== null Query

that satisfy:   or(and( like ($6.phone,'%81%'),($6.phone!=null),($6!=null)),and( like ($6.fax,'%81%'),($6.fax!=null),($6!=null)),and( like ($3.firstName,'%81%'),($3.firstName!=null),($3!=null)),and( like ($6.email,'%81%'),($6.email!=null),($6!=null)),and( like ($3.lastName,'%81%'),($3.lastName!=null),($3!=null

to commit and open a new transaction). But this does not sound like a nice solution. We tried to detach ... MyStep objects. Every MyStep contains a list of 2 MyValue objects. Then we do something like ... a solution for this serious issue. We would like to know if - we do something wrong and should change

somewhere in the find. The thread dump looks like : Name: DEV1-WSAgent-1-Existing/3 State: RUNNABLE Total ... .java:662) A dump from one of the blocked threads looks like : Name: DEV1-WSAgent-1-Existing/4 State ... which made it into the wrapper looks like : Name: uatsrtlonw342-WSAgent-1-New/4 State: BLOCKED on com.objectdb.o.LKM

.paymentTerm $3 LEFT JOIN $1.receiver $4 WHERE ((((($2 IS NOT NULL) AND (UPPER($2.isoCode) LIKE UPPER('%Meier%'))) OR (($3 IS NOT NULL) AND (UPPER($3.description) LIKE UPPER('%Meier%'))) OR (UPPER($1.number) LIKE UPPER('%Meier%')) OR (($4 IS NOT NULL) AND (UPPER($4.name) LIKE UPPER('%Meier%'))) OR

-Xms512m -Xmx1g. I have scope to increase these limits but would like to get an understanding ... more then it sounds like the threads are not exiting and this is a problem with the test. I'll check ... to something which is different in server mode - connection management seemed like a good place to start

I modified the example code to include an index on the Point class like so:     ... , to see how that affects things.  The full object is likely to be our common use case ... " on JDK 6, so hopefully that's good enough.  I need to look into it more. I'd like to look closer

. What we have is something like (pseudo code) class TestEntity { public Integer getAge() { return 100 ... .jar:1.6.0_37] The expression is created like mentioned in the initial issue so the method is there. The only thing is that we're having an inheritance hierarchy like class TestEntity_1 { public