Internal Website Search

) 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

.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

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

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 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

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

" 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

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):  

-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

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

program.   CBE CBE Looks like ignoreCache set to false is still ignored after the above fix ... the cache, like it was told to do).  If I manually set ignoreCache=false to correct the failure

Hello, We're trying to upgrade the DB-Schema. Simplied our source/original Schema/Class-Hierarchy looked like this: class contact.Contact class customer.Customer extends contact.Contact class member ... and Member). Our new hierarchy looks like that: - The package "member" has been renamed to package

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

Hello , some products developed by JDBC , So we cannot use ObjectDB. My idea is , you can make JDBC To ObjectDB wizard compiler or something like this. You can eliminate JDBC Requests from Java Code ... like "insert into ObjectT values('hasan','test')" to ObjectT obj = new ObjectT("hasan","test"); em

Why does this NamedQuery only work sometimes? @NamedQuery(name = "ItemDB.getPartial", query = "SELECT i FROM com.model.ItemDB i JOIN i.lstSupplier s WHERE s.strSupNumber LIKE ?1") I use ... ("SELECT i FROM com.model.ItemDB i LEFT JOIN i.lstSupplier s WHERE s.strSupNumber LIKE '%5785483

I have being searching all around for how to do this but still no luck. I want objectdb to be able to listen in server mode to other connections from another machine where client is installed. I will like to have objectdb on machine A, while B,C, D can access the database in a using code like

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

file only once to my karaf and use it like any other OSGi bundle. Many thanks in advance ... of JPA will define a standard API for OSGi integration.   support Support Hello, OK, sounds like a plan. Regards, Alex alexweirig Alex Weirig

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

_id, city, house_no; the third table will be like . emp_add: e_id, add_id i am using annotation like

The beginning of my "Sample" class looks like : @Entity @SequenceGenerator(name = "sampleSeqGenerator", initialValue = 1, allocationSize = 100) public class Sample implements Serializable { private ... when I browse the database: 1,2,3,4 etc. I would like the field sampleName to be: SPL1, SPL2, SPL3

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

Hi, We have a ObjectDB instalation and licence for one server on a virtual machine within ESXi, we would like to migrate it to Physical server, is there any restrictions in moving or ... get prices for OEM licence. We have a DMS like custom build software with 5-6 customers and 2-3 developers

object's arrays of arrays are n x 1 - so the amount of data saved is exactly the same - So it looks like there is something ObjectDb (2.7.1) does not like about arrays of arrays. Thanks EKK   EKK

. 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  

. In a more usual DB like MySQL with a seperate server we first query for the Entitys of class ... ? I would assume so and can this be worked around by having PicData a reference to the Pet like

That sounds the most likely . After a bit of research I've came across a bit of documentation ... " + paramString); /* */ } /* 87 */ return localEntityManagerFactory; /* */ } It looks like either the list

to application entities and tried to remove all used objects after commit like shown below: if ( m ... that we are not expecting to close DB after import data and would like to release acquired by ObjectDB

($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, we would like to propose a feature in the objectdb if this is not already available. We use objectdb in our product development and deployment in high secure environments like police, military and government agencies. We have developed a specialized hardware device in a form of appliance

the close mechanism works like this if (manager.getTransaction().isActive() { // Condition A manager ... even issues like profiling or printing in the console might intefere. Until now the tests are executed from

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

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

Hi, ObjectDB! While you have a very nice product, which I recommend everywhere I go, it is quite difficult to explain to my customers what is it and why we should use it, and things like ... other, quality and popularity. What is your view on this? zmirc Mircea Chirac I'd like to add my good

") // 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

to solve it? serialization seems like a common taks to me so chances are the solution already exists ... , it is likely to solve the problem. Whenever you add this option, let me know so I can try

When I connect to embedded server it works good.  But when I connect to a standalone server, it will have invocation errors like can't find getters and setters.  To solve this I ... ; My query was a simple select statement with a where clause like where t.id=:id and t.range=:range

containing my Class hierarchy like so:  URLClassLoader classLoader = new URLClassLoader ... like so: Class claz = classLoader.loadClass(myClassName); I hope this helps. If you need

. So...it was like the query received Type.BAD as parameter. This happens regardless of Type being an inner ... different projects. I would like so much to have this working properly. Thank you. BTW...Images are not

of its resources, and so should never end up in a situation where it runs out of memory like this.   ... up in a situation where it runs out of memory like this. Servers that run on Java JVM, such as

Hello, I've just installed ObjectDB and done some tests. I'm inserting 22k of records like 10k iterations of 22 linked entites. I've got indexes on Long id on every entity and additionally ... and everything worked like a charm: the execution time of test now is around 2 seconds. Thanks for assistance. 4410 Arsenii

with JPA included and all works like a charm. paddy Patrick Gerhardt ObjectDB runs fine now ... and all works like a charm! Persistence.xml is now found and ClassLoader problems are gone... thats a suitable solution for now! paddy Patrick Gerhardt

" 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

the syntax for selective update is unclear as the syntax in the documentation seems to be wrong. Query Update Action Set transferred = 0 where a.objectsInCharge.nodePath like "/(PR)W4455NS01%" and a.objectsInCharge.nodePath like "%MARAS%" results in Query Execution Error

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

we have a query like this: SELECT a.endDate,a.objectsInCharge.nodePath,a.objectsInCharge.properties.doubleValue FROM Action a WHERE a.type = 0 and a.subType = 3 and a.state = 3 and a.endDate = ?1 ... ). Would you like to try repeating Doctor + Stat on it and send the result? Or better, start

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

: even without using the hint, does the new version behave like 2.7.6? We will introduce hints later ... we have queries like the above that are entered by customers on the fly, no chance to use hints

. what can we do with this, are there other options how we can reach more reliability in situations like these ?   hgzwicker ... setting, it is more or less not acceptable to slow down the system like this hgzwicker Hans-Georg

like was gone after paste java code into Reply-editor and subsequent editing. Original is attached ... .name like ?1 and v.id.platformSensor=ps.id and v.id.year=?2 and v.id.month=?3 and v.id.day=?4