About array

forum_thread

@AttributeOverrides , and postgresql + own TYPE

Hello,  first of all i want to thank for this is site. I'm begginer in Java and also in JPA and this site is very helpful for me. Now What is my problem. Unfortunately  i have to work with postgresql + JPA + eclipselink, because is my school project. Database is final and i can't do any changes even if i wanted to. In structure of DB  is this. -- -- Name: address; Type: TYPE; Schema: artio; Owner: facman --   ... will be getAddress method what data type it will be ? Array ?  4.I uploded for you my entity class of table Property ...

 
forum_thread

Find the error...JPA ENTITY HIBERNATE

Hey guys....i am searching for some days for the problem...Maybe one of you can find the error   DATABASE SHEMA: https://www.file-upload.net/download-12530779/2017-06-0214_25_00-MySQLWorkbench.png.html       Entities:   ... the error is that i get in return a endless array with message in users and users in message So my annotations are not ...

 
forum_thread

Getting sales quantity per country with a query, an idea anyone?

Hi, For the purpose of some charts on a dashboard for our ERP i would like to get the list of countries and the sales quantity for each of them. I am pretty sure it is somehow possible to get that directly from a more or less complex query but i failed to find it; Does any have an idea? The entity (we call it OrderData) contains fields and other entities related to an order, fields we are interrested in are  buyerCountry and orderPrice. ... This call will retrieve a list of 3 dimensional Object array containing respectively countries, quantity of orders and sum of orders, ...

 
manual

GROUP BY and HAVING clauses

Explains how to use the GROUP BY and HAVING clauses in a JPA/JPQL query. The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns properties of generated groups instead of individual objects and fields. The position of a GROUP BY clause in the query execution order is afte ...

 
forum_thread

significant performance decrease

we are using objected in embedded mode (on OS X and WINDOWS). The database increased now to around 400000 entities of one class (database file size around 1.5 GByte). The response time of standard queries increased with this database size to an unacceptable rate (several seconds compared to around 30% when the number of entities was just half of the current). We tried to optimize the cache settings, current objectdb.conf is: <!-- ObjectDB Configuration --> <objectdb> #1 2016-03-15 14:57 we are using objected in embedded mode (on OS X and WINDOWS). The database increased now to around 400000 entitie ...

 
forum_thread

IN operator syntax

Hi, what is the correct syntax for IN operator when list of literals ia used instead of parameter, e.g. SELECT FROM Info i WHERE i.status IN (1,4) ? (Suppose status is int.) I always get this exception: SELECT FROM Info i WHERE i.status IN (1 ==> , <== 4) javax.persistence.PersistenceException Unexpected query token ',' (closing ')' is missing) (error 752)   Query with only one item in list works fine: #1 2013-03-20 15:30 Hi, what is the correct syntax for IN operator when list of literals ia used instead of parameter, e.g. ...

 
api-jdo

javax.jdo.FetchPlan

Fetch groups are activated using methods on this interface.(Interface of JDO)

 
page

How to upgrade from ObjectDB 1.0?

Explains how to upgrade from ObjectDB 1.0 to ObjectDB 2.0. Upgrade - Step By Step To upgrade an existing application that uses ObjectDB 1.0 to ObjectDB 2.0: Replace the old ObjectDB and JDO jar files with the new objectdb.jar file. Make sure that the old jar files are removed from the classpath ...

 
manual

[ODB1] Chapter 9 - ObjectDB Explorer

Explains how to view and manipulate database files in the database explorer. ... an initial value and arrays require specifying an array length. Click the "OK" button to construct the new persistent objects. ...

 
forum_thread

Replication error on slave restart

I'm trying to enable replication on master server that was running with "recovery" enabled previously. I have copied database file to slave... and so on by manual. It worked fine. But if I restart slave server: #1 2014-03-01 15:53 I'm trying to enable replication on master server that was running with "recovery" enabled previously. ...